JPA Mapping toy project
Tables (4)
ITEM (Untitled4)
- ITEM_ID (Key) — Primary key — NOT NULL
- NAME (Field)
- PRICE (Field2)
- STOCKQUANTITY (Field3)
MEMBER (Untitled)
- MEMBER_ID (멤버아이디) — Primary key — NOT NULL
- NAME (Field)
- CITY (Field2)
- STREET (Field3)
- ZIPCODE (Field4)
ORDERS (Untitled2)
- ORDER_ID (주문 아이디) — Primary key — NOT NULL
- MEMBER_ID (멤버아이디) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- ORDERDATE (Field)
- STATUS (Field2)
ORDER_ITEM (Untitled3)
- ORDER_ITEM_ID (Key) — Primary key — NOT NULL
- ORDER_ID (주문 아이디) — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (Key2) — Foreign key → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE (Field)
- COUNT (Field2)