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