# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models

# Create your models here.


class TeacherInfo(models.Model):
    teacher_id = models.IntegerField(db_column='teacher_id')
    teacher_name = models.CharField(db_column='teacher_name', max_length=45, blank=True, null=True)
    first_semester_expect = models.FloatField(db_column='first_semester_expect', blank=True, null=True)
    second_semester_expect = models.FloatField(db_column='second_semester_expect', blank=True, null=True)
    first_semester_hours = models.FloatField(db_column='first_semester_hours', blank=True, null=True)
    second_semester_hours = models.FloatField(db_column='second_semester_hours', blank=True, null=True)
    first_semester_degree = models.FloatField(db_column='first_semester_degree', blank=True, null=True)
    second_semester_degree = models.FloatField(db_column='second_semester_degree', blank=True, null=True)
    teacher_apply_done = models.CharField(db_column='teacher_apply_done', max_length=45, blank=True, null=True)
    notes = models.CharField(db_column='notes', max_length=2000, blank=True, null=True)
    update_time = models.DateTimeField(db_column='update_time', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'teacher_info'


class CourseInfo(models.Model):
    course_id = models.CharField(db_column='course_id', max_length=45, blank=True, null=True)
    course_name = models.CharField(db_column='course_name', max_length=45, blank=True, null=True)
    student_type = models.CharField(db_column='student_type', max_length=45, blank=True, null=True)
    year = models.CharField(db_column='year', max_length=45, blank=True, null=True)
    class_name = models.CharField(db_column='class_name', max_length=45, blank=True, null=True)
    semester = models.CharField(db_column='semester', max_length=45, blank=True, null=True)
    course_hour = models.FloatField(db_column='course_hour', blank=True, null=True)
    course_degree = models.FloatField(db_column='course_degree', blank=True, null=True)
    course_type = models.CharField(db_column='course_type', max_length=45, blank=True, null=True)
    allow_teachers = models.IntegerField(db_column='allow_teachers')
    times_every_week = models.IntegerField(db_column='times_every_week')
    suit_teacher = models.CharField(db_column='suit_teacher', max_length=200, blank=True, null=True)
    teacher_ordered = models.CharField(db_column='teacher_ordered', max_length=200, blank=True, null=True)
    teacher_auto_pick = models.CharField(db_column='teacher_auto_pick', max_length=200, blank=True, null=True)
    teacher_final_pick = models.CharField(db_column='teacher_final_pick', max_length=200, blank=True, null=True)
    update_time = models.DateTimeField(db_column='update_time', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'course_info'


class CurrentStepInfo(models.Model):
    arrange_class_status = models.CharField(db_column='arrange_class_status', max_length=45, blank=True, null=True)
    s1_year_info = models.CharField(db_column='s1_year_info', max_length=45, blank=True, null=True)
    s2_undergraduate = models.CharField(db_column='s2_undergraduate', max_length=45, blank=True, null=True)
    s2_postgraduate_1 = models.CharField(db_column='s2_postgraduate_1', max_length=45, blank=True, null=True)
    s2_postgraduate_2 = models.CharField(db_column='s2_postgraduate_2', max_length=45, blank=True, null=True)
    s2_doctor = models.CharField(db_column='s2_doctor', max_length=45, blank=True, null=True)
    s2_start_request = models.CharField(db_column='s2_start_request', max_length=45, blank=True, null=True)
    s2_deadline = models.DateTimeField(db_column='s2_deadline', blank=True, null=True)
    s2_teacher_confirm_u = models.CharField(db_column='s2_teacher_confirm_u', max_length=45, blank=True, null=True)
    s2_teacher_confirm_p1 = models.CharField(db_column='s2_teacher_confirm_p1', max_length=45, blank=True, null=True)
    s2_teacher_confirm_p2 = models.CharField(db_column='s2_teacher_confirm_p2', max_length=45, blank=True, null=True)
    s2_teacher_confirm_d = models.CharField(db_column='s2_teacher_confirm_d', max_length=45, blank=True, null=True)
    s3_status_flag = models.CharField(db_column='s3_status_flag', max_length=45, blank=True, null=True)
    s4_status_flag = models.CharField(db_column='s4_status_flag', max_length=45, blank=True, null=True)
    s4_teacher_confirm_u = models.CharField(db_column='s4_teacher_confirm_u', max_length=45, blank=True, null=True)
    s4_teacher_confirm_p1 = models.CharField(db_column='s4_teacher_confirm_p1', max_length=45, blank=True, null=True)
    s4_teacher_confirm_p2 = models.CharField(db_column='s4_teacher_confirm_p2', max_length=45, blank=True, null=True)
    s4_teacher_confirm_d = models.CharField(db_column='s4_teacher_confirm_d', max_length=45, blank=True, null=True)
    s5_status_flag = models.CharField(db_column='s5_status_flag', max_length=45, blank=True, null=True)
    class Meta:
        managed = False
        db_table = 'current_step_info'
