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
| ALTER TABLE OCEAN_ADM.ACCESSOIRE
DROP PRIMARY KEY CASCADE;
DROP TABLE OCEAN_ADM.ACCESSOIRE CASCADE CONSTRAINTS;
CREATE TABLE OCEAN_ADM.ACCESSOIRE
(
ACC_ID NUMBER(6) NOT NULL,
ACC_SOURCEID NUMBER(6),
TAC_ID NUMBER(3) NOT NULL,
MDA_ID NUMBER(9) NOT NULL,
ACC_REF VARCHAR2(20 BYTE) NOT NULL,
ACC_NOMBRE NUMBER(3) NOT NULL,
ACC_COMMENT VARCHAR2(250 BYTE),
ACC_FOURN VARCHAR2(30 BYTE) NOT NULL,
ACC_NONINST NUMBER(1) DEFAULT 0 NOT NULL,
ACC_QUI VARCHAR2(50 BYTE) NOT NULL,
ACC_QUAND DATE NOT NULL,
ACC_VERSION NUMBER(9) DEFAULT 1 NOT NULL
)
TABLESPACE DATA_OCEAN_OBJPHYS_OCEANP
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
COMMENT ON TABLE OCEAN_ADM.ACCESSOIRE IS 'Accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_ID IS 'Identifiant Accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_SOURCEID IS 'Identifiant Accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.TAC_ID IS 'Identifiant type accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.MDA_ID IS 'Identifiant type accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_REF IS 'Référence accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_NOMBRE IS 'Nombre accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_COMMENT IS 'Commentaire accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_FOURN IS 'Nom fournisseur';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_NONINST IS 'Flag encours acc OT';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_QUI IS 'Auteur dernière modification accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_QUAND IS 'Date dernière modif accessoire';
COMMENT ON COLUMN OCEAN_ADM.ACCESSOIRE.ACC_VERSION IS 'Champ version accessoire';
CREATE INDEX OCEAN_ADM.ACC_ACO_FK ON OCEAN_ADM.ACCESSOIRE
(ACC_SOURCEID)
LOGGING
TABLESPACE INDX_OCEAN_OBJPHYS_OCEANP
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX OCEAN_ADM.MDA_ACC_FK ON OCEAN_ADM.ACCESSOIRE |
Partager