쇼핑몰2
테이블 (12)
address
- address_id — int — 기본 키 — NOT NULL
- road_address — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255) — NOT NULL
- user_id — varchar(50) — 외래 키 → users.user_id — NOT NULL
- created_at — datetime — NOT NULL
categories
- category_id — int — 기본 키 — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
order_product
- order_product_id — int — 기본 키 — NOT NULL
- quantity — int — NOT NULL
- price — int — NOT NULL
- order_id — int — 외래 키 → orders.order_id — NOT NULL
- product_id — int — 외래 키 → products.product_id — NOT NULL
orders
- order_id — int — 기본 키 — NOT NULL
- order_total_amount — int — NOT NULL
- order_status — enum('PENDING', 'COMPLETED', 'CANCELED') — NOT NULL
- ordered_at — datetime
- user_id — varchar(50) — 외래 키 → users.user_id — NOT NULL
payment_methods
- payment_method_id — int — 기본 키 — NOT NULL
- payment_method_name — varchar(50) — NOT NULL
payments
- payment_id — int — 기본 키 — NOT NULL
- payment_amount — int — NOT NULL
- order_id — int — 외래 키 → orders.order_id — NOT NULL
- payment_method_id — int — 외래 키 → payment_methods.payment_method_id — NOT NULL
- payment_status — enum('PENDING', 'COMPLETED', 'FAILED') — NOT NULL
- paid_at — datetime
- created_at — datetime — NOT NULL
point_change_types
- point_change_type_id — int — 기본 키 — NOT NULL
- point_change_type_name — varchar(20) — NOT NULL
point_changes
- point_change_history_id — int — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → users.user_id — NOT NULL
- points — int — NOT NULL
- direction — enum('ADD', 'SUBTRACT') — NOT NULL
- memo — varchar(200)
- changed_at — datetime — NOT NULL
- point_change_type_id — int — 외래 키 → point_change_types.point_change_type_id — NOT NULL
product_category
- product_category_id — int — 기본 키 — NOT NULL
- product_id — int — 외래 키 → products.product_id — NOT NULL
- category_id — int — 외래 키 → categories.category_id — NOT NULL
product_details
- product_detail_id — int — 기본 키 — NOT NULL
- product_id — int — 외래 키 → products.product_id — NOT NULL
- product_detail_image_url — varchar(255) — NOT NULL
- product_detail_priority — int — NOT NULL
products
- product_id — int — 기본 키 — NOT NULL
- product_name — varchar(100) — NOT NULL
- product_thumbnail_image_url — varchar(255) — NOT NULL
- product_price — int — NOT NULL
- product_unit — varchar(10) — NOT NULL
- register_at — datetime — NOT NULL
users
- user_id — varchar(50) — 기본 키 — NOT NULL — 아이디
- user_name — varchar(50) — NOT NULL — 이름
- user_password — varchar(255) — 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 — 마지막 로그인 일자