쇼핑몰
테이블 (8)
Addresses
- address_id — int auto_increament — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → User.user_id — NOT NULL
- address — text — NOT NULL
Category
- category_id — int auto_increment — 기본 키 — NOT NULL
- category_name — varchar(255) — NOT NULL
- parent (Field) — int
- created_at (Field2) — Datetime — NOT NULL
Order
- order_id — int auto_increament — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → User.user_id — NOT NULL
- order_date — datetime — NOT NULL
- total_money — int — NOT NULL
- destination — text — NOT NULL
Order_Product
- order_id — int auto_increament — 외래 키 → Order.order_id — NOT NULL
- product_id — int auto_increment — 외래 키 → Product.product_id — NOT NULL
- quantity — int — NOT NULL
PointRecord
- point_id — int auto_increament — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → User.user_id — NOT NULL
- whenuse — varchar(50) — NOT NULL
- plusminus — int — NOT NULL
- created_at — datetime — NOT NULL
Product
- product_id — int auto_increment — 기본 키 — NOT NULL
- product_name — varchar(50) — NOT NULL
- thumbnail_url — varchar(100)
- price — decimal — NOT NULL
- img_url — varchar(100)
- quantity — int — NOT NULL
- detail — text — NOT NULL
Product_Category
- product_id — int auto_increment — 외래 키 → Product.product_id — NOT NULL
- category_id — int auto_increment — 외래 키 → Category.category_id — NOT NULL
User
- user_id — varchar(50) — 기본 키 — NOT NULL
- user_birth — varchar(8) — NOT NULL
- user_name — varchar(50) — NOT NULL
- user_password — varchar(200) — NOT NULL
- user_point — int — NOT NULL
- created_at — datetime — NOT NULL
- latest_login_at — datetime
- user_auth — varchar(10) — NOT NULL