TwoGather

Tables (13)

BusinessHour (영업시간)

  • BusinessHour_id — long — Primary key — NOT NULL
  • Store_id — long — Foreign key → Store.Store_id — NOT NULL
  • StoreOwner_id — long — Foreign key → Store.StoreOwner_id — NOT NULL
  • user_id — long — Foreign key → Store.user_id — NOT NULL
  • tyep_id — long — Foreign key → Store.tyep_id — NOT NULL
  • startTime (영업시작시간) — Time
  • endTime (영업종료시간) — Time
  • dayofweek (요일) — DayOfWeek
  • isOpened (휴무여부) — boolean
  • hasBreakTime (쉬는시간여부) — boolean
  • startBreakTime (쉬는시작시작) — LocalTime
  • endBreakTime (쉬는종료시각) — LocalTIme

Consumer (소비자)

  • Consumer_id — long — Primary key — NOT NULL
  • user_id — long — Foreign key → member.user_id — NOT NULL

Keyword (검색키워드)

  • Keyword_id — long — Primary key — NOT NULL
  • name (키워드명) — string — unique

Likes (좋아요)

  • zzim_id — Long — Primary key — NOT NULL
  • Consumer_id — long — Foreign key → Consumer.Consumer_id — NOT NULL
  • user_id — long — Foreign key → Consumer.user_id — NOT NULL
  • Store_id — long — Foreign key → Store.Store_id — NOT NULL
  • StoreOwner_id — long — Foreign key → Store.StoreOwner_id — NOT NULL
  • user_id (user_id2) — long — Foreign key → Store.user_id — NOT NULL
  • tyep_id — long — Foreign key → Store.tyep_id — NOT NULL

Store (가게)

  • Store_id — long — Primary key — NOT NULL
  • StoreOwner_id — long — Foreign key → StoreOwner.StoreOwner_id — NOT NULL
  • user_id — long — Foreign key → StoreOwner.user_id — NOT NULL
  • tyep_id — long — Foreign key → category.category_id — NOT NULL
  • name (카페명/식당이름/활동이름) — string
  • address (주소) — string
  • phone (스토어번호) — String
  • businessNumber (사업자등록번호) — string
  • businessStartDate (사업자등록날짜) — Date
  • businessName (사업자이름) — String
  • reasonForReject (거부사유) — string
  • requestDate (Field)

StoreOwner (상인)

  • StoreOwner_id — long — Primary key — NOT NULL
  • user_id — long — Foreign key → member.user_id — NOT NULL

category (분류)

  • category_id — long — Primary key — NOT NULL
  • name (category명) — string

comment (답글)

  • comment_id — long — Primary key — NOT NULL
  • review_id — long — Foreign key → review.review_id — NOT NULL
  • Store_id — long — Foreign key → review.Store_id — NOT NULL
  • StoreOwner_id — long — Foreign key → review.StoreOwner_id — NOT NULL
  • user_id (user_id2) — long — Foreign key → review.user_id — NOT NULL
  • Consumer_id — long — Foreign key → review.Consumer_id — NOT NULL
  • user_id — long — Foreign key → review.user_id — NOT NULL
  • tyep_id — long — Foreign key → review.tyep_id — NOT NULL
  • content (리뷰내용) — string
  • type (리뷰타입) — string

image (사진)

  • image_id — long — Primary key — NOT NULL
  • Store_id — long — Foreign key → Store.Store_id — NOT NULL
  • StoreOwner_id — long — Foreign key → Store.StoreOwner_id — NOT NULL
  • user_id — long — Foreign key → Store.user_id — NOT NULL
  • tyep_id — long — Foreign key → Store.tyep_id — NOT NULL
  • url (이미지url) — string

member (가입회원)

  • user_id (식별id) — long — Primary key — NOT NULL
  • password (로그인pw) — string
  • name (사용자이름) — string
  • email (사용자이메일) — string
  • username (id) — string

menu (메뉴)

  • menu_id — long — Primary key — NOT NULL
  • Store_id — long — Foreign key → Store.Store_id — NOT NULL
  • StoreOwner_id — long — Foreign key → Store.StoreOwner_id — NOT NULL
  • user_id — long — Foreign key → Store.user_id — NOT NULL
  • tyep_id — long — Foreign key → Store.tyep_id — NOT NULL
  • name (메뉴이름) — string
  • price (메뉴가격) — DECIMAL(10,2)

review (리뷰)

  • review_id — long — Primary key — NOT NULL
  • Store_id — long — Foreign key → Store.Store_id — NOT NULL
  • StoreOwner_id — long — Foreign key → Store.StoreOwner_id — NOT NULL
  • user_id (user_id2) — long — Foreign key → Store.user_id — NOT NULL
  • Consumer_id — long — Foreign key → Consumer.Consumer_id — NOT NULL
  • user_id — long — Foreign key → Consumer.user_id — NOT NULL
  • tyep_id — long — Foreign key → Store.tyep_id — NOT NULL
  • content (리뷰내용) — string
  • score (리뷰평점) — double

store_keyword (중간테이블)

  • store_keyword_id — long — Primary key — NOT NULL
  • Store_id — long — Foreign key → Store.Store_id — NOT NULL
  • Keyword_id — long — Foreign key → Keyword.Keyword_id — NOT NULL
  • StoreOwner_id — long — Foreign key → Store.StoreOwner_id — NOT NULL
  • user_id — long — Foreign key → Store.user_id — NOT NULL
  • tyep_id — long — Foreign key → Store.tyep_id — NOT NULL