JPA TEST

Tables (4)

Item (제품 목록)

  • ITEM_ID (Key) — Primary key — NOT NULL
  • MEMBER_ID (Key2) — Foreign key → Member.MEMBER_ID — NOT NULL
  • name (Field)
  • price (Field2)
  • stockQuantity (재고수량)
  • zeep (Field4)

Member (회원)

  • MEMBER_ID (Key) — Primary key — NOT NULL
  • name (Field)
  • city (Field2)
  • street (Field3)
  • zeep (Field4)

Order (주문)

  • ORDER_ID (Key) — Primary key — NOT NULL
  • ITEM_ID (Key2) — Foreign key → Item.ITEM_ID — NOT NULL
  • MEMBER_ID (Key22) — Foreign key → Item.MEMBER_ID — NOT NULL
  • orderdate (Field2)
  • status (Field3)

OrderItem (주문목록)

  • ORDER_ITEM_ID (Key) — Primary key — NOT NULL
  • ORDER_ID (Key2) — Foreign key → Order.ORDER_ID — NOT NULL
  • ITEM_ID (Key22) — Foreign key → Order.ITEM_ID — NOT NULL
  • MEMBER_ID (Key222) — Foreign key → Order.MEMBER_ID — NOT NULL
  • ITEM_ID (Field)
  • ORDER_ID (Field2)