Advertisement
Guest User

Untitled

a guest
Dec 26th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE VASILHAME_CAPA
  2. (
  3.   CODIGO            NUMBER(10) DEFAULT 0 NOT NULL,
  4.   DATA_CRIACAO      DATE DEFAULT TO_DATE('1980/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
  5.   USUARIO           NUMBER(10) DEFAULT 0,
  6.   CODIGO_BARRA      VARCHAR2(50) DEFAULT 0 NOT NULL,
  7.   SITUACAO          NUMBER(5) DEFAULT 0,
  8.   TIPO_MOVIMENTACAO NUMBER(5) DEFAULT 0,
  9.   MOTIVO            NUMBER(5) DEFAULT 0,
  10.   LOJA              NUMBER(10) DEFAULT 0 NOT NULL,
  11.   LOJAINCLUSAO      INTEGER DEFAULT 0,
  12.   DATAINCLUSAO      DATE DEFAULT TO_DATE('1980/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
  13.   CODUSUINCLUSAO    INTEGER DEFAULT 0,
  14.   NOMEUSUINCLUSAO   VARCHAR2(50) DEFAULT ' ',
  15.   LOJAALTERACAO     INTEGER DEFAULT 0,
  16.   DATAALTERACAO     DATE DEFAULT TO_DATE('1980/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
  17.   CODUSUALTERACAO   INTEGER DEFAULT 0,
  18.   NOMEUSUALTERACAO  VARCHAR2(50) DEFAULT ' ',
  19.   IDEXEOPERACAO     VARCHAR2(15) DEFAULT ' ',
  20.   NOMEEXEOPERACAO   VARCHAR2(20) DEFAULT ' ',
  21.   VRSEXEOPERACAO    VARCHAR2(15) DEFAULT ' ',
  22.   VRSBANCOOPERACAO  INTEGER DEFAULT 0
  23. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement