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