qq
Tables (6)
Product
- product_id — BIGINT — Primary key — NOT NULL
- store_id — BIGINT — NOT NULL
- product_category_id — BIGINT — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- product_price — DECIMAL(10,2)
- product_short_desc — VARCHAR(255) — NOT NULL
- product_long_desc — TEXT — NOT NULL
- product_thumbnail — VARCHAR(500)
- created_at — DATETIME
ProductImage
- product_image_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — NOT NULL
- product_image_link — VARCHAR(500) — NOT NULL
ServiceUser
- user_id — BIGINT
- user_pw — VARCHAR(255)
- user_name — VARCHAR(100) — NOT NULL
- user_phone — VARCHAR(20) — NOT NULL
- user_email — VARCHAR(100) — NOT NULL
- user_age — INT — NOT NULL
- user_gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
- user_role — ENUM('MEMBER', 'MANAGER', 'ADMIN') — NOT NULL
- user_created_at — DATETIME
- last_modified_at — DATETIME
Store
- store_id — BIGINT — Primary key — NOT NULL
- store_category_id — BIGINT — NOT NULL
- store_name — VARCHAR(255) — NOT NULL
- store_short_desc — VARCHAR(255) — NOT NULL
- store_long_desc — TEXT — NOT NULL
- store_start — DATE — NOT NULL
- store_end — DATE — NOT NULL
- store_thumbnail — VARCHAR(500)
StoreCategory
- store_category_id — BIGINT — Primary key — NOT NULL
- store_category_name — VARCHAR(100) — NOT NULL
- store_category_desc — TEXT
Untitled
- Key — Primary key — NOT NULL