database-project

Tables (6)

menus

  • menu_id — BIGINT(20) — Primary key — NOT NULL
  • store_id — BIGINT(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • status — VARCHAR(255) — NOT NULL — 영업 상태
  • price — INT(11) — NOT NULL
  • createdDate — TIMESTAMP — NOT NULL

order_menus

  • order_menu_id — BIGINT(20) — Primary key — NOT NULL
  • order_id — BIGINT(20) — NOT NULL
  • menu_id — BIGINT(20) — NOT NULL
  • user_id — BIGINT(20) — NOT NULL
  • store_id — BIGINT(20) — NOT NULL
  • quantity — INT(11) — NOT NULL
  • createdDate — TIMESTAMP — NOT NULL

orders

  • order_id — BIGINT(20) — Primary key — NOT NULL
  • store_id — BIGINT(20) — NOT NULL
  • user_id — BIGINT(20) — NOT NULL
  • total_price — INT(11) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • createdDate — TIMESTAMP — NOT NULL

reviews

  • review_id — BIGINT(20) — Primary key — NOT NULL
  • store_id — BIGINT(20) — NOT NULL
  • user_id — BIGINT(20) — NOT NULL
  • menu_id — BIGINT(20) — NOT NULL
  • rating — INT(1) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • createdDate — TIMESTAMP — NOT NULL

stores

  • store_id — BIGINT(20) — Primary key — NOT NULL
  • user_id — BIGINT(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL — 영업 상태
  • content — VARCHAR(255)
  • createdDate — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • role — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • createdDate — TIMESTAMP — NOT NULL