JPATest
Tables (11)
A (Parent)
- A_id (Key) — Primary key — NOT NULL
- name (Field)
A (Parent1)
- A_id (Key) — Primary key — NOT NULL
- name (Field)
B (Child)
- B_id (Key) — Primary key — NOT NULL
- A_id (Key2) — Foreign key → A.A_id — NOT NULL
- name (Field)
B (Child1)
- B_id (Key) — Primary key — NOT NULL
- name (Field)
- A_id (Key2) — Foreign key → A.A_id — NOT NULL
Category (카테고리)
- category_id (기본키) — bigint — Primary key — NOT NULL
- name (이름) — varchar(255)
- parent_id (부모??) — bigint
Category_Item (카테고리 상품 매핑테이블)
- item_id (기본키) — bigint — Foreign key → Item.item_id — NOT NULL
- category_id (기본키2) — bigint — Foreign key → Category.category_id — NOT NULL
Delivery (배송지)
- delivery_id (기본키) — bigint — Primary key — NOT NULL
- city (주소관련) — varchar(255)
- street (주소관련1) — varchar(255)
- zipcode (우편주소) — varchar(255)
- status (배송상태) — varchar(255)
Item (상품)
- item_id (기본키) — bigint — Primary key — NOT NULL
- name (이름) — varchar(255)
- price (가격) — int
- stockquantity (재고수량) — int
Member (사용자)
- member_id (기본키) — bigint — Primary key — NOT NULL
- name (사용자이름) — varchar(255)
- city (주소관련) — varchar(255)
- street (주소관련1) — varchar(255)
- zipcode (우편주소) — varchar(255)
Order_Item (주문과 상품 매핑테이블)
- order_item_id (대리키) — bigint — Primary key — NOT NULL
- orderprice (주문가격) — int
- count (주문수) — int
- item_id (기본키2) — bigint — Foreign key → Item.item_id — NOT NULL
- order_id (기본키3) — bigint — Foreign key → Orders.order_id — NOT NULL
Orders (주문)
- order_id (기본키) — bigint — Primary key — NOT NULL
- orderdate (주문날짜) — datetime
- status (주문상태) — varchar(255)
- member_id (기본키2) — bigint — Foreign key → Member.member_id — NOT NULL
- delivery_id (기본키3) — bigint — Foreign key → Delivery.delivery_id — NOT NULL