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