05232 - 2024-05-23 12:40:09
Tables (11)
carts
- cart_id — INT
- user_id — VARCHAR(50) — Foreign key — NOT NULL
- product_id — INT — Foreign key — NOT NULL
- quantity — INT — NOT NULL
- created_at — DATETIME — NOT NULL
categories
- category_id — INT
- name — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
images
- image_id — INT
- product_id — INT — Foreign key — NOT NULL
- image_type — VARCHAR(50) — NOT NULL
- image_url — VARCHAR(255)
login_history
- history_id — INT
- user_id — VARCHAR(50) — Foreign key — NOT NULL
- login_at — DATETIME — NOT NULL
order_details
- detail_id — INT
- order_id — INT — Foreign key — NOT NULL
- product_id — INT — Foreign key — NOT NULL
- quantity — INT — NOT NULL
- price_per_item — DECIMAL(10, 2) — NOT NULL
orders
- order_id — INT
- user_id — VARCHAR(50) — Foreign key — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- order_status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
point_history
- history_id — INT
- user_id — VARCHAR(50) — Foreign key — NOT NULL
- change_type — VARCHAR(50) — NOT NULL
- points — INT — NOT NULL
- changed_at — DATETIME — NOT NULL
- description — VARCHAR(255)
product_categories
- product_id — INT — Foreign key — NOT NULL
- category_id — INT — Foreign key — NOT NULL
products
- product_id — INT
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- description — TEXT
- thumbnail_image — VARCHAR(255)
- detail_image — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_addresses
- address_id — INT
- user_id — VARCHAR(50) — Foreign key — NOT NULL
- address — VARCHAR(255) — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — varchar(50) — Primary key — NOT NULL — 아이디
- user_name — varchar(50) — NOT NULL — 이름
- user_password — varchar(200) — NOT NULL — mysql password 사용
- user_birth — varchar(8) — NOT NULL — 생년월일 : 19840503
- user_auth — varchar(10) — NOT NULL — 권한: ROLE_ADMIN,ROLE_USER
- user_point — int — NOT NULL — default : 1000000
- created_at — datetime — NOT NULL — 가입 일자
- latest_login_at — datetime — 마지막 로그인 일자