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