from django.db import models

# Create your models here.


class User(models.Model):
    name = models.CharField(max_length=50, blank=True, null=True)
    email = models.CharField(max_length=50, blank=True, null=True)
    phone = models.CharField(max_length=20, blank=True, null=True)
    password = models.CharField(max_length=50, blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    org = models.IntegerField(blank=True, null=True)
    role = models.IntegerField(blank=True, null=True)
    create_at = models.DateTimeField(blank=True, null=True)
    update_at = models.DateTimeField(blank=True, null=True)
    last_login_time = models.DateTimeField(blank=True, null=True)
    introducer = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user'


class UserProfiles(models.Model):
    userid = models.IntegerField(blank=True, null=True)
    gender = models.IntegerField(blank=True, null=True)
    school = models.CharField(max_length=50, blank=True, null=True)
    grade = models.IntegerField(blank=True, null=True)
    provincial = models.CharField(max_length=50, blank=True, null=True)
    city = models.CharField(max_length=50, blank=True, null=True)
    street = models.CharField(max_length=150, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_profiles'


class UserTask(models.Model):
    user_id = models.IntegerField(blank=True, null=True)
    map_id = models.IntegerField(blank=True, null=True)
    courses_id = models.IntegerField(blank=True, null=True)
    href = models.CharField(max_length=100, blank=True, null=True)
    content = models.CharField(max_length=200, blank=True, null=True)
    lecturer_id = models.IntegerField(blank=True, null=True)
    remarks = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_task'


class UserWechat(models.Model):
    userid = models.IntegerField(blank=True, null=True)
    openid = models.CharField(max_length=100, blank=True, null=True)
    sessionkey = models.CharField(max_length=100, blank=True, null=True)
    phone = models.CharField(max_length=15, blank=True, null=True)
    nikename = models.CharField(max_length=100, blank=True, null=True)
    gender = models.IntegerField(blank=True, null=True)
    avatarurl = models.CharField(db_column='avatarUrl', max_length=100, blank=True, null=True)  # Field name made lowercase.
    countrycode = models.CharField(db_column='countryCode', max_length=100, blank=True, null=True)  # Field name made lowercase.
    country = models.CharField(max_length=50, blank=True, null=True)
    province = models.CharField(max_length=50, blank=True, null=True)
    city = models.CharField(max_length=50, blank=True, null=True)
    language = models.CharField(max_length=50, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_wechat'