jpa_study

Tables (4)

DRDER_ID (주문테이블)

  • ORDER_ID (주문기본키) — bigint — Primary key — NOT NULL
  • MEMBER_ID (회원외래키) — bigint — Foreign key → MEMBER_ID.MEMBER_ID — NOT NULL
  • ORDERDATE (주문날짜) — datetime
  • STATUS (등급) — orderstatus

ITEM (상품테이블)

  • ITEM_ID (상품기본키) — bigint — Primary key — NOT NULL
  • NAME (이름) — varchar
  • PRICE (가격) — integer
  • STOCKQUANTITY (재고물량) — integer

MEMBER_ID (회원테이블)

  • MEMBER_ID (회원기본키) — bigint — Primary key — NOT NULL
  • NAME (이름) — varchar
  • CITY (도시명) — varchar
  • STREET (도로명) — varchar
  • ZIPCODE (지번) — varchar

ORDER_ITEM (주문상품테이블)

  • ORDER_ITEM_ID (주문상품기본키) — bigint — Primary key — NOT NULL
  • ORDER_ID (주문왜래키) — bigint — Foreign key → DRDER_ID.ORDER_ID — NOT NULL
  • ITEM_ID (상품왜래키) — bigint — Foreign key → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE (주문금액) — integer
  • COUNT (주문수량) — integer