빅맥

테이블 (9)

hashtag (Untitled9)

  • hashtag_id (Key) — bigint — 기본 키 — NOT NULL
  • hashtag_name (Field) — varchar(20)

member (Untitled)

  • member_id (Key) — bigint — 기본 키 — NOT NULL
  • login_id (Field) — varchar(30)
  • password (Field2) — varchar(30)
  • member_name (Field5) — varchar(10)
  • gender (Field3) — ENUM('Male', 'Female', 'Other')
  • age (Field4) — int

menu (Untitled5)

  • menu_id (Key) — bigint — 기본 키 — NOT NULL
  • menu_name (Field) — varchar(60)
  • price (Field2) — decimal(5,2)

menu_list (Untitled6)

  • restaurant_id (Key) — bigint — 외래 키 → restaurant.restaurant_id — NOT NULL
  • menu_id (Key2) — bigint — 외래 키 → menu.menu_id — NOT NULL

restaurant (Untitled2)

  • restaurant_id (Key) — bigint — 기본 키 — NOT NULL
  • restaurant_name (Field) — varchar(50)
  • cuisine (Field5) — varchar(30)
  • city (Field2) — varchar(20)
  • borough (Field3) — varchar(20)
  • avenue (Field4) — varchar(20)
  • open_days_id (Key2) — bigint — 외래 키 → restaurant_open_days.open_days_id — NOT NULL
  • review_count (Field6) — bigint

restaurant_hashtag (Untitled10)

  • restaurant_id (Key2) — bigint — 외래 키 → restaurant.restaurant_id — NOT NULL
  • hashtag_id (Key3) — bigint — 외래 키 → hashtag.hashtag_id — NOT NULL

restaurant_member_likes (Untitled7)

  • restaurant_id (Key2) — bigint — 외래 키 → restaurant.restaurant_id — NOT NULL
  • liked_member_id (Key) — bigint — 외래 키 → member.member_id — NOT NULL

restaurant_open_days (Untitled3)

  • open_days_id (Key) — bigint — 기본 키 — NOT NULL
  • monday (Field) — int
  • tuesday (Field2) — int
  • wednesday (Field3) — int
  • thursday (Field4) — int
  • friday (Field5) — int
  • saturday (Field6) — int
  • sunday (Field7) — int

review (Untitled4)

  • review_id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.member_id — NOT NULL
  • restaurant_id (Key3) — bigint — 외래 키 → restaurant.restaurant_id — NOT NULL
  • rating (Field) — int
  • comment (Field2) — text