erd
Tables (20)
BottleCategories (바틀카테고리)
- id (Key) — int — Primary key — NOT NULL
- name (Field)
- SubCategoryId (Key2) — int — Foreign key → SubCategories.id — NOT NULL
- BottleId (Key3) — int — Foreign key → Bottles.id — NOT NULL
BottleTags (바틀태그)
- Key — Primary key — NOT NULL
- BottleId (Key2) — int — Foreign key → Bottles.id — NOT NULL
- TagId (Key3) — int — Foreign key → tags.id — NOT NULL
Bottles (바틀)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- description (Field2) — varchar
- image (Field3) — varchar
- inventory (Field4) — int
- volume (Field5) — int
- degree (Field6) — int
- origin (Field7) — varchar
- packaging (Field8) — boolean
- price (Field9) — int
- limit (Field10) — int
- memo (Field11) — varchar
- deliveryPolicy (Field12) — varchar
- pointPolicy (Field13) — varchar
- sellStatus (Field14) — varchar
- MarketId (Key2) — int — Foreign key → Markets.id — NOT NULL
Carts (장바구니)
- id (Key) — int — Primary key — NOT NULL
- quantity (Field) — int
- createdAt (Field2) — date
- UserId (Key2) — int — Foreign key → Users.id — NOT NULL
- BottleId (Key3) — int — Foreign key → Bottles.id — NOT NULL
Dorments (휴면)
- UserId (Key) — int — Foreign key → Users.id — NOT NULL
- createdAt (Field) — date
Likes (좋아요)
- id (Key) — int — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → Users.id — NOT NULL
- BottleId (Key3) — int — Foreign key → Bottles.id — NOT NULL
MainCategories (메인카테고리)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
Markets (매장리스트)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- latitude (Field2)
- longitude (Field3)
- UserId (Key2) — int — Foreign key → Users.id — NOT NULL
Notifications (알림)
- id (Key) — int — Primary key — NOT NULL
- Field
- id (Key2) — int — Foreign key → Users.id — NOT NULL
Orders (주문)
- id (Key) — int — Primary key — NOT NULL
- quantity (Field) — int
- deliveryType (Field3) — varchar
- createdAt (Field2) — date
- OrdererId (Key2) — int — Foreign key → Users.id — NOT NULL
- RecipientId (Key4) — int — Foreign key → Users.id — NOT NULL
- BottleId (Key3) — int — Foreign key → Bottles.id — NOT NULL
Pickups (픽업)
- id (Key2) — int — Primary key — NOT NULL
- OrderId (Key) — int — Foreign key → Orders.id — NOT NULL
- createdAt (Field) — date
- type (Field2) — varchar
PointDetails (포인트내역)
- id (Key) — int — Primary key — NOT NULL
- isUsed (Field) — boolean
- point (Field2) — int
- description (Field3) — varchar
- createdAt (Field4) — date
- UserId (Key2) — int — Foreign key → Users.id — NOT NULL
Recommendations (추천)
- id (Key) — int — Primary key — NOT NULL
- BottleId (Key2) — int — Foreign key → Bottles.id — NOT NULL
ReviewImages (리뷰사진)
- id (Key) — int — Primary key — NOT NULL
- image (Field) — varchar
- ReviewId (Key2) — int — Foreign key → Reviews.id — NOT NULL
Reviews (리뷰)
- id (Key) — int — Primary key — NOT NULL
- description (Field) — varchar
- scope (Field2) — int
- createdAt (Field3) — date
- UserId (Key2) — int — Foreign key → Users.id — NOT NULL
- BottleId (Key3) — int — Foreign key → Bottles.id — NOT NULL
Settlements (정산)
- id (Key) — int — Primary key — NOT NULL
- Field
- PickupId (Key2) — int — Foreign key → Pickups.id — NOT NULL
- UserId (Key3) — int — Foreign key → Users.id — NOT NULL
SubCategories (서브카테고리)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- CategoryId (Key2) — int — Foreign key → MainCategories.id — NOT NULL
Users (유저)
- id (Key) — int — Primary key — NOT NULL
- email (Field) — varchar
- password (Field2) — varchar
- name (Field3) — varchar
- phoneNumber (Field4) — varchar
- birth (Field5) — varchar
- inviteCode (Field6) — varchar
- createdAt (Field7) — date
- point (Field8) — int
- type (Field9) — varchar
- marketingAgree (Field10) — boolean
- marketingNight (Field11) — boolean
buisness (사업가)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- phoneNumber (Field2) — varchar
- address (Field3) — varchar
- UserId (Key2) — int — Foreign key → Users.id — NOT NULL
tags (태그)
- id (Key) — int — Primary key — NOT NULL
- tag (Field) — varchar