Rev 766 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 766 | Rev 777 | ||
|---|---|---|---|
| Line 79... | Line 79... | ||
| 79 | /* Table: slp_ativo */
|
79 | /* Table: slp_ativo */
|
| 80 | /*==============================================================*/
|
80 | /*==============================================================*/
|
| 81 | CREATE TABLE slp_ativo ( |
81 | CREATE TABLE slp_ativo ( |
| 82 | seq_ativo INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_ativo'::regclass), |
82 | seq_ativo INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_ativo'::regclass), |
| 83 | dsc_ativo VARCHAR(120) NULL, |
83 | dsc_ativo VARCHAR(120) NULL, |
| - | 84 | tip_tendencia CHAR(1) NOT NULL |
|
| - | 85 | CONSTRAINT ck_tendencia_ativo CHECK (tip_tendencia IN ('A','B','N')), |
|
| 84 | ind_ativo BOOL NOT NULL, |
86 | ind_ativo BOOL NOT NULL, |
| 85 | CONSTRAINT pk_ativo PRIMARY KEY (seq_ativo) |
87 | CONSTRAINT pk_ativo PRIMARY KEY (seq_ativo) |
| 86 | );
|
88 | );
|
| - | 89 | ||
| - | 90 | comment ON COLUMN slp_ativo.tip_tendencia IS |
|
| - | 91 | 'Valores possíveis:
|
|
| - | 92 | A - Alta
|
|
| - | 93 | B - Baixa
|
|
| - | 94 | N - Não Definida';
|
|
| 87 | 95 | ||
| 88 | -- set table ownership
|
96 | -- set table ownership
|
| 89 | ALTER TABLE slp_ativo owner TO sc_slp |
97 | ALTER TABLE slp_ativo owner TO sc_slp |
| 90 | ; |
98 | ; |
| 91 | /*==============================================================*/
|
99 | /*==============================================================*/
|