from django.db import models


# Create your models here.
# 用户表
class UserModel(models.Model):
    id = models.AutoField(primary_key=True)
    username = models.CharField(max_length=64, unique=True, default='', verbose_name='用户名')
    password = models.CharField(max_length=128, default='', verbose_name='密码')
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '用户表'
        db_table = 'lang_user'

    def __str__(self):
        return self.username


# 语种
class LangAreaModel(models.Model):
    id = models.AutoField(primary_key=True)
    lang = models.CharField(max_length=32, default='', verbose_name='语言')
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '语种'
        db_table = 'lang_area'


# 用户关联语种配置
class LangSetModel(models.Model):
    id = models.AutoField(primary_key=True)
    user = models.ForeignKey(UserModel, verbose_name='用户表id', to_field='id', on_delete=models.CASCADE)
    lang = models.ForeignKey(LangAreaModel, verbose_name='关联语种id', to_field='id', on_delete=models.CASCADE)
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '用户关联语种配置'
        db_table = 'lang_set'


# 词汇
class LangKeyModel(models.Model):
    id = models.AutoField(primary_key=True)
    word_key = models.CharField(default='', max_length=64, verbose_name='词汇键',unique=True)
    addTime = models.IntegerField(default=0, verbose_name='添加时间')
    updTime = models.IntegerField(default=0, verbose_name='更新时间')

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '词汇k表'
        db_table = 'lang_key'


class LangValModel(models.Model):
    id = models.AutoField(primary_key=True)
    lk = models.ForeignKey(LangKeyModel, verbose_name='v关联词汇k', to_field='id', on_delete=models.CASCADE)
    la = models.ForeignKey(LangAreaModel, verbose_name='词汇k关联语种', to_field='id', on_delete=models.CASCADE)
    word_val = models.CharField(default='', max_length=64, verbose_name='词汇v')
    addTime = models.IntegerField(default=0, verbose_name='添加时间')
    updTime = models.IntegerField(default=0, verbose_name='更新时间')

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '词汇v表'
        db_table = 'lang_val'