TestJpa/jpa026

Tables (4)

MEMBER

  • MEMBER_ID — Primary key — NOT NULL
  • USERNAME — NOT NULL
  • TEAM_ID — Foreign key → TEAM.TEAM_ID — NOT NULL

ORDER

  • ORDER_ID — Primary key — NOT NULL
  • MEMBER_ID — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_ID — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • ORDERAMOUNT — NOT NULL

PRODUCT

  • PRODUCT_ID — Primary key — NOT NULL
  • NAME

TEAM

  • TEAM_ID — Primary key — NOT NULL
  • NAME — NOT NULL