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 (방문날짜)