exhibit
Tables (8)
COMMENT
- COMMENT_NO — NUMBER(5) — Primary key — NOT NULL
- REVIEW_NO — NUMBER(5) — Foreign key → REVIEW.REVIEW_NO — NOT NULL
- ID — NUMBER(5) — Foreign key → USER.ID — NOT NULL
EXHIBIT
- EXHIBIT_NO — NUMBER(5) — Primary key — NOT NULL
- NAME — VARCHAR2(50)
- POSTER_URL — VARCHAR2(50)
- CONTENT — VARCHAR2(300)
- PRICE — NUMBER(6)
- REGISTERED_DATE — DATE
- VIEW — NUMBER(5)
- START_DATE — DATE
- END_DATE — DATE
- LOCATION — VARCHAR2(30)
QA
- QA_NO — NUMBER(5) — Primary key — NOT NULL
- EXHIBIT_NO — NUMBER(5) — Foreign key → EXHIBIT.EXHIBIT_NO — NOT NULL
- QA_CATEGORY_NO — NUMBER(5) — Foreign key → QA_CATEGORY.QA_CATEGORY_NO — NOT NULL
- ID — NUMBER(5) — Foreign key → USER.ID — NOT NULL
- USER_NAME — VARCHAR2(20)
- TITLE — VARCHAR2(100)
- CONTENT — VARCHAR2(300)
- REGISTERED_DATE — DATE
- ATTACHED_FILE — VARCHAR2(50)
QA_ANSWER
- ANSWER_NO — NUMBER(5) — Primary key — NOT NULL
- QA_NO — NUMBER(5) — Foreign key → QA.QA_NO — NOT NULL
- CONTENT — VARCHAR2(300)
QA_CATEGORY
- QA_CATEGORY_NO — NUMBER(5) — Primary key — NOT NULL
- NAME — VARCHAR2(20)
- Field — varchar2(20) — NOT NULL
REVIEW
- REVIEW_NO — NUMBER(5) — Primary key — NOT NULL
- EXHIBIT_NO — NUMBER(5) — Foreign key → EXHIBIT.EXHIBIT_NO — NOT NULL
- ID — NUMBER(5) — Foreign key → USER.ID — NOT NULL
- USER_NAME — VARCHAR2(20)
- TITLE — VARCHAR2(100)
- REGISTERED_DATETIME — DATE
- CONTENT — VARCHAR2(300)
- VIEW — NUMBER(5)
- ATTACHED_FILE — VARCHAR2(50)
ROLE
- ROLE_NO — NUMBER(5) — Primary key — NOT NULL
- NAME — VARCHAR2(20)
USER
- ID — NUMBER(5) — Primary key — NOT NULL
- ROLE_NO — NUMBER(5) — Foreign key → ROLE.ROLE_NO — NOT NULL
- PWD — VARCHAR2(20)
- NAME — VARCHAR2(20)
- EMAIL — VARCHAR2(30)
- PHONE — VARCHAR2(15)
- REGISTERED_DATE — DATE
- LOGIN_DATE — DATE