12334
Tables (7)
Untitled
- Key — Primary key — NOT NULL
order
- order_id — varchar(255) — Primary key — NOT NULL
- user_id — varchar(255) — Foreign key → users.user_id — NOT NULL
order_detail
- orderdetail_id — varchar(255) — Primary key — NOT NULL
- order_id — varchar(255) — Foreign key → order.order_id — NOT NULL
- product_id — varchar(255) — NOT NULL
- quantity — int
- totalprice — int
- product_id (product_id2) — varchar(255) — Foreign key → product.product_id — NOT NULL
payment
- payment_id — varchar(255) — Primary key — NOT NULL
- order_id — varchar(255) — Foreign key → order.order_id — NOT NULL
product
- product_id — varchar(255) — Primary key — NOT NULL
- product_name — varchar(255) — NOT NULL
- product_price — int — NOT NULL
- product_quantity — int — NOT NULL
product_image
- image_id — varchar(255) — Primary key — NOT NULL
- product_id — varchar(255) — Foreign key → product.product_id — NOT NULL
- image_link — varchar(255)
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 — 마지막 로그인 일자