MarsMall
Tables (16)
address
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- label — varchar(15) — NOT NULL
- recipient — varchar(17) — NOT NULL
- recipient_phone — char(11) — NOT NULL
- postal_code — char(5) — NOT NULL
- address — varchar(255) — NOT NULL
- address_detail — varchar(255) — NOT NULL
- is_default — tinyint(4) — NOT NULL
- used_at — datetime
- user_id — int(10) — Foreign key → user.id — NOT NULL
cart
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — int(10) — Foreign key → user.id
cart_item
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- quantity — tinyint(3) — NOT NULL
- cart_id — int(10) — Foreign key → cart.id — NOT NULL
- variant_id — int(10) — Foreign key → variant.id — NOT NULL
category
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- name — varchar(15) — NOT NULL
- code — varchar(15) — NOT NULL
- size_group_id — int(10) — Foreign key → size_group.id
color
- id — int(10) — Primary key — NOT NULL
- label — varchar(20) — NOT NULL
- hex_code — char(6) — NOT NULL
order
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- total_price — int(10) — NOT NULL
- payment_real — int(10) — NOT NULL
- point — int(11) — NOT NULL
- purchaser — varchar(17) — NOT NULL
- purchaser_phone — char(11) — NOT NULL
- purchaser_email — varchar(255) — NOT NULL
- recipient — varchar(17) — NOT NULL
- recipient_phone — char(11) — NOT NULL
- postal_code — char(5) — NOT NULL
- shipping_address — varchar(255) — NOT NULL
- message — varchar(100) — NOT NULL
- status — varchar(255) — NOT NULL
- payment_method — varchar(255) — NOT NULL
- merchant_uid — varchar(255)
- arrived_at — datetime
- paid_at — datetime
- user_id — int(10) — Foreign key → user.id — NOT NULL
order_detail
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- price — mediumint(8) — NOT NULL
- quantity — smallint(5) — NOT NULL
- variant_id — int(10) — Foreign key → variant.id
- order_id — int(10) — Foreign key → order.id — NOT NULL
product
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- code — varchar(50)
- name — varchar(50) — NOT NULL
- description — text — NOT NULL
- retail_price — mediumint(8)
- selling_price — mediumint(8) — NOT NULL
- sales_volume — int(10) — NOT NULL
- review_count — int(10) — NOT NULL
- wish_count — int(10) — NOT NULL
- display — tinyint(4) — NOT NULL
- on_sale — tinyint(4) — NOT NULL
- category_id — int(10) — Foreign key → category.id
product_image
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- url — varchar(2083) — NOT NULL
- order — tinyint(3) — NOT NULL
- product_id — int(10) — Foreign key → product.id — NOT NULL
question
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- is_private — tinyint(4) — NOT NULL
- user_id — int(10) — Foreign key → user.id — NOT NULL
- product_id — int(10) — Foreign key → product.id — NOT NULL
review
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- content — varchar(1000) — NOT NULL
- image_url — varchar(2083)
- rating — tinyint(3) — NOT NULL
- user_id — int(10) — Foreign key → user.id — NOT NULL
- product_id — int(10) — Foreign key → product.id — NOT NULL
size_group
- id — int(10) — Primary key — NOT NULL
- label — varchar(20) — NOT NULL
size_value
- id — int(10) — Primary key — NOT NULL
- label — varchar(20) — NOT NULL
- order — tinyint(3) — NOT NULL
- size_group_id — int(10) — Foreign key → size_group.id — NOT NULL
user
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- username — varchar(17) — NOT NULL
- password — varchar(255)
- name — varchar(17) — NOT NULL
- phone — char(11)
- point — int(11) — NOT NULL
- role — char(5) — NOT NULL
- provider — varchar(20) — NOT NULL
- sns_id — varchar(255)
- refresh_token — varchar(255)
variant
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- quantity — smallint(5) — NOT NULL
- hide — tinyint(4) — NOT NULL
- product_id — int(10) — Foreign key → product.id — NOT NULL
- color_id — int(10) — Foreign key → color.id — NOT NULL
- size_value_id — int(10) — Foreign key → size_value.id — NOT NULL
wishlist
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- product_id — int(10) — Foreign key → product.id
- user_id — int(10) — Foreign key → user.id