ssense
Tables (7)
Images (사진)
- item_id (Key) — long — Foreign key → Item.item_id — NOT NULL
Item (상품)
- item_id (Key) — long — Primary key — NOT NULL
- item_name (이름) — str
- price (가격) — int
- category (분류)
- designer (디자이너) — str
- stock (재고) — int
Mapped (Untitled)
- created_date (생성일) — localDateTime
- views (조회수) — long
Member (회원)
- member_id (Key) — long — Primary key — NOT NULL
- username (아이디) — str
- password (비밀번호) — str
- role (권한) — role
- first_name (이름) — str
- last_name (성) — str
- address (주소) — address
Order (주문)
- order_id (Key) — long — Primary key — NOT NULL
- member_id (Key2) — long — Foreign key → Member.member_id — NOT NULL
- status (상태) — orderstatus
- order_date (주문일시) — localDateTime
OrderItem (주문한 상품)
- item_id (Key) — long — Foreign key → Item.item_id — NOT NULL
- order_id (Key2) — long — Foreign key → Order.order_id — NOT NULL
- order_price (주문 당시 가격) — int
- count (수량) — int
Sale (할인)
- item_id (Key) — long — Foreign key → Item.item_id — NOT NULL
- period (세일 기간) — period
- rate (할인율) — float