stylo

Tables (18)

address

  • address_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • recipient — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • address_detail — VARCHAR(255)
  • postal_code — VARCHAR(10) — NOT NULL
  • is_default — BOOLEAN

cart_item

  • cart_item_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT
  • product_id — BIGINT
  • option_id — BIGINT
  • quantity — INT

category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — varchar(255)
  • created_at — timestamp

faq

  • faq_id — BIGINT — Primary key — NOT NULL
  • question — VARCHAR(255) — NOT NULL
  • answer — TEXT — NOT NULL
  • category — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL

image

  • image_id — BIGINT — Primary key — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • owner_type — ENUM('MEMBER', 'PRODUCT', 'REVIEW', 'BANNER') — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

inquiry

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('WAITING','ANSWERED')
  • created_at — TIMESTAMP

inquiry_reply

  • inquiry_reply_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — NOT NULL
  • admin_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • is_term — BOOLEAN
  • is_marketing — BOOLEAN
  • profile_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

option_key

  • option_key_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT
  • name — timestamp

option_value

  • option_value_id (option_value_Id) — BIGINT — Primary key — NOT NULL
  • option_key_id — BIGINT
  • value — VARCHAR(100)

option_variant

  • option_variant_id — BIGINT — Primary key — NOT NULL
  • product_option_id — BIGINT
  • option_value_id — BIGINT

order_item

  • order_item_id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • option_id — BIGINT
  • quantity — INT — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • address_id — BIGINT — NOT NULL
  • status — ENUM('PENDING','PAID','SHIPPING','COMPLETED','CANCELLED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

payment

  • payment_id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — NOT NULL
  • pg_provider — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • status — ENUM('READY','SUCCESS','FAILED','REFUND') — NOT NULL
  • transaction_id — VARCHAR(100)
  • paid_at — TIMESTAMP

product

  • product_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10,2) — NOT NULL
  • thumbnailUrl — VARCHAR(100)
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

product_option

  • product_option_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT
  • sku — BIGINT
  • additional_price — DECIMAL(10,2)
  • stock — BIGINT
  • created_at — TIMESTAMP

review

  • review_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • rating — INT
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

wishlist

  • wishlist_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL