jpa_study
Tables (4)
ITEM
- ITEM_ID — Long — Primary key — NOT NULL
- NAME — String
- PRICE — int
- STOCKQUANTITY — int
MEMBER
- MEMBER_ID — Long — Primary key — NOT NULL
- NAME — String
- CITY — String
- STREET — String
- ZIPCODE — String
ORDER (ORDERS)
- MEMBER_ID (MEMBER_ID2) — Long — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- Field (ORDERDATE) — String
- Field (STATUS) — String
- Field
ORDER_ITEM
- ORDER_ITEM_ID (PK) — Long — Primary key — NOT NULL
- MEMBER_ID (FK) — Long — Foreign key → ORDER.MEMBER_ID — NOT NULL
- ITEM_ID — Long — Foreign key → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE — Long
- COUNT — int