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