01.商品模块表结构分析

1.表结构分析

1.1 商品模块表结构分析

from django.db import models
from utils.MyBaseModel import Base

class Goods(Base):
    GOODS_TYPE = (
        ('1', 'Vip'),
        ('2', 'Course')
    )
    CHANNEL_TYPE = (
        ('1', '普通'),
        ('2', '促销')
    )
    course = models.ForeignKey('course.Course', on_delete=models.PROTECT)
    goods_type = models.CharField('商品种类', choices=GOODS_TYPE, max_length=8)
    product_id = models.CharField('产品id', max_length=8)
    title = models.CharField('商品名称', max_length=24)
    price = models.DecimalField('商品价格', max_digits=8, decimal_places=2)
    channel_type = models.CharField('购买渠道', choices=CHANNEL_TYPE, max_length=8)
    period = models.IntegerField('有效期'