-- d:\jde\mc\mapdata.tab
--
-- Generated for Oracle 8 on Thu Mar 26  10:57:08 1998 by Server Generator 2.1.19.2.0
 


PROMPT Creating Table 'LINE_SEGMENT'
CREATE TABLE LINE_SEGMENT
 (ID NUMBER(4) NOT NULL
 ,FROM_NODE NUMBER(4) NOT NULL
 ,TO_NODE NUMBER(4) NOT NULL
 ,PEAK_ONLY CHAR(1) DEFAULT 'N' NOT NULL
 ,DIRECTION CHAR(2) NOT NULL
 )
/

PROMPT Creating Table 'LINE'
CREATE TABLE LINE
 (ID NUMBER(2) NOT NULL
 ,NAME VARCHAR2(50) NOT NULL
 ,COLOUR VARCHAR2(30)
 ,CODE CHAR(2) NOT NULL
 )
/

PROMPT Creating Table 'STATION'
CREATE TABLE STATION
 (ID NUMBER(4) NOT NULL
 ,NAME VARCHAR2(50) NOT NULL
 ,ZONE NUMBER(7) NOT NULL
 )
/

PROMPT Creating Table 'STATION_NODE'
CREATE TABLE STATION_NODE
 (ID NUMBER(4) NOT NULL
 ,ST_ID NUMBER(4) NOT NULL
 ,LI_ID NUMBER(2) NOT NULL
 ,ORDINAL NUMBER(1,0) DEFAULT 0 NOT NULL
 ,QUADRANT CHAR(2)
 ,INTERCHANGE CHAR(1) DEFAULT 'N' NOT NULL
 ,TERMINUS CHAR(1) DEFAULT 'N' NOT NULL
 ,MAP_X NUMBER(4,0) NOT NULL
 ,MAP_Y NUMBER(4) NOT NULL
 )
/