테이블링

테이블 (8)

Like (like)

  • customer_id — 기본 키 — NOT NULL
  • restaurant_id — 기본 키 — NOT NULL

category

  • category_id — int — 기본 키 — NOT NULL
  • category_name — varchar(50) — NOT NULL

customer

  • customer_id — int — 기본 키 — NOT NULL
  • customer_name — varchar(50)
  • phone — varchar(50) — NOT NULL
  • state — enum('Y', 'N')
  • location_id — int

food

  • food_id — int — 기본 키 — NOT NULL
  • food_name — VARCHAR(100) — NOT NULL
  • category_id — int

location

  • location_id — int — 기본 키 — NOT NULL
  • location_name — varchar(50)

menu

  • restaurant_id — int
  • food_id — int
  • price — int — NOT NULL

reservation

  • reservation_id — int — 기본 키 — NOT NULL
  • reservation_state — enum('Y', 'N')
  • reservation_time — timestamp
  • customer_id — int
  • restaurant_id — int

restaurant

  • restaurant_id — int — 기본 키 — NOT NULL
  • restaurant_name — varchar(100) — NOT NULL
  • phone — varchar(50)
  • address — varchar(255) — NOT NULL
  • content — text
  • open_time — time
  • close_time — time
  • rating — decimal(2, 1)
  • likes — int
  • rest_day — varchar(5)
  • location_id — int
  • category_id — int