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