class clinica(db.Model):
Cli_ID = db.Column(db.Integer, primary_key = True)
Cli_AdmCli_ID = db.Column(db.Integer, db.ForeignKey('adm_clinica.AdmCli_ID'))
Cli_CNPJ = db.Column(db.VARCHAR(14), unique=True, nullable=False)
Cli_Nome = db.Column(db.VARCHAR(50), unique=False, nullable=False)
Cli_Endereco = db.Column(db.Text, unique=False, nullable=False)
Cli_Telefone = db.Column(db.VARCHAR(30), unique=False, nullable=False)
Cli_Prazo_Cancelamento = db.Column(db.Integer, unique=False, nullable=False)
Cli_Taxa_Deslocamento = db.Column(db.Float, unique=False, nullable=False)
adm_clinica = db.relationship('adm_clinica', backref=db.backref('clinica', lazy=True))
class agenda_medica(db.Model):
__tablename__ = "agenda_medica"
AgdMed_ID = db.Column(db.Integer, primary_key=True, autoincrement=True)
AgdMed_Marcado = db.Column(db.Integer, unique=False, nullable=False)
AgdMed_Dia = db.Column(db.VARCHAR(20), unique=False, nullable=False)
AgdMed_Hora_Inicio = db.Column(db.VARCHAR(10),
unique=False,
nullable=False)
AgdMed_Duracao = db.Column(db.VARCHAR(10), unique=False, nullable=False)
AgdMed_Med_ID = db.Column(db.Integer,
db.ForeignKey('medico.Med_ID'),
primary_key=True)
class medico(db.Model):
__tablename__ = "medico"
Med_ID = db.Column(db.Integer, primary_key=True)
Med_Nome = db.Column(db.VARCHAR(50), unique=False, nullable=False)
Med_CRM = db.Column(db.VARCHAR(7), unique=True, nullable=False)
Med_Email = db.Column(db.VARCHAR(255), unique=False, nullable=False)
Med_Telefone = db.Column(db.VARCHAR(255), unique=False, nullable=False)
Med_Especialidade = db.Column(db.VARCHAR(50), unique=False, nullable=False)
consultas = db.relationship('consulta', backref='medico', lazy='dynamic')
horarios = db.relationship('agenda_medica',
backref='medico',
lazy='dynamic')
class consulta(db.Model):
__tablename__ = "consulta"
Cons_ID = db.Column(db.Integer, primary_key=True, autoincrement=True)
Cons_Pct_ID = db.Column(db.Integer)
Cons_Med_ID = db.Column(db.Integer)
Cons_Horario = db.Column(db.Time(6))
Cons_Data = db.Column(db.Date)
Cons_Descricao = db.Column(db.Text(255))
Cons_Pagamento = db.Column(db.VARCHAR(20))
Cons_Tipo = db.Column(db.VARCHAR(10))
Cons_Status = db.Column(db.VARCHAR(50))
Cons_Pct_ID = db.Column(db.Integer,
db.ForeignKey('paciente.Pct_ID'),
primary_key=True)
Cons_Med_ID = db.Column(db.Integer,
db.ForeignKey('medico.Med_ID'),
primary_key=True)
class politica_agendamento(db.Model):
__tablename__ = "politica_agendamento"
PltAgd_ID = db.Column(db.Integer, primary_key=True, autoincrement=True)
PltAgd_Turno_Regular = db.Column(db.VARCHAR(50),
unique=False,
nullable=False)
PltAgd_Turno_Grupo_Risco = db.Column(db.VARCHAR(50),
unique=False,
nullable=False)
PltAgd_Capacidade_Regular = db.Column(db.Integer,
unique=False,
nullable=False)
PltAgd_Capacidade_Grupo_Risco = db.Column(db.Integer,
unique=False,
nullable=False)
PltAgd_Protocolos_Regular = db.Column(db.Text,
unique=False,
nullable=False)
PltAgd_Protocolos_Grupo_Risco = db.Column(db.Text,
unique=False,
nullable=False)
class paciente(db.Model):
__tablename__ = "paciente"
Pct_ID = db.Column(db.Integer, primary_key=True)
Pct_Nome = db.Column(db.VARCHAR(50), unique=False, nullable=False)
Pct_Rg = db.Column(db.VARCHAR(20), unique=False, nullable=True)
Pct_CPF = db.Column(db.VARCHAR(11), unique=True, nullable=False)
Pct_Endereco = db.Column(db.VARCHAR(255), unique=False, nullable=True)
Pct_Email = db.Column(db.VARCHAR(50), unique=True, nullable=False)
Pct_Telefone = db.Column(db.VARCHAR(30), unique=False, nullable=False)
Pct_Senha = db.Column(db.VARCHAR(15), unique=False, nullable=False)
Pct_Grupo_Risco = db.Column(db.VARCHAR(50), unique=False, nullable=False)
consultas = db.relationship('consulta', backref='paciente', lazy='dynamic')
def as_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class adm_clinica(db.Model):
AdmCli_ID = db.Column(db.Integer, primary_key=True)
AdmCli_Senha = db.Column(db.VARCHAR(15), unique=False, nullable=False)
AdmCli_Nome = db.Column(db.VARCHAR(255), unique=False, nullable=False)
AdmCli_Telefone = db.Column(db.VARCHAR(255), unique=False, nullable=False)
AdmCli_Email = db.Column(db.VARCHAR(50), unique=True, nullable=False)
class adm_sistema(db.Model):
AdmSis_ID = db.Column(db.Integer, primary_key=True)
AdmSis_email = db.Column(db.VARCHAR(255), unique=True, nullable=False)
AdmSis_Senha = db.Column(db.VARCHAR(15), unique=True, nullable=False)
class atendente(db.Model):
Atd_ID = db.Column(db.Integer, primary_key=True)
Atd_Nome = db.Column(db.VARCHAR(255), unique=False, nullable=False)
Atd_Email = db.Column(db.VARCHAR(255), unique=True, nullable=False)
Atd_Telefone = db.Column(db.VARCHAR(255), unique=False, nullable=False)
Atd_Senha = db.Column(db.VARCHAR(15), unique=True, nullable=False)