DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.11.UC1  
Copyright (C) Informix Software, Inc., 1984-1995
Software Serial Number AAB#J427560
{ TABLE "sysinfo".tetb00001 row size = 71 number of columns = 11 index size = 12 
              }
create table "sysinfo".tetb00001 
  (
    num_doc serial not null constraint "usainf01".n351_88,
    cuenta_no char(8),
    cta_banco char(13),
    procedencia smallint,
    fecha date,
    monto decimal(12,2),
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00001 from "public";

create unique index "sysinfo".ix1278_1 on "sysinfo".tetb00001 (num_doc);


{ TABLE "sysinfo".tetb00002 row size = 65 number of columns = 7 index size = 9 }
create table "sysinfo".tetb00002 
  (
    procedencia smallint not null constraint "usainf01".n352_89,
    descripcion char(30),
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00002 from "public";

create unique index "sysinfo".ix367_1 on "sysinfo".tetb00002 (procedencia);


{ TABLE "sysinfo".tetb00003 row size = 67 number of columns = 8 index size = 0 }
create table "sysinfo".tetb00003 
  (
    codigo smallint,
    descripcion char(30),
    tipo char(2),
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00003 from "public";


{ TABLE "sysinfo".tetb00004 row size = 51 number of columns = 9 index size = 0 }
create table "sysinfo".tetb00004 
  (
    codigo integer,
    ano integer,
    mes smallint,
    valor decimal(14,2),
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00004 from "public";


{ TABLE "sysinfo".tetb00005 row size = 51 number of columns = 9 index size = 0 }
create table "sysinfo".tetb00005 
  (
    codigo integer,
    ano integer,
    mes smallint,
    valor_real decimal(14,2),
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00005 from "public";


{ TABLE "sysinfo".tetb00006 row size = 49 number of columns = 8 index size = 12 }
create table "sysinfo".tetb00006 
  (
    cheque_no integer,
    banco char(8),
    codigo integer,
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00006 from "public";

create index "sysinfo".ix495_1 on "sysinfo".tetb00006 (cheque_no);


{ TABLE "sysinfo".tetb00007 row size = 51 number of columns = 8 index size = 0 }
create table "sysinfo".tetb00007 
  (
    ano integer,
    valor decimal(12,2),
    valor1 decimal(12,2),
    status_t char(1),
    us_crea char(9),
    fech_crea datetime year to minute,
    us_mod char(9),
    fech_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00007 from "public";


{ TABLE "sysinfo".tetb00008 row size = 50 number of columns = 9 index size = 0 }
create table "sysinfo".tetb00008 
  (
    sec_vend smallint,
    fecha date,
    cod_n smallint,
    porc_cobros1 decimal(8,2),
    porc_cobros2 decimal(8,2),
    us_crea char(9),
    fecha_crea datetime year to minute,
    us_mod char(9),
    fecha_mod datetime year to minute
  );
revoke all on "sysinfo".tetb00008 from "public";





