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