ASJServer/Roomumy/models.py

from django.db import models


# Create your models here.
class BabyUser(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='自增id')
    user_id = models.CharField(default='', max_length=32, verbose_name='关联用户id')
    nick_name = models.CharField(default='', max_length=20, verbose_name='昵称')
    sex = models.SmallIntegerField(default=0, verbose_name='性别')  # 0：女 1：男
    birthday = models.IntegerField(default=0, verbose_name='生日')
    icon_url = models.TextField(default='', verbose_name='头像地址')
    device_id = models.CharField(default='', max_length=32, verbose_name='关联设备')
    is_default = models.BooleanField(default=False, verbose_name='是否默认')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    updated_time = models.IntegerField(default=0, verbose_name='更新时间')

    class Meta:
        db_table = 'baby_user'
        verbose_name = '宝宝用户表'
        verbose_name_plural = verbose_name
        app_label = 'Roomumy'


class FeedType(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='自增id')
    name = models.CharField(default='', max_length=10, verbose_name='名称')
    # 1：母乳亲喂 2：母乳瓶喂 3：奶粉 4：辅食 5：换尿布 6：身高体重 7：户外活动 8：育儿日记 9：自定义
    icon_url = models.TextField(default='', verbose_name='图标地址')
    is_show = models.BooleanField(default=True, verbose_name='是否展示')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    updated_time = models.IntegerField(default=0, verbose_name='更新时间')

    class Meta:
        db_table = 'feed_type'
        verbose_name = '喂养类型表'
        verbose_name_plural = verbose_name
        app_label = 'Roomumy'


class FeedDiary(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='自增id')
    baby_id = models.IntegerField(default=0, verbose_name='关联宝宝id')
    feed_type = models.ForeignKey(FeedType, to_field='id', on_delete=models.CASCADE, default='', verbose_name='喂养类型')
    # 1：母乳亲喂 2：母乳瓶喂 3：奶粉 4：辅食 5：换尿布 6：身高体重 7：户外活动 8：育儿日记 9：自定义
    feed_content = models.JSONField(null=True, verbose_name='事件内容')
    # 当类型为5时，sub_event_type为 1:嘘嘘 2:臭臭 3：嘘嘘+臭臭 4：干爽
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    updated_time = models.IntegerField(default=0, verbose_name='更新时间')

    class Meta:
        db_table = 'feed_diary'
        verbose_name = '喂养日记表'
        verbose_name_plural = verbose_name
        app_label = 'Roomumy'