kuit_week9

Tables (8)

Address (주소)

  • PK (address_id) — NOT NULL — Primary key — NOT NULL
  • Field2 (address) — NOTNULL
  • Field3 (createdDate) — NOTNULL
  • Field4 (modifiedDate) — NOTNULL
  • PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL

Like (찜)

  • PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
  • PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
  • Field3 (createdDate) — NOTNULL
  • Field4 (modifiedDate) — NOTNULL
  • Field5 (status) — NOT NULL

Member (회원)

  • PK (member_id) — NOT NULL — Primary key — NOT NULL
  • Field (password) — NOT NULL
  • Field2 (nickname) — NOT NULL
  • Field3 (phone) — NOT NULL
  • Field4 (role) — NOT NULL
  • Field5 (createdDate) — NOTNULL
  • Field (modifiedDate) — NOTNULL
  • Field (grade) — NOT NULL

Menu (메뉴)

  • PK (menu_id) — NOTNULL — Primary key — NOT NULL
  • Field2 (category) — NOT NULL
  • Field3 (name) — NOT NULL
  • Field4 (price) — NOT NULL
  • Field (createdDate) — NOTNULL
  • Field (modifiedDate) — NOTNULL
  • Field (status) — NOT NULL
  • PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL

Order (주문)

  • PK (order_id) — NOTNULL — Primary key — NOT NULL
  • Field3 (payment) — NOT NULL
  • Field4 (request) — NOT NULL
  • Field5 (createdDate) — NOTNULL
  • Field (modifiedDate) — NOTNULL
  • Field (totalPrice) — NOTNULL
  • Field (status) — NOT NULL
  • PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
  • PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL

Review (리뷰)

  • PK (review_id) — NOTNULL — Primary key — NOT NULL
  • Field4 (rating) — NOTNULL
  • Field5 (content) — NOT NULL
  • Field (createdDate) — NOTNULL
  • Field (modifiedDate) — NOTNULL
  • Field (status) — NOT NULL
  • PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
  • PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
  • PK (menu_id) — NOTNULL — Foreign key → Menu.PK — NOT NULL

ShoppingCart (장바구니)

  • PK (cart_id) — NOTNULL — Primary key — NOT NULL
  • Field (quantity) — NOTNULL
  • Field (createdDate) — NOTNULL
  • Field (modifiedDate) — NOTNULL
  • Field
  • PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
  • PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
  • PK (menu_id) — NOTNULL — Foreign key → Menu.PK — NOT NULL
  • PK (order_id) — NOTNULL — Foreign key → Order.PK — NOT NULL

Store (가게)

  • PK (store_id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field2 (category) — NOT NULL
  • Field3 (address) — NOT NULL
  • Field4 (storeImageUrl)
  • Field (minPrice) — NOT NULL
  • Field (deliveryTip) — NOT NULL
  • Field (rating) — NOTNULL
  • Field (reviewCount) — NOTNULL
  • Field (operationTime) — NOT NULL
  • Field (likesCount) — NOTNULL
  • Field (createdDate) — NOTNULL
  • Field (modifiedDate) — NOTNULL