| DDL Code |
CREATE TABLE EPICS.PS_DVC(
DVC_ID VARCHAR2(40) NOT NULL,
OPER_MAX_V NUMBER(12, 6),
OPER_MIN_V NUMBER(12, 6),
OPER_MAX_I NUMBER(12, 6),
OPER_MIN_I NUMBER(12, 6),
PSI_DVC_ID VARCHAR2(40),
DSGN_CAB_SLOT_BGN NUMBER(3, 0),
DSGN_CAB_SLOT_END NUMBER(3, 0),
DSGN_CAB_SLOT_POS_IND CHAR(1) DEFAULT 'F' NOT NULL,
POS_WITHIN_SLOTS NUMBER(3, 0),
SMOOTH NUMBER(14, 6) DEFAULT .8,
HYST NUMBER(14, 6),
B_LO NUMBER(14, 6),
B_LOLO NUMBER(14, 6),
B_HI NUMBER(14, 6),
B_HIHI NUMBER(14, 6),
I_LO NUMBER(14, 6),
I_LOLO NUMBER(14, 6),
I_HI NUMBER(14, 6),
I_HIHI NUMBER(14, 6),
CONSTRAINT PS_DVC_ZERO_CK CHECK (dsgn_cab_slot_bgn > 0),
CONSTRAINT PS_DVC_SLOT_END_CK CHECK (dsgn_cab_slot_end < 46),
CONSTRAINT PS_DVC_POS_CK CHECK (dsgn_cab_slot_pos_ind in ('F','B','L','R')),
CONSTRAINT SYS_C0015341 CHECK (SMOOTH > 0 and SMOOTH < .99),
CONSTRAINT PS_DVC_PK PRIMARY KEY (DVC_ID)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE EPICS_INDEX_TS
NOLOGGING
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
CONSTRAINT PS_DVC_DVC_RF FOREIGN KEY (DVC_ID)
REFERENCES EPICS.DVC(DVC_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EPICS_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOCACHE
NOCOMPRESS
;
|
