capstone
Tables (20)
bookmark
- member_id — INT
- restaurant_id — INT
- bookmarked_at — TIMESTAMP
business_hour
- restaurant_id — int
- day_of_week — varchar(10) — NOT NULL
- businesshour_start — time
- businesshour_end — time
- breaktime_start — time
- breaktime_end — time
- lastorder_first — time
- lastorder_second — time
chatbotdata
- chatbotdata (챗봇데이터) — varchar(255)
companion_type
- companion_id — serial
- companion — varchar(255) — NOT NULL
image
- image_id — SERIAL
- restaurant_id — int
- image_path — VARCHAR(255)
member
- member_id (회원아이디) — serial — Primary key — NOT NULL
- email (이메일) — varchar(255) — NOT NULL
- password (비밀번호) — varchar(255) — NOT NULL
- language (사용언어) — varchar(2) — NOT NULL
- member_id (회원아이디2) — serial — Foreign key → member.member_id — NOT NULL
menu
- restaurant_id — int
- menu_name — varchar(255) — NOT NULL
- menu_price — int — NOT NULL
purpose_type
- purpose_id — serial
- purpose — varchar(255) — NOT NULL
restaurant_bookmark_count
- restaurant_id — INT
- bookmark_count — INT
restaurant_info
- restaurant_id — serial
- restaurant_type_id — int
- restaurant_name — varchar(255) — NOT NULL
- address — varchar(255)
- by_subway — varchar(255)
- telephone — varchar(100)
- homepage — varchar(255)
- icon_path — varchar(255)
restaurant_type
- restaurant_type_id — serial
- restaurant_type — varchar(255) — NOT NULL
review
- review_id — serial
- restaurant_id — int
- review — text
- service_mode_id — int
- waiting_time_id — int
review_companion
- review_id — int
- companion_id — int
review_purpose
- review_id — int
- purpose_id — int
review_sentiment
- review_id — int
- sentiment_id — int
sentiment_type
- sentiment_id — serial
- sentiment_keyword — varchar(255) — NOT NULL
service
- restaurant_id — int
- service_id — int
service_mode_type
- service_mode_id — serial
- service_mode — varchar(255) — NOT NULL
service_type
- service_id — serial
- service — varchar(255) — NOT NULL
waiting_time_type
- waiting_time_id — serial
- waiting_time — varchar(255) — NOT NULL