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