project
Tables (9)
addresses
- address_id — INT
- user_id — INT — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- recipient_phone — VARCHAR(20) — NOT NULL
- address — TEXT — NOT NULL
- customs_clearance_code — VARCHAR(20)
carts
- cart_id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- size — VARCHAR(50)
- quantity — INT
- created_at — TIMESTAMP
events
- event_id — INT
- event_name — VARCHAR(255) — NOT NULL
- event_description — TEXT
- event_date — TIMESTAMP
orders
- order_id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- address_id — INT — NOT NULL
- quantity — INT — NOT NULL
- total_price — DECIMAL(10,2) — NOT NULL
- order_date — TIMESTAMP
payments
- payment_id — INT
- user_id — INT — NOT NULL
- order_id — INT — NOT NULL
- refund_account — VARCHAR(50)
- payment_date — TIMESTAMP
products
- product_id — INT
- product_name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- discount_price — DECIMAL(10,2)
- discount_percentage — INT
- coupon — TEXT
- market_name — VARCHAR(255)
- likes — INT
- created_at — TIMESTAMP
reviews
- review_id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- height — FLOAT
- weight — FLOAT
- size — VARCHAR(50)
- face_shape — VARCHAR(50)
- review_text — TEXT
- created_at — TIMESTAMP
third_party_services
- service_id — INT
- service_name — VARCHAR(255) — NOT NULL
- country — VARCHAR(100) — NOT NULL
- data_type — TEXT — NOT NULL
- created_at — TIMESTAMP
users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- gender — ENUM('male', 'female', 'other') — NOT NULL
- created_at — TIMESTAMP