class Sitting(db.Model): __tablename__ = 'sitting' __table_args__ = {'schema': 'public'} sitting_id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) group_id = db.Column(db.ForeignKey('public.group.group_id'), nullable=False) session_id = db.Column(db.ForeignKey('public.session.session_id')) short_name = db.Column(db.String(512)) start_date = db.Column(db.DateTime, nullable=False) end_date = db.Column(db.DateTime, nullable=False) sitting_length = db.Column(db.Integer) recurring_id = db.Column(db.Integer) recurring_type = db.Column(db.String(32)) recurring_end_date = db.Column(db.DateTime) status = db.Column(db.String(48)) status_date = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) venue_id = db.Column(db.ForeignKey('public.venue.venue_id')) language = db.Column(db.String(5), nullable=False) activity_type = db.Column(db.String(1024)) meeting_type = db.Column(db.String(1024)) convocation_type = db.Column(db.String(1024)) cancel_reason = db.Column(db.String(1024)) group = db.relationship('Group', primaryjoin='Sitting.group_id == Group.group_id', backref='group_sittings') session = db.relationship('Session', primaryjoin='Sitting.session_id == Session.session_id', backref='session_sittings') venue = db.relationship('Venue', primaryjoin='Sitting.venue_id == Venue.venue_id', backref='venue_sittings')
class User(db.Model): __tablename__ = 'teacher_info' tea_id = db.Column(db.Integer, primary_key=True) tea_email = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) tea_name = db.Column(db.String(25), nullable=False, server_default=db.FetchedValue()) password = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) teacher_intro = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue())
class Usuario(db.Model): __tablename__ = 'usuario' id__usuario = db.Column(db.Integer, primary_key=True) id__tp_usuario = db.Column(db.ForeignKey('tipo_usuario.id__tipo_usuario'), nullable=False, index=True) nome = db.Column(db.String(100), nullable=False, unique=True) email = db.Column(db.String(100), nullable=False, unique=True) senha = db.Column(db.String(255), nullable=False) data_cadastro = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) data_atualizacao = db.Column(db.DateTime, server_default=db.FetchedValue()) tipo_usuario = db.relationship( 'TipoUsuario', primaryjoin='Usuario.id__tp_usuario == TipoUsuario.id__tipo_usuario', backref='usuarios') def hash_password(self): self.senha = generate_password_hash(self.senha).decode('utf8') def check_password(self, senha): return check_password_hash(self.senha, senha) def isAdmin(self): return self.tipo_usuario.nome == 'Admin'
class Doc(db.Model): __tablename__ = 'doc' __table_args__ = {'schema': 'public'} doc_id = db.Column(db.Integer, primary_key=True) parliament_id = db.Column(db.ForeignKey('public.parliament.parliament_id')) owner_id = db.Column(db.ForeignKey('public.user.user_id'), nullable=False) type = db.Column(db.String(128), nullable=False) doc_type = db.Column(db.String(128)) doc_procedure = db.Column(db.String(128)) type_number = db.Column(db.Integer) registry_number = db.Column(db.String(128)) uri = db.Column(db.String(1024)) acronym = db.Column(db.String(48)) title = db.Column(db.String(1024), nullable=False) description = db.Column(db.Text) language = db.Column(db.String(5), nullable=False) body = db.Column(db.Text) original_text = db.Column(db.Text) status = db.Column(db.String(48), index=True) status_date = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) group_id = db.Column(db.ForeignKey('public.group.group_id')) subject = db.Column(db.Text) coverage = db.Column(db.Text) geolocation = db.Column(db.Text) head_id = db.Column(db.ForeignKey('public.doc.doc_id')) timestamp = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) assignee_id = db.Column(db.Integer) sitting_id = db.Column(db.ForeignKey('public.sitting.sitting_id'), index=True) group = db.relationship('Group', primaryjoin='Doc.group_id == Group.group_id', backref='group_docs') head = db.relationship('Doc', remote_side=[doc_id], primaryjoin='Doc.head_id == Doc.doc_id', backref='docs') owner = db.relationship('User', primaryjoin='Doc.owner_id == User.user_id', backref='user_docs') parliament = db.relationship('Parliament', primaryjoin='Doc.parliament_id == Parliament.parliament_id', backref='parliament_docs') sitting = db.relationship('Sitting', primaryjoin='Doc.sitting_id == Sitting.sitting_id', backref='sitting_docs')
class Domain(db.Model): __tablename__ = 'domains' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False, unique=True) master = db.Column(db.String(128), server_default=db.FetchedValue()) last_check = db.Column(db.Integer, server_default=db.FetchedValue()) type = db.Column(db.String(6), nullable=False) notified_serial = db.Column(db.Integer, server_default=db.FetchedValue()) account = db.Column(db.String(40), server_default=db.FetchedValue())
class Chitietbaocaocongno(db.Model): __tablename__ = 'chitietbaocaocongno' MaBaoCao = db.Column(db.ForeignKey('baocaocongno.MaBaoCao'), primary_key=True, nullable=False) MaKhachHang = db.Column(db.ForeignKey('khachhang.MaKhachHang'), primary_key=True, nullable=False, index=True) SoTienNoDau = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) SoTienNoCuoi = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) baocaocongno = db.relationship('Baocaocongno', primaryjoin='Chitietbaocaocongno.MaBaoCao == Baocaocongno.MaBaoCao', backref='chitietbaocaocongnoes') khachhang = db.relationship('Khachhang', primaryjoin='Chitietbaocaocongno.MaKhachHang == Khachhang.MaKhachHang', backref='chitietbaocaocongnoes')
class Chitietbaocaoton(db.Model): __tablename__ = 'chitietbaocaoton' MaBaoCao = db.Column(db.ForeignKey('baocaoton.MaBaoCao'), primary_key=True, nullable=False) MaSach = db.Column(db.ForeignKey('sach.MaSach'), primary_key=True, nullable=False, index=True) SoLuongTonDau = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) SoLuongTonCuoi = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) baocaoton = db.relationship('Baocaoton', primaryjoin='Chitietbaocaoton.MaBaoCao == Baocaoton.MaBaoCao', backref='chitietbaocaotons') sach = db.relationship('Sach', primaryjoin='Chitietbaocaoton.MaSach == Sach.MaSach', backref='chitietbaocaotons')
class Chitiethoadon(db.Model): __tablename__ = 'chitiethoadon' MaHoaDon = db.Column(db.ForeignKey('hoadon.MaHoaDon'), primary_key=True, nullable=False) MaSach = db.Column(db.ForeignKey('sach.MaSach'), primary_key=True, nullable=False, index=True) SoLuong = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) DonGia = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) hoadon = db.relationship('Hoadon', primaryjoin='Chitiethoadon.MaHoaDon == Hoadon.MaHoaDon', backref='chitiethoadons') sach = db.relationship('Sach', primaryjoin='Chitiethoadon.MaSach == Sach.MaSach', backref='chitiethoadons')
class LoggedInUser(db.Model): __tablename__ = 'user_online' id = db.Column(db.Integer, primary_key=True, autoincrement=True) user_id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), nullable=False, index=True, server_default=db.FetchedValue()) created_time = db.Column(db.Date, nullable=False, server_default=db.FetchedValue())
class Hoadon(db.Model): __tablename__ = 'hoadon' MaHoaDon = db.Column(db.Integer, primary_key=True, autoincrement=True) MaKhachHang = db.Column(db.ForeignKey('khachhang.MaKhachHang'), nullable=False, index=True) NgayLap = db.Column(db.DateTime, nullable=False) TienTra = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) TongTien = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) DaLuu = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) khachhang = db.relationship('Khachhang', primaryjoin='Hoadon.MaKhachHang == Khachhang.MaKhachHang', backref='hoadons')
class Student(db.Model): __tablename__ = 'student_info' stu_id = db.Column(db.String(15), primary_key=True) credit = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) qresult = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) rec_result = db.Column(db.String(25), nullable=False, server_default=db.FetchedValue())
class Khachhang(db.Model): __tablename__ = 'khachhang' MaKhachHang = db.Column(db.Integer, primary_key=True, autoincrement=True) HoTen = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'), nullable=False) SoTienNo = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) DiaChi = db.Column(db.String(255, 'utf8mb4_0900_ai_ci')) DienThoai = db.Column(db.String(20), nullable=False) Email = db.Column(db.String(255)) BiXoa = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) def __str__(self): return self.HoTen
class MapTown(db.Model): __tablename__ = 'map_town' id = db.Column(db.Integer, primary_key=True) paikkakunta = db.Column(db.String(40), nullable=False, unique=True, server_default=db.FetchedValue()) maa_id = db.Column(db.Integer, nullable=False, index=True, server_default=db.FetchedValue()) lat = db.Column(db.String(50)) lon = db.Column(db.String(50))
class DnsForwarders(db.Model): __tablename__ = 'dns_forwarders_view' view_name = db.Column('view_name', db.String(45), primary_key=True) view_prio = db.Column('view_prio', db.Integer, server_default=db.FetchedValue(), primary_key=True) dm_zone = db.Column('dm_zone', db.String(255), primary_key=True) fwd_policy = db.Column('fwd_policy', db.String(45), server_default=db.FetchedValue()) ldns_name = db.Column('ldns_name', db.String(45), primary_key=True) ldns_addr = db.Column('ldns_addr', db.String(45), primary_key=True)
class Record(db.Model): __tablename__ = 'records' __table_args__ = (db.Index('nametype_index', 'name', 'type'), ) id = db.Column(db.Integer, primary_key=True) domain_id = db.Column(db.ForeignKey('domains.id', ondelete='CASCADE', onupdate='CASCADE'), index=True, server_default=db.FetchedValue()) name = db.Column(db.String(255), index=True, server_default=db.FetchedValue()) type = db.Column(db.String(10), server_default=db.FetchedValue()) content = db.Column(db.String(65535), server_default=db.FetchedValue()) ttl = db.Column(db.Integer, server_default=db.FetchedValue()) prio = db.Column(db.Integer, server_default=db.FetchedValue()) disabled = db.Column(db.Boolean, server_default=db.FetchedValue()) ordername = db.Column(db.String(255), index=True) auth = db.Column(db.Boolean, server_default=db.FetchedValue()) domain = db.relationship( 'Domain', primaryjoin='Record.domain_id == Domain.id', backref='records', )
class DnsForwardIpnetGrp(db.Model): __tablename__ = 'dns_forward_ipnet_grp' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(45), nullable=False, unique=True) prio = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) enabled = db.Column(db.Boolean(), nullable=False, server_default=db.FetchedValue()) def __repr__(self): return self.name
class Paciente(db.Model): __tablename__ = 'paciente' id__paciente = db.Column(db.BigInteger, primary_key=True) encaminhado_por = db.Column(db.String(100)) nome = db.Column(db.String(100)) nr_sus = db.Column(db.String(50)) sexo = db.Column(db.String(1)) dt_nasc = db.Column(db.Date) cor = db.Column(db.String(1)) nm_mae = db.Column(db.String(100)) nm_pai = db.Column(db.String(100)) cep_residencia = db.Column(db.String(8)) logradouro_residencia = db.Column(db.String(100)) bairro_residencia = db.Column(db.String(50)) numero_residencia = db.Column(db.String(50)) cidade_residencia = db.Column(db.String(100)) cep_trabalho = db.Column(db.String(8)) logradouro_trabalho = db.Column(db.String(100)) bairro_trabalho = db.Column(db.String(50)) numero_trabalho = db.Column(db.String(50)) cidade_trabalho = db.Column(db.String(100)) email = db.Column(db.String(50)) nr_telefone_1 = db.Column(db.String(11)) nr_telefone_2 = db.Column(db.String(11)) profissao = db.Column(db.String(50)) nmContato = db.Column(db.String(100)) nr_contato = db.Column(db.String(11)) obs_contato = db.Column(db.String) obs_gerais = db.Column(db.String) data_cadastro = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) naturalidade = db.Column(db.String(100)) nacionalidade = db.Column(db.String(100)) procedencia = db.Column(db.String(1)) ocupacao = db.Column(db.String(100)) data_atualizacao = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) estado_civil = db.Column(db.String(2)) nome_responsavel = db.Column(db.String(100)) parentesco_responsavel = db.Column(db.String(50)) relacionamento_contato = db.Column(db.String(50)) cep_contato = db.Column(db.String(8)) logradouro_contato = db.Column(db.String(100)) bairro_contato = db.Column(db.String(50)) numero_contato = db.Column(db.String(50)) cidade_contato = db.Column(db.String(100))
class PCourse(db.Model): __tablename__ = 'percourse_info' pcourse_id = db.Column(db.Integer, primary_key=True) vedio_url = db.Column(db.String(60), nullable=False, server_default=db.FetchedValue()) pcourse_intro = db.Column(db.String(500), nullable=False, server_default=db.FetchedValue()) pcourse_imgurl = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) pcourse_title = db.Column(db.String(250), nullable=False, server_default=db.FetchedValue())
class Sach(db.Model): __tablename__ = 'sach' MaSach = db.Column(db.Integer, primary_key=True, autoincrement=True) TenSach = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'), nullable=False) AnhBia = db.Column(db.String(255)) SoLuongTon = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) DonGia = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) BiXoa = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) tacgia = db.relationship('Tacgia', secondary='chitiettacgiasach', backref='saches') theloai = db.relationship('Theloai', secondary='chitiettheloaisach', backref='saches') def __str__(self): return self.TenSach
class Ldns(db.Model): __tablename__ = 'ldns' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(45), nullable=False, unique=True) addr = db.Column(db.String(45), nullable=False, unique=True) enabled = db.Column(db.Boolean(), nullable=False, server_default=db.FetchedValue()) status = db.Column(db.Boolean(), nullable=False, server_default=db.FetchedValue()) def __repr__(self): return self.name + "-" + self.addr
class Rol(db.Model): __tablename__ = 'rols' id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) name = db.Column(db.String(100), unique=True)
class VulnerabilityNotification(db.Model): __tablename__ = 'vulnerability_notification' id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) name = db.Column(db.String(64), nullable=False, unique=True) created_at = db.Column(db.DateTime(True)) notified_at = db.Column(db.DateTime(True), index=True) deleted_at = db.Column(db.DateTime(True), index=True) old_vulnerability_id = db.Column( db.ForeignKey(u'vulnerability.id', ondelete=u'CASCADE')) new_vulnerability_id = db.Column( db.ForeignKey(u'vulnerability.id', ondelete=u'CASCADE')) new_vulnerability = db.relationship( u'Vulnerability', primaryjoin= 'VulnerabilityNotification.new_vulnerability_id == Vulnerability.id', backref=u'vulnerability_vulnerability_notifications') old_vulnerability = db.relationship( u'Vulnerability', primaryjoin= 'VulnerabilityNotification.old_vulnerability_id == Vulnerability.id', backref=u'vulnerability_vulnerability_notifications_0')
class Layer(db.Model): __tablename__ = 'layer' id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) name = db.Column(db.String(128), nullable=False, unique=True) engineversion = db.Column(db.SmallInteger, nullable=False) parent_id = db.Column(db.ForeignKey(u'layer.id', ondelete=u'CASCADE'), index=True) namespace_id = db.Column(db.ForeignKey(u'namespace.id'), index=True) created_at = db.Column(db.DateTime(True)) manifest = db.Column(db.JSON) manifest_v1 = db.Column(db.JSON) parent_name = db.Column(db.String(128)) namespace = db.relationship( u'Namespace', primaryjoin='Layer.namespace_id == Namespace.id', backref=u'layers') parent = db.relationship(u'Layer', remote_side=[id], primaryjoin='Layer.parent_id == Layer.id', backref=u'layers') def get_feature_installed(self): return Featureversion.query.join(\ LayerDiffFeatureversion, \ (Featureversion.id == LayerDiffFeatureversion.featureversion_id) & \ (LayerDiffFeatureversion.layer_id==self.id))
class VulnerabilityFixedinFeature(db.Model): __tablename__ = 'vulnerability_fixedin_feature' __table_args__ = ( db.UniqueConstraint('vulnerability_id', 'feature_id'), db.Index( 'vulnerability_fixedin_feature_feature_id_vulnerability_id_idx', 'feature_id', 'vulnerability_id')) id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) vulnerability_id = db.Column(db.ForeignKey(u'vulnerability.id', ondelete=u'CASCADE'), nullable=False) feature_id = db.Column(db.ForeignKey(u'feature.id'), nullable=False) version = db.Column(db.String(128), nullable=False) feature = db.relationship( u'Feature', primaryjoin='VulnerabilityFixedinFeature.feature_id == Feature.id', backref=u'vulnerability_fixedin_features') vulnerability = db.relationship( u'Vulnerability', primaryjoin= 'VulnerabilityFixedinFeature.vulnerability_id == Vulnerability.id', backref=u'vulnerability_fixedin_features')
class Vulnerability(db.Model): __tablename__ = 'vulnerability' __table_args__ = (db.Index('vulnerability_namespace_id_name_idx', 'namespace_id', 'name'), ) id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) namespace_id = db.Column(db.ForeignKey(u'namespace.id'), nullable=False) name = db.Column(db.String(128), nullable=False, index=True) description = db.Column(db.Text) link = db.Column(db.String(128)) severity = db.Column(ENUM(u'Unknown', u'Negligible', u'Low', u'Medium', u'High', u'Critical', u'Defcon1', name='severity'), nullable=False) metadata2 = db.Column(db.Text, name="metadata") created_at = db.Column(db.DateTime(True)) deleted_at = db.Column(db.DateTime(True)) namespace = db.relationship( u'Namespace', primaryjoin='Vulnerability.namespace_id == Namespace.id', backref=u'vulnerabilities')
class PwdRecover(db.Model): __tablename__ = 'pwdrecover' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(255), nullable=False) email = db.Column(db.String(255), nullable=False) token = db.Column(db.String(255), nullable=False) create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
class LayerDiffFeatureversion(db.Model): __tablename__ = 'layer_diff_featureversion' __table_args__ = ( db.UniqueConstraint('layer_id', 'featureversion_id'), db.Index('layer_diff_featureversion_layer_id_modification_idx', 'layer_id', 'modification'), db.Index('layer_diff_featureversion_featureversion_id_layer_id_idx', 'featureversion_id', 'layer_id')) id = db.Column(db.Integer, primary_key=True, server_default=db.FetchedValue()) layer_id = db.Column(db.ForeignKey(u'layer.id', ondelete=u'CASCADE'), nullable=False, index=True) featureversion_id = db.Column(db.ForeignKey(u'featureversion.id'), nullable=False, index=True) modification = db.Column(ENUM(u'add', u'del', name='modification'), nullable=False) featureversion = db.relationship( u'Featureversion', primaryjoin= 'LayerDiffFeatureversion.featureversion_id == Featureversion.id', backref=u'layer_diff_featureversions') layer = db.relationship( u'Layer', primaryjoin='LayerDiffFeatureversion.layer_id == Layer.id', backref=u'layer_diff_featureversions') def __repr__(self): return '<Layer_id {} featureversion_id {} >'.format( self.featureversion_id, self.layer_id)
class CovidAnamnese(db.Model): __tablename__ = 'covid_anamnese' id__covid_anamnese = db.Column(db.Integer, primary_key=True) nome_paciente = db.Column(db.String(100)) data_nasc_paciente = db.Column(db.Date) e_paciente = db.Column(db.Integer) id__usuario = db.Column(db.ForeignKey('usuario.id__usuario'), index=True) diag_covid = db.Column(db.Integer, nullable=False) febre = db.Column(db.Integer, nullable=False) prob_resp = db.Column(db.Integer, nullable=False) viagem = db.Column(db.Integer, nullable=False) contato_infect = db.Column(db.Integer, nullable=False) contato_sintomas = db.Column(db.Integer, nullable=False) part_reuniao = db.Column(db.Integer, nullable=False) prob_card_resp = db.Column(db.Integer, nullable=False) prob_outro = db.Column(db.Integer, nullable=False) usa_medic = db.Column(db.Integer, nullable=False) medic_desc = db.Column(db.Text) temperatura = db.Column(db.Numeric(2, 2), nullable=False) obs = db.Column(db.String) data_cadastro = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) data_atualizacao = db.Column(db.DateTime) assinatura = db.Column(db.String) usuario = db.relationship( 'Usuario', primaryjoin='CovidAnamnese.id__usuario == Usuario.id__usuario', backref='covid_anamnese')
class Uploads(db.Model): __tablename__ = 'uploads' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(255), nullable=False) create_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) path = db.Column(db.String(255), nullable=False)
class TipoUsuario(db.Model): __tablename__ = 'tipo_usuario' id__tipo_usuario = db.Column(db.Integer, primary_key=True) nome = db.Column(db.String(100), nullable=False, unique=True) data_cadastro = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())