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)