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