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 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 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 User(db.Model): __tablename__ = 'users' __table_args__ = ( db.UniqueConstraint('name'), db.UniqueConstraint('email'), ) id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(15, collation='utf8mb4_general_ci'), nullable=False) display_name = db.Column(db.String(50, collation='utf8mb4_general_ci'), nullable=False) email = db.Column(db.String(256, collation='utf8mb4_general_ci'), nullable=False) password = db.Column(db.String(1024, collation='utf8mb4_general_ci'), nullable=False) created_at = db.Column(db.DateTime, nullable=False, default=datetime.now) updated_at = db.Column(db.DateTime, nullable=False, default=datetime.now, onupdate=datetime.now) def __init__(self, name, display_name, email, password): self.name = name self.display_name = display_name self.email = email self.password = password
class ProductArea(Abstract): """ ProductArea model class""" slug = db.Column(db.String(255), nullable=False) title = db.Column(db.String(255), nullable=False) def __repr__(self): return f'<ProductArea: {self.title}>'
class Country(CommonModel): __tablename__ = "country" country_name = db.Column(db.String(50)) code = db.Column(db.String(50)) cities = db.relationship("City", order_by="City.id", cascade="all, delete-orphan")
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 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 BaiViet(CommonModel): __tablename__ = 'baiviet' id = db.Column(db.Integer, primary_key=True) ngaytao = db.Column(db.DateTime(),default=func.now()) tieude = db.Column(db.String()) gioithieu = db.Column(db.String()) noidung = db.Column(db.Text()) phamvi = db.Column(db.String(20))
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 Employee(Abstract, UserMixin): """ Employee model class""" first_name = db.Column(db.String(255), nullable=False) last_name = db.Column(db.String(255), nullable=False) email = db.Column(EmailType, unique=True, nullable=False) password = db.Column(db.Text) def __repr__(self): return f'<Employee: {self.first_name} {self.last_name}>'
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())
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 BaoCaoNghiNgoNhiemBenhNguoiTiepXuc(CommonModel): __tablename__ = 'baocaonghingonhiembenhnguoitiepxuc' 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('baocaonghingonhiembenhnguoitiepxuc',lazy='dynamic')) hoten = db.Column(db.String()) quoctich = db.Column(db.String()) cmtnd = db.Column(db.String()) dienthoai = db.Column(db.String()) email = db.Column(db.String())
class BaoCaoNghiNgoNhiemBenhVacxin(CommonModel): __tablename__ = 'baocaonghingonhiembenhvacxin' 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('baocaonghingonhiembenhvacxin',lazy='dynamic')) tenvacxin = db.Column(db.String()) solandung = db.Column(db.SmallInteger) ngaydunggannhat = db.Column(db.DateTime()) ketqua = db.Column(db.String())
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 user(Base): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) username = db.Column('username',db.String(80), unique=True) password = db.Column('password',db.String(120)) def __init__(self, username, password): self.username = username self.password = password print("User __init__ has fired")
class OrganizationStaff(CommonModel): __tablename__ = 'organizationstaff' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) name = db.Column(db.String(255)) phone = db.Column(db.String(255)) email = db.Column(db.String(255)) role = db.Column(db.String(255)) organization_id = db.Column(UUID(as_uuid=True), ForeignKey('organization.id'), 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 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 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 Employee(db.Model): __tablename__ = "Employees" id = db.Column(db.Integer, primary_key=True, autoincrement=True) gid = db.Column(db.String(50), unique=True, nullable=False) local_id = db.Column(db.String(50), unique=True, nullable=False) name = db.Column(db.String(50), nullable=False) last_name = db.Column(db.String(50), nullable=False) time_tracks = db.relationship("TimeTrack", backref="employee", lazy=True) def __repr__(self): return f"{self.name} {self.last_name}"
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 User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True) password = db.Column(db.String(120)) permissions = db.relationship('Permission', secondary=user_permissions, backref=db.backref('users', lazy='dynamic')) def __init__(self, username, password): self.username = username self.password = password
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 ConfigVariables(db.Model): __bind_key__ = 'caesar' __tablename__ = '%s_config' % TABLE_PREFIX id = db.Column(db.Integer, primary_key=True, autoincrement=True) code = db.Column(db.String(25), unique=True, nullable=False) name = db.Column(db.Unicode(50), unique=True, nullable=False) value = db.Column(db.Unicode(100)) value_type = db.Column(db.String(30)) def __unicode__(self): return self.code
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 Car(db.Model): id = db.Column(db.Integer, primary_key=True) make = db.Column(db.String(20)) model = db.Column(db.String(20)) build_date = db.Column(db.DateTime) colour_id = db.Column(db.Integer, db.ForeignKey('colour.id')) def save_to_db(self): db.session.add(self) db.session.commit() def delete_from_db(self): db.session.delete(self) db.session.commit()