/* Table ABONNE */ CREATE TABLE ABONNE ( NUMABONNE NUMABONNE NOT NULL, NUMSOUSCRIPT NUMABONNE, NUMCONTRAT NUMABONNE, GENRE SEXE, NOM VARCHAR(50), LGT VARCHAR(4), CODINSEE JOURNAL, ADRESSE VARCHAR(100), BOITPOST VARCHAR(15), TELDOM VARCHAR(14), TELBURO VARCHAR(14), TELCEL VARCHAR(14), DTABON DAT, DTSAISIE DAT, LETWLC BOOL, CODOPE LOGIN, RUTA NBPRISE, CBOR CODE, NATION VARCHAR(10), CAUTION PRICE, TRAVAIL VARCHAR(20), CODRGT CODE, NUMTVA VARCHAR(10), SOLDE PRICE, LOCALIZATION INSEE, CEDULA VARCHAR(20), NUMID NUMABONNE, INTERNET VARCHAR(62), HABITACION SMALLINT, LIMITPPV PRICE, ASUJETIV DOM_BOOL, VENCELGT TIMESTAMP, TIPO VARCHAR(1), NITREAL VARCHAR(25), NUME_HOGAR VARCHAR(8), CPROV VARCHAR(3), CCANTON VARCHAR(3), CDISTRI VARCHAR(3), CLAVEDLA VARCHAR(8), TIPOFACT CHAR(4), TEMPORAL INTEGER, TELFAX VARCHAR(14), MULTA DOM_BOOL ) --- /* Table ABONNEPPV */ CREATE TABLE ABONNEPPV ( NUMORDREPPV NUMABONNE NOT NULL, NUMABONNE NUMABONNE, DTSAISIE DAT, NUMTRANSACDLA NUMABONNE, NUMEVENT INTEGER, NUMSERIE CHAR(15), DTFACT TIMESTAMP ) --- /* Table ABONNEPPVPROB */ CREATE TABLE ABONNEPPVPROB ( NUMORDREPPV NUMABONNE NOT NULL, DTSAISIE DAT, NUMSERIE CHAR(15), NUMABONNE INTEGER ) --- /* Table ACTUALIZACION */ CREATE TABLE ACTUALIZACION ( NUMABONNE NUMABONNE NOT NULL, OPTICNODE VARCHAR(9), NUMTAP VARCHAR(9), SORTIETAP SMALLINT ) --- /* Table AG */ CREATE TABLE AG ( NUMABONNE NUMABONNE NOT NULL, SOLD1 PRICE, SOLD2 PRICE, SOLD3 PRICE, SOLD4 PRICE, SOLD5 PRICE ) --- /* Table AMNETINFO */ CREATE TABLE AMNETINFO ( FICHEID INTEGER NOT NULL, PRECIOS BLOB SUB_TYPE 1 SEGMENT SIZE 80, CANALES BLOB SUB_TYPE 1 SEGMENT SIZE 80, NOTICIAS BLOB SUB_TYPE 1 SEGMENT SIZE 80, TELEFONO BLOB SUB_TYPE 1 SEGMENT SIZE 80, PROMOCION BLOB SUB_TYPE 1 SEGMENT SIZE 80, AVERIAS BLOB SUB_TYPE 1 SEGMENT SIZE 80, COBERINTERNET BLOB SUB_TYPE 1 SEGMENT SIZE 80, VENTAS BLOB SUB_TYPE 1 SEGMENT SIZE 80, RHUMANO BLOB SUB_TYPE 1 SEGMENT SIZE 80, INFOLOGIC BLOB SUB_TYPE 1 SEGMENT SIZE 80, INFORADIOS BLOB SUB_TYPE 1 SEGMENT SIZE 80 ) --- /* Table AVERINTERNET */ CREATE TABLE AVERINTERNET ( NUMLLAMADA INTEGER NOT NULL, NUMABONNE INTEGER NOT NULL, NUMOT INTEGER, FECHAINI TIMESTAMP, HORAINI VARCHAR(5), USUARIOINI VARCHAR(10), MOTIVO VARCHAR(4), RESPUESTA VARCHAR(4), OBSERVACION VARCHAR(4096), ESTADO CHAR(1) NOT NULL, GRUPOLATE VARCHAR(4), FECHAFINAL TIMESTAMP, HORAFINAL VARCHAR(5), USUARIOFIN VARCHAR(10), NUMCASO INTEGER, PRIORIDAD INTEGER ) --- /* Table BLOCNOTE */ CREATE TABLE BLOCNOTE ( NUMBN NUMABONNE NOT NULL, NUMABONNE NUMABONNE, DTSAISIE DAT, LIB VARCHAR(50), CODOPE VARCHAR(10) ) --- /* Table CABLEMODEMSERV */ CREATE TABLE CABLEMODEMSERV ( ORDRE INTEGER NOT NULL, NUMSERIE VARCHAR(40), MACADDRESS VARCHAR(15), TIPOEQUIPO VARCHAR(12), FECHAVENCIM TIMESTAMP, PROPIETARIO VARCHAR(12), NUMCLIALOPA VARCHAR(10), POLITICA CHAR(10) ) --- /* Table CAJACAJERO */ CREATE TABLE CAJACAJERO ( NUMMOUVEMENT NUMABONNE NOT NULL, HEURE HEURE, DTCPT DAT, CASHIER LOGIN, CASHEFECTIVOCOL PRICE, CASHEFECTIVODOL PRICE, CASHCHEQUECOL PRICE, CASHCHEQUEDOL PRICE, CASHBANCODEPOSIT PRICE, CASHDIFER PRICE, CASHVOUCHERCREST PRICE, CASHVOUCHERCREDOMATIC PRICE, CASHVOUCHERAVAL PRICE, CASHDIFERCANAL PRICE, CASHDIFERSISTEMAS PRICE, COMMENT CHAR(200), CAMBIO PRICE, COMISION PRICE, DIFERCAMBIO PRICE, DIFERCORTE PRICE, PCOBRAREMPLEA PRICE, DIFERCAJERO PRICE ) --- /* Table CAJAPRINC */ CREATE TABLE CAJAPRINC ( NUMMOUVEMENT NUMABONNE NOT NULL, HEURE HEURE, CODOPE LOGIN, DTCPT DAT, NUMLOTE VARCHAR(10), CASHIER LOGIN, TOTEFECTIVO PRICE, TOTCHEQUE PRICE, TOTBANCRECEN PRICE, TOTCREDOMATIC PRICE, TOTAVAL PRICE, TOTOTRO PRICE, TOTCREST PRICE, TOTBANCO PRICE, CASHEFECTIVOCOL PRICE, CASHEFECTIVODOL PRICE, CASHCHEQUECOL PRICE, CASHCHEQUEDOL PRICE, CASHBANCODEPOSIT PRICE, CASHDIFER PRICE, CASHVOUCHERCREST PRICE, CASHVOUCHERCREDOMATIC PRICE, CASHVOUCHERAVAL PRICE, CASHDIFERCANAL PRICE, CASHDIFERSISTEMAS PRICE, COMMENT CHAR(200), CAMBIO PRICE, COMISION PRICE, TOTBSJ PRICE, DIFERCAMBIO PRICE, DIFERCORTE PRICE, PCOBRAREMPLEA PRICE, DIFERCAJERO PRICE, TIPO CHAR(5), OFICINA CHAR(4), AVALMILLAS PRICE, TOTAVALMILLAS PRICE, CASHAVALMILLAS PRICE, DIFERAVALMILLAS PRICE ) --- /* Table CAMBIOCOLILLA */ CREATE TABLE CAMBIOCOLILLA ( NUMCAMBIO NUMABONNE NOT NULL, NUMABONNE NUMABONNE NOT NULL, NUMSOUSCRIPT NUMABONNE, NOM VARCHAR(50), DTSAISIE DAT, CODOPE VARCHAR(10) ) --- /* Table CANTONES */ CREATE TABLE CANTONES ( CCANTON VARCHAR(3) NOT NULL, NCANTON VARCHAR(50), CPROV VARCHAR(2) NOT NULL, CPAIS VARCHAR(3) ) --- /* Table CDDTRCONDI */ CREATE TABLE CDDTRCONDI ( NUMABONNE INTEGER, OFICIAL CHAR(10), FECHA TIMESTAMP, ESTCTA VARCHAR(1), INST VARCHAR(1), AVE VARCHAR(1), TEXT VARCHAR(1), TINST VARCHAR(1), DEV VARCHAR(1), DES VARCHAR(1), RECO VARCHAR(1), PREM VARCHAR(1), STEC VARCHAR(1), SALDO VARCHAR(1), VENTAS VARCHAR(1), VARIOS VARCHAR(1), OBSERV VARCHAR(100), TELEFONO VARCHAR(14), EMISOR VARCHAR(50), CMBTAR VARCHAR(1), EXCTAR VARCHAR(1), INCTAR VARCHAR(1) ) --- /* Table CIUDADES */ CREATE TABLE CIUDADES ( CODIGO INTEGER NOT NULL, DESCRIPCION VARCHAR(50) ) --- /* Table CLOSING */ CREATE TABLE CLOSING ( DTCLOS DAT NOT NULL ) --- /* Table COMMUNE */ CREATE TABLE COMMUNE ( CODINSEE JOURNAL NOT NULL, NOM LIBELLE, NBPREV NBPRISE, NUMSOC NUMLOGIC NOT NULL ) --- /* Table COMPTA */ CREATE TABLE COMPTA ( PERIODE MOIS NOT NULL, CAMBIO PRICE, STATUS CODE ) --- /* Table COMPTE */ CREATE TABLE COMPTE ( CPTNUM VARCHAR(20) NOT NULL, LIB VARCHAR(50) ) --- /* Table CONFIGURACION */ CREATE TABLE CONFIGURACION ( DESC3 PRICE, DESC6 PRICE, DESC9 PRICE, DESC12 PRICE, TIPOMULTA CHAR(1), MULTA PRICE, PASSENCRYP CHAR(1), AVALMILLAS PRICE, AVALMONTO PRICE, FACTORAVAL PRICE, RUTA_PPV_WIN VARCHAR(30), RUTA_PPV_LINUX VARCHAR(30), ALOPA DOM_BOOL, PNODESCO CHAR(4), PDESCOTRAS CHAR(4), PDESCONORM CHAR(4), COD_DEPOSITO CODE, COST_INS CODE ) --- /* Table CONTACTOS */ CREATE TABLE CONTACTOS ( NUMCONTACTO INTEGER NOT NULL, NUMABONNE INTEGER NOT NULL, NOMBRE VARCHAR(50) NOT NULL, TELEFONO1 VARCHAR(10), TELEFONO2 VARCHAR(10) NOT NULL, EMAIL VARCHAR(50), APARTADO VARCHAR(15) ) --- /* Table CONTRAT */ CREATE TABLE CONTRAT ( TYPCTRT CODE, DTLASTMODIF DAT, DTRESI DAT, CODRESI CODE, CODRGT CODE, CODVDS CODE, CODPROV CODE, COMMENT VARCHAR(100), NUMABONNE NUMABONNE NOT NULL, AMPLIACION CHAR(1), INSINMEDIATA CHAR(1), TIPOTRABAJO CHAR(4) ) --- /* Table CORREOS */ CREATE TABLE CORREOS ( NUMMAIL INTEGER NOT NULL, ORDRE INTEGER, NUMINTER INTEGER, LOGIN VARCHAR(25), DOMINIO VARCHAR(25), PASSWD VARCHAR(20), CAPACITY PRICE, ESTADO CHAR(1), DTSAISIE DAT, DTMENS DAT, DTRESI DAT, MOVIMIENTO CHAR(3) ) --- /* Table CREDFISCAL */ CREATE TABLE CREDFISCAL ( NUMABONNE NUMABONNE NOT NULL, NUMREGISTRO VARCHAR(10), ACTIVIDAD VARCHAR(50) ) --- /* Table DECOLUNES */ CREATE TABLE DECOLUNES ( NUMABONNE NUMABONNE NOT NULL, SALDO PRICE, CODOPE LOGIN, DTSAISIE TIMESTAMP, NOM VARCHAR(50), JOUR VARCHAR(10), CODINSEE INSEE ) --- /* Table DEMENAGE */ CREATE TABLE DEMENAGE ( NUMABONNE NUMABONNE NOT NULL, ADRESSE COMMENTAIRE, CODINSEE INSEE, TELDOM TELEPHONE, DTRACC DAT, CODINT CODE, COMMENT COMMENTAIRE, LOCA CHAR(11), LOCALIZATION CHAR(11), OPTICNODE LIBCOURT ) --- /* Table DEPOSITOS */ CREATE TABLE DEPOSITOS ( NUMABONNE INTEGER NOT NULL, DEPOSITO PRICE NOT NULL, ESTADO DOM_BOOL NOT NULL, RECIBO INTEGER, CODOPE VARCHAR(10), FECHA TIMESTAMP ) --- /* Table DERECHOS_REPORTE */ CREATE TABLE DERECHOS_REPORTE ( GRUPO CODE, REPORTE VARCHAR(50) ) --- /* Table DETEC */ CREATE TABLE DETEC ( NUMPIECE PIECECPT NOT NULL, CODPROD CODE NOT NULL, MTT PRICE, CODTVA CODE, NUMJRNL JOURNAL, CANTIDAD INTEGER ) --- /* Table DETECHQ */ CREATE TABLE DETECHQ ( NUMPIECE PIECECPT NOT NULL, NUMCHQ LIBCOURT, BANKCHQ LIBELLE, EMISOR VARCHAR(25), NUMCARD VARCHAR(16), NUMAUTORIZ VARCHAR(16), TARJETAHABIENTE VARCHAR(40), MILLAS PRICE, PAQUETE CHAR(4) ) --- /* Table DETINTER */ CREATE TABLE DETINTER ( NUMINTER NUMABONNE NOT NULL, CODPROD CODE NOT NULL, QTEDMD SMALLINT, MOVIMIENTO CHAR(3), ESTADO DOM_BOOL, ORDREVTE INTEGER NOT NULL, TIPO VARCHAR(1), MOTIVO CHAR(4) ) --- /* Table DETINTER_TEMP */ CREATE TABLE DETINTER_TEMP ( NUMINTER NUMABONNE NOT NULL, ORDRE INTEGER NOT NULL, NUMSERIE CHAR(15), CODPROD CODE NOT NULL, TIPOACCION CHAR(3), ACCRESULT VARCHAR(50), OPTICNODE LIBCOURT ) --- /* Table DETINTERMAT */ CREATE TABLE DETINTERMAT ( NUMINTER NUMABONNE NOT NULL, CODMAT CHAR(9) NOT NULL, QTEINST SMALLINT ) --- /* Table DICO */ CREATE TABLE DICO ( OBJID INTEGER, VERSION SMALLINT, NAME VARCHAR(31), ALIASNAME VARCHAR(31), TYPEID INTEGER, MISCINFO1 INTEGER, MISCINFO2 INTEGER, SRCOBJID INTEGER, SRCVERSION SMALLINT, DESTOBJID INTEGER, DESTVERSION SMALLINT, OUTOFDATE VARCHAR(1), CREATEDATE TIMESTAMP, LASTUPDATE TIMESTAMP, INFOBLOB BLOB SUB_TYPE 0 SEGMENT SIZE 80, MISCINFO3 INTEGER ) --- /* Table DISTRITOS */ CREATE TABLE DISTRITOS ( CDISTRI VARCHAR(3) NOT NULL, NDISTRI VARCHAR(50), CCANTON VARCHAR(3) NOT NULL, CPROV VARCHAR(2) NOT NULL, CPAIS VARCHAR(3) ) --- /* Table DROITS */ CREATE TABLE DROITS ( DROIT CODE NOT NULL, LIB LIBELLE, SOCIO DOM_BOOL, NUEVOSOCIO DOM_BOOL, CONSULTSOCIO DOM_BOOL, MODIFSOCIO DOM_BOOL, MODIFINTERNET DOM_BOOL, CAMBIOSERV DOM_BOOL, REACTIV DOM_BOOL, COMPLETEOT DOM_BOOL, MODIFOT DOM_BOOL, DESCO DOM_BOOL, RECO DOM_BOOL, TRASLADO DOM_BOOL, COLILLA DOM_BOOL, CONTA DOM_BOOL, FACTURA DOM_BOOL, PAGOCONLOTE DOM_BOOL, REIMBULSO DOM_BOOL, NOTACRED DOM_BOOL, DEVUELTO DOM_BOOL, NOTADEBITO DOM_BOOL, PAGOSINLOTE DOM_BOOL, RECONCIL DOM_BOOL, LOTECAJA DOM_BOOL, TRANSFCAJA DOM_BOOL, CIERRE DOM_BOOL, LOTENC DOM_BOOL, TRANSFNC DOM_BOOL, EDICION DOM_BOOL, EDTCOBRADOR DOM_BOOL, EXPORT DOM_BOOL, PREMIUM DOM_BOOL, TERMINAL DOM_BOOL, PELICULAS DOM_BOOL, COBRADOR DOM_BOOL, MODIFLOTECOB DOM_BOOL, MODIFCOB DOM_BOOL, COBCREARCHIVO DOM_BOOL, COBTRANSARCHIVO DOM_BOOL, FACTPRORAT DOM_BOOL, RED DOM_BOOL, FACTURACION DOM_BOOL, EDTSOCIO DOM_BOOL, EDTCLIENTE DOM_BOOL, EDTCONTA DOM_BOOL, EDTRED DOM_BOOL, EDTDIVERSO DOM_BOOL, EDTOT DOM_BOOL, ADMINISTRACION DOM_BOOL, AGENDA DOM_BOOL, PARAMETRO DOM_BOOL, DECOFALTAPAGO DOM_BOOL, CAMBIODIR DOM_BOOL ) --- /* Table ECRITCPT */ CREATE TABLE ECRITCPT ( NUMPIECE PIECECPT NOT NULL, NUMABONNE NUMABONNE, PERIODE MOIS, DTCPT DAT, DTSAISIE DAT, NUMJRNL JOURNAL, LIB VARCHAR(50), NUMFACT PIECECPT, MTTDEB PRICE, MTTCRED PRICE, MDRGLT CODE, MOTIFIMP CODE, CODOPE LIBCOURT, ENCAISSE PRICE, RESTE PRICE, CODINSEE INSEE, TYPEC CODE, CBOR CODE, RESUMANU INTEGER, NUMLOTE VARCHAR(10), NUMFACTURA INTEGER, RECONCIL DOM_BOOL, IMPRESO VARCHAR(1), WORKTO CODE, FACTURA VARCHAR(8), FECHA_DESDE TIMESTAMP, FECHA_HASTA TIMESTAMP ) --- /* Table ESTCTA_031 */ CREATE TABLE ESTCTA_031 ( NUMABONNE NUMABONNE NOT NULL, NUMSOUSCRIPT NUMABONNE, NOM VARCHAR(50), ADRESSE VARCHAR(100), PERIODE MOIS, DT DAT, TITULOSALDO VARCHAR(20), SOLDMESANTES PRICE, SERVICIO1 VARCHAR(25), SERVMTT1 PRICE, SERVICIO2 VARCHAR(25), SERVMTT2 PRICE, SERVICIO3 VARCHAR(25), SERVMTT3 PRICE, SERVICIO4 VARCHAR(25), SERVMTT4 PRICE, NUEVOSALDO PRICE, RUTA NBPRISE, VENCIMIENTO DAT, TELDOM VARCHAR(14), DESDE DAT, HASTA DAT, MTT5 PRICE, CBOR CODE, PAGODESPUES PRICE, MULTAPLICADA CHAR(4), NUEVOSALDOCOL PRICE, PAGOOFICINA CHAR(10), FACTURA INTEGER, SERVICIO5 VARCHAR(25), SERVMTT5 PRICE, SERVICIO6 VARCHAR(25), SERVMTT6 PRICE, SERVICIO7 VARCHAR(25), SERVMTT7 PRICE, SERVICIO8 VARCHAR(25), SERVMTT8 PRICE, SERVICIO9 VARCHAR(25), SERVMTT9 PRICE, SERVICIO10 VARCHAR(25), SERVMTT10 PRICE, MULTA PRICE, FACTURA_TC INTEGER, MONTO_MULTA PRICE, MONTO_FACTURA PRICE, MONTO_FACTURA_TC PRICE, NOTA_CRED1 VARCHAR(50), MTT_NOTA_CRED1 PRICE, NOTA_CRED2 VARCHAR(50), MTT_NOTA_CRED2 PRICE, NOTA_CRED3 VARCHAR(50), MTT_NOTA_CRED3 PRICE, NOTA_CREDTC1 VARCHAR(50), MTT_NOTA_CREDTC1 PRICE, NOTA_CREDTC2 VARCHAR(50), MTT_NOTA_CREDTC2 PRICE, NOTA_CREDTC3 VARCHAR(50), MTT_NOTA_CREDTC3 PRICE, QTYS1 SMALLINT, QTYS2 SMALLINT, QTYS3 SMALLINT, QTYS4 SMALLINT, QTYS5 SMALLINT, QTYS6 SMALLINT, QTYS7 SMALLINT, QTYS8 SMALLINT, QTYS9 SMALLINT, QTYS10 SMALLINT, TOTAL_IMPUESTOS PRICE, ASUJETI CHAR(4), MONTOMES PRICE, DESDE1 DAT, HASTA1 DAT, CODPROD1 CHAR(4), CODPROD2 CHAR(4), CODPROD3 CHAR(4), CODPROD4 CHAR(4), CODPROD5 CHAR(4), CODPROD6 CHAR(4), CODPROD7 CHAR(4), CODPROD8 CHAR(4), CODPROD9 CHAR(4), CODPROD10 CHAR(4), ASUJETIV DOM_BOOL, ULT_PAGO TIMESTAMP ) --- /* Table FACTRECIBO */ CREATE TABLE FACTRECIBO ( NUMABONNE NUMABONNE NOT NULL, NUMSOUSCRIPT NUMABONNE, NOMBREPAGADOR VARCHAR(50), ADRESSE VARCHAR(100), PERIODE MOIS, RUTA NBPRISE, TELDOM VARCHAR(14), NOMBRECBOR VARCHAR(25), SERV0 VARCHAR(25), MTT0 PRICE, MTT0G PRICE, MTTDOL0 PRICE, SERV1 VARCHAR(25), MTT1 PRICE, MTT1G PRICE, MTTDOL1 PRICE, SERV2 VARCHAR(25), MTT2 PRICE, MTT2G PRICE, MTTDOL2 PRICE, SERV3 VARCHAR(25), MTT3 PRICE, MTT3G PRICE, MTTDOL3 PRICE, SERV4 VARCHAR(25), MTT4 PRICE, MTT4G PRICE, MTTDOL4 PRICE, SERV5 VARCHAR(25), MTT5 PRICE, MTT5G PRICE, MTTDOL5 PRICE, SERV6 VARCHAR(25), MTT6 PRICE, MTT6G PRICE, MTTDOL6 PRICE, SERV7 VARCHAR(25), MTT7 PRICE, MTT7G PRICE, MTTDOL7 PRICE, SERV8 VARCHAR(25), MTT8 PRICE, MTT8G PRICE, MTTDOL8 PRICE, SERV9 VARCHAR(25), MTT9 PRICE, MTT9G PRICE, MTTDOL9 PRICE, SERV10 VARCHAR(25), MTT10 PRICE, MTT10G PRICE, MTTDOL10 PRICE, SERV11 VARCHAR(25), MTT11 PRICE, MTT11G PRICE, MTTDOL11 PRICE, TVAPROD PRICE, TOTALAPAGAR PRICE, DESDEHASTA VARCHAR(20), FECHASPAGOS CHAR(36), FACTURA INTEGER ) --- /* Table HEADEND */ CREATE TABLE HEADEND ( CODIGO_HEADEND VARCHAR(5) NOT NULL, NOMBRE_HEADEND VARCHAR(25) ) --- /* Table HISTERMINAL */ CREATE TABLE HISTERMINAL ( NUMHIST INTEGER NOT NULL, NUMSERIE CHAR(15), NUMABONNE NUMABONNE, FECHAMOVI DAT, CODOPE VARCHAR(10), TIPOMOVIMIENTO CHAR(3), COMMENT VARCHAR(50) ) --- /* Table HISTORICO_NUMCONTRAT */ CREATE TABLE HISTORICO_NUMCONTRAT ( NUMABONNE INTEGER NOT NULL, NUMCONTRAT_VIEJO INTEGER, NOM VARCHAR(50) ) --- /* Table HUB */ CREATE TABLE HUB ( CODIGO_HUB VARCHAR(5) NOT NULL, NOMBRE_HUB VARCHAR(25), CODIGO_HEADEND VARCHAR(5) NOT NULL ) --- /* Table IMPAYE */ CREATE TABLE IMPAYE ( NUMIMP NUMABONNE NOT NULL, NUMPIECE PIECECPT NOT NULL, NUMABONNE NUMABONNE NOT NULL, PERIODE DAT, MTT PRICE, MOTIF CODE, LIB LIBELLE, DTPAIE TIMESTAMP, ESTADO DOM_BOOL ) --- /* Table INTERNET */ CREATE TABLE INTERNET ( NUMABONNE NUMABONNE NOT NULL, SYSTEMEOPE VARCHAR(11), RACSANAME VARCHAR(50), EQUIPEMENT VARCHAR(20), CONTACTO VARCHAR(25), LOGINCOMMUT VARCHAR(25), CABLEMODEM VARCHAR(15), RACSANUMCONTRAT INTEGER, TIPOCABLEMODEM CHAR(6), USERNAME VARCHAR(50), FECHAVENCE TIMESTAMP, ORDRE INTEGER ) --- /* Table INTERVENANT */ CREATE TABLE INTERVENANT ( CODINT CODE NOT NULL, NOM VARCHAR(42), ACTIVIDAD BOOL, TIPO CODE, CODINSEE CHAR(3), PRIORIDAD INTEGER, EMAIL VARCHAR(50), MSGCORTO VARCHAR(50) ) --- /* Table INTERVENTION */ CREATE TABLE INTERVENTION ( NUMINTER NUMABONNE NOT NULL, NUMABONNE NUMABONNE, DTDEB DAT, DTFIN DAT, HEURE HEURE, OPESAISIE LOGIN, OPEMODIF LOGIN, MOTIF CODE, PANNE CODE, REPONSE CODE, SIEGE CODE, INTERVENANT CODE, DETMOTIF LIBLG, DETPANNE LIBLG, DETREP LIBLG, LIB LIBELLE, NUMRDV NUMABONNE, LATE CODE, HEUREDEB HEURE, HEUREFIN HEURE, DTCLOS DAT, DTEDTOR DAT, HRCLOS HEURE, TRASDEB HEURE, TRASFIN HEURE, TIPO CODE, DTOTAVERIA TIMESTAMP, GRUPOLATE CODE, ESTADO DOM_BOOL, ROLLINICIAL TIMESTAMP, ROLLFINAL TIMESTAMP, TIPOINSTAL CHAR(1), FECH_CHG_GRUPO TIMESTAMP, HORA_CHG_GRUPO CHAR(5) ) --- /* Table IPSERV */ CREATE TABLE IPSERV ( NUMIP INTEGER NOT NULL, ORDRE INTEGER NOT NULL, BLOCKIP VARCHAR(19), ETHERNETIP VARCHAR(15), MASKIP VARCHAR(15), RFIP VARCHAR(15), CODELUGAR CHAR(4), NUMLUGAR SMALLINT ) --- /* Table JOURNAL */ CREATE TABLE JOURNAL ( NUMJRNL JOURNAL NOT NULL, LIB LIBELLE, TIPOJRNL CHAR(1) ) --- /* Table LATE */ CREATE TABLE LATE ( CODLATE CODE NOT NULL, LIB LIBELLE ) --- /* Table LINEUP */ CREATE TABLE LINEUP ( NUMCANAL INTEGER NOT NULL, NOM LIBELLE ) --- /* Table LOCALIZACION_NODO */ CREATE TABLE LOCALIZACION_NODO ( CODIGO_HEADEND VARCHAR(5), CODIGO_HUB VARCHAR(5), CODINSEE INSEE NOT NULL, LOCALISATION INSEE NOT NULL, NUMNODE LIBCOURT NOT NULL ) --- /* Table LOCALIZATION */ CREATE TABLE LOCALIZATION ( CODINSEE INSEE NOT NULL, LOCALISATION INSEE NOT NULL, LIB VARCHAR(25), PRINTO CODE, CPAIS VARCHAR(3), CPROV VARCHAR(3), CCANTON VARCHAR(3), CDISTRI VARCHAR(3) ) --- /* Table LOGINS */ CREATE TABLE LOGINS ( NUMLOGIN INTEGER NOT NULL, ORDRE INTEGER, PASSWD VARCHAR(20), DTSAISIE DAT, USUARIO VARCHAR(50) ) --- /* Table LOGRELOJ */ CREATE TABLE LOGRELOJ ( ID INTEGER NOT NULL, LOGIN CHAR(10), AUTORIZA CHAR(10), FECHA TIMESTAMP, HORA CHAR(10), MINUTOS INTEGER ) --- /* Table LOTE_DESC_RACSA */ CREATE TABLE LOTE_DESC_RACSA ( ORDRE INTEGER NOT NULL, INTE VARCHAR(15), FECHA_CARGA TIMESTAMP, CODOPE VARCHAR(10), NUMCLIALOPA VARCHAR(10), ESTADO DOM_BOOL, FECHA_DESCO TIMESTAMP ) --- /* Table LOTE_RECO_RACSA */ CREATE TABLE LOTE_RECO_RACSA ( ORDRE INTEGER NOT NULL, INTE VARCHAR(15), FECHA_CARGA TIMESTAMP, CODOPE VARCHAR(10), NUMCLIALOPA VARCHAR(10), ESTADO DOM_BOOL, FECHA_DESCO TIMESTAMP, NUMINTER INTEGER ) --- /* Table MATERIAL */ CREATE TABLE MATERIAL ( CODMAT CHAR(9) NOT NULL, NOM LIBELLE, TIPOMAT CODE, PRIX PRICE, ORDEN_REPORTE INTEGER, ACTIVO DOM_BOOL ) --- /* Table MATRIZ_MAX_SERVICIOS */ CREATE TABLE MATRIZ_MAX_SERVICIOS ( CODPROD CODE NOT NULL, MAXIMO INTEGER NOT NULL ) --- /* Table MATRIZ_NO_COMBINA */ CREATE TABLE MATRIZ_NO_COMBINA ( CODPROD CODE NOT NULL, CODPROD_NO_COMBO CODE NOT NULL ) --- /* Table MATRIZ_OPCIONES */ CREATE TABLE MATRIZ_OPCIONES ( NUM_OPCION CHAR(1) NOT NULL, DESC_OPCION VARCHAR(50) ) --- /* Table MATRIZ_REGLAS */ CREATE TABLE MATRIZ_REGLAS ( LN SMALLINT NOT NULL, MAXSERVICIOS DOM_BOOL NOT NULL, NOCOMBINA DOM_BOOL NOT NULL, SERVOBLIGATORIO DOM_BOOL NOT NULL, DEBECOMBINAR DOM_BOOL NOT NULL ) --- /* Table MATRIZ_REGLAS_OT */ CREATE TABLE MATRIZ_REGLAS_OT ( NUM_OPCION CHAR(1) NOT NULL, LINEA INTEGER NOT NULL, TIPO CHAR(1), GRUPOLATE CHAR(4) ) --- /* Table MATRIZ_SERV_OBLIGATORIO */ CREATE TABLE MATRIZ_SERV_OBLIGATORIO ( CODPROD CODE NOT NULL ) --- /* Table MATRIZ_SI_COMBINA */ CREATE TABLE MATRIZ_SI_COMBINA ( CODPROD CODE NOT NULL, CODPROD_SI_COMBO CODE NOT NULL ) --- /* Table MOORE */ CREATE TABLE MOORE ( NUMABONNE NUMABONNE NOT NULL, NUMSOUSCRIPT NUMABONNE, NOM VARCHAR(50), ADRESSE VARCHAR(100), PERIODE MOIS, DT DAT, TITULOSALDO VARCHAR(20), SOLDMESANTES PRICE, CODPROD0 CHAR(4), SERVICIO0 VARCHAR(25), CANT0 INTEGER, SERVMTT0 PRICE, SERVMTTDOL0 PRICE, SERVMTT0G PRICE, CODPROD1 CHAR(4), SERVICIO1 VARCHAR(25), CANT1 INTEGER, SERVMTT1 PRICE, SERVMTTDOL1 PRICE, SERVMTT1G PRICE, CODPROD2 CHAR(4), SERVICIO2 VARCHAR(25), CANT2 INTEGER, SERVMTT2 PRICE, SERVMTTDOL2 PRICE, SERVMTT2G PRICE, CODPROD3 CHAR(4), SERVICIO3 VARCHAR(25), CANT3 INTEGER, SERVMTT3 PRICE, SERVMTTDOL3 PRICE, SERVMTT3G PRICE, CODPROD4 CHAR(4), SERVICIO4 VARCHAR(25), CANT4 INTEGER, SERVMTT4 PRICE, SERVMTTDOL4 PRICE, SERVMTT4G PRICE, CODPROD5 CHAR(4), SERVICIO5 VARCHAR(25), SERVMTT5 PRICE, CANT5 INTEGER, SERVMTTDOL5 PRICE, SERVMTT5G PRICE, CODPROD6 CHAR(4), SERVICIO6 VARCHAR(25), SERVMTT6 PRICE, SERVMTTDOL6 PRICE, SERVMTT6G PRICE, CODPROD7 CHAR(4), SERVICIO7 VARCHAR(25), CANT7 INTEGER, SERVMTT7 PRICE, SERVMTTDOL7 PRICE, SERVMTT7G PRICE, CODPROD8 CHAR(4), SERVICIO8 VARCHAR(25), CANT8 INTEGER, SERVMTT8 PRICE, SERVMTTDOL8 PRICE, SERVMTT8G PRICE, CODPROD9 CHAR(4), SERVICIO9 VARCHAR(25), CANT9 INTEGER, SERVMTT9 PRICE, SERVMTTDOL9 PRICE, SERVMTT9G PRICE, CODPROD10 CHAR(4), SERVICIO10 VARCHAR(25), CANT10 INTEGER, SERVMTT10 PRICE, SERVMTTDOL10 PRICE, SERVMTT10G PRICE, CODPROD11 CHAR(4), SERVICIO11 VARCHAR(25), CANT11 INTEGER, SERVMTT11 PRICE, SERVMTTDOL11 PRICE, SERVMTT11G PRICE, NUEVOSALDO PRICE, RUTA NBPRISE, TELDOM VARCHAR(14), NOMBRECBOR VARCHAR(25), SERV0 VARCHAR(25), MTT0 PRICE, MTT0G PRICE, SERV1 VARCHAR(25), MTT1 PRICE, MTT1G PRICE, SERV2 VARCHAR(25), MTT2 PRICE, MTT2G PRICE, SERV3 VARCHAR(25), MTT3 PRICE, MTT3G PRICE, SERV4 VARCHAR(25), MTT4 PRICE, MTT4G PRICE, SERV5 VARCHAR(25), MTT5 PRICE, MTT5G PRICE, SERV6 VARCHAR(25), MTT6 PRICE, MTT6G PRICE, SERV7 VARCHAR(25), MTT7 PRICE, MTT7G PRICE, SERV8 VARCHAR(25), MTT8 PRICE, MTT8G PRICE, SERV9 VARCHAR(25), MTT9 PRICE, MTT9G PRICE, SERV10 VARCHAR(25), MTT10 PRICE, MTT10G PRICE, SERV11 VARCHAR(25), MTT11 PRICE, MTT11G PRICE, TVAPROD PRICE, TOTALAPAGAR PRICE, CBOR CODE, PAGODESPUES PRICE, NOMBREPAGADOR VARCHAR(50), DESDEHASTA VARCHAR(20), ULTIMOPAGO DAT, COLONMESACTUAL PRICE, COLONMESANTERIOR PRICE, FECHASPAGOS CHAR(36), FACTURA INTEGER, COMMENT1 CHAR(60), COMMENT2 CHAR(60), LOCALIZATION INSEE, CAMBIODIR DOM_BOOL, NUMTAP VARCHAR(9) ) --- /* Table MOTIF */ CREATE TABLE MOTIF ( CODMOTIF CODE NOT NULL, LIB LIBELLE, CODPROD CODE, TIPO CHAR(2) ) --- /* Table NODE */ CREATE TABLE NODE ( NUMNODE LIBCOURT NOT NULL, LIB LIBELLE, NBREABONNE NUMABONNE, DOBLEVIA BOOL, ACTIVO VARCHAR(1), CODIFICADO DOM_BOOL, ESTADO INTEGER, CLASE CHAR(1), FECHA_INIC TIMESTAMP, FECHA_FINC TIMESTAMP, CANTCABLE INTEGER, STRAND INTEGER, CAPACIDAD INTEGER, KMXNODO INTEGER, COMENTARIO VARCHAR(50), COD_ENLACE VARCHAR(15), DESCRIP_ENLACE VARCHAR(30), FECHA_ENLACE TIMESTAMP, KM_ENLACE INTEGER, FIBRA_ENLACE INTEGER, COMENT_ENLACE VARCHAR(50), PUNTA_INI_ENLACE INTEGER, PUNTA_FIN_ENLACE INTEGER, CODIGO_HEADEND VARCHAR(5), CODIGO_HUB VARCHAR(5), PLAQUEADO VARCHAR(1) ) --- /* Table NODETAP */ CREATE TABLE NODETAP ( NUMNODE LIBCOURT NOT NULL, TAPINI VARCHAR(10) NOT NULL, TAPFIN VARCHAR(10) NOT NULL ) --- /* Table PAISES */ CREATE TABLE PAISES ( CPAIS VARCHAR(3) NOT NULL, NPAIS VARCHAR(50), TIPO CHAR(1) ) --- /* Table PANNE */ CREATE TABLE PANNE ( CODPANNE CODE NOT NULL, LIB LIBELLE, CODPROD CODE ) --- /* Table PARAM_COMPA */ CREATE TABLE PARAM_COMPA ( COD_PARAM_COMPA INTEGER NOT NULL, DESCRICION BLOB SUB_TYPE 0 SEGMENT SIZE 80, ESTADO BLOB SUB_TYPE 0 SEGMENT SIZE 80 ) --- /* Table PARAMETRE */ CREATE TABLE PARAMETRE ( CODTBL CODE NOT NULL, CODE CODE NOT NULL, LIBCODE LIBELLE, INFO_REQUE VARCHAR(1) ) --- /* Table PAYEUR */ CREATE TABLE PAYEUR ( NUMABONNE NUMABONNE NOT NULL, GENRE SEXE, NOM VARCHAR(50), ADRESSE VARCHAR(100), COMMUNE VARCHAR(25), TEL VARCHAR(14), BANQUE VARCHAR(25), TYPCB CODE, DTEXPIR INSEE, ZONE INSEE, CODCB VARCHAR(25), NUMID NUMABONNE, DTCBDEBUT DAT, DTCBFIN DAT, CPROV VARCHAR(3), CCANTON VARCHAR(3), CDISTRI VARCHAR(3) ) --- /* Table PBSERV */ CREATE TABLE PBSERV ( ORDRE NUMABONNE NOT NULL ) --- /* Table PPVCLASE */ CREATE TABLE PPVCLASE ( CODE CODE NOT NULL, LIBCODE VARCHAR(30) ) --- /* Table PPVRATING */ CREATE TABLE PPVRATING ( CODE CODE NOT NULL, LIBCODE VARCHAR(30) ) --- /* Table PPVTIPO */ CREATE TABLE PPVTIPO ( CODE CODE NOT NULL, LIBCODE VARCHAR(30) ) --- /* Table PRISE */ CREATE TABLE PRISE ( NUMABONNE NUMABONNE NOT NULL, CODINT CODE, NUMPLB PB, DTRACC DAT, DTCOUPE DAT, COMMENT VARCHAR(100), NUMTERM VARCHAR(9), NUMTERM2 VARCHAR(9), NUMTAP VARCHAR(9), SORTIETAP SMALLINT, ESTADO CHAR(1), PILOTO DOM_BOOL, OPTICNODE2 VARCHAR(20), CODIGO_HEADEND VARCHAR(5), CODIGO_HUB VARCHAR(5), CODIGO_RAMAL VARCHAR(3), CODIGO_TAP VARCHAR(12), OPTICNODE LIBCOURT ) --- /* Table PROB */ CREATE TABLE PROB ( NUMABONNE NUMABONNE NOT NULL, SOLDEC PRICE, SOLDDETEC PRICE ) --- /* Table PRODUIT */ CREATE TABLE PRODUIT ( CODPROD CODE NOT NULL, NOM LIBELLE, PRIX PRICE, CODTVA CODE NOT NULL, JRNLVTE JOURNAL NOT NULL, JRNLBKE JOURNAL, NATURE CODE, TAX PRICE, CPTNUM CHAR(20), DTDEB TIMESTAMP, DTFIN TIMESTAMP, PRIXDOL PRICE, PAGOMESES SMALLINT, CODINSEE INSEE, CTMODIF CODE, CTINST CODE, PRORATEO DOM_BOOL, FALTATERMINAL DOM_BOOL, FACMONTOFIJO DOM_BOOL, DOBLEVIA DOM_BOOL, PERIODICIDAD SMALLINT, FECHA_FIJA DOM_BOOL, PROMOCION DOM_BOOL, TIPO CHAR(1), NUMAPS VARCHAR(15), ALOPA VARCHAR(15), PAQRACSA CHAR(4) ) --- /* Table PROPSERV */ CREATE TABLE PROPSERV ( ORDRE NUMABONNE NOT NULL, ANCHOBANDA CODE, MEDIOTRANS CODE, METODTRANS CODE, EXCLUSIVIDAD DOM_BOOL NOT NULL ) --- /* Table PROVINCIAS */ CREATE TABLE PROVINCIAS ( CPROV VARCHAR(3) NOT NULL, NPROV VARCHAR(50), CPAIS VARCHAR(3) ) --- /* Table RAMAL */ CREATE TABLE RAMAL ( CODIGO_RAMAL VARCHAR(3) NOT NULL, NOMBRE_RAMAL VARCHAR(15), CODIGO_HEADEND VARCHAR(5) NOT NULL, CODIGO_HUB VARCHAR(5) NOT NULL, NUMNODE LIBCOURT NOT NULL ) --- /* Table RECHABONNE */ CREATE TABLE RECHABONNE ( NUMID NUMABONNE NOT NULL, ABONNE NUMABONNE, SOUSCRIT NUMABONNE, NOM LIBLG, TEL TELEPHONE, NUMCTRT NUMABONNE ) --- /* Table RECIBO */ CREATE TABLE RECIBO ( NUMRECU NUMABONNE NOT NULL, NUMABONNE NUMABONNE NOT NULL, PERIODE MOIS, DT DAT, SERVICIO1 VARCHAR(25), SERVICIO2 VARCHAR(25), SERVICIO3 VARCHAR(25), SERVICIO4 VARCHAR(25), SERVICIO5 VARCHAR(25), SERVICIO6 VARCHAR(25), MTT1 PRICE, MTT2 PRICE, MTT3 PRICE, MTT4 PRICE, MTT5 PRICE, MTT6 PRICE, MTT1G PRICE, MTT2G PRICE, MTT3G PRICE, MTT4G PRICE, MTT5G PRICE, MTT6G PRICE, MTTDOL1 PRICE, MTTDOL2 PRICE, MTTDOL3 PRICE, MTTDOL4 PRICE, MTTDOL5 PRICE, MTTDOL6 PRICE, NUEVOSALDO PRICE, PAGODESPUES PRICE, SOLDPREC PRICE, STATUT BOOL, CBOR CODE, PAGOCOBRADOR PRICE, PAGOCOBRADORDESPUES PRICE, SERVICIO7 VARCHAR(25), SERVICIO8 VARCHAR(25), SERVICIO9 VARCHAR(25), SERVICIO10 VARCHAR(25), SERVICIO11 VARCHAR(25), SERVICIO12 VARCHAR(25), MTT7 PRICE, MTT8 PRICE, MTT9 PRICE, MTT10 PRICE, MTT11 PRICE, MTT12 PRICE, MTT7G PRICE, MTT8G PRICE, MTT9G PRICE, MTT10G PRICE, MTT11G PRICE, MTT12G PRICE, MTTDOL7 PRICE, MTTDOL8 PRICE, MTTDOL9 PRICE, MTTDOL10 PRICE, MTTDOL11 PRICE, MTTDOL12 PRICE, COMMENT1 CHAR(60) ) --- /* Table RECU */ CREATE TABLE RECU ( NUMRECU NUMABONNE NOT NULL, NUMABONNE NUMABONNE, MDRGT CODE, SOLDE PRICE, PERIODE MOIS, DTPAIE DAT, CBOR CODE, CPT INTEGER NOT NULL, CODOPE LOGIN, CODINSEE JOURNAL ) --- /* Table RECUPIMP */ CREATE TABLE RECUPIMP ( NUMABONNE NUMABONNE NOT NULL, MTT PRICE, STATUT BOOL, TIPOPAGO CHAR(2), NUMRECU CHAR(8) ) --- /* Table REPORTES */ CREATE TABLE REPORTES ( CODIGO INTEGER NOT NULL, NOMBRE VARCHAR(50) ) --- /* Table ROLES */ CREATE TABLE ROLES ( NUMROLE NUMABONNE NOT NULL, NUMINTER NUMABONNE, TIPO CODE, DTSAISIE DAT, HRSAISIE HEURE, OPESAISIE LOGIN, FECHACITA DAT, HRCITA HEURE, OPEMODIF LOGIN, FECHAMODIF DAT, HRMODIF HEURE, OBSERVACION VARCHAR(40), STATUS DOM_BOOL, CODINT CODE, MOVIL CHAR(6), SECTOR CHAR(1), PADRINO LOGIN ) --- /* Table SALDOS_PENDIENTES */ CREATE TABLE SALDOS_PENDIENTES ( NUMABONNE INTEGER NOT NULL, SALDO PRICE NOT NULL, FECHA TIMESTAMP NOT NULL, ID_SALDOS_PENDIENTES INTEGER NOT NULL, ESTADO VARCHAR(1) NOT NULL, NUMINTER INTEGER, NUMPIECE INTEGER ) --- /* Table SCHEDULEPPV */ CREATE TABLE SCHEDULEPPV ( SCHEDID INTEGER NOT NULL, LBEN INTEGER NOT NULL, CHANNELID SMALLINT, CHANNELNAME VARCHAR(30), SCHEDSTARTDT TIMESTAMP, SCHEDSTARTTI CHAR(5), SCHEDUREE SMALLINT, DTSAISIE TIMESTAMP, SCHEDBSID INTEGER ) --- /* Table SECTOR */ CREATE TABLE SECTOR ( CODIGO INTEGER NOT NULL, DESCRIPCION VARCHAR(30), SECTOR VARCHAR(1) ) --- /* Table SERVTERMINAL */ CREATE TABLE SERVTERMINAL ( ORDRE NUMABONNE NOT NULL, CODPROD CODE, NUMSERIE CHAR(15) NOT NULL ) --- /* Table SOCIETE */ CREATE TABLE SOCIETE ( NUMSOC NUMLOGIC NOT NULL, NOM LIBELLE, NBABONNE NUMABONNE, AGENCE LIBELLE, NUMRECU NUMABONNE, TITULO1 VARCHAR(40), TITULO2 VARCHAR(40), TITULO3 VARCHAR(40), TITULO4 VARCHAR(40), OFICEID INTEGER, HEADEND SMALLINT, NOTELDLA CHAR(15), REG_BANCOS NUMLOGIC, LABL_NIV01 VARCHAR(15), LABL_NIV02 VARCHAR(15), LABL_NIV03 VARCHAR(15), LABL_NIV04 VARCHAR(15), SOCIOCOLILLA DOM_BOOL ) --- /* Table STATRECO */ CREATE TABLE STATRECO ( NUMSTATRECO NUMABONNE NOT NULL, NUMABONNE NUMABONNE NOT NULL, DTRECO DAT, DTRESI DAT ) --- /* Table TAP */ CREATE TABLE TAP ( CODIGO_TAP INTEGER NOT NULL, NOMBRE_TAP VARCHAR(25), CODIGO_HEADEND VARCHAR(5) NOT NULL, CODIGO_HUB VARCHAR(5) NOT NULL, NUMNODE LIBCOURT NOT NULL, CODIGO_RAMAL VARCHAR(3) NOT NULL, CAPACIDAD INTEGER, RANGO INTEGER, PUERTOS INTEGER, VALOR INTEGER, MARCA VARCHAR(15) ) --- /* Table TAPXNODE */ CREATE TABLE TAPXNODE ( NUMTAP CHAR(9) NOT NULL, NUMNODE CHAR(5) NOT NULL, RAMAL CHAR(5) NOT NULL, CAPACIDAD SMALLINT NOT NULL ) --- /* Table TEMP */ CREATE TABLE TEMP ( NUMPIECE NUMABONNE NOT NULL, NUMABONNE NUMABONNE, PERIODE MOIS ) --- /* Table TEMPCOMPARAINTERNET */ CREATE TABLE TEMPCOMPARAINTERNET ( NUMABONNE NUMABONNE NOT NULL, SERVIDOR VARCHAR(5), TIPOCABLEMODEM VARCHAR(6), FECHA TIMESTAMP, USUARIO VARCHAR(10), MSGERROR VARCHAR(400) ) --- /* Table TEMPDETEC */ CREATE TABLE TEMPDETEC ( NUMTEMP PIECECPT NOT NULL, CODPROD CODE NOT NULL, MTT PRICE, CODTVA CODE, NUMJRNL JOURNAL ) --- /* Table TEMPDETINTERMAT */ CREATE TABLE TEMPDETINTERMAT ( NUMINTER NUMABONNE NOT NULL, CODMAT CHAR(9) NOT NULL, QTEINST SMALLINT ) --- /* Table TEMPEC */ CREATE TABLE TEMPEC ( NUMTEMP PIECECPT NOT NULL, NUMABONNE NUMABONNE, PERIODE MOIS, DTCPT DAT, DTSAISIE DAT, NUMJRNL JOURNAL, LIB VARCHAR(50), NUMFACT PIECECPT, MTTDEB PRICE, MTTCRED PRICE, MDRGLT CODE, CODOPE LIBCOURT, CODINSEE INSEE, TYPEC CODE, CBOR CODE, RESUMANU INTEGER, NUMLOTE VARCHAR(10), MOTIFIMP CHAR(4), LIBNC VARCHAR(50), NUMCHQ LIBCOURT, BANKCHQ LIBELLE, EMISOR VARCHAR(25), NUMCARD VARCHAR(16), NUMAUTORIZ VARCHAR(16), TARJETAHABIENTE VARCHAR(40), MILLAS PRICE, PAQUETE CHAR(4) ) --- /* Table TEMPFACTPPV */ CREATE TABLE TEMPFACTPPV ( NUMABONNE NUMABONNE, MONTO PRICE, PELICULAS SMALLINT ) --- /* Table TEMPINTES */ CREATE TABLE TEMPINTES ( CUENTARACSA INTEGER, INTE VARCHAR(15), LOGIN VARCHAR(25), PAQUETE CHAR(4), NUMCONTRAT NUMABONNE, ORDRE INTEGER ) --- /* Table TEMPNODE */ CREATE TABLE TEMPNODE ( LOCALIZATION CHAR(5), NUMNODO VARCHAR(9) ) --- /* Table TEMPRACSAINTE */ CREATE TABLE TEMPRACSAINTE ( NUMABONNE NUMABONNE NOT NULL, CUENTARACSA INTEGER, INTE VARCHAR(15), LOGIN VARCHAR(50), PAQRACSA CHAR(4), MSGERROR VARCHAR(400) ) --- /* Table TERMINAL */ CREATE TABLE TERMINAL ( NUMID NUMABONNE, NUMSERIE CHAR(15) NOT NULL, MODELO CHAR(8), TIPO CHAR(2), STATUS CHAR(10), PRECIO PRICE, DTSAISIE DAT, PPV BOOL, DOBLEVIA BOOL, VOLUME BOOL, REMOTE BOOL, IPPV BOOL, FAVORITE BOOL, BSID17 BOOL, BSID20 BOOL, BSID21 BOOL, BSID22 BOOL, CREDIT SMALLINT, BSID123 BOOL, FECHAVENCE TIMESTAMP, NUME_PROMO SMALLINT, NUME_PROVI SMALLINT ) --- /* Table TERMINALBSID */ CREATE TABLE TERMINALBSID ( NUMSERIE VARCHAR(15) NOT NULL, BSID CHAR(5) NOT NULL ) --- /* Table TITLEPPV */ CREATE TABLE TITLEPPV ( LBEN INTEGER NOT NULL, MOVIENAME VARCHAR(80), DUREE SMALLINT, RATING SMALLINT, TIPOEVENT SMALLINT, DTSAISIE TIMESTAMP, PRIX PRICE, GENREEVENT SMALLINT, MOVIENAMEDLA VARCHAR(80) ) --- /* Table TRANSACDLA */ CREATE TABLE TRANSACDLA ( NUMTRANSACDLA NUMABONNE NOT NULL, DTSAISIE DAT, HEURETRANSAC CHAR(8), ENVOITRANSAC VARCHAR(250), OPETRANSAC LOGIN, RECUTRANSAC VARCHAR(150) ) --- /* Table TRANSACPPV */ CREATE TABLE TRANSACPPV ( NUMTRANSACDLA NUMABONNE NOT NULL, DTSAISIE DAT, HEURETRANSAC CHAR(8), OPETRANSAC LOGIN, RECUTRANSAC CHAR(250) ) --- /* Table TYPPARA */ CREATE TABLE TYPPARA ( CODTBL CODE NOT NULL, LIB LIBELLE ) --- /* Table TYPTVA */ CREATE TABLE TYPTVA ( CODTVA CODE NOT NULL, LIB LIBELLE, TAUX TAUX, DIVISOR PRICE ) --- /* Table UTILISATEUR */ CREATE TABLE UTILISATEUR ( LOGIN LOGIN NOT NULL, PASSE LOGIN, DROIT CODE, LIB LIBLG, DATE_PASSWORD DAT, DATE_CIERRE DAT, DATE_LOGIN DAT, HEURE_LOGIN HEURE, FECHASALIDA TIMESTAMP, EMAIL VARCHAR(50), WORKTO CODE, PRIORIDAD INTEGER, CASILLERO VARCHAR(20), CAMBIA_RELOJ VARCHAR(1), CLAVE_EMAIL VARCHAR(12), ALOPA DOM_BOOL ) --- /* Table VENTE */ CREATE TABLE VENTE ( ORDRE NUMABONNE NOT NULL, NUMABONNE NUMABONNE NOT NULL, CODPROD CODE, MTT PRICE, CODVEND CODE, CODPROV CODE, DTSAISIE DAT, DTSIGN DAT, DTMENS DAT, DTPAIE DAT, DTRESI DAT, CODRESI CODE, DTCHGTTF DAT, CTINST PRICE, CTREDUC PRICE, MTTDOL PRICE, QTEDMD SMALLINT, QTEREA SMALLINT, STATUT STATUT, CODMARK CODE, FACTPRORAT DOM_BOOL, INTE VARCHAR(15), NUM_DOCU INTEGER ) --- /* Table VISITE */ CREATE TABLE VISITE ( NUMVISITE NUMABONNE NOT NULL, NUMABONNE NUMABONNE, DTSAISIE DAT, LIB VARCHAR(50) ) --- /* Table VTE */ CREATE TABLE VTE ( NUMABONNE NUMABONNE NOT NULL, CODPROD CODE NOT NULL, NOM LIBELLE, MTT PRICE, PAIE PRICE )