class Aluno(db.Model): id_alun = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(120), nullable=False) nome = db.Column(db.String(120), nullable=False) telefone = db.Column(db.Integer, nullable=False) endereco = db.Column(db.String(120), nullable=False) cpf = db.Column(db.Integer, unique=True, nullable=False) def __init__(self, username, email, password, nome, telefone, endereco, cpf): self.username = username self.email = email self.password = password self.nome = nome self.telefone = telefone self.endereco = endereco self.cpf = cpf func_id = db.Column(db.Integer, db.ForeignKey('funcionario.id_func')) funcionario = db.relationship('Funcionario', backref='user_func') def __repr__(self): return '<Funcionario %r %r %r %r %r %r %r >' % ( self.username, self.email, self.password, self.nome, self.telefone, self.endereco, self.cpf)
class Funcionario(db.Model): id_func = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(120), nullable=False) def __init__(self, username, email, password): self.username = username self.email = email self.password = password def __repr__(self): return '<Funcionario %r %r %r>' % (self.username, self.email, self.password)
class Professores(db.Model): id_prof = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(120), nullable=False) def __init__(self, username, email, password): self.username = username self.email = email self.password = password def __repr__(self): return '<Funcionario %r %r %r>' % (self.username, self.email, self.password) disciplina_id = db.Column(db.Integer, db.ForeignKey('disciplina.id_disc')) disciplian = db.relationship('Disciplina', backref='user_disc')
class Curso(db.Model): id_curs = db.Column(db.Integer, primary_key=True) codigo = db.Column(db.String(8), unique=True, nullable=False) nome_curso = db.Column(db.String(120), unique=True, nullable=False) qtnd_semestres = db.Column(db.Integer, nullable=False) def __init__(self, codigo, nome_curso, qtnd_semestres): self.codigo = codigo self.nome_curso = nome_curso self.qtnd_semestres = qtnd_semestres aluno_id = db.Column(db.Integer, db.ForeignKey('aluno.id_alun')) aluno = db.relationship('Aluno', backref='user_alun') def __repr__(self): return '<Curso %r %r %r>' % (self.codigo, self.nome_curso, self.qtnd_semestres)
class Acesso(db.Model): id_acess = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(120), nullable=False) def __init__(self, username, email, password): self.username = username self.email = email self.password = password def __repr__(self): return '<Funcionario %r %r %r>' % (self.username, self.email, self.password) id_professor = db.Column(db.Integer, db.ForeignKey('professores.id_prof')) Profesores = db.relationship('Professores', backref='user_prof')
class Disciplina(db.Model): id_disc = db.Column(db.Integer, primary_key=True) codigo = db.Column(db.String(8), unique=True, nullable=False) nome_disc = db.Column(db.String(120), nullable=False) nota1_semes = db.Column(db.Float, nullable=False) nota2_semes = db.Column(db.Float, nullable=False) def __init__(self, codigo, nome_disc, nota1_semes, nota2_semes): self.codigo = codigo self.nome_disc = nome_disc self.nota1_semes = nota1_semes self.nota2_semes = nota2_semes curso_id = db.Column(db.Integer, db.ForeignKey('curso.id_curs')) curso = db.relationship('Curso', backref='user_curs') def __repr__(self): return '<Disciplina %r %r %r %r>' % ( self.codigo, self.nome_disc, self.nota1_semes, self.nota2_semes)