jpa_study

Tables (4)

ITEM

  • ITEM_ID — Long — Primary key — NOT NULL
  • NAME — String
  • PRICE — int
  • STOCKQUANTITY — int

MEMBER

  • MEMBER_ID — Long — Primary key — NOT NULL
  • NAME — String
  • CITY — String
  • STREET — String
  • ZIPCODE — String

ORDER (ORDERS)

  • MEMBER_ID (MEMBER_ID2) — Long — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • Field (ORDERDATE) — String
  • Field (STATUS) — String
  • Field

ORDER_ITEM

  • ORDER_ITEM_ID (PK) — Long — Primary key — NOT NULL
  • MEMBER_ID (FK) — Long — Foreign key → ORDER.MEMBER_ID — NOT NULL
  • ITEM_ID — Long — Foreign key → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE — Long
  • COUNT — int