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)