KREAM-Clone
Tables (14)
account (계좌)
- id (PK) — String — Primary key — NOT NULL
- user_id (FK) — String — Foreign key → user.id — NOT NULL
- bank (Field) — String
- account_number (Field2) — String
- depositor (Field3) — String
address (주소)
- id (PK) — String — Primary key — NOT NULL
- user_id (FK) — String — Foreign key → user.id — NOT NULL
- address (Field) — String
- detail (Field2) — String
- phone (Field3) — String
- receiver (Field4) — String
brand (브랜드)
- id (PK) — String — Primary key — NOT NULL
- brand (Field) — String
buy_request (구매 요청)
- id (PK) — String — Primary key — NOT NULL
- user_id (FK1) — String — Foreign key → user.id — NOT NULL
- product_id (FK2) — String — Foreign key → product.id — NOT NULL
- price (Field) — String
- status (Field2) — String
- created_at (Field3) — Date
- updated_at (Field4) — Date
category (메인 카테고리)
- id (PK) — String — Primary key — NOT NULL
- category (Field) — String
deal (거래)
- id (PK) — String — Primary key — NOT NULL
- buy_request_id (FK1) — String — Foreign key → buy_request.id — NOT NULL
- sell_request_id (FK2) — String — Foreign key → sell_request.id — NOT NULL
- status (Field) — String
- created_at (Field2) — Date
- updated_at (Field3) — Date
image (상품 이미지)
- id (PK) — String — Primary key — NOT NULL
- product_id (FK) — String — Foreign key → product.id — NOT NULL
- url (Field) — String
payment (결제)
- id (PK) — String — Primary key — NOT NULL
- deal_id (FK1) — String — Foreign key → deal.id — NOT NULL
- user_id (FK2) — String — Foreign key → user.id — NOT NULL
- payment_method (Field) — String
- total_price (Field2) — Number
- status (Field3) — String
- created_at (Field4) — Date
- updated_at (Field5) — Date
product (상품)
- id (PK) — String — Primary key — NOT NULL
- category_id (FK1) — String — Foreign key → category.id — NOT NULL
- sub_category_id (FK2) — String — Foreign key → sub_category.id — NOT NULL
- brand_id (FK3) — String — Foreign key → brand.id — NOT NULL
- kr_name (Field) — String
- eng_name (Field2) — String
- model_number (Field3) — String
- color (Field4) — String
- sex (Field5) — String
- created_at (Field6) — Date
- updated_at (Field7) — Date
sell_request (판매 요청)
- id (PK) — String — Primary key — NOT NULL
- user_id (FK1) — String — Foreign key → user.id — NOT NULL
- product_id (FK2) — String — Foreign key → product.id — NOT NULL
- price (Field) — String
- status (Field2) — String
- created_at (Field3) — Date
- updated_at (Field4) — Date
size (상품 사이즈)
- id (PK) — String — Primary key — NOT NULL
- product_id (FK) — String — Foreign key → product.id — NOT NULL
- size (Field) — String
- price (Field2) — Number
sub_category (서브 카테고리)
- id (PK) — String — Primary key — NOT NULL
- category_id (FK) — String — Foreign key → category.id — NOT NULL
- sub_category (Field) — String
user (회원)
- id (PK) — String — Primary key — NOT NULL
- username (Field) — String
- nickname (Field1) — String
- email (Field2) — String
- password (Field3) — String
- phone (Field4) — String
- shoe_size (Field5) — String
- profile_image (Field6) — String
- provider (Field7) — String
- point (Field8) — Number
- created_at (Field9) — Date
wishlist (찜 목록)
- id (PK) — String — Primary key — NOT NULL
- user_id (FK1) — String — Foreign key → user.id — NOT NULL
- product_id (FK2) — String — Foreign key → product.id — NOT NULL