CREATE TABLE DAV_DAVIVIENDA_TRAN
(
   N_ID          NUMBER                          NOT NULL,
  C_CEDULA      VARCHAR2(20 BYTE)               NOT NULL,
  C_TIPO_TRANS  VARCHAR2(5 BYTE)                NOT NULL,
  N_MONTO       NUMBER                          NOT NULL,
  C_TARJETA     VARCHAR2(17 BYTE),
  C_CUENTA      VARCHAR2(32 BYTE),
  C_PRESTAMO    VARCHAR2(50 BYTE),
  C_MONEDA      VARCHAR2(3 BYTE)                NOT NULL,
  C_ESTADO      VARCHAR2(20 BYTE)               NOT NULL,
  N_REPORTE     NUMBER,
  C_COMENTARIO  VARCHAR2(100 BYTE),
  C_REF         VARCHAR2(50 BYTE)               NOT NULL,
  C_NOMBRE      NVARCHAR2(100),
  N_DOCUMENTO   NUMBER(10) NOT NULL,
  N_SOCIO NUMBER(10) NOT NULL,
  N_BODEGA NUMBER(10) NOT NULL

)
TABLESPACE WMS_TAB
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


ALTER TABLE DAV_DAVIVIENDA_TRAN ADD (
  PRIMARY KEY
 (N_ID)
    USING INDEX 
    TABLESPACE WMS_TAB
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));
