carrot

Tables (5)

Untitled (product_img)

  • Key (url) — varchar(255) — Primary key — NOT NULL
  • product_id — int(11) — Foreign key → products.product_id — NOT NULL

Untitled (chatrooms)

  • room_id — int(11) — Primary key — NOT NULL
  • product_id — int(11) — Foreign key → products.product_id — NOT NULL
  • user_id (seller_id) — int(11) — Foreign key → users.user_id — NOT NULL
  • user_id (buyer_id) — int(11) — Foreign key → users.user_id — NOT NULL

Untitled (chats)

  • chat_id — int(11) — Primary key — NOT NULL
  • content — longtext — NOT NULL
  • time — timestamp — NOT NULL
  • room_id — int(11) — Foreign key → Untitled.room_id — NOT NULL
  • user_id (sender_id) — int(11) — Foreign key → users.user_id — NOT NULL
  • read — bit(1) — NOT NULL

products

  • product_id — int(11) — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • price — int(11)
  • register_date — timestamp — NOT NULL
  • category — varchar(20) — NOT NULL
  • content — longtext — NOT NULL
  • user_id — int(11) — Foreign key → users.user_id — NOT NULL

users

  • user_id — int(11) — Primary key — NOT NULL
  • area — VARCHAR(20)