d

Tables (4)

chatroom

  • room_id (room_od) — INT — Primary key — NOT NULL
  • receiver_id — INT — NOT NULL
  • sender_id — INT — NOT NULL
  • product_id — INT

message

  • receiver_id — INT — Primary key — NOT NULL
  • sender_id — INT — Primary key — NOT NULL
  • Key — Foreign key → user.Key — NOT NULL
  • product_id (Key2) — INT — Foreign key → product.product_id — NOT NULL
  • room_id (room_od) — INT — Foreign key → chatroom.room_id — NOT NULL
  • content — TEXT

product

  • product_id (Key) — INT — Primary key — NOT NULL
  • owner_id — INT — NOT NULL
  • product_name — VARCHAR(50) — NOT NULL
  • price — INT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • datetime — DATE
  • description — TEXT

user

  • Key — Primary key — NOT NULL
  • user_id — INT
  • email — VARCHAR(50) — NOT NULL
  • pwd — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL