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