shop

Tables (8)

Admin (Untitled8)

  • PK (admin_id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (password) — String
  • Field (adminUserId) — String

Category (종류)

  • PK (category_id) — Long — Primary key — NOT NULL
  • FK (parent_id) — Long
  • (name) — String

CategoryItem (상품 종류)

  • PK (category_item_id) — Long — Primary key — NOT NULL
  • FK (category_id) — Long
  • FK (item_id) — Long
  • PK (item_id2) — Long — Foreign key → Item.PK — NOT NULL
  • PK (category_id2) — Long — Foreign key → Category.PK — NOT NULL

Delivery (배송)

  • PK (delivery_id) — Long — Primary key — NOT NULL
  • (status) — DeliveryStatus
  • (address) — Address
  • PK (order_id) — Long — Foreign key → Orders.PK — NOT NULL

Item (상품)

  • PK (item_id) — Long — Primary key — NOT NULL
  • (name) — String
  • (price) — int
  • (stockquantity) — int
  • (dtype) — Type
  • Book (author) — String
  • Book (isbn) — String
  • Album (artist) — String
  • Album (etc) — String
  • Movie (director) — String
  • Movie (actor) — String

Member (회원)

  • PK (member_id) — Long — Primary key — NOT NULL
  • (name) — String
  • (address) — Address

OrderItem (주문 상품)

  • PK (order_item_id) — Long — Primary key — NOT NULL
  • FK (order_id) — Long
  • FK (item_id) — Long
  • (orderprice) — int
  • (count) — int
  • PK (order_id2) — Long — Foreign key → Orders.PK — NOT NULL
  • PK (item_id2) — Long — Foreign key → Item.PK — NOT NULL

Orders (주문)

  • PK (order_id) — Long — Primary key — NOT NULL
  • Field (member_id) — Long
  • FK (delivery_id) — Long
  • (orderdate) — LocalDateTime
  • (status) — OrderStatus
  • PK (member_id2) — Long — Foreign key → Member.PK — NOT NULL