LingRing
Tables (9)
Untitled (user)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(500) — NOT NULL
- Field (profile_image) — varchar(500)
Untitled (user_stats)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — UNIQUE
- Field (level) — enum — NOT NULL
- Field (manner_temperature) — decimal — NOT NULL
- Field (total_call_count) — bigint — NOT NULL
- Field (current_streak_days) — int — NOT NULL
- Field (expression_count) — bigint — NOT NULL
- Field (last_study_date) — date — NOT NULL
Untitled (user_expression)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (expression) — varchar(500) — NOT NULL
- Field (meaning) — varchar(500) — NOT NULL
Untitled (call_history)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_a_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_b_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (duration_seconds) — int — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (ended_at) — datetime — NOT NULL
Untitled (call_analyze)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — unique (user_id, call_history_id)
- Key (call_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL — unique (user_id, call_history_id)
- Field (good_points_json) — json — NOT NULL
- Field (feedback_json) — json — NOT NULL
- Field (status) — enum — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled (call_content)
- Key (id) — bigint — Primary key — NOT NULL
- Key (call_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL — UNIQUE
- Field (content) — longtext — NOT NULL
Untitled (recommend_expression)
- Key (id) — bigint — Primary key — NOT NULL
- Field (expression) — varchar(500) — NOT NULL
- Field2 (meaning) — varchar(500) — NOT NULL
Untitled (user_block)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (blocked_user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (user_report)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (reported_user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (reason) — enum — NOT NULL
- Field (description) — varchar(255) — NOT NULL