1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
CREATE TABLE wms.ARTICLE_COTES(
ARCT_I_IDENT BIGINT IDENTITY,
ARCT_F_LONGUEUR DECIMAL(8,3) NOT NULL default 0,
ARCT_F_LARGEUR DECIMAL(8,3) NOT NULL default 0,
ARCT_F_HAUTEUR DECIMAL(8,3) NOT NULL default 0,
ARCT_F_PDS_BRUT DECIMAL(8,3) NOT NULL default 0,
ARCT_F_PDS_NET DECIMAL(8,3) NOT NULL default 0,
ARCT_T_CREATION DATETIME2 NOT NULL default current_timestamp,
ARCT_T_MODIFICATION DATETIME2 NOT NULL default current_timestamp,
UM_I_IDENT_POIDS TINYINT NOT NULL,
UM_I_IDENT_DIMENSION TINYINT NOT NULL,
ART_I_IDENT INT NOT NULL,
CONSTRAINT PK_ARTICLE_COTES PRIMARY KEY(ARCT_I_IDENT),
CONSTRAINT FK_ARTICLE_COTES_UNITE_MESURE_POIDS FOREIGN KEY(UM_I_IDENT_POIDS) REFERENCES dictionnaire.UNITE_MESURE(UM_I_IDENT),
CONSTRAINT FK_ARTICLE_COTES_UNITE_MESURE_DIMENSION FOREIGN KEY(UM_I_IDENT_DIMENSION) REFERENCES dictionnaire.UNITE_MESURE(UM_I_IDENT),
CONSTRAINT FK_ARTICLE_COTES_ARTICLE FOREIGN KEY(ART_I_IDENT) REFERENCES erp.ARTICLE(ART_I_IDENT)
); |
Partager