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)