jpamodel

Tables (5)

Category (카테고리)

  • category_id — Long — Primary key — NOT NULL
  • Field

Item (상품)

  • item_id — bigint — Primary key — NOT NULL
  • item_name — string — NOT NULL
  • price — int — NOT NULL
  • stockQuantity — int — NOT NULL
  • categories

Member (회원)

  • member_id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • city — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)

Order (주문)

  • order_id — bigint — Primary key — NOT NULL
  • member_id — Long — NOT NULL
  • orderItems — List — NOT NULL
  • delivery — ? — NOT NULL
  • orderDate — Date — NOT NULL
  • status (statud) — ? — NOT NULL

OrderItem (주문상품)

  • order_item_id — Long — Primary key — NOT NULL
  • item_id — NOT NULL
  • Field