class ContactTagsDetails(CommonModel): __tablename__ = 'contact_tags_details' contact_tags_id = db.Column(UUID(as_uuid=True), ForeignKey("contact_tags.id", onupdate="CASCADE", ondelete="CASCADE"), nullable=False) contact_id = db.Column(UUID(as_uuid=True), ForeignKey("contact.id", onupdate="CASCADE", ondelete="CASCADE"), nullable=False) timestamp = db.Column(BigInteger) description = db.Column(Text()) tenant_id = db.Column(String(), ForeignKey("tenant.id", onupdate="CASCADE", ondelete="RESTRICT"), nullable=False)
class DanToc(CommonModel): __tablename__ = 'dantoc' id = db.Column(String, primary_key=True, default=default_uuid) ma = db.Column(String(255), index=True) ten = db.Column(String(255)) tenkhongdau = db.Column(String) active = db.Column(SmallInteger(), default=0)
class Task(db.Model): id = db.Column(db.Integer, primary_key=True) content = db.Column(db.String(200), nullable=False) date_created = db.Column(db.DateTime, default=datetime.utcnow) def __repr__(self): return f"Post('{self.id}','{self.content}','{self.date_created}')"
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 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 CommonModel(db.Model): __abstract__ = True id = db.Column(Integer, primary_key=True, default=default_uuid) created_at = db.Column(DateTime) updated_at = db.Column(DateTime) deleted = db.Column(Boolean, default=False) deleted_at = db.Column(DateTime)
class User(CommonModel): __tablename__ = 'user' id = db.Column(String, primary_key=True, default=default_uuid) name = db.Column(String()) unsigned_name = db.Column(String()) email = db.Column(String(255)) phone = db.Column(String()) password = db.Column(String(255)) accountName = db.Column(String(255)) salt = db.Column(String()) active = db.Column(SmallInteger(), default=0) #0- chua active, 1- active # confirmed_at = db.Column(DateTime()) # type_confirm = db.Column(SmallInteger()) #0 - email, 1- sms roles = relationship("Role", secondary=roles_users) organization_id = db.Column(String, ForeignKey('organization.id', onupdate='CASCADE', ondelete='SET NULL'), nullable=True) Organization = relationship('Organization') # Methods def __repr__(self): """ Show user object info. """ return '<User: {}>'.format(self.id) def has_role(self, role): if isinstance(role, str): return role in (role.name for role in self.roles) else: return role in self.roles
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 Notify(CommonModel): __tablename__ = 'notify' target = db.Column(String(20)) action = db.Column(String(16)) api_path = db.Column(String(255)) message = db.Column(Text())
class HangHoa(CommonModel): __tablename__ = 'hanghoa' id = db.Column(Integer, primary_key=True) ma = db.Column(String(255), unique=True) ten = db.Column(String(255), nullable=False) gia = db.Column(Integer) ghichu = db.Column(String(255))
class Test(db.Model): __tablename__ = "test" id = db.Column(UUID(as_uuid=True), primary_key=True) name = db.Column(String(50)) image = db.Column(String(255)) price = db.Column(DECIMAL(10, 2)) describe = db.Column(Text())
class Permission(db.Model): id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String(200)) def __init__(self, id, description): self.id = id self.description = description
class Province(CommonModel): __tablename__ = 'province' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) code = db.Column(String(255), unique=True, index=True) name = db.Column(String(255)) nation_id = db.Column(UUID(as_uuid=True), ForeignKey('nation.id')) nation = relationship('Nation', viewonly=True)
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 TinhThanh(CommonModel): __tablename__ = 'tinhthanh' id = db.Column(Integer, primary_key=True) ma = db.Column(String(255), unique=True) ten = db.Column(String(255), nullable=False) quocgia_id = db.Column(Integer, ForeignKey('quocgia.id'), nullable=False) quocgia = db.relationship('QuocGia')
class Client(Abstract): """ Client model class""" name = db.Column(db.Text, nullable=False) slug = db.Column(db.String(200)) def __repr__(self): return f'<Client: {self.name}>'
class HoatDongBCCXaThon(CommonModel): __tablename__ = 'hoatdongbccxathon' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) hopcapxa = db.Column(db.String) camketdat = db.Column(db.String) vesinh_thuongxuyen = db.Column(db.String) truyenthong_thon = db.Column(db.String)
class Currency(CommonModel): __tablename__ = 'currency' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) currency_name = db.Column(String(50), unique=True, nullable=True) currency_code = db.Column(String(11), unique=True, nullable=True) currency_symbol = db.Column(String(11), nullable=True) tenant_id = db.Column(db.String)
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 Wards(CommonModel): __tablename__ = 'wards' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) code = db.Column(String(255), unique=True, index=True) name = db.Column(String(255)) district_id = db.Column(UUID(as_uuid=True), ForeignKey('district.id')) district = relationship('District', viewonly=True)
class District(CommonModel): __tablename__ = 'district' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) code = db.Column(String(255), unique=True, index=True) name = db.Column(String(255)) province_id = db.Column(UUID(as_uuid=True), ForeignKey('province.id')) province = relationship('Province', viewonly=True)
class Workstation(CommonModel): __tablename__ = 'workstation' id = db.Column(Integer, primary_key=True) id_organization = db.Column(Integer, ForeignKey('organization.id'), nullable=False) address = db.Column(String(255))
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 TaskSchedule(CommonModel): __tablename__ = 'task_schedule' taskschedule_name = db.Column(String()) # shift_of_day = db.Column(BigInteger()) #2^n start_time_working = db.Column(BigInteger(), default=0) end_time_working = db.Column(BigInteger(), default=0) active = db.Column(SmallInteger, default=1) task_scheduledetail = db.relationship('TaskScheduleDetail')
class Permission(CommonModel): __tablename__ = 'permission' id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) role_id = db.Column(UUID(as_uuid=True), ForeignKey('role.id'), nullable=False) subject = db.Column(String,index=True) permission = db.Column(String) value = db.Column(Boolean, default=False) __table_args__ = (UniqueConstraint('role_id', 'subject', 'permission', name='uq_permission_role_subject_permission'),)
class Project(db.Model): __tablename__ = "Projects" id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(100), nullable=False) accounts = db.relationship("Account", backref="project", lazy=True) def __repr__(self): return f"{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 NotifyUser(CommonModel): __tablename__ = 'notify_user' id = db.Column(String, primary_key=True, default=default_uuid) user_id = db.Column(String) notify_id = db.Column(String, ForeignKey('notify.id'), nullable=True) notify = db.relationship('Notify') notify_at = db.Column(BigInteger()) read_at = db.Column(BigInteger())
class CommonModel(db.Model): __abstract__ = True id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid) _created_at = db.Column(DateTime) _updated_at = db.Column(DateTime) _deleted = db.Column(Boolean, default=False) _deleted_at = db.Column(DateTime)
class TodoSchedule(CommonModel): id = db.Column(Integer, primary_key=True) __tablename__ = 'todoschedule' start_time_working = db.Column(DateTime) end_time_working = db.Column(DateTime) todoscheduledetail = db.relationship("TodoScheduleDetail", cascade="all, delete-orphan", lazy='dynamic')