스프링부트와 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