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