JPA prac
테이블 (7)
배송 (DELIVERY)
- (DELIVERY_ID) — BIGINT — 기본 키 — NOT NULL
- (CITY) — VARCHAR — NOT NULL
- (STREET) — VARCHAR — NOT NULL
- (ZIPCODE) — VARCHAR — NOT NULL
- (STATUS) — VARCHAR — NOT NULL
상품 (ITEM)
- (ITEM_ID) — BIGINT — 기본 키 — NOT NULL
- (NAME) — VARCHAR — NOT NULL
- (PRICE) — INTEGER — NOT NULL
- (STOCKQUANTITY) — INTEGER — NOT NULL
- (DTYPE) — VARCHAR — NOT NULL
- (ACTOR) — VARCHAR — NOT NULL
- (ARTIST) — VARCHAR — NOT NULL
- (AUTHOR) — VARCHAR — NOT NULL
- (DIRECTOR) — VARCHAR — NOT NULL
- (ETC) — VARCHAR — NOT NULL
- (ISBN) — VARCHAR — NOT NULL
상품 카테고리 (CATEGORY_ITEM)
- (CATEGORY_ID) — BIGINT — 외래 키 → 카테고리.CATEGORY_ID — NOT NULL
- (ITEM_ID) — BIGINT — 외래 키 → 상품.ITEM_ID — NOT NULL
주문 (ORDERS)
- (ORDER_ID) — BIGINT — 기본 키 — NOT NULL
- (MEMBER_ID) — BIGINT — 외래 키 → 회원.MEMBER_ID — NOT NULL
- (DELIVERY_ID) — BIGINT — 외래 키 → 배송.DELIVERY_ID — NOT NULL
- (ORDERDATE) — TIMESTAMP — NOT NULL
- (STATUS) — VARCHAR — NOT NULL
주문 상품 (ORDER_ITEM)
- (ORDER_ITEM_ID) — BIGINT — 기본 키 — NOT NULL
- (ORDER_ID) — BIGINT — 외래 키 → 주문.ORDER_ID — NOT NULL
- (ITEM_ID) — BIGINT — 외래 키 → 상품.ITEM_ID — NOT NULL
- (ORDERPRICE) — INTEGER — NOT NULL
- (COUNT) — INTEGER — NOT NULL
카테고리 (CATEGORY)
- (CATEGORY_ID) — BIGINT — 기본 키 — NOT NULL
- (NAME) — NOT NULL
회원 (MEMBER)
- (MEMBER_ID) — BIGINT — 기본 키 — NOT NULL
- (NAME) — VARCHAR — NOT NULL
- (CITY) — VARCHAR
- (STREET) — VARCHAR
- (ZIPCODE) — VARCHAR