df

Tables (15)

ACHIEVEMENT_MASTER

  • achievement_id — INT
  • title — VARCHAR(100) — NOT NULL
  • condition_description — TEXT
  • reward_point — INT

COLLISION_LOG

  • collision_id — INT
  • session_id — INT — NOT NULL
  • obstacle_type — VARCHAR(100)
  • impact_speed — FLOAT
  • triggered_at — DATETIME

COMMENT

  • comment_id — INT
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

FILE_ATTACHMENT

  • file_id — INT
  • post_id — INT
  • user_id — INT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_size — INT
  • file_type — VARCHAR(50)
  • created_at — DATETIME

POST

  • post_id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME

POST_TAG

  • post_id — INT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL

SCENARIO_EXECUTION

  • execution_id — INT
  • session_id — INT — NOT NULL
  • scenario_id — INT — NOT NULL
  • executed_at — DATETIME

SCENARIO_MASTER

  • scenario_id — INT
  • title — VARCHAR(100) — NOT NULL
  • difficulty — VARCHAR(20)
  • description — TEXT

SCENARIO_RESULT

  • result_id — INT
  • execution_id — INT — NOT NULL
  • judge_status — VARCHAR(20)
  • score — INT
  • feedback_text — TEXT

SIMULATION_SESSION

  • session_id — INT
  • user_id — INT — NOT NULL
  • scene_type — VARCHAR(100)
  • controller_status — VARCHAR(100)
  • voice_accel_setting — VARCHAR(100)
  • started_at — DATETIME
  • ended_at — DATETIME

TAG

  • tag_id — INT
  • tag_name — VARCHAR(100) — NOT NULL

USER

  • user_id — INT
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — DATETIME

USER_ACHIEVEMENT

  • user_achievement_id — INT
  • user_id — INT — NOT NULL
  • achievement_id — INT — NOT NULL
  • unlocked_at — DATETIME

USER_PROGRESS

  • progress_id — INT
  • user_id — INT — NOT NULL
  • total_play_time — INT
  • completion_rate — FLOAT
  • last_played_at — DATETIME

WEAKNESS_ANALYSIS

  • analysis_id — INT
  • user_id — INT — NOT NULL
  • weak_incident_type — VARCHAR(100)
  • failure_count — INT
  • updated_at — DATETIME