-- md_script.tab
--
-- Generated for Oracle 8 on Wed May 05 11:59:48 1999 by Server Generator 2.1.24.5.0
PROMPT Creating Table 'DETAIL_TABLE'
CREATE TABLE DETAIL_TABLE
(MASTER_KEY NUMBER NOT NULL
,DETAIL_KEY NUMBER NOT NULL
,DETAIL_ELEMENT_1 NUMBER NOT NULL
,DETAIL_ELEMENT_2 VARCHAR2(50)
)
INITRANS 1
MAXTRANS 255
PCTUSED 60
PCTFREE 20
STORAGE
(
INITIAL 14336
NEXT 14336
PCTINCREASE 1
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
TABLESPACE USERS
/
COMMENT ON COLUMN DETAIL_TABLE.DETAIL_KEY IS 'Detail unique key'
/
COMMENT ON COLUMN DETAIL_TABLE.DETAIL_ELEMENT_1 IS 'Numeric Data'
/
COMMENT ON COLUMN DETAIL_TABLE.DETAIL_ELEMENT_2 IS 'The name of the time of year when
class are held'
/
PROMPT Creating Table 'MASTER_TABLE'
CREATE TABLE MASTER_TABLE
(MASTER_KEY NUMBER NOT NULL
,DATA_ELEMENT_1 VARCHAR2(40) NOT NULL
,DATA_ELEMENT_2 VARCHAR2(78)
)
INITRANS 1
MAXTRANS 255
PCTUSED 60
PCTFREE 20
STORAGE
(
INITIAL 14336
NEXT 14336
PCTINCREASE 1
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
TABLESPACE USERS
/
COMMENT ON COLUMN MASTER_TABLE.DATA_ELEMENT_2 IS 'Type of Course, e.g. Remedial, etc.'
/