shoppingmall
Tables (4)
orders
- order_id — int — Primary key — NOT NULL
- quantity — int
- total_price (totalprice) — BIGINT
- Field (order_dte) — varchar(50)
- address_id — BIGINT — Foreign key → useraddress.address_id — NOT NULL
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL
- product_id — varchar(50) — Foreign key → products.product_id — NOT NULL
products
- product_id — varchar(50) — Primary key — NOT NULL
- product_name — varchar(50)
- product_description — varchar(200)
- product_price — int
- product_image_url — varchar(200)
- product_category — enum
useraddress (useraddresses)
- address_id — BIGINT — Primary key — NOT NULL
- address_line — varchar(255)
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL
users
- user_id — varchar(50) — Primary key — NOT NULL
- user_name — varchar(50)
- user_password — varchar(200)
- user_birth — varchar(15)
- user_auth — varchar(10)
- user_point — int
- created_at — datatime
- lastest_login_at (latest_login_at) — datetime