Subversion Repositories Integrator Subversion

/*==============================================================*/

/* Table: slp_sinal                                             */

/*==============================================================*/

CREATE TABLE slp_sinal (

   cod_sinal            VARCHAR(30)          NOT NULL,

   seq_candleref        INT8                 NOT NULL,

   seq_candleg1         INT8                 NULL,

   seq_candleg2         INT8                 NULL,

   seq_candleg3         INT8                 NULL,

   seq_candleg4         INT8                 NULL,

   dth_sinal            DATE                 NOT NULL,

   tip_sinal            CHAR(1)              NOT NULL,

   tip_situacao_sinal   CHAR(1)              NOT NULL,

   val_entrada2         NUMERIC(10,2)        NULL,

   val_alvo1            NUMERIC(10,2)        NULL,

   val_entrada1         NUMERIC(10,2)        NULL,

   val_alvo2            NUMERIC(10,2)        NULL,

   val_stop1            NUMERIC(10,2)        NULL,

   val_stop2            NUMERIC(10,2)        NULL,

   CONSTRAINT pk_sinal PRIMARY KEY (cod_sinal)

);

-- set table ownership

ALTER TABLE slp_sinal owner TO sc_slp

;

ALTER TABLE slp_sinal

   ADD CONSTRAINT fk_sinal_candleg1 FOREIGN KEY (seq_candleg1)

      REFERENCES slp_candle (seq_candle)

      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE slp_sinal

   ADD CONSTRAINT fk_sinal_candleg2 FOREIGN KEY (seq_candleg2)

      REFERENCES slp_candle (seq_candle)

      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE slp_sinal

   ADD CONSTRAINT fk_sinal_candleg3 FOREIGN KEY (seq_candleg3)

      REFERENCES slp_candle (seq_candle)

      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE slp_sinal

   ADD CONSTRAINT fk_sinal_candleg4 FOREIGN KEY (seq_candleg4)

      REFERENCES slp_candle (seq_candle)

      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE slp_sinal

   ADD CONSTRAINT fk_sinal_candleref FOREIGN KEY (seq_candleref)

      REFERENCES slp_candle (seq_candle)

      ON DELETE RESTRICT ON UPDATE RESTRICT;