capstone
Tables (20)
bookmark (회원북마크)
- member_id (회원아이디) — serial — Foreign key → member.member_id — NOT NULL
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- bookmarked_at (북마크시점) — timestamp
business_hour (식당운영시간)
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- day_of_week (요일) — varchar(10)
- businesshour_start (운영시간시작) — time — NOT NULL
- businesshour_end (운영시간종료) — time — NOT NULL
- breaktime_start (브레이크타임시작) — time — NOT NULL
- breaktime_end (브레이크타임종료) — time — NOT NULL
- lastorder_first (첫번째라스트오더) — time — NOT NULL
- lastorder_second (두번째라스트오더) — time — NOT NULL
chatbotdata (챗봇데이터)
- member_id (회원아이디) — serial — Foreign key → member.member_id — NOT NULL
- chatbotdata (챗봇데이터) — NOT NULL
companion_type (동행종류)
- companion_id (동행아이디) — serial — Primary key — NOT NULL
- companion (동행) — varchar(255)
image (식당이미지)
- image_id (이미지아이디) — serial — Primary key — NOT NULL
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- image_path (이미지경로) — varchar(255)
member (회원정보)
- member_id (회원아이디) — serial — Primary key — NOT NULL
- email (이메일) — varchar(255)
- password (비밀번호) — varchar(255)
- language (사용언어) — varchar(2)
menu (식당메뉴)
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- menu_name (메뉴이름) — varchar(255)
- menu_price (메뉴가격) — int
purpose_type (목적종류)
- purpose_id (목적아이디) — serial — Primary key — NOT NULL
- purpose (목적) — varchar(255)
restaurant_bookmark_count (식당북마크)
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- bookmark_count (북마크횟수) — int
restaurant_info (식당정보)
- restaurant_id (식당아이디) — serial — Primary key — NOT NULL
- restaurant_type_id (식당종류아이디) — serial — Foreign key → restaurant_type.restaurant_type_id — NOT NULL
- restaurant_name (식당이름) — varchar(255)
- address (식당주소) — varchar(255) — NOT NULL
- by_subway (지하철길찾기) — varchar(255) — NOT NULL
- telephone (식당전화번호) — varchar(100) — NOT NULL
- homepage (식당홈페이지) — varchar(255) — NOT NULL
- icon_path (아이콘경로) — varchar(255) — NOT NULL
restaurant_type (식당종류)
- restaurant_type_id (식당종류아이디) — serial — Primary key — NOT NULL
- restaurant_type (식당종류) — varchar(255)
review (식당리뷰)
- review_id (리뷰아이디) — serial — Primary key — NOT NULL
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- review (리뷰원문) — text
- service_mode_id (이용방법아이디) — serial — Foreign key → service_mode_type.service_mode_id — NOT NULL
- waiting_time_id (대기시간아이디) — serial — Foreign key → waiting_time_type.waiting_time_id — NOT NULL
review_companion (리뷰동행)
- review_id (리뷰아이디) — serial — Foreign key → review.review_id — NOT NULL
- companion_id (동행아이디) — serial — Foreign key → companion_type.companion_id — NOT NULL
review_purpose (리뷰목적)
- review_id (리뷰아이디) — serial — Foreign key → review.review_id — NOT NULL
- purpose_id (목적아이디) — serial — Foreign key → purpose_type.purpose_id — NOT NULL
review_sentiment (리뷰감상키워드)
- review_id (리뷰아이디) — serial — Foreign key → review.review_id — NOT NULL
- sentiment_id (감상아이디) — serial — Foreign key → sentiment_type.sentiment_id — NOT NULL
sentiment_type (감상키워드종류)
- sentiment_id (감상아이디) — serial — Primary key — NOT NULL
- sentiment_keyword (감상키워드) — varchar(255)
service (식당서비스)
- Field
- restaurant_id (식당아이디) — serial — Foreign key → restaurant_info.restaurant_id — NOT NULL
- service_id (서비스아이디) — serial — Foreign key → service_type.service_id — NOT NULL
service_mode_type (이용방법종류)
- service_mode_id (이용방법아이디) — serial — Primary key — NOT NULL
- service_mode (이용방법) — varchar(255)
service_type (서비스종류)
- service_id (서비스아이디) — serial — Primary key — NOT NULL
- service (서비스이름) — varchar(255)
waiting_time_type (대기시간종류)
- waiting_time_id (대기시간아이디) — serial — Primary key — NOT NULL
- waiting_time (대기시간) — varchar(255)