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