class BaoCaoTongHopNghiNgoNhiemBenhNhomA(CommonModel): __tablename__ = "baocaotonghopnghingonhiembenhnhoma" id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid()) loaibaocao = db.Column(db.SmallInteger()) #1 - don vi, 2 cua khau ngaybaocao = db.Column(db.DateTime(), index=True, default=func.now()) donvi_id = db.Column(db.Integer, index=True, nullable=False) madonvi = db.Column(db.String()) tendonvi = db.Column(db.String()) cuakhau_id = db.Column(db.Integer, index=True, nullable=True) tencuakhau = db.Column(db.String()) macuakhau = db.Column(db.String()) #cuakhau songuoinhapcanh = db.Column(db.BigInteger) sohanhkhachkhaibao = db.Column(db.BigInteger) sochuyenbay = db.Column(db.BigInteger) songuoinghingo = db.Column(db.BigInteger) #donvi songuoidangcachlytaptrung = db.Column(db.BigInteger) songuoidangcachlytaptrung_cotrieuchung = db.Column(db.BigInteger) songuoicachlytainha = db.Column(db.BigInteger) songuoihetcachly = db.Column(db.BigInteger) data = 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 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 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 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 BangVienCanBo(CommonModel): __tablename__ = 'bangviencanbo' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True) baocao = db.relationship('BaoCaoVien', backref=db.backref('bangviencanbo',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) trinhdochuyenmon = db.Column(db.String()) soluongchuyentrach = db.Column(db.Integer()) soluongkiemnhiem = db.Column(db.Integer())
class BangVienHoatDongChung(CommonModel): __tablename__ = 'bangvienhoatdongchung' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True) baocao = db.relationship('BaoCaoVien', backref=db.backref('bangvienhoatdongchung',lazy='dynamic')) noidung = db.Column(db.String()) sothutu = db.Column(db.SmallInteger()) tenhoatdong = db.Column(db.String()) soluong = db.Column(db.Integer())
class BangVienSuKien(CommonModel): __tablename__ = 'bangviensukien' id = db.Column(db.Integer, primary_key=True) baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True) baocao = db.relationship('BaoCaoVien', backref=db.backref('bangviensukien',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tensukien = db.Column(db.String()) diadiem = db.Column(db.String()) bienphap = db.Column(db.String()) ketqua = db.Column(db.String())
class BangNghienCuuKhoaHoc(CommonModel): __tablename__ = 'bangnghiencuukhoahoc' 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('bangnghiencuukhoahoc',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tendetai = db.Column(db.String()) thoigianthuchien = db.Column(db.String()) detaicap = db.Column(db.String()) linhvucnghiencuu = db.Column(db.String())
class BangTruyenThong(CommonModel): __tablename__ = 'bangtruyenthong' 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('bangtruyenthong',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) hinhthuc = db.Column(db.String()) noidung = db.Column(db.String()) doituong = db.Column(db.String()) ketqua = db.Column(db.Integer())
class BangXetNghiem(CommonModel): __tablename__ = 'bangxetnghiem' 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('bangxetnghiem',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) loaixetnghiem = db.Column(db.String()) soluongmau = db.Column(db.Integer()) dattieuchuan = db.Column(db.Integer()) ghichu = db.Column(db.String())
class BangTiemChung(CommonModel): __tablename__ = 'bangtiemchung' 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('bangtiemchung',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tenbenh = db.Column(db.String()) tenvacxin = db.Column(db.String()) soluong = db.Column(db.Integer()) ghichu = db.Column(db.String())
class BangDaoTaoCanBo(CommonModel): __tablename__ = 'bangdaotaocanbo' 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('bangdaotaocanbo',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) hinhthucdaotao = db.Column(db.String()) soluong = db.Column(db.Integer()) vesinhdichte = db.Column(db.Integer()) ytecongdong = db.Column(db.Integer()) xetnghiem = db.Column(db.Integer()) ngoaingu = db.Column(db.Integer()) khac = db.Column(db.Integer())
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 BangVSSH(CommonModel): __tablename__ = 'bangvssh' 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('bangvssh',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()) vssh_nc_vs_sl = db.Column(db.Integer()) vssh_nc_vs_skt = db.Column(db.Integer()) vssh_nc_vs_sxl = db.Column(db.Integer()) vssh_nc_sh_sl = db.Column(db.Integer()) vssh_nc_sh_skt = db.Column(db.Integer()) vssh_nc_sh_sxl = db.Column(db.Integer()) vssh_nc_mo_sl = db.Column(db.Integer()) vssh_nc_mo_skt = db.Column(db.Integer()) vssh_nc_mo_sxl = db.Column(db.Integer()) vssh_xc_vs_sl = db.Column(db.Integer()) vssh_xc_vs_skt = db.Column(db.Integer()) vssh_xc_vs_sxl = db.Column(db.Integer()) vssh_xc_sh_sl = db.Column(db.Integer()) vssh_xc_sh_skt = db.Column(db.Integer()) vssh_xc_sh_sxl = db.Column(db.Integer()) vssh_xc_mo_sl = db.Column(db.Integer()) vssh_xc_mo_skt = db.Column(db.Integer()) vssh_xc_mo_sxl = db.Column(db.Integer()) vssh_qc_vs_sl = db.Column(db.Integer()) vssh_qc_vs_skt = db.Column(db.Integer()) vssh_qc_vs_sxl = db.Column(db.Integer()) vssh_qc_sh_sl = db.Column(db.Integer()) vssh_qc_sh_skt = db.Column(db.Integer()) vssh_qc_sh_sxl = db.Column(db.Integer()) vssh_qc_mo_sl = db.Column(db.Integer()) vssh_qc_mo_skt = db.Column(db.Integer()) vssh_qc_mo_sxl = db.Column(db.Integer()) vssh_nc_ghichu = db.Column(db.String()) vssh_xc_ghichu = db.Column(db.String()) vssh_qc_ghichu = db.Column(db.String())
class BangTrinhDoChuyenMon(CommonModel): __tablename__ = 'bangtrinhdochuyenmon' 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('bangtrinhdochuyenmon',lazy='dynamic')) sothutu = db.Column(db.SmallInteger()) tenbophan = db.Column(db.String()) y_tiensy = db.Column(db.Integer()) y_thacsy = db.Column(db.Integer()) y_cunhan = db.Column(db.Integer()) y_ysy = db.Column(db.Integer()) y_dieuduong = db.Column(db.Integer()) y_kythuatvien = db.Column(db.Integer()) y_khac = db.Column(db.Integer()) duoc_daihoc = db.Column(db.Integer()) duoc_trunghoc = db.Column(db.Integer()) duoc_duocta = db.Column(db.Integer()) nganhkhac_daihoc = db.Column(db.Integer()) nganhkhac_trunghoc = db.Column(db.Integer()) nganhkhac_khac = db.Column(db.Integer())
class BangNguoi(CommonModel): __tablename__ = 'bangnguoi' 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('bangnguoi',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()) ng_nc_sl1 = db.Column(db.Integer()) ng_nc_sl2 = db.Column(db.Integer()) ng_nc_ts1 = db.Column(db.Integer()) ng_nc_ts2 = db.Column(db.Integer()) ng_nc_ghichu = db.Column(db.String()) ng_xc_sl1 = db.Column(db.Integer()) ng_xc_sl2 = db.Column(db.Integer()) ng_xc_ts1 = db.Column(db.Integer()) ng_xc_ts2 = db.Column(db.Integer()) ng_xc_ghichu = db.Column(db.String()) ng_qc_sl1 = db.Column(db.Integer()) ng_qc_sl2 = db.Column(db.Integer()) ng_qc_ts1 = db.Column(db.Integer()) ng_qc_ts2 = db.Column(db.Integer()) ng_qc_ghichu = db.Column(db.String())
class ToKhaiYTe(CommonModel): __tablename__ = "tokhaiyte" id = db.Column(db.String, primary_key=True) ngaykekhai = db.Column(db.DateTime(), nullable=False) donvi_id = db.Column(db.Integer, nullable=False, index=True) tendonvi = db.Column(db.String()) madonvi = db.Column(db.String()) cuakhau_id = db.Column(db.Integer, nullable=False, index=True) tencuakhau = db.Column(db.String()) macuakhau = db.Column(db.String()) canbo_id = db.Column(db.Integer, nullable=True) tencanbo = db.Column(db.String) emailcanbo = db.Column(db.String) hoten = db.Column(db.String, index=True) namsinh = db.Column(db.Integer) gioitinh = db.Column(db.String) quoctich = db.Column(db.String) cmtnd = db.Column(db.String, index=True) thongtindilai_taubay = db.Column(db.SmallInteger) #taubay, tauthuyen, oto, khac thongtindilai_tauthuyen = db.Column(db.SmallInteger) thongtindilai_oto = db.Column(db.SmallInteger) thongtindilai_khac = db.Column(db.SmallInteger) thongtindilai_chitiet = db.Column(db.String) sohieu_phuongtien = db.Column(db.String) soghe_phuongtien = db.Column(db.String) ngay_khoihanh = db.Column(db.DateTime()) ngay_nhapcanh = db.Column(db.DateTime()) noi_khoihanh = db.Column(db.String) noiden = db.Column(db.String) quocgiadiqua = db.Column(db.String()) diachi_taivietnam = db.Column(db.String) sodienthoai = db.Column(db.String) email = db.Column(db.String) dauhieubenh_sot = db.Column(db.SmallInteger) dauhieubenh_ho = db.Column(db.SmallInteger) dauhieubenh_khotho = db.Column(db.SmallInteger) dauhieubenh_dauhong = db.Column(db.SmallInteger) dauhieubenh_buonnon = db.Column(db.SmallInteger) dauhieubenh_tieuchay = db.Column(db.SmallInteger) dauhieubenh_xuathuyetngoaida = db.Column(db.SmallInteger) dauhieubenh_phatban = db.Column(db.SmallInteger) vacxin_dasudung = db.Column(db.String()) tiepxuc_dongvat = db.Column(db.SmallInteger()) chamsocnguoibenhtruyennhiem = db.Column(db.SmallInteger()) ngaygio_phathien = db.Column(db.String) tinhtrang = db.Column(db.String) huongxutri = db.Column(db.String) cachlytaptrung = db.Column(db.String) trangthai = db.Column(db.String) note = db.Column(db.Text()) ngon_ngu = db.Column(db.String(10)) extra_data = db.Column(JSONB)