Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE VASILHAME_CAPA
- (
- CODIGO NUMBER(10) DEFAULT 0 NOT NULL,
- DATA_CRIACAO DATE DEFAULT TO_DATE('1980/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
- USUARIO NUMBER(10) DEFAULT 0,
- CODIGO_BARRA VARCHAR2(50) DEFAULT 0 NOT NULL,
- SITUACAO NUMBER(5) DEFAULT 0,
- TIPO_MOVIMENTACAO NUMBER(5) DEFAULT 0,
- MOTIVO NUMBER(5) DEFAULT 0,
- LOJA NUMBER(10) DEFAULT 0 NOT NULL,
- LOJAINCLUSAO INTEGER DEFAULT 0,
- DATAINCLUSAO DATE DEFAULT TO_DATE('1980/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
- CODUSUINCLUSAO INTEGER DEFAULT 0,
- NOMEUSUINCLUSAO VARCHAR2(50) DEFAULT ' ',
- LOJAALTERACAO INTEGER DEFAULT 0,
- DATAALTERACAO DATE DEFAULT TO_DATE('1980/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
- CODUSUALTERACAO INTEGER DEFAULT 0,
- NOMEUSUALTERACAO VARCHAR2(50) DEFAULT ' ',
- IDEXEOPERACAO VARCHAR2(15) DEFAULT ' ',
- NOMEEXEOPERACAO VARCHAR2(20) DEFAULT ' ',
- VRSEXEOPERACAO VARCHAR2(15) DEFAULT ' ',
- VRSBANCOOPERACAO INTEGER DEFAULT 0
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement