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