자바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)