ORACLE
CREATE TABLE TSIUSUBK
(
NUNICO NUMBER(10) NOT NULL,
CODUSU NUMBER(5) NOT NULL,
BAIXAREC VARCHAR2(1),
BAIXADESP VARCHAR2(1),
VERCABPROPRIA VARCHAR2(1),
SENHANUNCAEXPIRA VARCHAR2(1),
ALTCTAFAT VARCHAR2(1),
ALTCTAIMPBOL VARCHAR2(1),
ALTORDCFECH VARCHAR2(1),
EXIBIRVALANALRENT VARCHAR2(1),
IMPNFCENTRAL VARCHAR2(1),
MINUTOSFIN NUMBER(5),
APROVCOT VARCHAR2(1),
ACESSOVISUALCAB VARCHAR2(1),
RESTRINGECART VARCHAR2(1),
CONTACESSO VARCHAR2(30),
CONTAGOL VARCHAR2(30),
CONSTRAINT PK_TSIUSUBK PRIMARY KEY (NUNICO,CODUSU),
CONSTRAINT FK_TSIUSUBK_TSIHCF FOREIGN KEY (NUNICO) REFERENCES TSIHCF (NUNICO),
CONSTRAINT FK_TSIUSUBK_TSIUSU FOREIGN KEY (CODUSU) REFERENCES TSIUSU (CODUSU)
)
/
MSSQL
CREATE TABLE TSIUSUBK
(
NUNICO INT NOT NULL,
CODUSU SMALLINT NOT NULL,
BAIXAREC VARCHAR(1),
BAIXADESP VARCHAR(1),
VERCABPROPRIA VARCHAR(1),
SENHANUNCAEXPIRA VARCHAR(1),
ALTCTAFAT VARCHAR(1),
ALTCTAIMPBOL VARCHAR(1),
ALTORDCFECH VARCHAR(1),
EXIBIRVALANALRENT VARCHAR(1),
IMPNFCENTRAL VARCHAR(1),
MINUTOSFIN SMALLINT,
APROVCOT VARCHAR(1),
ACESSOVISUALCAB VARCHAR(1),
RESTRINGECART VARCHAR(1),
CONTACESSO VARCHAR(30),
CONTAGOL VARCHAR(30),
CONSTRAINT PK_TSIUSUBK PRIMARY KEY (NUNICO,CODUSU),
CONSTRAINT FK_TSIUSUBK_TSIHCF FOREIGN KEY (NUNICO) REFERENCES TSIHCF (NUNICO),
CONSTRAINT FK_TSIUSUBK_TSIUSU FOREIGN KEY (CODUSU) REFERENCES TSIUSU (CODUSU)
)
GO
Nenhum comentário:
Postar um comentário