| DDL Code |
CREATE TABLE MNFCTR_MDL(
MNFCTR_ID NUMBER(4, 0) NOT NULL,
MDL_NBR VARCHAR2(75) NOT NULL,
EQUIP_CAT_ID VARCHAR2(10) NOT NULL,
EQUIP_SUBCAT_ID VARCHAR2(10),
MDL_DESC VARCHAR2(255),
ELECT_CLASS VARCHAR2(50),
UNIT_CST NUMBER(18, 0),
PNL_HGHT NUMBER(12, 4),
AC_VOLTAGE VARCHAR2(50),
AC_CUR VARCHAR2(50),
AC_WATTS VARCHAR2(50),
AC_VA VARCHAR2(50),
DC_VOLTAGE VARCHAR2(50),
DC_CUR VARCHAR2(50),
HEAT_OUT VARCHAR2(50),
RAD_LIMIT VARCHAR2(50),
DIMENSIONS_UOM VARCHAR2(50),
WIDTH NUMBER(12, 4),
DEPTH NUMBER(12, 4),
HEIGHT NUMBER(12, 4),
LENGTH NUMBER(12, 4),
WT NUMBER(10, 0),
WEB_ADDR VARCHAR2(2048),
EST_COST NUMBER(18, 0),
SHAPE VARCHAR2(50),
OUTPUT_UOM VARCHAR2(25),
OUTPUT_HIGH NUMBER(10, 2),
OUTPUT_LOW NUMBER(10, 2),
INPUT_TYPE VARCHAR2(255),
TMIN NUMBER(94, 0),
TMAX NUMBER(94, 0),
PMAX NUMBER(38, 0),
MAGFLD NUMBER(12, 6),
RACK_MOUNT_IND CHAR(1) DEFAULT 'N' NOT NULL,
CONSTRAINT MNFCTR_MDL_PK PRIMARY KEY (MNFCTR_ID, MDL_NBR)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE EQUIP_INDEX_TS
LOGGING
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
),
CONSTRAINT MNFCTR_RF FOREIGN KEY (MNFCTR_ID)
REFERENCES MNFCTR(MNFCTR_ID),
CONSTRAINT EQUIP_CAT_MDL_RF FOREIGN KEY (EQUIP_CAT_ID)
REFERENCES EQUIP_CAT(EQUIP_CAT_ID),
CONSTRAINT UOM_MNFCTR_MDL_RF FOREIGN KEY (DIMENSIONS_UOM)
REFERENCES UNIT_OF_MEASURE(UOM),
CONSTRAINT MNFTR_MDL_SUBCAT_RF FOREIGN KEY (EQUIP_CAT_ID, EQUIP_SUBCAT_ID)
REFERENCES EQUIP_SUBCAT(EQUIP_CAT_ID, EQUIP_SUBCAT_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EQUIP_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
)
NOCACHE
NOCOMPRESS
;
|
