자바orm프로그래밍
테이블 (7)
CATEGORY (Untitled6)
- CATEGORY_ID (PK) — 기본 키 — NOT NULL
- PARENT_ID (FK)
- NAME (Field)
CATEGORY_ITEM (Untitled7)
- CATEGORY_ID (FK) — 기본 키 — NOT NULL
- ITEM_ID (PK) — 외래 키 → ITEM.ITEM_ID — NOT NULL
- CATEGORY_ID (PK2) — 외래 키 → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID (Field)
DELIVERY (Untitled5)
- DELIVERY_ID (PK) — 기본 키 — NOT NULL
- ORDER_ID (PK2) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- MEMBER_ID (FK) — 외래 키 → ORDERS.MEMBER_ID — NOT NULL
- CITY (Field)
- STREET (Field2)
- ZIPCODE (Field3)
- STATUS (Field4)
ITEM (Untitled2)
- ITEM_ID (PK) — 기본 키 — NOT NULL
- NAME (Field)
- PRICE (Field2)
- STOCKQUANTITY (Field3)
MEMBER (Untitled)
- MEMBER_ID (PK) — 기본 키 — NOT NULL
- NAME (Field)
- CITY (Field2)
- STREET (Field3)
- ZIPCODE (Field4)
ORDERS (Untitled3)
- ORDER_ID (PK) — 기본 키 — NOT NULL
- MEMBER_ID (FK) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- ORDERDATE (Field)
- STATUS (Field2)
ORDER_ITEM (Untitled4)
- ORDER_ITEM_ID (PK) — 기본 키 — NOT NULL
- ORDER_ID (FK) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (PK2) — 외래 키 → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE (Field)
- COUNT (Field2)