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)