ch07-model4

Tables (10)

CATEGORY (Untitled5)

  • CATEGORY_ID (id) — Long — Primary key — NOT NULL
  • NAME (name) — String
  • (items) — List
  • PARENT_ID (parent) — Category
  • (child) — List

CATEGORY_ITEM (Untitled6)

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

DELIVERY (Untitled2)

  • DELIVERY_ID (id) — Long — Primary key — NOT NULL
  • (order) — Order
  • CITY (city) — String
  • STREET (street) — String
  • ZIPCODE (zipcode) — String
  • STATUS (status) — DeliveryStatus

ITEM (Untitled4)

  • ITEM_ID (id) — Long — Primary key — NOT NULL
  • NAME (name) — String
  • PRICE (price) — int
  • STOCKQUANTITY (stockQuantity) — int
  • (categories) — List
  • DTYPE (Field)
  • ARTIST (artist)
  • ETC (etc)
  • AUTHOR (author)
  • ISBN (isbn)
  • DIRECTOR (director)
  • ACTOR (actor)

MEMBER (Member)

  • MEMBER_ID (id) — Long — Primary key — NOT NULL
  • NAME (name) — String
  • CITY (city) — String
  • STREET (street) — String
  • ZIPCODE (zipcode) — String
  • (orders) — List

ORDERS (Order)

  • ORDER_ID (id) — Long — Primary key — NOT NULL
  • MEMBER_ID (member) — Member — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID (delivery) — Delivery — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
  • (orderItems) — List
  • ORDERDATE (orderDate) — Date
  • STATUS (status) — OrderStatus

ORDER_ITEM (Untitled3)

  • ORDER_ITEM_ID (id) — Long — Primary key — NOT NULL
  • ORDER_ID (order) — Order — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID (item) — Item — Foreign key → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE (orderPrice) — int
  • COUNT (count) — int

Untitled (Movie)

  • (director)
  • (actor)

Untitled (Book)

  • (author)
  • (isbn)

Untitled (Album)

  • (artist)
  • (etc)