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