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 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 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 Recipe(CommonModel):
__tablename__ = 'recipe'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
item_id = db.Column(UUID(as_uuid=True),
ForeignKey('item.id'),
nullable=True)
item_exchange_id = db.Column(db.String)
quantity = db.Column(db.Integer())
tenant_id = db.Column(db.String, index=True)
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 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 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 Item(CommonModel):
__tablename__ = 'item'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
pricelist_id = db.Column(UUID(as_uuid=True),
ForeignKey('pricelist.id'),
nullable=True)
# pricelist_id = db.Column(UUID(as_uuid=True), ForeignKey('pricelist.id'), nullable=True)
#organization_id = db.Column(UUID(as_uuid=True), ForeignKey("organization.id", ondelete="set null"))
item_exid = db.Column(String(100),
index=True) #id tich hop tu he thong khac
item_name = db.Column(db.String)
item_no = db.Column(db.String)
tenant_id = db.Column(db.String, index=True)
specification = db.Column(db.Text())
categories = db.relationship("ItemCategory", secondary=items_categories)
unit = relationship('Unit')
unit_id = db.Column(UUID(as_uuid=True), ForeignKey('unit.id'))
unit_code = db.Column(db.String)
description = db.Column(db.String)
status = db.Column(db.String)
manufacturer = db.Column(String(200), nullable=True)
importer = db.Column(db.String(200))
list_price = db.Column(DECIMAL(27, 8), default=0)
purchase_cost = db.Column(DECIMAL(27, 8), default=0)
pack_size = db.Column(db.DECIMAL, nullable=True)
weight = db.Column(db.DECIMAL, nullable=True)
cost_factor = db.Column(db.DECIMAL, nullable=True)
discontinued = db.Column(db.Boolean, nullable=True)
vendor_part_no = db.Column(db.String, nullable=True)
allow_delivery = db.Column(db.Boolean, nullable=True)
image = db.Column(db.String,
default="static/images/default-dist.jpeg",
nullable=True)
item_type = db.Column(db.String(), default="material")
# is_product = db.Column(db.Boolean, default=False) # la dich vu
# is_service = db.Column(db.Boolean, default=False) # la dich vu
# is_package = db.Column(db.Boolean, default=False) # la combo
# is_raw_material = db.Column(db.Boolean, default=False) # nguyen lieu tho
# is_material = db.Column(db.Boolean, default=False) # vat lieu
parent_id = db.Column(UUID(as_uuid=True))
package_products = db.Column(JSONB(), nullable=True)
position = db.Column(db.Integer(), nullable=True)
extension_data = db.Column(JSONB(), nullable=True)
status = db.Column(db.String)
# medicalequipment_id = db.Column(UUID(as_uuid=True), ForeignKey('medicalequipment.id'))
# medicalequipment = relationship('MedicalEquipment', viewonly=True)
recipe = relationship('Recipe')
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())
from werkzeug.security import generate_password_hash, check_password_hash
from sqlalchemy.orm import relationship
from application.database import db, UUID
from datetime import datetime
import uuid as uuid_ext
user_role_assoc = db.Table('na_user_role_assoc',
db.Column('id', db.Integer(), primary_key=True),
db.Column('user_uuid',
UUID,
db.ForeignKey('na_user.uuid'),
primary_key=True),
db.Column('role_uuid',
UUID,
db.ForeignKey('na_user_role.uuid'),
primary_key=True),
extend_existing=True)
role_hierachy_assoc = db.Table('na_user_role_hierachy_assoc',
db.Column('id', db.Integer(), primary_key=True),
db.Column('parent_role_uuid',
UUID,
db.ForeignKey('na_user_role.uuid'),
primary_key=True),
db.Column('child_role_uuid',
UUID,
db.ForeignKey('na_user_role.uuid'),
primary_key=True),
extend_existing=True)
#role_ability_assoc = db.Table('na_user_role_ability_assoc',
class Role(CommonModel):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))
from application.database import db
from application.database.model import CommonModel
import uuid
def default_uuid():
return str(uuid.uuid4())
roles_users = db.Table(
'roles_users',
db.Column('user_id', UUID(as_uuid=True), db.ForeignKey('user.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
#Enum
class TuyenDonViEnum(object):
TW = 1
soyte = 2
cosodaotao = 3
bvydct = 4
khoaydct = 5
quanhuyen = 6
bvtructhuocso = 7
moidangky = 99
class TrangThaiDangKyDonViEnum(object):
class TruongHopCachLyTapTrung(CommonModel):
__tablename__ = 'truonghopcachlytaptrung'
# id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255))
matokhaiyte = db.Column(db.String(), index=True)
ngaybaocao = db.Column(db.DateTime(), index=True, nullable=False)
noibaocao = db.Column(db.String(255))
nambaocao = db.Column(db.Integer, 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, index=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String())
#dulieu
hoten = db.Column(db.String(), index=True)
gioitinh = db.Column(db.String(20))
namsinh = db.Column(db.Integer())
quoctich = db.Column(db.String())
ma_quoctich = db.Column(db.String())
cmtnd = db.Column(db.String(), index=True)
cuakhau_nhapquacanh = db.Column(db.String())
gio_nhapquacanh = db.Column(db.Integer())
ngay_nhapquacanh = db.Column(db.DateTime())
phuongtien = db.Column(db.String())
sohieu_phuongtien = db.Column(db.String())
noio = db.Column(db.String())
noio_tinhthanh = db.Column(db.String())
noio_matinhthanh = db.Column(db.String())
noio_quanhuyen = db.Column(db.String())
noio_xaphuong = db.Column(db.String())
diachi_lienlac = db.Column(db.String())
email = db.Column(db.String())
sodienthoai = db.Column(db.String(63))
nghenghiep = db.Column(db.String())
benh_nghingo = db.Column(db.String())
tiensu_dichte = db.Column(db.String())
tiensu_trieuchunglamsang = db.Column(db.String())
tiensu_xutri = db.Column(db.String())
noitiepnhan_xutri_id = db.Column(db.Integer())
noitiepnhan_xutri = db.Column(db.String())
ngaygio_phathien = db.Column(db.String())
# ngay_phathien = db.Column(db.DateTime())
# gio_phathien = db.Column(db.Integer())
tinhtrang_phathien = db.Column(db.String())
benhly_kemtheo = db.Column(db.String())
# huongxutri = db.Column(db.String())
nhanxet_danhgia = db.Column(db.String())
ghichu = db.Column(db.String())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
# class TruongHopCachLyTapTrung(CommonModel):
# __tablename__ = "truonghopcachlytaptrung"
# #id = db.Column(db.Integer, primary_key=True)
# id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid())
# ma = db.Column(db.String(255))
# matokhaiyte = db.Column(db.String(), index=True)
# ngaybaocao = db.Column(db.DateTime(),default=func.now(), index=True)
# noibaocao = db.Column(db.String(255))
# #nambaocao = db.Column(db.Integer, nullable=False)
# donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True, index=True)
# tendonvi = db.Column(db.String())
# madonvi = db.Column(db.String())
# donvi = db.relationship('DonVi',viewonly=True)
# cuakhau_id = db.Column(db.Integer, index=True, nullable=True)
# tencuakhau = db.Column(db.String())
# macuakhau = db.Column(db.String())
# #dulieu
# hoten = db.Column(db.String(), index=True)
# gioitinh = db.Column(db.String(20))
# namsinh = db.Column(db.Integer())
# quoctich = db.Column(db.String())
# ma_quoctich = db.Column(db.String())
# cmtnd = db.Column(db.String(), index=True)
# noio = db.Column(db.String())
# noio_tinhthanh = db.Column(db.String())
# noio_matinhthanh = db.Column(db.String())
# trangthai = db.Column(db.String)
# note = db.Column(db.Text())
# extra_data = db.Column(JSONB)
class BaoCaoNghiNgoNhiemBenh(CommonModel):
__tablename__ = 'baocaonghingonhiembenh'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255))
matokhaiyte = db.Column(db.String(), index=True)
ngaybaocao = db.Column(db.DateTime(),default=func.now(), index=True)
noibaocao = db.Column(db.String(255))
nambaocao = db.Column(db.Integer, nullable=False)
donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True, index=True)
tendonvi = db.Column(db.String())
madonvi = db.Column(db.String())
donvi = db.relationship('DonVi',viewonly=True)
cuakhau_id = db.Column(db.Integer, index=True, nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String())
#dulieu
hoten = db.Column(db.String(), index=True)
gioitinh = db.Column(db.String(20))
namsinh = db.Column(db.Integer())
quoctich = db.Column(db.String())
ma_quoctich = db.Column(db.String())
cmtnd = db.Column(db.String(), index=True)
cuakhau_nhapquacanh = db.Column(db.String())
gio_nhapquacanh = db.Column(db.Integer())
ngay_nhapquacanh = db.Column(db.DateTime())
phuongtien = db.Column(db.String())
sohieu_phuongtien = db.Column(db.String())
noio = db.Column(db.String())
noio_tinhthanh = db.Column(db.String())
noio_matinhthanh = db.Column(db.String())
diachi_lienlac = db.Column(db.String())
email = db.Column(db.String())
dienthoai = db.Column(db.String(63))
benh_nghingo = db.Column(db.String())
tiensu_dichte = db.Column(db.String())
tiensu_ngaykhoiphat = db.Column(db.DateTime())
tiensu_trieuchunglamsang = db.Column(db.String())
tiensu_chandoan = db.Column(db.String())
tiensu_xutri = db.Column(db.String())
noitiepnhan_xutri = db.Column(db.String())
nhanxet_danhgia = 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)
ngaygio_phathien = db.Column(db.String())
huongxutri = db.Column(db.String())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
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 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 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 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 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())