123
Tables (10)
community_comments
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → community_posts.id — NOT NULL
- userid — varchar(50) — NOT NULL
- content — text — NOT NULL
- created_at — datetime
community_likes
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → community_posts.id — NOT NULL
- userid — varchar(50) — NOT NULL
- created_at — datetime
community_posts
- id — int — Primary key — NOT NULL
- userid — varchar(50) — NOT NULL
- category — varchar(20) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- image — varchar(255)
- views — int
- likes — int
- created_at — datetime
notifications
- id — int — Primary key — NOT NULL
- userid — varchar(50) — NOT NULL
- message — text — NOT NULL
- link — varchar(255) — NOT NULL
- is_read — tinyint(1)
- created_at — datetime
order_items
- id — int — Primary key — NOT NULL
- order_uid — varchar(100) — Foreign key → orders.order_uid — NOT NULL
- product_id — int — NOT NULL
- product_name — varchar(100) — NOT NULL
- price — int — NOT NULL
- qty — int — NOT NULL
- image — varchar(255)
orders
- id — int — Primary key — NOT NULL
- order_uid — varchar(100) — NOT NULL
- userid — varchar(50) — NOT NULL
- total_amount — int — NOT NULL
- status — varchar(20)
- receiver_name — varchar(50) — NOT NULL
- receiver_phone — varchar(20) — NOT NULL
- receiver_address — varchar(255) — NOT NULL
- created_at — datetime
products
- id — int — Primary key — NOT NULL
- product_name — varchar(100) — NOT NULL
- region — varchar(50)
- type — varchar(50)
- rice_polish — varchar(20)
- abv — varchar(20)
- price — int
- image — varchar(255)
- badges — varchar(100)
- description — text
- created_at — datetime
- stock — int
restock_notifications
- product_id — int
- userid — varchar(50)
users
- id — int — Primary key — NOT NULL
- userid — varchar(50) — NOT NULL
- email — varchar(100)
- password — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- nickname — varchar(50)
- phone — varchar(20)
- social_type — varchar(20)
- role — enum('user','manager','admin')
- social_id — varchar(100)
- created_at — datetime
wishlists
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- product_id — int — NOT NULL
- created_at — datetime