Data Village
Tables (10)
Badges
- badge_id — int — Primary key — NOT NULL
- title — varchar(100)
- path — varchar(200)
Chapters
- chapter_id — int — Primary key — NOT NULL
- title — varchar(100)
- episode_id — int — Foreign key → Episodes.episode_id — NOT NULL
- badge_id — int — Foreign key → Badges.badge_id — NOT NULL
Clear_Chapters
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → Users.user_id — NOT NULL
- chapter_id — int — Foreign key → Chapters.chapter_id — NOT NULL
Clear_Episodes
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → Users.user_id — NOT NULL
- episode_id — int — Foreign key → Episodes.episode_id — NOT NULL
Episodes
- episode_id — int — Primary key — NOT NULL
- title — varchar(100)
- subtitle — varchar(100)
- character — varchar(200)
- story — varchar(500)
- chapter_num — int
- badge_id — int — Foreign key → Badges.badge_id — NOT NULL
Models
- model_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → Users.user_id — NOT NULL
- title — varchar(100)
- path — varchar(200)
Scripts
- script_id — int — Primary key — NOT NULL
- order — int
- figure — int
- line — varchar(1000)
- step_id — int — Foreign key → Steps.step_id — NOT NULL
Steps
- step_id — int — Primary key — NOT NULL
- title — varchar(100)
- default_code — varchar(2000)
- answer_code — varchar(2000)
- result_picture — varchar(200)
- chapter_id — int — Foreign key → Chapters.chapter_id — NOT NULL
User_Badges
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → Users.user_id — NOT NULL
- badge_id — int — Foreign key → Badges.badge_id — NOT NULL
Users
- user_id — int — Primary key — NOT NULL