class User(db.Model):
__tablename__ = 'user'
Host = db.Column(db.String(60, 'utf8_bin'), primary_key=True, nullable=False, server_default=db.FetchedValue())
User = db.Column(db.String(32, 'utf8_bin'), primary_key=True, nullable=False, server_default=db.FetchedValue())
ssl_cipher = db.Column(db.LargeBinary, nullable=False)
x509_issuer = db.Column(db.LargeBinary, nullable=False)
x509_subject = db.Column(db.LargeBinary, nullable=False)
max_questions = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
max_updates = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
max_connections = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
max_user_connections = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
plugin = db.Column(db.String(64, 'utf8_bin'), nullable=False, server_default=db.FetchedValue())
authentication_string = db.Column(db.Text(collation='utf8_bin'))
password_last_changed = db.Column(db.DateTime)
password_lifetime = db.Column(db.SmallInteger)
class FoodStockChangeLog(db.Model):
__tablename__ = 'food_stock_change_log'
id = db.Column(db.Integer, primary_key=True)
food_id = db.Column(db.Integer, nullable=False, index=True)
unit = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
total_stock = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
note = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class BookCat(db.Model):
__tablename__ = 'book_cat'
id = db.Column(db.Integer, primary_key=True, unique=True)
name = db.Column(db.String(32), nullable=False)
weight = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class JzkAdvertising(db.Model):
__tablename__ = 'jzk_advertising'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
content = db.Column(db.String(500))
link = db.Column(db.String(500))
time = db.Column(db.DateTime, server_default=db.FetchedValue())
class StockList(db.Model):
__tablename__ = 'stock_list'
id = db.Column(db.BigInteger, primary_key=True, info='id')
symbol = db.Column(db.String(20),
nullable=False,
server_default=db.FetchedValue(),
info='symbol')
class QqGroup(db.Model):
__tablename__ = 'qq_group'
id = db.Column(db.BigInteger, primary_key=True)
group_name = db.Column(db.String(100),
nullable=False,
unique=True,
server_default=db.FetchedValue())
group_number = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class FoodCat(db.Model):
__tablename__ = 'food_cat'
id = db.Column(db.Integer, primary_key=True, unique=True)
name = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue(), info='类别名称')
weight = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='权重')
status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='状态 1：有效 0：无效')
updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='最后一次更新时间')
created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间')
@property
def status_desc(self):
status_mapping = {
'0': '已删除',
'1': '正常'
}
return status_mapping[str(self.status)]
class Account(db.Model):
__tablename__ = 'account'
id = db.Column(db.Integer, primary_key=True)
userName = db.Column(db.String(50), nullable=False)
password = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
createTime = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
remarks = db.Column(db.String(50))
def __init__(self, **items):
for key in items:
if hasattr(self, key):
setattr(self, key, items[key])
class Shop(db.Model):
__tablename__ = 'shop'
Shopid = db.Column(db.BigInteger, primary_key=True) # 商店ID
Aid = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue()) # 商户ID
ShopName = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 商户名称
ShopImage = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 商户图片
ShopCategory = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue()) # 店铺分类
ShopProvince = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 省
ShopCity = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 市
ShopCountry = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 地区
class OauthMemberBind(db.Model):
__tablename__ = 'oauth_member_bind'
__table_args__ = (db.Index('idx_type_openid', 'type', 'openid'), )
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='会员id')
client_type = db.Column(db.String(20),
nullable=False,
server_default=db.FetchedValue(),
info='客户端来源类型。qq,weibo,weixin')
type = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='类型 type 1:wechat ')
openid = db.Column(db.String(80),
nullable=False,
server_default=db.FetchedValue(),
info='第三方id')
unionid = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
extra = db.Column(db.Text, nullable=False, info='额外字段')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
class Product(db.Model):
__tablename__ = 'product_info'
Id = db.Column(db.BigInteger, primary_key=True) # id号码
ProductName = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 商品名称
ShopId = db.Column(db.BigInteger, primary_key=True) # 商品店主ID
ProductMerchanName = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) # 商品店主名字
ProductCategory = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) # 商品分类
ProductInfo = db.Column(db.String(5000), nullable=False, server_default=db.FetchedValue()) # 商品信息
ProdectPrice = db.Column(DECIMAL, nullable=False, server_default=db.FetchedValue()) # 商品价格
ProductImage = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 商品图片
ProductStock = db.Column(Integer, nullable=False, unique=True, server_default=db.FetchedValue()) # 商品库存
ProductSold = db.Column(Integer, nullable=False, server_default=db.FetchedValue()) # 商品已售数
ProductStatus = db.Column(Integer, nullable=False, server_default=db.FetchedValue()) # 商品状态 1为已过审
class UserBuyHistory(db.Model):
__tablename__ = 'user_buy_history'
id = db.Column(db.Integer, primary_key=True)
openid = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
nickname = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
cat_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
product = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
buy_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class AllAddres(db.Model):
__tablename__ = 'all_address'
id = db.Column(db.Integer, primary_key=True)
school_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
school_str = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
grade_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
grade_str = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
class_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
class_str = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
status = db.Column(db.Integer,
nullable=False,
index=True,
server_default=db.FetchedValue())
class Work(db.Model):
__tablename__ = 'works'
id = db.Column(db.BigInteger, primary_key=True, info='??id')
nickname = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='???')
uid = db.Column(db.String(11),
nullable=False,
server_default=db.FetchedValue(),
info='????id')
worksOK = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='???? 0???? 1????2?????? 3??????')
photo_imageurl = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='???????')
transfer_photo_imageurl = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='?????????')
style = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='??')
tag = db.Column(db.Text, info='????')
time = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='??????')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='?? 1????? 0??????')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????????')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????')
class MemberCart(db.Model):
__tablename__ = 'member_cart'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.BigInteger,
nullable=False,
index=True,
server_default=db.FetchedValue())
course_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
register_status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
payment_status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
quantity = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
@property
def payment_status_desc(self):
payment_status_mapping = {"0": '未付', '1': '已付'}
return payment_status_mapping[str(self.payment_status)]
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, info='??')
nickname = db.Column(db.String(30),
nullable=False,
server_default=db.FetchedValue(),
info='??')
login_name = db.Column(db.String(20),
nullable=False,
unique=True,
server_default=db.FetchedValue(),
info='?????')
login_pwd = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='??????')
login_salt = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='?????????')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='?? 0??? 1???')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????????')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????')
class Commodity(db.Model):
__tablename__ = 'commodity'
id = db.Column(db.Integer, primary_key=True, info='主键-商品id')
name = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='商品名称')
origin = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='商品产地')
seller = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='卖家')
trans = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='运输')
warehouse = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='仓库')
buyer = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='买家')
status = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='商品状态')
class Sysconfig(db.Model):
__tablename__ = 'sysconfig'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue(),
info='配置描述')
tip = db.Column(db.String(100, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue())
k_field = db.Column(db.String(20, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue(),
info='配置名称key')
k_val = db.Column(db.String(500, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue(),
info='配置对应的值')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='状态 1：有效 0：无效')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后一次更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
def __init__(self, **items):
for key in items:
if hasattr(self, key):
setattr(self, key, items[key])
class AppAccessLog(db.Model):
__tablename__ = 'app_access_log'
id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.BigInteger,
nullable=False,
index=True,
server_default=db.FetchedValue(),
info='uid')
referer_url = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue(),
info='当前访问的refer')
target_url = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue(),
info='访问的url')
query_params = db.Column(db.Text, nullable=False, info='get和post参数')
ua = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue(),
info='访问ua')
ip = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='访问ip')
note = db.Column(db.String(1000),
nullable=False,
server_default=db.FetchedValue(),
info='json格式备注字段')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class OauthMemberBind(db.Model):
__tablename__ = 'oauth_member_bind'
__table_args__ = (db.Index('idx_type_openid', 'type', 'openid'), )
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
client_type = db.Column(db.String(20),
nullable=False,
server_default=db.FetchedValue())
type = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
openid = db.Column(db.String(80),
nullable=False,
server_default=db.FetchedValue())
unionid = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
extra = db.Column(db.Text, nullable=False)
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class Address(db.Model):
__tablename__ = 'address'
Id = db.Column(db.BigInteger, primary_key=True) # ID号码
Cid = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue()) # 顾客ID
Addressee = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 收件人姓名
AddresseePhone = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 收件人电话
Province = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 省份
City = db.Column(db.String(20), primary_key=True) # 市区
County = db.Column(db.String(20),
nullable=False,
server_default=db.FetchedValue()) # 县
Details = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue()) # 地址详细
Status = db.Column(Integer,
nullable=False,
server_default=db.FetchedValue()) # 是否为默认地址 1位默认
class AppAccessLog(db.Model):
# db.create_all()
__tablename__ = 'app_access_log'
id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.BigInteger,
nullable=False,
index=True,
server_default=db.FetchedValue())
referer_url = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue())
target_url = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue())
query_params = db.Column(db.Text, nullable=False)
ua = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue())
ip = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue())
note = db.Column(db.String(1000),
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class StatDailySite(db.Model):
__tablename__ = 'stat_daily_site'
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, nullable=False, index=True)
total_pay_money = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
total_member_count = db.Column(db.Integer, nullable=False)
total_new_member_count = db.Column(db.Integer, nullable=False)
total_order_count = db.Column(db.Integer, nullable=False)
total_shared_count = db.Column(db.Integer, nullable=False)
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class FoodCat(db.Model):
__tablename__ = 'food_cat'
id = db.Column(db.Integer, primary_key=True, unique=True)
name = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
weight = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
@property
def status_desc(self):
status_map = {"0": "已删除", "1": "正常"}
return status_map[str(self.status)]
class FoodSaleChangeLog(db.Model):
__tablename__ = 'food_sale_change_log'
id = db.Column(db.Integer, primary_key=True)
food_id = db.Column(db.Integer,
nullable=False,
index=True,
server_default=db.FetchedValue())
quantity = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2), nullable=False)
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class UserInfo(db.Model):
__tablename__ = 'user_info'
__table_args__ = (
db.Index('USER_STOCK_DATE', 'user_id', 'hold_stock', 'buy_date'),
)
id = db.Column(db.BigInteger, primary_key=True, info='id')
hold_stock = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue(), info='持有股票代码')
name = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue(), info='股票名称')
user_id = db.Column(db.ForeignKey('user.uid'), nullable=False, server_default=db.FetchedValue(), info='用户id fk')
buy_price = db.Column(db.Float, nullable=False, server_default=db.FetchedValue(), info='卖出价格')
sold_price = db.Column(db.Float, info='卖出价格')
sale_point = db.Column(db.Float, info='卖点')
strategy = db.Column(db.String(2000), info='当前交易策略')
buy_date = db.Column(db.String(20), info='买入日期')
hold_time = db.Column(db.Float, info='卖出日期')
user = db.relationship('User', primaryjoin='UserInfo.user_id == User.uid', backref='user_infos')
class AppErrorLog(db.Model):
__tablename__ = 'app_error_log'
id = db.Column(db.Integer, primary_key=True)
referer_url = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue(),
info='当前访问的refer')
target_url = db.Column(db.String(255),
nullable=False,
server_default=db.FetchedValue(),
info='访问的url')
query_params = db.Column(db.Text, nullable=False, info='get和post参数')
content = db.Column(db.String, nullable=False, info='日志内容')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
class Member(db.Model):
__tablename__ = 'member'
id = db.Column(db.Integer, primary_key=True)
nickname = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='会员名')
mobile = db.Column(db.String(11),
nullable=False,
server_default=db.FetchedValue(),
info='会员手机号码')
sex = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='性别 1：男 2：女')
avatar = db.Column(db.String(200),
nullable=False,
server_default=db.FetchedValue(),
info='会员头像')
salt = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='随机salt')
reg_ip = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='注册ip')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='状态 1：有效 0：无效')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后一次更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
@property
def status_desc(self):
return app.config['STATUS_MAPPING'][str(self.status)]
@property
def sex_desc(self):
SEX_MAPPING = {'0': '未知', '1': '男', '2': '女'}
return SEX_MAPPING[str(self.sex)]
class Member(db.Model):
__tablename__ = 'member'
id = db.Column(db.Integer, primary_key=True)
nickname = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='???')
mobile = db.Column(db.String(11),
nullable=False,
server_default=db.FetchedValue(),
info='??????')
sex = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='?? 1?? 2??')
avatar = db.Column(db.String(200),
nullable=False,
server_default=db.FetchedValue(),
info='????')
salt = db.Column(db.String(32),
nullable=False,
server_default=db.FetchedValue(),
info='??salt')
reg_ip = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='??ip')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='?? 1??? 0???')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????????')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????')
@property
def status_desc(self):
return app.config["STATUS_MAPPING"][str(self.status)]
@property
def sex_desc(self):
sex_mapping = {"0": "未知", "1": "男", "2": "女"}
return sex_mapping[str(self.sex)]
class News(db.Model):
__tablename__ = 'news'
id = db.Column(db.Integer, primary_key=True)
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
title = db.Column(db.String(30),
nullable=False,
server_default=db.FetchedValue())
content = db.Column(db.String(280),
nullable=False,
server_default=db.FetchedValue())
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
location = db.Column(db.String(20),
nullable=False,
server_default=db.FetchedValue())
