스키마

-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.BRD
  (
   SERIAL           NUMBER,
   MID              VARCHAR2(20),
   PWD              VARCHAR2(10),
   JEMOK            VARCHAR2(100),
   CONTENT          VARCHAR2(1000),
   MDATE            DATE,
   CNT              NUMBER,
   GRP              NUMBER,
   DAP              VARCHAR2(250)
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;


-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.MEMBER
  (
   MID              VARCHAR2(10) NOT NULL,
   IRUM             VARCHAR2(20),
   GENDER           VARCHAR2(10),
   PHONE            VARCHAR2(15),
   ADDRESS          VARCHAR2(100),
   GRADE            VARCHAR2(4),
   MANAGER          VARCHAR2(20),
   CONSTRAINT PK_MEMBER_MID
     PRIMARY KEY (MID) USING INDEX 
       PCTFREE 10 INITRANS 2 MAXTRANS 255
       STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
                FREELISTS 1 FREELIST GROUPS 1)
       TABLESPACE SYSTEM
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;

CREATE INDEX PARK.MEMBER_MID_PHONE_INDEX
  ON PARK.MEMBER (MID, PHONE)
    PCTFREE 10 INITRANS 2 MAXTRANS 255
    STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
            FREELISTS 1 FREELIST GROUPS 1)
    TABLESPACE SYSTEM;

-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.MEMBER2
  (
   MID              VARCHAR2(10),
   IRUM             VARCHAR2(20),
   GENDER           VARCHAR2(10),
   PHONE            VARCHAR2(15),
   ADDRESS          VARCHAR2(40),
   GRADE            VARCHAR2(4),
   MANAGER          VARCHAR2(10)
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;


-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.SCORE
  (
   MID              VARCHAR2(10),
   EXAM             VARCHAR2(20),
   KOR              NUMBER(3),
   MAT              NUMBER(3),
   ENG              NUMBER(3),
   COMP             NUMBER(3),
   ETC              NUMBER(3)
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;


-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.STUDENT
  (
   MID              VARCHAR2(10) NOT NULL,
   IRUM             VARCHAR2(20),
   GENDER           VARCHAR2(5),
   SCHOOL           VARCHAR2(30),
   CLASSYEAR        NUMBER(2),
   RDATE            DATE,
   CONSTRAINT PK_STUDENT_MID
     PRIMARY KEY (MID) USING INDEX 
       PCTFREE 10 INITRANS 2 MAXTRANS 255
       STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
                FREELISTS 1 FREELIST GROUPS 1)
       TABLESPACE SYSTEM
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;

CREATE INDEX PARK.STUDENT_SCHOOL_INDEX
  ON PARK.STUDENT (SCHOOL)
    PCTFREE 10 INITRANS 2 MAXTRANS 255
    STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
            FREELISTS 1 FREELIST GROUPS 1)
    TABLESPACE SYSTEM;



-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.VIDEO
  (
   MID              VARCHAR2(10),
   RENTDATE         DATE,
   RETURNDATE       DATE,
   AMT              NUMBER(5),
   SERIAL           NUMBER(5),
   VID              VARCHAR2(10)
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;



-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.VIDEOTAPE
  (
   MID              VARCHAR2(10) NOT NULL,
   JEMOK            VARCHAR2(40),
   GRADE            VARCHAR2(20),
   AMT              NUMBER(5),
   RDATE            DATE,
   CONSTRAINT SYS_C004072
     PRIMARY KEY (MID) USING INDEX 
       PCTFREE 10 INITRANS 2 MAXTRANS 255
       STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
                FREELISTS 1 FREELIST GROUPS 1)
       TABLESPACE SYSTEM
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;



-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.WBOARD
  (
   SERIAL           NUMBER,
   MID              VARCHAR2(10),
   PWD              VARCHAR2(20),
   JEMOK            VARCHAR2(100),
   MDATE            DATE,
   UPLOAD           VARCHAR2(200),
   CONTENT          VARCHAR2(1000),
   GRP              NUMBER,
   DAP              VARCHAR2(200),
   CNT              NUMBER
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;



-- This DDL script is generated by SQL Tools. 
-- It does not include all properties of the original object.
-- Also excluded CLUSTER or PARTITION information.

CREATE TABLE PARK.ZIPCODE
  (
   ZIPCODE          VARCHAR2(7),
   SIDO             VARCHAR2(20),
   GUGUN            VARCHAR2(40),
   DONG             VARCHAR2(100),
   BUNJI            VARCHAR2(80)
  )
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE (INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645
           FREELISTS 1 FREELIST GROUPS 1)
  TABLESPACE SYSTEM
  ;