JPA TEST
Tables (4)
Item (제품 목록)
- ITEM_ID (Key) — Primary key — NOT NULL
- MEMBER_ID (Key2) — Foreign key → Member.MEMBER_ID — NOT NULL
- name (Field)
- price (Field2)
- stockQuantity (재고수량)
- zeep (Field4)
Member (회원)
- MEMBER_ID (Key) — Primary key — NOT NULL
- name (Field)
- city (Field2)
- street (Field3)
- zeep (Field4)
Order (주문)
- ORDER_ID (Key) — Primary key — NOT NULL
- ITEM_ID (Key2) — Foreign key → Item.ITEM_ID — NOT NULL
- MEMBER_ID (Key22) — Foreign key → Item.MEMBER_ID — NOT NULL
- orderdate (Field2)
- status (Field3)
OrderItem (주문목록)
- ORDER_ITEM_ID (Key) — Primary key — NOT NULL
- ORDER_ID (Key2) — Foreign key → Order.ORDER_ID — NOT NULL
- ITEM_ID (Key22) — Foreign key → Order.ITEM_ID — NOT NULL
- MEMBER_ID (Key222) — Foreign key → Order.MEMBER_ID — NOT NULL
- ITEM_ID (Field)
- ORDER_ID (Field2)