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())
