neuro

Tables (17)

categories (Category)

  • id (int) — Primary key — NOT NULL
  • name (varchar(100))

categories_sub (CategorySub)

  • id — int — Primary key — NOT NULL
  • category_id — int — Foreign key → categories.id — NOT NULL
  • name
  • Field2

categories_sub_sub (CategorySubSub)

  • id — int — Primary key — NOT NULL
  • category_id — int — Foreign key → categories.id — NOT NULL
  • category_sub_id — int — Foreign key → categories_sub.id — NOT NULL
  • name — int

centers (Center)

  • id — int — Primary key — NOT NULL
  • code (Field)
  • name

favorite (Favorite)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • training_id — not null — Foreign key → trainings.id — NOT NULL

homework (Homework)

  • id — Primary key — NOT NULL
  • training_id — not null — Foreign key → trainings.id — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • instructor_id — int — Foreign key → user.center_id — NOT NULL
  • id (id2) — int — Foreign key → training_settings.id — NOT NULL
  • user_id (user_id2) — int — Foreign key → training_settings.user_id — NOT NULL
  • traing_id (training_id2) — not null — Foreign key → training_settings.traing_id — NOT NULL
  • id (id22) — int — Foreign key → training_settings.stage_id — NOT NULL
  • Field

symptoms (Symptom)

  • id — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

training_images (TrainingImage)

  • id — int — Primary key — NOT NULL
  • training_id — not null — Foreign key → trainings.id — NOT NULL
  • image_url
  • start_level — int
  • end_level — int
  • order — int

training_levels (TrainingStage)

  • id — int — Primary key — NOT NULL
  • training_id (traing_id) — not null — Foreign key → trainings.id — NOT NULL
  • stage — int

training_setting_fields (TrainingSettingFields)

  • id — int — Primary key — NOT NULL
  • training_id — not null — Foreign key → trainings.id — NOT NULL
  • field_name

training_settings (TrainingSetting)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • traing_id (training_id) — not null — Foreign key → trainings.id — NOT NULL
  • stage_id — int — Foreign key → training_levels.id — NOT NULL
  • is_default
  • is_homework
  • is_course
  • is_std_dev
  • time_to_solve — int
  • time_to_present — int
  • method_to_present
  • hint_activation
  • time_to_hint — int
  • num_hint — int
  • star_reward — int

trainings (Training)

  • id — not null — Primary key — NOT NULL
  • name
  • avg_accuracy — int
  • avg_response_time
  • difficulty — null
  • Field5
  • Field6

trainings_categories (TrainingCategory)

  • id — int — Primary key — NOT NULL
  • category_id — int — Foreign key → categories.id — NOT NULL
  • training_id (trainng_id) — not null — Foreign key → trainings.id — NOT NULL

user (User)

  • id — int — Primary key — NOT NULL
  • center_id — int — Foreign key → centers.id — NOT NULL
  • symptom_id — int — Foreign key → symptoms.id — NOT NULL
  • nickname
  • email (Field2)
  • kakao_id
  • password
  • mobile
  • business_license_img
  • business_license_number
  • is_accepted
  • age — int
  • birthdate
  • gender
  • created_at

user_login_logs (LoginLog)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • created_at

user_schedule (Schedule)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • title
  • type — int
  • frequency_day — int
  • frequency_month — int
  • start_date
  • end_date
  • created_at
  • Field

user_training_result (UserTrainingResult)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • training_id — not null — Foreign key → trainings.id — NOT NULL
  • stage — int
  • problem_total — int
  • accuracy — int
  • response_time
  • time_spent
  • star — int