shopping-mall-final
Tables (10)
cart_items
- id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- product_id — bigint — NOT NULL
- quantity — int — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
members
- id — bigint — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- gender — varchar(255) — NOT NULL
- birth_date — date — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
order_items
- id — bigint — NOT NULL
- order_id — bigint
- product_id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- price — bigint — NOT NULL
- image_file_name — varchar(255) — NOT NULL
- quantity — int — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
order_stats
- id — bigint — NOT NULL
- product_id — bigint — NOT NULL
- birth_year_range — varchar(255) — NOT NULL
- gender — varchar(255) — NOT NULL
- count — bigint — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
orders
- id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- status — varchar(255) — NOT NULL
- pay_type — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
pays
- id — bigint — NOT NULL
- order_id — bigint — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
points
- id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- point — bigint — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
products
- id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- price — bigint — NOT NULL
- image_file_name — varchar(255) — NOT NULL
- stock — int — NOT NULL
- description — text — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
rate_stats
- id — bigint — NOT NULL
- product_id — bigint — NOT NULL
- birth_year_range — varchar(255) — NOT NULL
- gender — varchar(255) — NOT NULL
- total_score — bigint — NOT NULL
- count — bigint — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL
rates
- id — bigint — NOT NULL
- order_item_id — bigint — NOT NULL
- score — smallint — NOT NULL
- created_at — datetime — NOT NULL
- last_modified_at — datetime — NOT NULL