mechuri

Tables (4)

chat_room (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • id (Key2) — INT — Foreign key → user.id — NOT NULL
  • user_id (Field) — VARCHAR(40)

message (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • id (Key22) — INT — Foreign key → chat_room.id — NOT NULL
  • chatroom_id (Field3) — INT
  • query (Field) — TEXT
  • answer (Field2) — TEXT
  • time (Field4) — TIMESTAMP

user (User)

  • id (Key) — INT — Primary key — NOT NULL
  • id (Field) — VARCHAR(40)
  • password (Field2) — VARCHAR(40)
  • name (Field3) — VARCHAR(10)

user_preference (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • id (Key2) — INT — Foreign key → user.id — NOT NULL
  • user_id (Field) — VARCHAR(40)
  • food (Field3) — TEXT
  • score (Field2) — INT
  • query (Key3) — TEXT — Foreign key → message.id — NOT NULL