-- 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.'

/