빅맥
테이블 (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