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