2025-2- cource
Tables (4)
Member (Untitled)
- 회원ID (member_id) — bigint — Primary key — NOT NULL
- 회원로그인ID (member_login_id) — varchar(50)
- 비밀번호 (member_pw) — varchar(100)
- 적립금 (member_point) — int
- Field
Order (Untitled2)
- 주문ID (Key) — bigint — Primary key — NOT NULL
- 주문일시 (Field) — datetime
- 주문총액 (Field2) — int
- 주문상태 (Field3) — varchar(20)
- 회원ID (member_id) — bigint — Foreign key → Member.회원ID — NOT NULL
Order_Product (Untitled4)
- 주문품목ID (Key2) — bigint — Primary key — NOT NULL
- 주문ID (Key3) — bigint — Foreign key → Order.주문ID — NOT NULL
- 상품ID (Key4) — bigint — Foreign key → Product.상품ID — NOT NULL
Product (Untitled3)
- 상품ID (Key) — bigint — Primary key — NOT NULL
- 재고량 (Field) — int
- 가격 (Field2) — int
- 상품이름 (Field3) — varcahr(50)