A

Tables (5)

BOARD (Untitled3)

  • NOTNULL (ID) — VARCHAR2(30) — Foreign key → MEMBER.NOTNULL — NOT NULL
  • SEQUENCE (POSTNUM) — NMBER
  • NOTNULL (CATEGORY) — NUMBER
  • SEQUENCE (GROUP_NUM) — NUMBER
  • NOTNULL (GROUP_ORDER) — NUMBER
  • NOTNULL (TITLE) — VARCHAR2(200)
  • NOTNULL (CONTENT) — VARCHAR2(4000)
  • NOTNULL (TODAY) — DATE
  • Field

FESTIVAL (Untitled2)

  • SEQUENCE (F_NUM) — NUMBER — Primary key — NOT NULL
  • NOTNULL (F_TITLE) — VARCHAR2(200)
  • NOTNULL (F_CONTENT) — VARCHAR2(4000)
  • NOTNULL (F_START) — DATE
  • NOTNULL (F_END) — DATE
  • NOTNULL (F_LOCATION) — VARCHAR2(50)
  • NOTNULL (TICKET) — VARCHAR2(2)
  • NOTNULL (T_PRICE) — NUMBER

INTEREST (Untitled5)

  • NOTNULL (ID) — VARCHAR2(30) — Foreign key → MEMBER.NOTNULL — NOT NULL
  • SEQUENCE (F_NUM) — NUMBER — Foreign key → FESTIVAL.SEQUENCE — NOT NULL

MEMBER (Untitled)

  • NOTNULL (ID) — VARCHAR2(30) — Primary key — NOT NULL
  • NOTNULL (PW) — VARCHAR2(30)
  • NOTNULL (NAME) — VARCHAR2(20)
  • NOTNULL (PHONE) — VARCHAR2(20)
  • NOTNULL (ADDRESS) — VARCHAR2(50)
  • NOTNULL (EMIAL) — VARCHAR2(30)
  • NOTNULL (JOIN) — VARCHAR2(10)
  • NOTNULL (LEVEL) — VARCHAR2(20)

RESERVATION (Untitled4)

  • NOTNULL (ID) — VARCHAR2(30) — Foreign key → MEMBER.NOTNULL — NOT NULL
  • SEQUENCE (F_NUM) — NUMBER — Foreign key → FESTIVAL.SEQUENCE — NOT NULL
  • SEQUENCE (R_NUM) — NUMBER
  • (T_QUANTITY) — NUMBER
  • (TOTAL_PRICE) — NUMBER
  • (STATUS) — VARCHAR2(20)
  • (CANCELLABLE) — VARCHAR2(20)