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