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