from django.db import models

# Create your models here.


class ProductInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_name = models.CharField(default='', max_length=32, verbose_name='产品名称')
    icon_url = models.CharField(default='', max_length=200, verbose_name='图标地址')

    class Meta:
        db_table = 'product_info'
        verbose_name = '产品信息'
        verbose_name_plural = verbose_name


class VideoInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_info_id = models.SmallIntegerField(default=0, verbose_name='关联产品信息表')
    title = models.CharField(default='', max_length=100, verbose_name='标题')
    link = models.TextField(default='', verbose_name='链接')
    status = models.SmallIntegerField(default=0, verbose_name='状态')     # 1: 上架, 0: 下架

    class Meta:
        db_table = 'video_info'
        verbose_name = '视频信息'
        verbose_name_plural = verbose_name


class QuickStartInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_info_id = models.SmallIntegerField(default=0, verbose_name='关联产品信息表')
    title = models.CharField(default='', max_length=100, verbose_name='标题')
    link = models.TextField(default='', verbose_name='链接')
    status = models.SmallIntegerField(default=0, verbose_name='状态')     # 1: 上架, 0: 下架

    class Meta:
        db_table = 'quick_start_info'
        verbose_name = '说明书信息'
        verbose_name_plural = verbose_name


class UpgradeFirmwareInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_info_id = models.SmallIntegerField(default=0, verbose_name='关联产品信息表')
    title = models.CharField(default='', max_length=100, verbose_name='标题')
    link = models.TextField(default='', verbose_name='链接')
    status = models.SmallIntegerField(default=0, verbose_name='状态')     # 1: 上架, 0: 下架

    class Meta:
        db_table = 'upgrade_firmware_info'
        verbose_name = '升级文件信息'
        verbose_name_plural = verbose_name