1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103
| CREATE TABLE OPERATIONCOMPTABLE
(
VERSION NUMBER(6) DEFAULT 0 NULL,
ID NUMBER(20) NOT NULL,
CODEETABLISSEMENT VARCHAR2(8 BYTE) NULL,
DATECREATION TIMESTAMP(6) NULL,
DATEMODIFICATION TIMESTAMP(6) NULL,
MOISCOMPTABLE VARCHAR2(7 BYTE) NULL,
MONTANTPARTDISPONIBLE NUMBER(19,2) NULL,
MONTANTPARTPARTIESCIVILES NUMBER(19,2) NULL,
MONTANTPECULELIBERATION NUMBER(19,2) NULL,
MONTANTTOTAL NUMBER(19,2) NULL,
OBSERVATION VARCHAR2(50 BYTE) NULL,
COMPTE_OPERATIONSCOMPTABLES_FK NUMBER(20) NULL,
OPERATIONCOMPTABLE_RESERVE_FK NUMBER(20) NULL,
DATESUPPRESSION TIMESTAMP(6) NULL,
TYPEECRITURE VARCHAR2(64 BYTE) NULL
)
CREATE UNIQUE INDEX OPERATIONCOMPTABLE_PK ON OPERATIONCOMPTABLE
(ID)
LOGGING
NOPARALLEL;
-------------------------------------------------------------------------
CREATE TABLE CREDIT
(
CREDIT_OPERATIONCOMPTABLE_FK NUMBER(20) NOT NULL,
LN_MODEVERSEM_MODEVERSEMENT_FK VARCHAR2(16 BYTE) NULL,
CREDIT_CONTREECRITUREDEBIT_FK NUMBER(20) NULL
)
ALTER TABLE CREDIT ADD (
CONSTRAINT CREDIT_PK
PRIMARY KEY
(CREDIT_OPERATIONCOMPTABLE_FK)
USING INDEX CREDIT_PK);
ALTER TABLE CREDIT ADD (
CONSTRAINT CREDIT_CONTREECRITUREDEBIT_FK
FOREIGN KEY (CREDIT_CONTREECRITUREDEBIT_FK)
REFERENCES CONTREECRITUREDEBIT (CONTREECRITUREDEBIT_DEBIT_FK),
CONSTRAINT CREDIT_OPERATIONCOMPTABLE_FK
FOREIGN KEY (CREDIT_OPERATIONCOMPTABLE_FK)
REFERENCES OPERATIONCOMPTABLE (ID),
CONSTRAINT LN_MODEVERSEM_MODEVERSEMENT_FK
FOREIGN KEY (LN_MODEVERSEM_MODEVERSEMENT_FK)
REFERENCES LN_MODEVERSEMENT (CODE));
-------------------------------------------------------------
CREATE TABLE DEBIT
(
DEBIT_OPERATIONCOMPTABLE_FK NUMBER(20) NOT NULL,
NUMEROCHEQUE VARCHAR2(32 BYTE) NULL,
FICHEBENEFICIAIRE_DEBIT_FK NUMBER(20) NULL,
DECLARATION_DEBIT_FK NUMBER(20) NULL,
LN_MODEREGLEM_MODEREGLEMENT_FK VARCHAR2(16 BYTE) NULL,
LN_MODERE_MODEREGLMTCLOTURE_FK VARCHAR2(16 BYTE) NULL,
DEBIT_CONTREECRITURECREDIT_FK NUMBER(20) NULL,
DEBIT_OPERATIONLIVRET_FK NUMBER(20) NULL
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE UNIQUE INDEX DEBIT_PK ON DEBIT
(DEBIT_OPERATIONCOMPTABLE_FK)
LOGGING
NOPARALLEL;
ALTER TABLE DEBIT ADD (
CONSTRAINT DEBIT_PK
PRIMARY KEY
(DEBIT_OPERATIONCOMPTABLE_FK)
USING INDEX DEBIT_PK);
ALTER TABLE DEBIT ADD (
CONSTRAINT DEBIT_CONTREECRITURECREDIT_FK
FOREIGN KEY (DEBIT_CONTREECRITURECREDIT_FK)
REFERENCES CONTREECRITURECREDIT (CONTREECRITURECREDIT_CREDIT_FK),
CONSTRAINT DEBIT_OPERATIONCOMPTABLE_FK
FOREIGN KEY (DEBIT_OPERATIONCOMPTABLE_FK)
REFERENCES OPERATIONCOMPTABLE (ID),
CONSTRAINT DEBIT_OPERATIONLIVRET_FK
FOREIGN KEY (DEBIT_OPERATIONLIVRET_FK)
REFERENCES OPERATIONLIVRET (ID),
CONSTRAINT DECLARATION_DEBIT_FK
FOREIGN KEY (DECLARATION_DEBIT_FK)
REFERENCES DECLARATION (ID),
CONSTRAINT FICHEBENEFICIAIRE_DEBIT_FK
FOREIGN KEY (FICHEBENEFICIAIRE_DEBIT_FK)
REFERENCES FICHEBENEFICIAIRE (ID),
CONSTRAINT LN_MODEREGLEM_MODEREGLEMENT_FK
FOREIGN KEY (LN_MODEREGLEM_MODEREGLEMENT_FK)
REFERENCES LN_MODEREGLEMENT (CODE),
CONSTRAINT LN_MODERE_MODEREGLMTCLOTURE_FK
FOREIGN KEY (LN_MODERE_MODEREGLMTCLOTURE_FK)
REFERENCES LN_MODEREGLEMENTCLOTURE (CODE)); |
Partager