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