ch04-model1

Tables (4)

ITEM_ID (Item)

  • ITEM_ID (id) — Long — Primary key — NOT NULL
  • NAME (name) — String
  • PRICE (price) — int
  • STOCKQUANTITY (stockQuantity) — int

MEMBER (Member)

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

ORDERS (Order)

  • ORDER_ID (id) — Long — Primary key — NOT NULL
  • MEMBER_ID (memberId) — Long — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • ORDERDATE (orderDate) — Date
  • STATUS (status) — OrderStatus

ORDER_ITEM (OrderItem)

  • ORDER_ITEM_ID (id) — Long — Primary key — NOT NULL
  • ORDER_ID (orderId) — Long — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID (itemId) — Long — Foreign key → ITEM_ID.ITEM_ID — NOT NULL
  • ORDERPRICE (orderPrice) — int
  • COUNT (count) — int