Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | /*========tur===================================================*/ |
| 2 | /* DBMS name: PostgreSQL 8 */ |
||
| 3 | /* Criado em: 13/06/2016 */ |
||
| 4 | /* Autor: Bruno Lopes Peixoto */ |
||
| 5 | /*==============================================================*/ |
||
| 6 | |||
| 7 | SET search_path = sc_sec; |
||
| 8 | |||
| 9 | CREATE SEQUENCE sq_vigencia |
||
| 10 | INCREMENT 1 |
||
| 11 | minvalue 1 |
||
| 12 | maxvalue 99999999 |
||
| 13 | START 1; |
||
| 14 | |||
| 15 | CREATE SEQUENCE sq_avaliacao |
||
| 16 | INCREMENT 1 |
||
| 17 | minvalue 1 |
||
| 18 | maxvalue 99999999 |
||
| 19 | START 1; |
||
| 20 | |||
| 21 | CREATE SEQUENCE sq_itemaval |
||
| 22 | INCREMENT 1 |
||
| 23 | minvalue 1 |
||
| 24 | maxvalue 99999999 |
||
| 25 | START 1; |
||
| 26 | |||
| 27 | ALTER TABLE sq_vigencia owner TO sc_sec; |
||
| 28 | ALTER TABLE sq_avaliacao owner TO sc_sec; |
||
| 29 | ALTER TABLE sq_itemaval owner TO sc_sec; |
||
| 30 | |||
| 31 | /*==============================================================*/ |
||
| 32 | /* Table: sec_vigencia */ |
||
| 33 | /*==============================================================*/ |
||
| 34 | CREATE TABLE sec_vigencia ( |
||
| 35 | seq_vigencia INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_vigencia'::regclass), |
||
| 36 | dsc_vigencia VARCHAR(10) NOT NULL, |
||
| 37 | dth_inicio TIMESTAMP NOT NULL, |
||
| 38 | dth_fim TIMESTAMP NOT NULL, |
||
| 39 | CONSTRAINT pk_vigencia PRIMARY KEY (seq_vigencia) |
||
| 40 | ); |
||
| 41 | |||
| 42 | -- set table ownership |
||
| 43 | ALTER TABLE sec_vigencia owner TO sc_sec |
||
| 44 | ; |
||
| 45 | |||
| 46 | /*==============================================================*/ |
||
| 47 | /* Table: sec_avaliacao */ |
||
| 48 | /*==============================================================*/ |
||
| 49 | CREATE TABLE sec_avaliacao ( |
||
| 50 | seq_avaliacao INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_avaliacao'::regclass), |
||
| 51 | seq_vigencia INT8 NOT NULL, |
||
| 52 | dth_inicio_resultado TIMESTAMP NULL, |
||
| 53 | dth_fim_resultado TIMESTAMP NULL, |
||
| 54 | CONSTRAINT pk_avaliacao PRIMARY KEY (seq_avaliacao) |
||
| 55 | ); |
||
| 56 | |||
| 57 | -- set table ownership |
||
| 58 | ALTER TABLE sec_avaliacao owner TO sc_sec |
||
| 59 | ; |
||
| 60 | /*==============================================================*/ |
||
| 61 | /* Index: ix_avalvigencia */ |
||
| 62 | /*==============================================================*/ |
||
| 63 | CREATE INDEX ix_avalvigencia ON sec_avaliacao ( |
||
| 64 | seq_vigencia |
||
| 65 | ); |
||
| 66 | |||
| 67 | ALTER TABLE sec_avaliacao |
||
| 68 | ADD CONSTRAINT fk_avaliacao_vigencia FOREIGN KEY (seq_vigencia) |
||
| 69 | REFERENCES sec_vigencia (seq_vigencia) |
||
| 70 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 71 | |||
| 72 | /*==============================================================*/ |
||
| 73 | /* Table: sec_avaliacao_funcionario */ |
||
| 74 | /*==============================================================*/ |
||
| 75 | CREATE TABLE sec_avaliacao_funcionario ( |
||
| 76 | seq_funcionario INT8 NOT NULL, |
||
| 77 | seq_avaliacao INT8 NOT NULL, |
||
| 78 | ind_receber_bonificacao BOOL NULL, |
||
| 79 | dsc_observacao VARCHAR(400) NULL, |
||
| 80 | qtd_horas_extras_50 INT4 NULL, |
||
| 81 | qtd_horas_extras_100 INT4 NULL, |
||
| 82 | CONSTRAINT pk_avaliafunc PRIMARY KEY (seq_avaliacao, seq_funcionario) |
||
| 83 | ); |
||
| 84 | |||
| 85 | -- set table ownership |
||
| 86 | ALTER TABLE sec_avaliacao_funcionario owner TO sc_sec |
||
| 87 | ; |
||
| 88 | /*==============================================================*/ |
||
| 89 | /* Index: ix_avalfunc_avaliacao */ |
||
| 90 | /*==============================================================*/ |
||
| 91 | CREATE INDEX ix_avalfunc_avaliacao ON sec_avaliacao_funcionario ( |
||
| 92 | seq_avaliacao |
||
| 93 | ); |
||
| 94 | |||
| 95 | /*==============================================================*/ |
||
| 96 | /* Index: ix_avalfunc_funcionario */ |
||
| 97 | /*==============================================================*/ |
||
| 98 | CREATE INDEX ix_avalfunc_funcionario ON sec_avaliacao_funcionario ( |
||
| 99 | seq_funcionario |
||
| 100 | ); |
||
| 101 | |||
| 102 | ALTER TABLE sec_avaliacao_funcionario |
||
| 103 | ADD CONSTRAINT fk_avalfunc_avaliacao FOREIGN KEY (seq_avaliacao) |
||
| 104 | REFERENCES sec_avaliacao (seq_avaliacao) |
||
| 105 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 106 | |||
| 107 | ALTER TABLE sec_avaliacao_funcionario |
||
| 108 | ADD CONSTRAINT fk_avalfunc_funcionario FOREIGN KEY (seq_funcionario) |
||
| 109 | REFERENCES sec_funcionario (seq_funcionario) |
||
| 110 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 111 | |||
| 112 | /*==============================================================*/ |
||
| 113 | /* Table: sec_item_avaliacao */ |
||
| 114 | /*==============================================================*/ |
||
| 115 | CREATE TABLE sec_item_avaliacao ( |
||
| 116 | seq_item_avaliacao INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_itemaval'::regclass), |
||
| 117 | dsc_item_avaliacao VARCHAR(400) NOT NULL, |
||
| 118 | ind_retira_pontos BOOL NOT NULL, |
||
| 119 | CONSTRAINT pk_itemaval PRIMARY KEY (seq_item_avaliacao) |
||
| 120 | ); |
||
| 121 | |||
| 122 | -- set table ownership |
||
| 123 | ALTER TABLE sec_item_avaliacao owner TO sc_sec |
||
| 124 | ; |
||
| 125 | |||
| 126 | /*==============================================================*/ |
||
| 127 | /* Table: sec_avalfunc_itemaval */ |
||
| 128 | /*==============================================================*/ |
||
| 129 | CREATE TABLE sec_avalfunc_itemaval ( |
||
| 130 | seq_item_avaliacao INT8 NOT NULL, |
||
| 131 | seq_avaliacao INT8 NOT NULL, |
||
| 132 | seq_funcionario INT8 NOT NULL, |
||
| 133 | qtd_pontos INT8 NOT NULL, |
||
| 134 | CONSTRAINT pk_avalfitemaval PRIMARY KEY (seq_avaliacao, seq_item_avaliacao, seq_funcionario) |
||
| 135 | ); |
||
| 136 | |||
| 137 | -- set table ownership |
||
| 138 | ALTER TABLE sec_avalfunc_itemaval owner TO sc_sec |
||
| 139 | ; |
||
| 140 | /*==============================================================*/ |
||
| 141 | /* Index: ix_avalfitemaval_itemaval */ |
||
| 142 | /*==============================================================*/ |
||
| 143 | CREATE INDEX ix_avalfitemaval_itemaval ON sec_avalfunc_itemaval ( |
||
| 144 | seq_item_avaliacao |
||
| 145 | ); |
||
| 146 | |||
| 147 | /*==============================================================*/ |
||
| 148 | /* Index: ix_avalfitemaval_avalfunc */ |
||
| 149 | /*==============================================================*/ |
||
| 150 | CREATE INDEX ix_avalfitemaval_avalfunc ON sec_avalfunc_itemaval ( |
||
| 151 | seq_avaliacao, |
||
| 152 | seq_funcionario |
||
| 153 | ); |
||
| 154 | |||
| 155 | ALTER TABLE sec_avalfunc_itemaval |
||
| 156 | ADD CONSTRAINT fk_avalfitemaval_avalfunc FOREIGN KEY (seq_avaliacao, seq_funcionario) |
||
| 157 | REFERENCES sec_avaliacao_funcionario (seq_avaliacao, seq_funcionario) |
||
| 158 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 159 | |||
| 160 | ALTER TABLE sec_avalfunc_itemaval |
||
| 161 | ADD CONSTRAINT fk_avalfitemaval_itemaval FOREIGN KEY (seq_item_avaliacao) |
||
| 162 | REFERENCES sec_item_avaliacao (seq_item_avaliacao) |
||
| 163 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 164 | |||
| 165 | |||
| 166 | SET search_path = public; |