베이글몬스터 최종 ERD

테이블 (6)

CartProducts

  • cartProductId — bigint(20) — 기본 키 — NOT NULL
  • cartId — bigint(20) — 외래 키 → Carts.cartId — NOT NULL
  • productId — bigint(20) — 외래 키 → Products.productId — NOT NULL
  • quantity — int(11) — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Carts

  • cartId — bigint(20) — 기본 키 — NOT NULL
  • userId — bigint(20) — 외래 키 → Users.userId — NOT NULL
  • storeId — bigint(20) — 외래 키 → Stores.storeId — NOT NULL
  • totalPrice — int(11) — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL
  • storeStatus — varchar(255)

Notifications

  • notificationId — bigint(20) — 기본 키 — NOT NULL
  • userId — bigint(20) — 외래 키 → Users.userId — NOT NULL
  • cartId — bigint(20) — 외래 키 → Carts.cartId — NOT NULL
  • content — varchar(255)
  • createdDate — timestamp — NOT NULL
  • rd — boolean — NOT NULL
  • expriationTime — timestamp — NOT NULL

Products

  • productId — bigint(20) — 기본 키 — NOT NULL
  • storeId — bigint(20) — 외래 키 → Stores.storeId — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — varchar(255)
  • price — int(11) — NOT NULL
  • productPictureUrl — text
  • popularity — int(11) — NOT NULL — 일반, 인기
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — boolean — NOT NULL

Stores

  • storeId — bigint(20) — 기본 키 — NOT NULL
  • userId — bigint(20) — 외래 키 → Users.userId — NOT NULL
  • name — varchar(255) — NOT NULL
  • address — varchar(255) — NOT NULL
  • storePictureUrl — text
  • phone — varchar(20) — NOT NULL
  • content — varchar(255)
  • productCreatedTime — time
  • openedTime — time
  • closedTime — time
  • closedDays — varchar(255)
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL

Users

  • userId — bigint(20) — 기본 키 — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone — varchar(11) — NOT NULL
  • email — varchar(100) — NOT NULL
  • role — varchar(100) — NOT NULL