from django.db import models

# Create your models here.


class Courses(models.Model):
    code = models.CharField(max_length=20)
    type = models.IntegerField(blank=True, null=True)
    phase = models.IntegerField(blank=True, null=True)
    name = models.CharField(max_length=100, blank=True, null=True)
    desc = models.CharField(max_length=200, blank=True, null=True)
    title_list = models.CharField(max_length=200, blank=True, null=True)
    target = models.CharField(max_length=200, blank=True, null=True)
    keynote_list = models.CharField(max_length=200, blank=True, null=True)
    result = models.CharField(max_length=200, blank=True, null=True)
    process_list = models.CharField(max_length=200, blank=True, null=True)
    course_ware = models.CharField(max_length=200, blank=True, null=True)
    course_video = models.CharField(max_length=200, blank=True, null=True)
    attachment_list = models.CharField(max_length=200, blank=True, null=True)
    practise = models.CharField(max_length=200, blank=True, null=True)
    task = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses'


class CoursesAttachment(models.Model):
    name = models.CharField(max_length=50, blank=True, null=True)
    href = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_attachment'


class CoursesKeynote(models.Model):
    name = models.CharField(max_length=50, blank=True, null=True)
    content = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_keynote'


class CoursesMap(models.Model):
    code = models.CharField(max_length=50, blank=True, null=True)
    name = models.CharField(max_length=50, blank=True, null=True)
    desc = models.CharField(max_length=200, blank=True, null=True)
    title = models.CharField(max_length=200, blank=True, null=True)
    list_img = models.CharField(max_length=200, blank=True, null=True)
    main_img = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_map'


class CoursesMapDetail(models.Model):
    map_id = models.IntegerField(blank=True, null=True)
    courses_id = models.IntegerField(blank=True, null=True)
    title = models.CharField(max_length=100, blank=True, null=True)
    seq = models.IntegerField(blank=True, null=True)
    init_img = models.CharField(max_length=200, blank=True, null=True)
    finish_img = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_map_detail'


class CoursesProcess(models.Model):
    name = models.CharField(max_length=50, blank=True, null=True)
    content = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_process'


class CoursesTitle(models.Model):
    name = models.CharField(max_length=50, blank=True, null=True)
    img = models.CharField(max_length=200, blank=True, null=True)
    content = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_title'


class CoursesType(models.Model):
    code = models.CharField(max_length=20, blank=True, null=True)
    name = models.CharField(max_length=20, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'courses_type'