JPA_PROJECT

Tables (7)

CATEGORY (Untitled6)

  • CATEGORY_ID (Key) — Long — Primary key — NOT NULL
  • PARENT_ID (FK) — Long
  • NAME (Field) — varchar2

CATEGORY_ITEM (Untitled7)

  • ITEM_ID (Key) — Long — Foreign key → ITEM.ITEM_ID — NOT NULL
  • CATEGORY_ID (Key2) — Long — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL

DELIVERY (Untitled3)

  • DELIVERY_ID (Key) — Long — Primary key — NOT NULL
  • STATUS (Field) — varchar2
  • CITY (Field2) — varchar2
  • STREET (Field3) — varchar2
  • ZIPCODE (Field4) — varchar2

ITEM (Untitled5)

  • ITEM_ID (Key) — Long — Primary key — NOT NULL
  • PRICE (Field) — int
  • STOCK (Field2) — int
  • DTYPE (Field3) — varchar2
  • ARTIST (Field4) — varchar2
  • ETC (Field5) — varchar2
  • AUTHOR (Field6) — varchar2
  • ISBN (Field7) — varchar2
  • DIRECTOR (Field8) — varchar2
  • ACTOR (Field9) — varchar2

MEMBER (Untitled)

  • MEMBER_ID (Key) — Long — Primary key — NOT NULL
  • NAME (Field) — varchar2
  • CITY (Field2) — varchar2
  • STREET (Field3) — varchar2
  • ZIPCODE (Field4) — varchar2

ORDER (Untitled2)

  • ORDER_ID (Key) — Long — Primary key — NOT NULL
  • DELIVERY_ID (Key3) — Long — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
  • MEMBER_ID (Key2) — Long — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DATE (Field3) — Date
  • STATUS (Field4) — varchar2

ORDER_ITEM (Untitled4)

  • ORDER_ITEM_ID (Key) — Long — Primary key — NOT NULL
  • ORDER_ID (Key2) — Long — Foreign key → ORDER.ORDER_ID — NOT NULL
  • ITEM_ID (Key3) — Long — Foreign key → ITEM.ITEM_ID — NOT NULL
  • PRICE (Field) — int
  • COUNT (Field2) — int