festival

Tables (5)

BOARD

  • board_id — int — Primary key — NOT NULL
  • member_id — int — Foreign key → MEMBER.member_id — NOT NULL
  • subject — varchar
  • content — varchar
  • name — varchar
  • date — varchar
  • views — int
  • category — varchar

ITEM

  • item_id — int — Primary key — NOT NULL
  • name — varchar
  • price — int

MEMBER

  • member_id — int — Primary key — NOT NULL
  • email — varchar
  • password — varchar
  • phone — varchar
  • name — varchar
  • address — varchar

ORDERS

  • order_id — int — Primary key — NOT NULL
  • member_id — int — Foreign key → MEMBER.member_id — NOT NULL
  • create_date — varchar

ORDER_ITEM

  • order_item_id — int — Primary key — NOT NULL
  • order_id — int — Foreign key → ORDERS.order_id — NOT NULL
  • item_id — int — Foreign key → ITEM.item_id — NOT NULL
  • count — int
  • price — int