ㄴㅁㅊㅁㄴ
Tables (12)
cart
- cart_id — BIGINT
- user_id — VARCHAR(64) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
cart_item
- cart_item_id — BIGINT
- cart_id — BIGINT — NOT NULL
- sku_id — VARCHAR(64) — NOT NULL
- qty — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
option_template
- template_id — BIGINT
- category_id — BIGINT — NOT NULL
- option_name — VARCHAR(255) — NOT NULL
- input_type — VARCHAR(30) — NOT NULL
- is_required — TINYINT(1) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
option_template_value
- template_value_id — BIGINT
- template_id — BIGINT — NOT NULL
- option_value — VARCHAR(255) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME
order_item
- order_item_id — BIGINT
- order_id — BIGINT — NOT NULL
- sku_id — VARCHAR(64) — NOT NULL
- qty — INT — NOT NULL
- unit_price — BIGINT — NOT NULL
- total_price — BIGINT — NOT NULL
- created_at — DATETIME
orders
- order_id — BIGINT
- user_id — VARCHAR(64) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- total_price — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
product
- product_id — BIGINT
- category_id — BIGINT — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- description — TEXT
- moq — INT — NOT NULL
- is_customizable — TINYINT(1) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
product_option
- product_option_id — BIGINT
- product_id — BIGINT — NOT NULL
- template_id — BIGINT — NOT NULL
- created_at — DATETIME
product_option_value
- product_option_value_id — BIGINT
- product_option_id — BIGINT — NOT NULL
- option_value — VARCHAR(255) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME
sku
- sku_id — VARCHAR(64)
- product_id — BIGINT — NOT NULL
- stock_quantity — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
sku_option_value
- sku_id — VARCHAR(64) — Primary key — NOT NULL
- product_option_value_id — BIGINT — Primary key — NOT NULL
sku_price_by_qty
- price_id — BIGINT
- sku_id — VARCHAR(64) — NOT NULL
- min_qty — INT — NOT NULL
- max_qty — INT
- unit_price — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME