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 104 105 106
| CREATE TABLE "MAQUETTE"."" ("COMPTEUR_SAGE" NUMBER(14), "COD_FOU"
CHAR(13 byte) NOT NULL, "NOM" CHAR(32 byte) NOT NULL,
"COD_APL" VARCHAR2(10 byte), "ADR_1" VARCHAR2(32 byte),
"ADR_2" VARCHAR2(32 byte), "ADR_3" VARCHAR2(32 byte),
"COD_PST" VARCHAR2(8 byte), "VIL" VARCHAR2(32 byte), "TEL"
VARCHAR2(16 byte), "TLC" VARCHAR2(16 byte), "TLX" VARCHAR2(7
byte), "ITL" VARCHAR2(32 byte), "COD_FAM" VARCHAR2(2 byte),
"COD_SOU_FAM" VARCHAR2(2 byte), "NAT" VARCHAR2(1 byte),
"GES_STA" VARCHAR2(1 byte), "COD_LAN" VARCHAR2(2 byte),
"COD_PAY" VARCHAR2(3 byte), "COD_DVS" VARCHAR2(2 byte),
"CPT_CLF" VARCHAR2(4 byte), "CPT_AUX" CHAR(13 byte) NOT NULL,
"CRD_TOL" NUMBER(14, 3), "TIE_RGL" VARCHAR2(13 byte), "RGL"
VARCHAR2(3 byte), "FLG_DOM_BQE" VARCHAR2(1 byte), "PRC_EPT"
NUMBER(6, 4), "PRC_RIS" NUMBER(6, 4), "PRC_REM" NUMBER(6, 4),
"PRC_ACP_CMD" NUMBER(2), "PRC_ACP_LIV" NUMBER(2), "IPT_CTB"
VARCHAR2(2 byte), "FAC_EMB" VARCHAR2(1 byte), "FAC_POR"
VARCHAR2(1 byte), "FRN_POR" NUMBER(14, 3), "FAC_FRA"
VARCHAR2(1 byte), "FAC_FRS_FIX" VARCHAR2(1 byte), "COD_CTR"
VARCHAR2(4 byte), "PRC_CTR" NUMBER(6, 4), "TSP" VARCHAR2(13
byte), "NUM_TRN" NUMBER(2), "RLQ" VARCHAR2(1 byte),
"MNT_BDG_1" NUMBER(14, 3), "MNT_BDG_2" NUMBER(14, 3), "CMT"
VARCHAR2(32 byte), "NIV_ACC" NUMBER(1), "FLG_SUP" VARCHAR2(1
byte), "DRN_LTR" VARCHAR2(2 byte), "TVA_ENC" VARCHAR2(1 byte),
"DAT_CRE" NUMBER(8), "DRN_FAC" NUMBER(8), "DRN_RGL" NUMBER(8),
"DRN_CMD" NUMBER(8), "DRN_LIV" NUMBER(8), "DRN_MAJ" NUMBER(8),
"MNT_DBT" NUMBER(14, 3), "MNT_CRD" NUMBER(14, 3),
"MNT_NON_EHU" NUMBER(14, 3), "NON_FAC" NUMBER(14, 3),
"CHF_AFR" NUMBER(14, 3), "EDI_COM" VARCHAR2(1 byte),
"MDL_CMD" VARCHAR2(3 byte), "NBR_EXL_CMD" NUMBER(1),
"EDI_REF_COM" VARCHAR2(1 byte), "EDI_PRX_COM" VARCHAR2(1
byte), "MNT_LBR_1" NUMBER(14, 3), "MNT_LBR_2" NUMBER(14, 3),
"DAT_LBR_1" NUMBER(8), "DAT_LBR_2" NUMBER(8), "COD_LBR_1"
VARCHAR2(16 byte), "COD_LBR_2" VARCHAR2(16 byte), "FLG_LBR_1"
VARCHAR2(1 byte), "FLG_LBR_2" VARCHAR2(1 byte), "ASJ_TVA"
VARCHAR2(1 byte), "RGR_PIE" VARCHAR2(1 byte), "CHF_AFR_N_1"
NUMBER(14, 3), "MNT_ANO" NUMBER(14, 3), "MOD_EXD" VARCHAR2(2
byte), "FLG_SML" VARCHAR2(1 byte), "NBR_EXL_LIV" NUMBER(1),
"MDL_LIV" VARCHAR2(3 byte), "NBR_EXL_BR" NUMBER(1), "MDL_BR"
VARCHAR2(3 byte), "NBR_EXL_FAC" NUMBER(1), "MDL_FAC"
VARCHAR2(3 byte), "NBR_EXL_AVO" NUMBER(1), "MDL_AVO"
VARCHAR2(3 byte), "NBR_EXL_RLV" NUMBER(1), "MDL_RLV"
VARCHAR2(3 byte), "ACC_CMD" VARCHAR2(1 byte), "ACC_BR"
VARCHAR2(1 byte), "ACC_BL" VARCHAR2(1 byte), "ACC_FAC"
VARCHAR2(1 byte), "ACC_AVO" VARCHAR2(1 byte), "DPO_PCP"
VARCHAR2(2 byte), "PRD_RLV" VARCHAR2(2 byte), "PRD_FAC"
VARCHAR2(1 byte), "NOT_LIG_1" VARCHAR2(32 byte), "NOT_LIG_2"
VARCHAR2(32 byte), "FLG_MES" NUMBER(1), "PIE_TYP" VARCHAR2(1
byte), "MES_FAC" VARCHAR2(56 byte), "MES_CTB" VARCHAR2(56
byte), "MES_GES_CMR" VARCHAR2(56 byte), "MAJ_CTB" VARCHAR2(1
byte), "RGL_LIV" VARCHAR2(1 byte), "NUM_SOC_EXP" NUMBER(3),
"NBR_EXL_ABO" NUMBER(1), "MDL_ABO" VARCHAR2(3 byte),
"NBR_EXL_DEV" NUMBER(1), "MDL_DEV" VARCHAR2(3 byte),
"NUM_IDE" VARCHAR2(14 byte), "NBR_EXL_VAL" NUMBER(1),
"MDL_VAL" VARCHAR2(3 byte), "MOD_TSP" VARCHAR2(2 byte),
"RGR_RPV" VARCHAR2(1 byte), "TVA_PRC_DBT" NUMBER(7, 4),
"TVA_PRC_ENC" NUMBER(7, 4), "CAL_VAL_STA" VARCHAR2(3 byte),
"RGR_CMD" VARCHAR2(1 byte), "RGR_BL" VARCHAR2(1 byte),
"RGR_FAC" VARCHAR2(1 byte), "RGR_AVO" VARCHAR2(1 byte),
"COD_CHR" VARCHAR2(13 byte), "RGR_BR" VARCHAR2(1 byte),
"MNT_CMD" NUMBER(14, 3), "NBR_EXL_APT" NUMBER(1), "MDL_APT"
VARCHAR2(3 byte), "MNT_DEV" NUMBER(14, 3), "TAU_FRA_IPC"
NUMBER(6, 4), "NPAI" VARCHAR2(1 byte), "NUM_SIRET" NUMBER(14),
"TRF_RGR" VARCHAR2(1 byte), "COD_BAR" CHAR(18 byte) NOT NULL,
"ADR_MAI" VARCHAR2(60 byte), "CLF_PVS" VARCHAR2(4 byte),
"NUM_DOM_BQE" NUMBER(1), "MNT_EHU_NON_RGL" NUMBER(14, 3),
"MOD_RGL_APT" VARCHAR2(3 byte),
CONSTRAINT "FOU$COMPTEUR_SAGE_1" CHECK(COMPTEUR_SAGE >=0),
CONSTRAINT "FOU$DAT_CRE_1" CHECK(DAT_CRE >=0),
CONSTRAINT "FOU$DAT_LBR_1_1" CHECK(DAT_LBR_1 >=0),
CONSTRAINT "FOU$DAT_LBR_2_1" CHECK(DAT_LBR_2 >=0),
CONSTRAINT "FOU$DRN_CMD_1" CHECK(DRN_CMD >=0),
CONSTRAINT "FOU$DRN_FAC_1" CHECK(DRN_FAC >=0),
CONSTRAINT "FOU$DRN_LIV_1" CHECK(DRN_LIV >=0),
CONSTRAINT "FOU$DRN_MAJ_1" CHECK(DRN_MAJ >=0),
CONSTRAINT "FOU$DRN_RGL_1" CHECK(DRN_RGL >=0),
CONSTRAINT "FOU$FLG_MES_1" CHECK(FLG_MES >=0),
CONSTRAINT "FOU_I1_1" PRIMARY KEY("COD_FOU")
USING INDEX
TABLESPACE "INT_I206"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255,
CONSTRAINT "FOU$NBR_EXL_ABO_1" CHECK(NBR_EXL_ABO >=0),
CONSTRAINT "FOU$NBR_EXL_APT_1" CHECK(NBR_EXL_APT >=0),
CONSTRAINT "FOU$NBR_EXL_AVO_1" CHECK(NBR_EXL_AVO >=0),
CONSTRAINT "FOU$NBR_EXL_BR_1" CHECK(NBR_EXL_BR >=0),
CONSTRAINT "FOU$NBR_EXL_CMD_1" CHECK(NBR_EXL_CMD >=0),
CONSTRAINT "FOU$NBR_EXL_DEV_1" CHECK(NBR_EXL_DEV >=0),
CONSTRAINT "FOU$NBR_EXL_FAC_1" CHECK(NBR_EXL_FAC >=0),
CONSTRAINT "FOU$NBR_EXL_LIV_1" CHECK(NBR_EXL_LIV >=0),
CONSTRAINT "FOU$NBR_EXL_RLV_1" CHECK(NBR_EXL_RLV >=0),
CONSTRAINT "FOU$NBR_EXL_VAL_1" CHECK(NBR_EXL_VAL >=0),
CONSTRAINT "FOU$NIV_ACC_1" CHECK(NIV_ACC >=0),
CONSTRAINT "FOU$NUM_DOM_BQE_1" CHECK(NUM_DOM_BQE >=0),
CONSTRAINT "FOU$NUM_SIRET_1" CHECK(NUM_SIRET >=0),
CONSTRAINT "FOU$NUM_SOC_EXP_1" CHECK(NUM_SOC_EXP >=0),
CONSTRAINT "FOU$NUM_TRN_1" CHECK(NUM_TRN >=0),
CONSTRAINT "FOU$PRC_ACP_CMD_1" CHECK(PRC_ACP_CMD >=0),
CONSTRAINT "FOU$PRC_ACP_LIV_1" CHECK(PRC_ACP_LIV >=0),
CONSTRAINT "FOU$TVA_PRC_DBT_1" CHECK(TVA_PRC_DBT >=0),
CONSTRAINT "FOU$TVA_PRC_ENC_1" CHECK(TVA_PRC_ENC >=0))
TABLESPACE "INT_D206" PCTFREE 10 PCTUSED 0 INITRANS 1
MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
MONITORING |
Partager