Hyper

Tables (8)

categorys (카테고리)

  • category_id (식별자) — LONG — Primary key — NOT NULL
  • name (이름) — VARCHAR(100)
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

items (재고)

  • item_id (식별자) — LONG — Primary key — NOT NULL
  • product_id (제품 식별자) — LONG — Foreign key → products.product_id — NOT NULL
  • color (색상) — VARCHAR(50)
  • size (사이즈) — VARCHAR(20)
  • stock (재고) — INT
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

order_items (주문 아이템)

  • order_item_id (식별자) — LONG — Primary key — NOT NULL
  • item_id (식별자2) — LONG — Foreign key → items.item_id — NOT NULL
  • order_id (식별자3) — LONG — Foreign key → orders.order_id — NOT NULL
  • quantity (수량) — INT
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

orders (주문)

  • order_id (식별자) — LONG — Primary key — NOT NULL
  • user_id (구매자) — LONG — Foreign key → users.user_id — NOT NULL
  • total_price (결제 가격) — INT
  • address_id (배송주소) — LONG — Foreign key → shipping_addresses.address_id — NOT NULL
  • status (주문 상태) — ENUM( processing, shipped, delivered )
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

products (제품)

  • product_id (식별자) — LONG — Primary key — NOT NULL
  • store_id (스토어 식별자) — LONG — Foreign key → stores.store_id — NOT NULL
  • user_id (등록자) — LONG — Foreign key → users.user_id — NOT NULL
  • category_id (카테고리) — LONG — Foreign key → categorys.category_id — NOT NULL
  • name (이름) — VARCHAR(255)
  • description (설명) — TEXT
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

shipping_addresses (배송 주소)

  • address_id (식별자) — LONG — Primary key — NOT NULL
  • user_id (유저 식별자) — LONG — Foreign key → users.user_id — NOT NULL
  • title (제목) — VARCHAR(255)
  • address (주소) — VARCHAR(255)
  • address_detail (상세 주소) — VARCHAR(255)
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

stores (스토어)

  • store_id (식별자) — LONG — Primary key — NOT NULL
  • user_id (관리자) — LONG — Foreign key → users.user_id — NOT NULL
  • store_name (이름) — VARCHAR(100)
  • store_description (소개) — TEXT
  • store_logo (로고) — VARCHAR(255)
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

users (유저)

  • user_id (식별자) — LONG — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255)
  • password (비밀번호) — VARCHAR(255)
  • name (이름) — VARCHAR(100)
  • role (역할) — ENUM('BUYER', 'SELLER', 'ADMIN')
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME