Shopping mall
Tables (4)
attach
- idx — int — Primary key — NOT NULL
- code — varchar(11) — Foreign key → goods.code — NOT NULL
- original_name — varchar(260) — NOT NULL
- stored_name — varchar(36) — NOT NULL
- size — int
- delete_yn — enum — NOT NULL
- insert_time — datetime — NOT NULL
- update_time — datetime
cart
- idx — int — Primary key — NOT NULL
goods
- idx — int — Primary key — NOT NULL
- code — varchar(11) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- price — int — NOT NULL
- quantity — int — NOT NULL
- status — enum — NOT NULL
- delete_yn — enum — NOT NULL
- insert_time — datetime — NOT NULL
- update_time — datetime
user
- idx — int — Primary key — NOT NULL
- email — varchar(50) — Primary key — NOT NULL
- password — varchar(50) — NOT NULL
- nickname — varchar(30) — NOT NULL
- phone — varchar(11) — NOT NULL
- address — varchar(150) — NOT NULL
- status — enum — NOT NULL
- delete_yn — enum — NOT NULL
- insert_time — datetime — NOT NULL
- update_time — datetime