syluv
Tables (14)
Cart (장바구니)
- Key (장바구니ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- menu_id (메뉴ID) — BIGINT — Foreign key → Menu.menu_id — NOT NULL
- field (수량) — INT
CartItem (장바구니 아이템)
- item_id (아이템ID) — BIGINT — Primary key — NOT NULL
- menu_id (메뉴ID) — BIGINT — Foreign key → Menu.menu_id — NOT NULL
Market (시장)
- market_id (시장ID) — BIGINT — Primary key — NOT NULL
- market_name (시장 이름) — VARCHAR
- description (가게정보) — VARCHAR
- startHour (시작시간) — VARCHAR
- closeHour (영업 시간) — VARCHAR
- location (위치) — VARCHAR
- contact (연락처) — VARCHAR
- imageUrl (이미지) — VARCHAR
- xloc (위도) — VARCHAR
- yloc (경도) — VARCHAR
MarketQrVisit (방문한시장)
- marketqrvisit_id (방문한시장ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- market_id (시장ID2) — BIGINT — Foreign key → Market.market_id — NOT NULL
- qrVisit (방문수) — INT
Menu (메뉴)
- menu_id (메뉴ID) — BIGINT — Primary key — NOT NULL
- store_id (가게ID) — BIGINT — Foreign key → Store.store_id — NOT NULL
- name (메뉴명) — VARCHAR
- price (가격) — INT
- content (메뉴설명) — VARCHAR
- imageUrl (이미지) — VARCHAR
Order (주문내역)
- order_id (주문 ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- orderNum (주문번호) — VARCHAR
- phoneNum (번호) — VARCHAR
- visitHour (방문시간) — INT
- visitMin (방문시간(분)) — INT
- pickUpRoute (픽업루트) — VARCHAR
OrderItem (주문상세)
- order_item_id (주문항목ID) — BIGINT — Primary key — NOT NULL
- order_id (주문 ID) — BIGINT — Foreign key → Order.order_id — NOT NULL
- menu_id (메뉴ID) — BIGINT — Foreign key → Menu.menu_id — NOT NULL
- quantity (수량) — INT
Review (리뷰)
- review_id (리뷰ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- order_id (주문 ID) — BIGINT — Foreign key → Order.order_id — NOT NULL
- rating (별점) — INT
- content (리뷰내용) — VARCHAR
ReviewImage (리뷰사진)
- reviewimage_id (리뷰이미지ID) — BIGINT — Primary key — NOT NULL
- review_id (리뷰ID) — BIGINT — Foreign key → Review.review_id — NOT NULL
- imageUrl (이미지주소) — VARCHAR
ReviewLike (도움이돼요)
- reviewlike (도움이돼요ID) — BIGINT — Primary key — NOT NULL
- review_id (리뷰ID) — BIGINT — Foreign key → Review.review_id — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
Store (가게)
- store_id (가게ID) — BIGINT — Primary key — NOT NULL
- market_id (시장ID) — BIGINT — Foreign key → Market.market_id — NOT NULL
- name (가게 이름) — VARCHAR
- category (카테고리) — 한식, 분식, 간식, 음료, 식료품, 의류, 의류잡화, 직물, 침구, 생활잡화, 기타
- description (설명) — VARCHAR
- location (주소) — VARCHAR
- opening_hours (오픈 시간) — VARCHAR
- closing_hours (마감 시간) — VARCHAR
- contact (연락처) — VARCHAR
- image_url (이미지) — VARCHAR
- xloc (x 좌표) — INT
- yloc (y 좌표) — INT
StoreVisit (가게방문)
- storevisit_ID (가게방문) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- store_id (가게ID) — BIGINT — Foreign key → Store.store_id — NOT NULL
- visitYn (방문여부) — BOOLEAN
User (사용자)
- user_id (사용자ID) — BIGINT — Primary key — NOT NULL
- nickname (닉네임) — VARCHAR
- name (이름) — VARCHAR
- password (비밀번호) — VARCHAR
- email (이메일) — VARCHAR
VisitList (방문 리스트)
- visit_id (방문ID) — BIGINT — Primary key — NOT NULL
- store_id (가게ID) — BIGINT — Foreign key → Store.store_id — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- visit_status (방문상태) — VARCHAR
- visitedDate (방문날짜)