class Ins(db.Model):
__tablename__ = 'ins'
id = db.Column(db.String(24), default=objectid, primary_key=True)
type = db.Column(db.String(255), comment='机构类型')
name = db.Column(db.String(50), comment='机构名称')
ins_picture = db.Column(db.String(255), comment='机构图片')
location_id = db.Column(db.String(50),
db.ForeignKey('location.id'),
comment='位置')
ins_address = db.Column(db.String(255), comment='机构地址')
note = db.Column(db.Text, comment='备注')
latitude = db.Column(db.Float(asdecimal=True), comment='纬度')
longitude = db.Column(db.Float(asdecimal=True), comment='经度')
admin_user_id = db.Column(db.String(24),
db.ForeignKey('user.id'),
comment='管理员id')
community = db.relationship('Community',
secondary=t_community_ins,
backref=db.backref('f1_community',
lazy='dynamic'),
lazy='dynamic')
user = db.relationship('User',
secondary=t_user_ins,
backref=db.backref('f_user', lazy='dynamic'),
lazy='dynamic')
disabled = db.Column(db.Boolean,
nullable=False,
default=False,
comment='是否可用')
class Step(db.Model):
"""
步骤
"""
__tablename__ = "step"
id = db.Column(db.Integer, primary_key=True)
case_id = db.Column(db.Integer)
#case_id = db.Column(db.Integer, db.ForeignKey('case.id'))
prev = db.Column(db.Integer) # 兄Step id
enable = db.Column(db.Boolean, default=True, index=True)
desc = db.Column(db.String(128), index=True)
keyword = db.Column(db.String(128), index=True)
param_1 = db.Column(db.String(128), index=True)
param_2 = db.Column(db.String(128), index=True)
param_3 = db.Column(db.String(128), index=True)
param_4 = db.Column(db.String(128), index=True)
param_5 = db.Column(db.String(128), index=True)
param_6 = db.Column(db.String(128), index=True)
param_7 = db.Column(db.String(128), index=True)
step = db.Column(db.Text)
create_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
create_timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now())
update_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
update_timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now())
class UserAlarmRecord(db.Model):
__tablename__ = 'user_alarm_record'
id = db.Column(db.String(24), default=objectid, primary_key=True)
type = db.Column(db.Integer,
default=0,
comment='参考创建信息类型 (0,119 1,疏散,2,传感器，3,求救)')
content = db.Column(db.String(255), comment='报警内容')
if_confirm = db.Column(db.Boolean, default=False, comment='是否关闭')
home_id = db.Column(db.String(24),
db.ForeignKey('home.id'),
comment='报警关联家庭id')
home = db.relationship('Home')
ins_id = db.Column(db.String(24), db.ForeignKey('ins.id'), comment='机构id')
reference_alarm_id = db.Column(db.String(24), comment='参考创建信息id')
user_id = db.Column(db.String(24),
db.ForeignKey('user.id'),
comment='发布人id')
user = db.relationship('User')
note = db.Column(db.String(255), comment='备注')
origin = db.Column(db.String(255), comment='创建来源')
mark = db.Column(db.String(255), comment='来源备注')
time = db.Column(db.DateTime,
default=datetime.datetime.now(),
comment='创建时间')
class MovieOrder(BaseModel):
o_user_id=db.Column(db.Integer,db.ForeignKey('movie_user.id'))
o_hall_movie_id=db.Column(db.Integer,db.ForeignKey('hall_movie.id'))
o_time=db.Column(db.DateTime)
o_status=db.Column(db.Integer,default=ORDER_STATUS_NOT_PAY)
o_seats=db.Column(db.String(128))
o_price=db.Column(db.Float,default=0)
class SensorAlarm(db.Model):
__tablename__ = 'sensor_alarm'
id = db.Column(db.String(24),
default=objectid,
primary_key=True,
comment='')
sensor_id = db.Column(db.String(24),
db.ForeignKey('sensor.id'),
comment='网关id')
sensor = db.relationship('Sensor')
gateway_id = db.Column(db.String(24),
db.ForeignKey('gateway.id'),
comment='关联网关id')
note = db.Column(db.String(255), comment='报警内容')
sensor_type = db.Column(db.Integer,
comment='传感器类型 (0.烟雾 1.温度 2.燃气 3.电流,4)')
var_type = db.Column(db.String(24), comment='变量类型')
unit = db.Column(db.String(24), comment='变量单位')
alarm_value = db.Column(db.String(24), comment='报警数值')
alarm_time = db.Column(db.DateTime,
default=datetime.datetime.now(),
comment='报警时间')
#confirm_time = db.Column(db.DateTime, comment='确认时间')
is_timeout = db.Column(db.Boolean, default=False, comment='是否超时')
# user_id = db.Column(db.String(24), db.ForeignKey('user.id'), comment='确认人id')
# user = db.relationship('User')
is_confirm = db.Column(db.Boolean, default=False, comment='是否确认')
class Home(db.Model):
__tablename__ = 'home'
id = db.Column(db.String(24), default=objectid, primary_key=True)
name = db.Column(db.String(255), comment='家庭名称')
community_id = db.Column(db.String(24),
db.ForeignKey('community.id'),
comment='社区id')
community = db.relationship('Community')
admin_user_id = db.Column(db.String(24),
db.ForeignKey('user.id'),
comment='创建者id')
detail_address = db.Column(db.String(255), comment='家庭地址')
link_name = db.Column(db.String(50), comment='主人姓名')
telephone = db.Column(db.String(50), comment='电话号码')
longitude = db.Column(db.Float(asdecimal=True), comment='经度')
latitude = db.Column(db.Float(asdecimal=True), comment='纬度')
alternate_phone = db.Column(db.String(50), comment='备用电话')
gateway_id = db.Column(db.String(50),
db.ForeignKey('gateway.id'),
comment='网关id')
disabled = db.Column(db.Boolean,
nullable=False,
default=False,
comment='是否可用')
class MeetingAttendance(db.Model, DictMixin):
__tablename__ = 'meeting_attendance'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
meeting_id = db.Column(db.Integer, db.ForeignKey('meeting.id'))
class Object(db.Model):
"""
对象库套件
"""
__tablename__ = "object"
id = db.Column(db.Integer, primary_key=True)
project_id = db.Column(db.Integer)
#project_id = db.Column(db.Integer, db.ForeignKey('project.id'))
category = db.Column(db.String(64), index=True)
prev = db.Column(db.Integer) # 兄对象 id
name = db.Column(db.String(64), index=True)
desc = db.Column(db.String(128), index=True)
tags = db.Column(db.String(64), index=True)
enable = db.Column(db.Boolean, default=True, index=True)
setup = db.Column(db.Text)
teardown = db.Column(db.Text)
create_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
create_timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now())
update_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
update_timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now())
class Project(db.Model):
"""
项目
"""
__tablename__ = "project"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), index=True)
product_id = db.Column(db.Integer)
# product_id = db.Column(db.Integer, db.ForeignKey('product.id'))
category = db.Column(db.String(64), index=True)
desc = db.Column(db.String(128), index=True)
tags = db.Column(db.String(64), index=True)
enable = db.Column(db.Boolean, default=False, index=True)
version = db.Column(db.String(32), index=True)
cron = db.Column(db.Text)
setup = db.Column(db.Text)
teardown = db.Column(db.Text)
create_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
create_timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now())
update_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
update_timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now())
class StructureMetricValue(db.Model):
__tablename__ = 'structure_metric_value'
id = db.Column(db.Integer, primary_key=True)
structure_id = db.Column(db.Integer, db.ForeignKey('structure.id'))
metric_id = db.Column(db.Integer, db.ForeignKey('metric.id'))
value = db.Column(db.Float)
date_key = db.Column(db.Date)
class Reply(DictMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
comment_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
content = db.Column(db.Text(512))
from_uid = db.Column(db.Integer, db.ForeignKey('user.id'))
to_uid = db.Column(db.Integer, db.ForeignKey('user.id'))
at = db.Column(db.String(32))
created_time = db.Column(db.DateTime, default=datetime.datetime.utcnow())
class EntityMetricValue(db.Model):
__tablename__ = 'entity_metric_value'
id = db.Column(db.Integer, primary_key=True)
entity_id = db.Column(db.Integer, db.ForeignKey('entity.id'))
metric_id = db.Column(db.Integer, db.ForeignKey('metric.id'))
value = db.Column(db.Float)
date_key = db.Column(db.Date)
class UserGoods(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
u_goods = db.Column(
db.Integer,
db.ForeignKey(Goods.id, ondelete="CASCADE", onupdate="CASCADE"))
u_user = db.Column(
db.Integer,
db.ForeignKey(User.id, ondelete="CASCADE", onupdate="CASCADE"))
num = db.Column(db.Integer)
class Moviecol(db.Model):
__tablename__ = "moviecol"
id = db.Column(db.Integer, primary_key=True) # 编号
movie_id = db.Column(db.Integer, db.ForeignKey('movie.id')) # 所属电影
user_id = db.Column(db.Integer, db.ForeignKey('user.id')) # 所属用户
addtime = db.Column(db.DateTime, index=True, default=datetime.now) # 添加时间
def __repr__(self):
return "<Moviecol %r>" % self.id
class Comment(db.Model):
__tablename__ = "comment"
id = db.Column(db.Integer, primary_key=True) # 编号
content = db.Column(db.Text) # 内容
movie_id = db.Column(db.Integer, db.ForeignKey('movie.id')) # 所属电影
user_id = db.Column(db.Integer, db.ForeignKey('user.id')) # 所属用户
addtime = db.Column(db.DateTime, index=True, default=datetime.now) # 添加时间
def __repr__(self):
return "<Comment %r>" % self.id
class Comment(db.Model):
__tablename__="comment"
id=db.Column(db.Integer,primary_key=True)
content=db.Column(db.Text) #评论内容
movie_id=db.Column(db.Integer,db.ForeignKey('movie.id')) #所属电影
user_id=db.Column(db.Integer,db.ForeignKey('user.id')) #所属用户
add_time=db.Column(db.DateTime,index=True,default=datetime.now)
def __repr__(self):
return "<Model Comment {}>".format(self.id)
class HallSchedule(db.Model):
hsid = db.Column(db.Integer, primary_key=True)
original_price = db.Column(db.Numeric(6, 2)) # 原价
dis_price = db.Column(db.Numeric(6, 2)) # 折扣价
start_time = db.Column(db.DateTime)
starus = db.Column(db.Integer, default=1)
is_delete = db.Column(db.Boolean, default=False)
# 关联外键 电影、影厅、影院
movie_id = db.Column(db.Integer, db.ForeignKey('movies.mid'))
hid = db.Column(db.Integer, db.ForeignKey('hall.hid'))
cid = db.Column(db.Integer, db.ForeignKey('cinemas.mid'))
class Moviecol(db.Model):
__tablename__ = "moviecol"
__table_args__ = {"useexisting": True}
id = db.Column(db.Integer, primary_key=True) # 编号
# 关联外键第一步，还要去user表和movie表进行第二步
movie_id = db.Column(db.Integer, db.ForeignKey('movie.id')) # 所属电影
user_id = db.Column(db.Integer, db.ForeignKey('user.id')) # 所属用户
addtime = db.Column(db.DateTime, index=True, default=datetime.now) # 添加时间
def __repr__(self):
return "<Moviecol %r>" % self.id
class Moviecol(db.Model):
'''
电影收藏
'''
id=db.Column(db.Integer,primary_key=True)
movie_id=db.Column(db.Integer,db.ForeignKey('movie.id'))
user_id=db.Column(db.Integer,db.ForeignKey('user.id'))
add_time = db.Column(db.DateTime, index=True, default=datetime.now)
def __repr__(self):
return "<Model Moviecol {}>".format(self.id)
class Entity(db.Model):
__tablename__ = 'entity'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64))
name_in_performance = db.Column(db.String(63))
name_in_risk = db.Column(db.String(63))
name_in_accounting = db.Column(db.String(63))
sector_id = db.Column(db.Integer, db.ForeignKey('sector.id'))
currency_id = db.Column(db.Integer, db.ForeignKey('currency.id'))
region_id = db.Column(db.Integer, db.ForeignKey('region.id'))
class HallSchedule(db.Model):
hs_id = db.Column(db.Integer, primary_key=True)
original_price = db.Column(db.Numeric(10, 2))
dis_price = db.Column(db.Numeric(10, 2))
start_time = db.Column(db.DateTime)
# 1未开始 2 正在放映
status = db.Column(db.Boolean, default=False)
is_delete = db.Column(db.Boolean, default=False)
# 关联影院外键
movie_id = db.Column(db.Integer, db.ForeignKey('movies.id'))
hid = db.Column(db.Integer, db.ForeignKey('hall.hid'))
cid = db.Column(db.Integer, db.ForeignKey('cinemas.id'))
class UserRole(db.Model):
__tablename__ = 'user_role'
id = db.Column(db.String(24), default=objectid, primary_key=True)
user_id = db.Column('user_id',
db.String(24),
db.ForeignKey('user.id'),
primary_key=True)
if_usable = db.Column('if_usable', db.Boolean, comment='是否可用')
role_id = db.Column('role_id',
db.String(24),
db.ForeignKey('role.id'),
primary_key=True)
class Meeting(DictMixin, db.Model):
__tablename__ = 'meeting'
id = db.Column(db.Integer, primary_key=True)
subject = db.Column(db.String(128))
location = db.Column(db.String(64))
start_time = db.Column(db.DateTime, default=datetime.datetime.utcnow())
end_time = db.Column(db.DateTime, default=datetime.datetime.utcnow())
status = db.Column(db.Integer, default=MeetingStatus.NEW.value)
entity_id = db.Column(db.Integer, db.ForeignKey('entity.id'))
organizer_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class Currentrecord(db.Model):
__tablename__ = 'currentrecord'
id = db.Column(db.String(24), default=objectid, primary_key=True)
currentperson_id = db.Column(db.String(24), db.ForeignKey('user.id'))
currenttime = db.Column(db.DateTime, default=datetime.datetime.now)
currentcontent = db.Column(db.Text)
attachment = db.Column(db.String(200))
work_id = db.Column(db.String(24), db.ForeignKey('workorder.id'))
work = db.relationship('Workorder',
backref=db.backref('f1_worker', lazy='dynamic'),
lazy='joined')
class DashboardFiltered(DictMixin, db.Model):
__tablename__ = 'dashboard_filtered'
"""
In our application, the dashboards also have the different filters on it, to get the conrresponding data,
we need to give the filter by default in some scenario,and show them on the UI
here is the class which have the specific filter of the dashboard and also connected with the entity
"""
id = db.Column(db.Integer, primary_key=True)
dashboard_id = db.Column(db.Integer, db.ForeignKey('dashboard.id'))
entity_id = db.Column(db.Integer, db.ForeignKey('entity.id'))
filters = db.Column(db.String(1023))
dashboard = db.relationship('Dashboard', foreign_keys=dashboard_id)
class FacilityIns(db.Model):
__tablename__ = 'facility_ins'
id = db.Column(db.String(24), default=objectid, primary_key=True)
facility_id = db.Column(db.String(24),
db.ForeignKey('facility.id'),
comment='设施id')
facility = db.relationship('Facility')
ins_id = db.Column(db.String(24), db.ForeignKey('ins.id'), comment='机构id')
ins = db.relationship('Ins')
note = db.Column(db.String(200), comment='备注')
count = db.Column(db.Integer, comment='设施数量')
expire_time = db.Column(db.DateTime, comment='过期时间')
class UserRole(db.Model):
__tablename__ = 'user_role'
id = db.Column(db.String(24), default=objectid, primary_key=True)
user_id = db.Column(db.String(24), db.ForeignKey('user.id'), index=True)
role_id = db.Column(db.String(24), db.ForeignKey('role.id'), index=True)
disable = db.Column(db.Boolean, nullable=False, default=False)
role = db.relationship('Role',
backref=db.backref('f1_role', lazy='dynamic'),
lazy='joined')
user = db.relationship('User',
backref=db.backref('f1_user', lazy='dynamic'),
lazy='joined')
class Alert(DictMixin, db.Model):
"""docstring for ClassName"""
__tablename__ = 'alert'
id = db.Column(db.Integer, primary_key=True)
description = db.Column(db.String(128))
is_read = db.Column(db.Boolean, default=False)
date_key = db.Column(db.Date, default=datetime.datetime.utcnow())
chart_id = db.Column(db.String(64))
entity_id = db.Column(db.Integer, db.ForeignKey('entity.id'))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
group_id = db.Column(db.Integer, db.ForeignKey('group.id'))
alert_threshold_id = db.Column(db.Integer,
db.ForeignKey('alert_threshold.id'))
alert_type_id = db.Column(db.Integer, db.ForeignKey('alert_type.id'))
class Workorder(db.Model):
__tablename__ = 'workorder'
id = db.Column(db.String(24), default=objectid, primary_key=True)
createperson_id = db.Column(db.String(24), db.ForeignKey('user.id'))
equ_id = db.Column(db.String(24), db.ForeignKey('equipment.id'))
alarm_type = db.Column(db.Integer)
passperson_id = db.Column(db.String(255), db.ForeignKey('user.id'))
notiperson_id = db.Column(db.String(255), db.ForeignKey('user.id'))
mailtopass = db.Column(db.Boolean, nullable=False, default=False)
mailtonoti = db.Column(db.Boolean, nullable=False, default=False)
smstopass = db.Column(db.Boolean, nullable=False, default=False)
smstonoti = db.Column(db.Boolean, nullable=False, default=False)
problem = db.Column(db.Text)
picture = db.Column(db.String(200))
class HomeUser(db.Model):
__tablename__ = 'homeuser'
id = db.Column(db.String(24), default=objectid, primary_key=True)
user_id = db.Column('user_id', db.String(24), db.ForeignKey('user.id'))
home_id = db.Column('home_id', db.String(24), db.ForeignKey('home.id'))
db.UniqueConstraint('user_id', 'home_id', name='uix_home_user')
apply_time = db.Column('apply_time',
db.DateTime,
default=datetime.datetime.now,
comment='申请时间')
if_confirm = db.Column('if_confirm',
db.Boolean,
default=False,
comment='是否批准')
confirm_time = db.Column('confirm_time', db.DateTime, comment='批准时间')
