team_seenear
Tables (7)
ai_chat_details
- id — INTEGER — Primary key — NOT NULL
- chat_id — INTEGER — Foreign key → ai_chats.id — NOT NULL
- speaker — VARCHAR(10) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
ai_chats
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
friends
- id — INTEGER — Primary key — NOT NULL
- requester_id — INTEGER — Foreign key → users.id — NOT NULL
- receiver_id — INTEGER — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- call_connected — BOOLEAN
- updated_at — DATETIME
keywords
- id — INTEGER — Primary key — NOT NULL
- category — VARCHAR(20) — NOT NULL
- keyword_name — VARCHAR(100) — NOT NULL
memories_images
- id — INTEGER — Primary key — NOT NULL
- chat_id — INTEGER — Foreign key → ai_chats.id — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- satisfaction_rating — INTEGER
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME
user_keywords
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- keyword_id — INTEGER — Foreign key → keywords.id — NOT NULL
- weight — INTEGER
- updated_at — DATETIME
users
- id — INTEGER — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- birth_date — DATE — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- region — VARCHAR(100) — NOT NULL
- created_at — DATETIME