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