1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
CREATE TABLE "FICHE"
(
FICHECT_ID int PRIMARY KEY NOT NULL,
FICHECT_DATE_CREATION timestamp NOT NULL,
FICHECT_DATE_CREATION_EF timestamp DEFAULT CURRENT TIMESTAMP NOT NULL,
FICHECT_REGIME_ID char(4) NOT NULL,
FICHECT_AGENT_CREATION varchar(50) NOT NULL,
FICHECT_NIR char(13) NOT NULL,
FICHECT_VGED_ID int,
FICHECT_RECEPT_DOC smallint,
FICHECT_CIBLE smallint,
FICHECT_DATE_MODIFICATION timestamp,
FICHECT_MODIFICATION_AGENT varchar(50),
FICHECT_MODIFICATION_REGIME_ID char(4),
FICHECT_MODIFICATION_DATE_EF timestamp DEFAULT CURRENT TIMESTAMP,
FICHECT_NIVEAU char(1),
FICHECT_DUPLICATA smallint,
FICHECT_INCOMP_LAC smallint,
FICHECT_INCOMP_BRO smallint,
FICHECT_RRNP_REGIME_ID char(4),
FICHECT_EVENTCT_ID int,
FICHECT_TIERS smallint,
FICHECT_DATE_DUPLICATA timestamp
); |
Partager