JPA 활용 1
테이블 (7)
CATEGORY
- Key (CATEGORY_ID) — NUMBER — 기본 키 — NOT NULL
- Key (PARENT_CATEGORY_ID) — NUMBER — 외래 키 → CATEGORY.Key — NOT NULL
- Field (NAME) — VARCHAR — NOT NULL
DELIVERY
- Key (DELIVERY_ID) — NUMBER — 기본 키 — NOT NULL
- Field (STATUS) — NUMBER — NOT NULL
- Field (CITY) — VARCHAR — NOT NULL
- Field (STREET) — VARCHAR — NOT NULL
- Field (ZIPCODE) — VARCHAR — NOT NULL
ITEM
- Key (ITEM_ID) — NUMBER — 기본 키 — NOT NULL
- Field (NAME) — VARCHAR — NOT NULL
- Field2 (PRICE) — NUMBER — NOT NULL
- Field3 (STOCK_QUANTITY) — NUMBER — NOT NULL
- Field4 (DTYPE) — VARCHAR — NOT NULL
- Field5 (ARTIST) — VARCHAR
- Field (ETC) — VARCHAR
- Field2 (AUTHOR) — VARCHAR
- Field3 (ISBN) — VARCHAR
- Field4 (DIRECTOR) — VARCHAR
- Field5 (ACTOR) — VARCHAR
MEMBER
- MEMBER_ID — NUMBER — 기본 키 — NOT NULL
- Field (NAME) — VARCHAR — NOT NULL
- Field (CITY) — VARCHAR
- Field (STREET) — VARCHAR
- Field (ZIPCODE) — VARCHAR
ORDERS
- Key (ORDER_ID) — NUMBER — 기본 키 — NOT NULL
- MEMBER_ID — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- Key (DELIVERY_ID) — NUMBER — 외래 키 → DELIVERY.Key — NOT NULL
- Field (ORDER_DATE) — DATE — NOT NULL
- Field (STATUS) — NUMBER — NOT NULL
ORDER_ITEM
- Key (ORDER_ITEM_ID) — NUMBER — 기본 키 — NOT NULL
- Key (ORDER_ID) — NUMBER — 외래 키 → ORDERS.Key — NOT NULL
- Key (ITEM_ID) — NUMBER — 외래 키 → ITEM.Key — NOT NULL
- Field (ORDER_PRICE) — NUMBER — NOT NULL
- Field (COUNT) — NUMBER — NOT NULL
Untitled (CATEGORY_ITEM)
- Key (ITEM_ID) — NUMBER — 외래 키 → ITEM.Key — NOT NULL
- Key (CATEGORY_ID) — NUMBER — 외래 키 → CATEGORY.Key — NOT NULL