4

Tables (13)

ANSWER

  • qna_id — VARCHAR(20) — NOT NULL
  • answer_member_id — VARCHAR(20) — NOT NULL
  • status — VARCHAR(1) — NOT NULL
  • answer_content — TEXT
  • status_date — DATETIME
  • last_edit_date — DATETIME — NOT NULL

CART

  • member_id — VARCHAR(20) — Primary key — NOT NULL
  • product_id — VARCHAR(20) — Primary key — NOT NULL
  • cart_add_date — DATETIME — NOT NULL

CATEGORY

  • category_id — VARCHAR(20) — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL
  • parent_id — VARCHAR(20)

COUPON

  • coupon_id — VARCHAR(20) — NOT NULL
  • issued_by_member_id — VARCHAR(20) — NOT NULL
  • discount_price — INT — NOT NULL
  • end_date — DATETIME — NOT NULL
  • last_edit_date — DATETIME — NOT NULL

LICENSE

  • product_id — VARCHAR(20) — Primary key — NOT NULL
  • member_id — VARCHAR(20) — Primary key — NOT NULL
  • expire_date — DATETIME — NOT NULL

MEMBER

  • member_id — VARCHAR(20) — NOT NULL
  • email — VARCHAR(40) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • is_admin — BOOLEAN — NOT NULL
  • register_date — DATETIME — NOT NULL

MEMBER_COUPON

  • member_coupon_id — VARCHAR(20) — NOT NULL
  • member_id — VARCHAR(20) — NOT NULL
  • coupon_id — VARCHAR(20) — NOT NULL
  • use_date — DATETIME
  • issued_date — DATETIME — NOT NULL

ORDER_DETAIL

  • order_id — VARCHAR(20) — Primary key — NOT NULL
  • product_id — VARCHAR(20) — Primary key — NOT NULL

ORDER_LIST

  • order_id — VARCHAR(20) — NOT NULL
  • member_id — VARCHAR(20) — NOT NULL
  • member_coupon_id — VARCHAR(20)
  • last_order_price — INT — NOT NULL
  • order_date — DATETIME — NOT NULL

PRODUCT

  • product_id — VARCHAR(20) — NOT NULL
  • category_id — VARCHAR(20) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • price — INT — NOT NULL
  • end_date — DATETIME — NOT NULL
  • version — VARCHAR(10) — NOT NULL
  • last_edit_date — DATETIME — NOT NULL
  • expire_date — DATETIME

QUESTION

  • qna_id — VARCHAR(20) — NOT NULL
  • member_id — VARCHAR(20) — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT — NOT NULL
  • last_edit_date — DATETIME — NOT NULL

REVIEW

  • product_id — VARCHAR(20) — Primary key — NOT NULL
  • member_id — VARCHAR(20) — Primary key — NOT NULL
  • content — TEXT
  • rate — INT — NOT NULL
  • last_edit_date — DATETIME — NOT NULL

WISHLIST

  • product_id — VARCHAR(20) — Primary key — NOT NULL
  • member_id — VARCHAR(20) — Primary key — NOT NULL
  • wishlist_add_date — DATETIME — NOT NULL