class BaoCaoVienChuyenNganhNuoc(CommonModel):
__tablename__ = 'baocao_vienchuyennganh_nuoc'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False, default=1)
loaikybaocao = db.Column(db.Integer, nullable=False)#thang=1,quy=2,6thang=3,nam=4
tong_tinh_phutrach = db.Column(db.Integer, default=0)
tong_tinh_cobaocao = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_phutrach = db.Column(db.Integer, default=0)
tong_hogiadinh_duoccungcapnuoc = db.Column(db.Integer, default=0)
tong_hogiadinh_diaban = db.Column(db.Integer, default=0)
tong_maunuoc_thunghiem_ngoaikiem_vien = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_ngoaikiem_vien = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_ngoaikiem_vien = db.Column(db.Integer, default=0)
thongso_khongdat_ngoaikiem_vien = db.Column(JSONB)
ketqua_kiemtra_noikiem_tinh = db.Column(JSONB)
cacdexuat_kythuat = db.Column(db.String)
nghiencuu_chatluong_nuocsach = db.Column(db.String)
ketluan = db.Column(db.String)
dexuat = db.Column(db.String)
class CuaKhau(CommonModel):
__tablename__ = 'cuakhau'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ten = db.Column(db.String(255), nullable=False)
#loaicuakhau = db.Column(db.SmallInteger) #
kiemdichyte = db.Column(db.Boolean, default=True)
phongcachly = db.Column(db.Boolean, default=True)
nguoilienlac = db.Column(db.String(255), nullable=True)
sodienthoai = db.Column(db.String, nullable=True)
diachi = db.Column(db.String, nullable=True)
email = db.Column(db.String, nullable=True)
donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True)
donvi = db.relationship('DonVi', backref=db.backref('cuakhau',lazy='dynamic'),viewonly=True)
tinhthanh_id = db.Column(db.Integer,db.ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = db.relationship('TinhThanh',viewonly=True)
thutu = db.Column(db.Integer, nullable=True)
#loaicuakhau
duongboquocte = db.Column(db.Boolean, default=False)
duongbochinh = db.Column(db.Boolean, default=False)
duongbophu = db.Column(db.Boolean, default=False)
duongsat = db.Column(db.Boolean, default=False)
duonghangkhong = db.Column(db.Boolean, default=False)
duongthuyloai1 = db.Column(db.Boolean, default=False)
duongthuyloai2 = db.Column(db.Boolean, default=False)
quocgia_tiepgiap = db.Column(db.String, nullable=True)
cuakhau_tiepgiap = db.Column(db.String, nullable=True)
class BaoCao(CommonModel):
__tablename__ = 'baocao'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255))
ngaybaocao = db.Column(db.DateTime(),default=func.now())
loaikybaocao = db.Column(db.Integer, nullable=False)
loaibaocao = db.Column(db.SmallInteger()) #1 - don vi, 2 cua khau
kybaocao = db.Column(db.SmallInteger, nullable=False)
nambaocao = db.Column(db.Integer, nullable=False)
tungay = db.Column(db.Date())
denngay = db.Column(db.Date())
donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True)
donvi = db.relationship('DonVi',viewonly=True)
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
cuakhau = db.relationship('CuaKhau',viewonly=True)
nhanxetnguoi = db.Column(db.String())
nhanxetphuongtien = db.Column(db.String())
nhanxethanghoa = db.Column(db.String())
nhanxetthithe = db.Column(db.String())
nhanxetvssh = db.Column(db.String())
nhanxet = db.Column(db.String())
kiennghi = db.Column(db.String())
hoatdongkhac = db.Column(db.String())
nhanlucts = db.Column(db.Integer())
nhanlucbienche = db.Column(db.Integer())
nhanluchopdong = db.Column(db.Integer())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
class TagsTree(db.Model):
"""Древовидная структура тегов"""
__bind_key__ = 'caesar'
__tablename__ = '%s_tags_tree' % TABLE_PREFIX
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
tag_id = db.Column(db.Integer,
db.ForeignKey('%s_tag.id' % TABLE_PREFIX),
index=True)
parent_id = db.Column(db.Integer,
db.ForeignKey('%s.id' % __tablename__),
index=True)
template_id = db.Column(db.Integer,
db.ForeignKey('%s_template.id' % TABLE_PREFIX),
nullable=False,
index=True)
ordernum = db.Column(db.Integer, doc=u'Поле для сортировки тегов')
tag = db.relationship(Tag)
parent = db.relationship('TagsTree',
remote_side=[id],
backref=db.backref('children', order_by=ordernum))
# template = db.relationship(Template)
__table_args__ = {'order_by': ordernum}
def __unicode__(self):
return self.tag.code
class DuyetVeSinhToanXa(CommonModel):
__tablename__ = 'duyet_vesinh_toanxa'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
nam_datvesinh_toanxa = db.Column(db.Integer)
nam_datvesinh_toanxa_benvung = db.Column(db.Integer)
class BaoCaoTienDoDuyTriVSTXBenVung(CommonModel):
__tablename__ = 'baocao_tiendo_duytri_vstx_benvung'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
nam_datvesinh_toanxa = db.Column(db.Integer)
nam_datvesinh_toanxa_benvung = db.Column(db.Integer)
tyle_truong_duytri_vesinh = db.Column(db.DECIMAL)
tyle_tramyte_duytri_vesinh = db.Column(db.DECIMAL)
class KetQuaNgoaiKiemChatLuongNuocSach(CommonModel):
__tablename__ = 'ketqua_ngoaikiem_chatluong_nuocsach'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
nambaocao = db.Column(db.Integer, nullable=False)
ngaybaocao = db.Column(db.DateTime())
donvicapnuoc_id = db.Column(UUID(as_uuid=True), db.ForeignKey('donvicapnuoc.id'), nullable=False)
donvicapnuoc = db.relationship('DonViCapNuoc', viewonly=True)
tendonvicapnuoc = db.Column(db.String)
diachi_donvicapnuoc = db.Column(db.String)
congsuat_thietke = db.Column(DECIMAL)
tongso_hogiadinh = db.Column(db.Integer, default=0)
nguonnuoc_nguyenlieu = db.Column(db.SmallInteger)
tansuat_noikiem = db.Column(db.String)
thoigiankiemtra = db.Column(db.DateTime())
tendonvi_ngoaikiem = db.Column(db.String)
noidung_ngoaikiem = db.Column(db.String)
thunghiem_chatluong_nuoc = db.Column(db.SmallInteger, default=0)
loai_donvi_kiemtra = db.Column(db.SmallInteger)
thanhphan_doankiemtra = db.Column(db.String)
laphoso_theoquydinh = db.Column(db.SmallInteger, default=0)
hoso_daydu_theoquydinh = db.Column(db.SmallInteger, default=0)
tailieu_thieu = db.Column(db.String)
somau_thunghiem_dungquydinh = db.Column(db.SmallInteger, default=0)
thunghiem_daydu_thongso = db.Column(db.SmallInteger, default=0)
tansuat_thuchien_noikiem_dungquydinh = db.Column(db.SmallInteger, default=0)
thuchien_baocao_daydu = db.Column(db.SmallInteger, default=0)
thuchien_congkhai_thongtin = db.Column(db.SmallInteger, default=0)
thuchien_bienphap_khacphuc = db.Column(db.SmallInteger, default=0)
tongsomau_noikiem_thunghiem = db.Column(db.Integer, default=0)
tongsomau_noikiem_dat_quychuan = db.Column(db.Integer, default=0)
tongsomau_noikiem_khongdat_quychuan = db.Column(db.Integer, default=0)
tong_thongso_noikiem_khongdat = db.Column(db.Integer, default=0)
danhsachthongso_noikiem_khongdat = db.Column(JSONB)
tong_thongso_ngoaikiem_khongdat = db.Column(db.Integer, default=0)
danhsachthongso_ngoaikiem_khongdat = db.Column(JSONB)
somauvavitri = db.Column(db.Integer, default=0)
danhsachvitrilaymau = db.Column(JSONB)
ketquangoaikiemchatluongnuoc = db.Column(JSONB)
ketquangoaikiem = db.Column(db.SmallInteger, default=0)
nhanxet = db.Column(db.String)
congbo_thongtin_chodonvicapnuoc = db.Column(db.SmallInteger, default=0)
congkhai_thongtin = db.Column(db.SmallInteger, default=0)
thongbao_coquan_thamquyen = db.Column(db.SmallInteger, default=0)
thongbao_donvi_chuquan = db.Column(db.SmallInteger, default=0)
kiennghi = db.Column(db.String)
ketluan = db.Column(db.String)
class MapVienChuyenNganhNuocVaTinh(CommonModel):
__tablename__ = 'map_vienchuyennganhnuoc_tinh'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
user_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
user = db.relationship('User', viewonly=True)
danhsachtinhthanh = db.Column(JSONB)
class BangDichBenh(CommonModel):
__tablename__ = 'bangdichbenh'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangdichbenh',lazy='dynamic'))
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String(25))
sothutu = db.Column(db.SmallInteger())
db_csbc = db.Column(db.Integer())
db_dvdtc = db.Column(db.Integer())
db_dvkd = db.Column(db.Integer())
db_mdc = db.Column(db.Integer())
db_mdm = db.Column(db.Integer())
db_sldtc = db.Column(db.Integer())
db_slgs = db.Column(db.Integer())
db_sxdtc = db.Column(db.Integer())
db_sxkd = db.Column(db.Integer())
#bosung:
db_mdc_slgs = db.Column(db.Integer())
db_mdc_slxl = db.Column(db.Integer())
db_csbc_slgs = db.Column(db.Integer())
db_csbc_slxl = db.Column(db.Integer())
db_mdm_slgs = db.Column(db.Integer())
db_mdm_slxl = db.Column(db.Integer())
db_csdv_slgs = db.Column(db.Integer())
db_csdv_sld = db.Column(db.Integer())
db_cssx_slgs = db.Column(db.Integer())
db_cssx_sld = db.Column(db.Integer())
class BangHangHoa(CommonModel):
__tablename__ = 'banghanghoa'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('banghanghoa',lazy='dynamic'))
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String(25))
sothutu = db.Column(db.SmallInteger())
hh_nc_bpbk_sl = db.Column(db.Integer())
hh_nc_bpbk_skt = db.Column(db.Integer())
hh_nc_bpbk_sxl = db.Column(db.Integer())
hh_nc_hhk_tl = db.Column(db.Float())
hh_nc_hhk_skt = db.Column(db.Integer())
hh_nc_hhk_sxl = db.Column(db.Integer())
hh_nc_ghichu = db.Column(db.String())
hh_xc_bpbk_sl = db.Column(db.Integer())
hh_xc_bpbk_skt = db.Column(db.Integer())
hh_xc_bpbk_sxl = db.Column(db.Integer())
hh_xc_hhk_tl = db.Column(db.Float())
hh_xc_hhk_skt = db.Column(db.Integer())
hh_xc_hhk_sxl = db.Column(db.Integer())
hh_xc_ghichu = db.Column(db.String())
hh_qc_bpbk_sl = db.Column(db.Integer())
hh_qc_bpbk_skt = db.Column(db.Integer())
hh_qc_bpbk_sxl = db.Column(db.Integer())
hh_qc_hhk_tl = db.Column(db.Float())
hh_qc_hhk_skt = db.Column(db.Integer())
hh_qc_hhk_sxl = db.Column(db.Integer())
hh_qc_ghichu = db.Column(db.String())
class StandartTree(db.Model):
"""Эталонная структура дерева для каждого из типов шаблонов, с использованием всех тегов"""
__bind_key__ = 'caesar'
__tablename__ = '%s_standart_tree' % TABLE_PREFIX
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
tag_id = db.Column(db.Integer,
db.ForeignKey('%s_tag.id' % TABLE_PREFIX),
index=True)
parent_id = db.Column(db.Integer,
db.ForeignKey('%s_standart_tree.id' % TABLE_PREFIX),
index=True)
template_type_id = db.Column(db.Integer,
db.ForeignKey('%s_template_type.id' %
TABLE_PREFIX),
index=True)
is_necessary = db.Column(db.Boolean)
ordernum = db.Column(db.Integer, doc=u'Поле для сортировки тегов')
tag = db.relationship(Tag)
parent = db.relationship('StandartTree', remote_side=[id])
template_type = db.relationship(TemplateType)
__table_args__ = {'order_by': ordernum}
def __unicode__(self):
return self.tag.code
class UserDonvi(CommonModel):
__tablename__ = 'user_donvi'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
fullname = db.Column(db.String(255))
email = db.Column(db.String(255))
password = db.Column(db.String(255))
cfpassword = db.Column(db.String(255))
phone = db.Column(db.String(255))
macongdan = db.Column(String(200))
user_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id',
onupdate="CASCADE",
ondelete="SET NULL"),
nullable=True)
users = db.relationship('User', viewonly=True)
donvi_id = db.Column(db.Integer,
db.ForeignKey('donvi.id',
onupdate="CASCADE",
ondelete="SET NULL"),
nullable=True)
donvi = db.relationship('DonVi', foreign_keys=[donvi_id], viewonly=True)
donvi_sodienthoai = db.Column(db.String())
donvi_diachi = db.Column(db.String())
donvi_ten = db.Column(db.String())
donvi_tuyendonvi_id = db.Column(db.Integer,
db.ForeignKey('tuyendonvi.id',
onupdate="SET NULL"),
nullable=True)
donvi_tuyendonvi = db.relationship('TuyenDonVi')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh', viewonly=True)
quocgia_id = db.Column(UUID(as_uuid=True),
ForeignKey('quocgia.id'),
nullable=True)
quocgia = relationship('QuocGia')
captren_id = db.Column(db.Integer,
db.ForeignKey('donvi.id',
onupdate="CASCADE",
ondelete="SET NULL"),
nullable=True)
captren = db.relationship('DonVi',
foreign_keys=[captren_id],
backref=db.backref('user_donvi', lazy='dynamic'),
viewonly=True)
trangthai = db.Column(db.SmallInteger, default=2)
class ScheduleTicket(db.Model):
__tablename__ = 'ScheduleTicket'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
schedule_id = db.Column(db.Integer,
db.ForeignKey('Schedule.id'),
nullable=False)
begTime = db.Column(db.Time)
endTime = db.Column(db.Time)
attendanceType_id = db.Column(db.Integer,
db.ForeignKey('rbAttendanceType.id'),
nullable=False)
createDatetime = db.Column(db.DateTime, nullable=False)
createPerson_id = db.Column(db.Integer,
db.ForeignKey('Person.id'),
index=True)
modifyDatetime = db.Column(db.DateTime, nullable=False)
modifyPerson_id = db.Column(db.Integer,
db.ForeignKey('Person.id'),
index=True)
deleted = db.Column(db.SmallInteger, nullable=False, server_default='0')
attendanceType = db.relationship('rbAttendanceType', lazy=False)
client_ticket = db.relationship(
'ScheduleClientTicket',
lazy=False,
primaryjoin=
"and_(ScheduleClientTicket.ticket_id == ScheduleTicket.id, ScheduleClientTicket.deleted == 0)",
uselist=False)
schedule = db.relationship(
'Schedule',
lazy="joined",
innerjoin=True,
uselist=False,
primaryjoin='and_('
'Schedule.deleted == 0, ScheduleTicket.deleted == 0, ScheduleTicket.schedule_id == Schedule.id)'
)
@property
def client(self):
ct = self.client_ticket
return ct.client if ct else None
@property
def begDateTime(self):
return datetime.datetime.combine(
self.schedule.date,
self.begTime) if self.begTime is not None else None
@property
def endDateTime(self):
return datetime.datetime.combine(
self.schedule.date,
self.endTime) if self.endTime is not None else None
class TienDoKeHoachBCC(CommonModel):
__tablename__ = 'tiendo_kehoach_bcc'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime(), default=default_datetime_now)
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
# danhmucnganh_id = db.Column(UUID(as_uuid=True), ForeignKey('danhmucnganh.id'), nullable=True)
# danhmucnganh = relationship('DanhMucNganh')
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
thonxom_id = db.Column(UUID(as_uuid=True),
ForeignKey('thonxom.id'),
nullable=True)
thonxom = relationship('ThonXom')
tiendo_xaydung = db.Column(db.SmallInteger, nullable=True)
tiendo_rasoat = db.Column(db.SmallInteger, nullable=True)
tiendo_pheduyet = db.Column(db.SmallInteger, nullable=True)
ngay_pheduyet = db.Column(db.DateTime())
sohoatdong_cotloi_pheduyet = db.Column(db.Integer)
sohoatdong_cotloi_hoanthanh = db.Column(db.Integer)
# nganh_id = db.Column(UUID(as_uuid=True), ForeignKey('nganh.id'), nullable=True)
# nganh = relationship('Nganh')
giangvien = db.Column(db.Integer, default=0) # giang vien tai don vi
giangvien_nu = db.Column(db.Integer, default=0) # giang vien tai don vi
tongsogiangvien = db.Column(
db.Integer, default=0) #tong so giang vien, bao gom cac don vi con
tongsogiangvien_nu = db.Column(db.Integer, default=0)
tongsonguoithamgia = db.Column(db.Integer, default=0)
tongsonguoithamgia_nu = db.Column(db.Integer, default=0)
tongsonguoithamgia_dtts = db.Column(db.Integer, default=0)
danhsach_hoatdong = db.Column(JSONB())
tuyendonvi = db.Column(db.String) #tinh/huyen/xa/thon
class DiaDiemCachLyTapTrung(CommonModel):
__tablename__ = "diadiemcachlytaptrung"
id = db.Column(db.Integer, primary_key=True)
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=True, index=True)
cuakhau_id = db.Column(db.Integer, db.ForeignKey('cuakhau.id'), nullable=True, index=True)
ten = db.Column(db.String(255), nullable=False)
diachi = db.Column(db.String(255), nullable=True)
nguoilienlac = db.Column(db.String(255), nullable=False)
sodienthoai = db.Column(db.String)
email = db.Column(db.String)
ghichu = db.Column(db.String)
class TagTemplateType(db.Model):
__bind_key__ = 'caesar'
__tablename__ = '%s_tag_template_type' % TABLE_PREFIX
tag_id = db.Column(db.Integer,
db.ForeignKey('%s_tag.id' % TABLE_PREFIX),
primary_key=True,
autoincrement=True,
nullable=False)
template_type_id = db.Column(db.Integer,
db.ForeignKey('%s_template_type.id' %
TABLE_PREFIX),
primary_key=True,
nullable=False)
class BangPhuongTien(CommonModel):
__tablename__ = 'bangphuongtien'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangphuongtien',lazy='dynamic'))
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String(25))
sothutu = db.Column(db.SmallInteger())
pt_nc_hk_sl = db.Column(db.Integer())
pt_nc_hk_skt = db.Column(db.Integer())
pt_nc_hk_sxl = db.Column(db.Integer())
pt_nc_db_sl = db.Column(db.Integer())
pt_nc_db_skt = db.Column(db.Integer())
pt_nc_db_sxl = db.Column(db.Integer())
pt_nc_dt_sl = db.Column(db.Integer())
pt_nc_dt_skt = db.Column(db.Integer())
pt_nc_dt_sxl = db.Column(db.Integer())
pt_nc_ghichu = db.Column(db.String())
pt_xc_ghichu = db.Column(db.String())
pt_qc_ghichu = db.Column(db.String())
pt_nc_ds_sl = db.Column(db.Integer())
pt_nc_ds_skt = db.Column(db.Integer())
pt_nc_ds_sxl = db.Column(db.Integer())
#pt_nc_ds_ghichu
pt_xc_hk_sl = db.Column(db.Integer())
pt_xc_hk_skt = db.Column(db.Integer())
pt_xc_hk_sxl = db.Column(db.Integer())
pt_xc_db_sl = db.Column(db.Integer())
pt_xc_db_skt = db.Column(db.Integer())
pt_xc_db_sxl = db.Column(db.Integer())
pt_xc_dt_sl = db.Column(db.Integer())
pt_xc_dt_skt = db.Column(db.Integer())
pt_xc_dt_sxl = db.Column(db.Integer())
pt_xc_ds_sl = db.Column(db.Integer())
pt_xc_ds_skt = db.Column(db.Integer())
pt_xc_ds_sxl = db.Column(db.Integer())
pt_qc_hk_sl = db.Column(db.Integer())
pt_qc_hk_skt = db.Column(db.Integer())
pt_qc_hk_sxl = db.Column(db.Integer())
pt_qc_db_sl = db.Column(db.Integer())
pt_qc_db_skt = db.Column(db.Integer())
pt_qc_db_sxl = db.Column(db.Integer())
pt_qc_dt_sl = db.Column(db.Integer())
pt_qc_dt_skt = db.Column(db.Integer())
pt_qc_dt_sxl = db.Column(db.Integer())
pt_qc_ds_sl = db.Column(db.Integer())
pt_qc_ds_skt = db.Column(db.Integer())
pt_qc_ds_sxl = db.Column(db.Integer())
class Comment(db.Model):
__tablename__ = "comments"
id = db.Column(db.Integer, primary_key=True)
content = db.Column(db.Text(length=600))
author_id = db.Column(db.Integer, db.ForeignKey("users.id"))
author = db.relationship("User")
game_id = db.Column(db.Integer, db.ForeignKey("games.id"))
game = db.relationship("Game")
replies = db.relationship(
"Comment",
secondary=comment_reply,
primaryjoin=("Comment.id==comment_reply.c.reply_id"),
secondaryjoin=("Comment.id==comment_reply.c.comment_id"),
)
class TimeTrack(db.Model):
__tablename__ = "TimeTracks"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
year = db.Column(db.Integer, nullable=False)
month = db.Column(db.Integer, nullable=False)
hours = db.Column(db.Float, nullable=False)
employee_id = db.Column(db.Integer,
db.ForeignKey("Employees.id"),
nullable=False)
account_id = db.Column(db.Integer,
db.ForeignKey("Accounts.id"),
nullable=False)
def __repr__(self):
return f"{self.hours}"
class BaoCaoNghiNgoNhiemBenhQuocGia(CommonModel):
__tablename__ = 'baocaonghingonhiembenhquocgia'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True)
baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhquocgia',lazy='dynamic'))
tenquocgia = db.Column(db.String())
ngaydiqua = db.Column(db.DateTime())
class TinhThanh(CommonModel):
__tablename__ = 'tinhthanh'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ten = db.Column(db.String(255), nullable=False)
quocgia_id = db.Column(db.Integer, db.ForeignKey('quocgia.id'), nullable=True)
quocgia = db.relationship('QuocGia',viewonly=True)
class Genre(db.Model):
__tablename__ = "genres"
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(120), unique=True)
parent_id = db.Column(db.Integer, db.ForeignKey("genres.id"))
parent_genre = db.relationship("Genre", remote_side=[id])
class Cart(db.Model):
__tablename__ = "cart"
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
user = db.relationship("User")
games = db.relationship("Game", secondary=cart_game, lazy="dynamic")
class QuanHuyen(CommonModel):
__tablename__ = 'quanhuyen'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ten = db.Column(db.String(255), nullable=False)
tinhthanh_id = db.Column(db.Integer, db.ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = db.relationship('TinhThanh',viewonly=True)
class Template(db.Model):
"""Шаблоны"""
__bind_key__ = 'caesar'
__tablename__ = '%s_template' % TABLE_PREFIX
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.Unicode(80), unique=True, nullable=False)
archive = db.Column(db.Boolean, default=False)
is_active = db.Column(db.Boolean, default=False)
#user = db.Column(db.Integer, db.ForeignKey('.id'))
type_id = db.Column(db.Integer,
db.ForeignKey('%s_template_type.id' % TABLE_PREFIX),
index=True)
type = db.relation(TemplateType)
tag_tree = db.relationship('TagsTree',
backref='template',
cascade="all, delete, delete-orphan")
def __repr__(self):
return '<Template %r>' % self.name
def __unicode__(self):
return self.name
class AvatarImage(db.Model):
__tablename__ = "avatar_image"
id = db.Column(db.Integer, primary_key=True)
path = db.Column(db.String(255), unique=True)
url = db.Column(db.String(255))
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
user = db.relationship("User")
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
post_id = db.Column(db.Integer, db.ForeignKey("post.id"))
name = db.Column(db.String(20))
content = db.Column(db.Text, nullable=False)
timestamp = db.Column(db.DateTime,
index=True,
default=datetime.now(get_localzone()))
class BangKinhPhi(CommonModel):
__tablename__ = 'bangkinhphi'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangkinhphi',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
nguonkinhphi = db.Column(db.String())
kinhphi = db.Column(db.Float())
class BangHopTacQuocTe(CommonModel):
__tablename__ = 'banghoptacquocte'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('banghoptacquocte',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
quocgia = db.Column(db.String())
noidung = db.Column(db.String())
class BaoCaoNghiNgoNhiemBenhXetNghiem(CommonModel):
__tablename__ = 'baocaonghingonhiembenhxetnghiem'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True)
baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhxetnghiem',lazy='dynamic'))
loaimauxetnghiem = db.Column(db.String())
ngaylay = db.Column(db.DateTime())
ketqua = db.Column(db.String())
