스프링부트와 JPA 활용

테이블 (7)

category (Untitled)

  • id (Key) — long — 기본 키 — NOT NULL
  • parent_id (Field) — long
  • name (Field2) — string

category_item (Category)

  • category_id (id2) — long — 외래 키 → item.id — NOT NULL
  • item_id (Key) — long — 외래 키 → category.id — NOT NULL

delivery (Delivery)

  • id — long — 기본 키 — NOT NULL
  • status (order) — deliverystatus
  • city (address) — address
  • street (status) — address
  • zipcode (Field) — address

item (Item)

  • id — long — 기본 키 — NOT NULL
  • name — string
  • price — int
  • stockquantity (stockQuantity)
  • dtype (categories) — list
  • artist (Field)
  • etc (Field2)
  • author (Field3)
  • isbn (Field4)
  • director (Field5)
  • actor (Field6)

member (Member)

  • id — long — 기본 키 — NOT NULL
  • name — string
  • city (address) — address
  • street (orders) — address
  • zipcode (Field) — address

order_item (OrderItem)

  • id — long — 기본 키 — NOT NULL
  • order_id (id2) — long — 외래 키 → orders.id — NOT NULL
  • item_id (id3) — long — 외래 키 → item.id — NOT NULL
  • orderprice (orderPrice)
  • count — int

orders (Order)

  • id — long — 기본 키 — NOT NULL
  • member_id (id2) — long — 외래 키 → member.id — NOT NULL
  • delivery (id3) — long — 외래 키 → delivery.id — NOT NULL
  • orderdate (orderDate) — date
  • status — orderstatus