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())