class Vinculo(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(120), nullable=False)
professor = db.relationship('Professor', backref='vinculo', lazy=True)
def __init__(self, nome):
self.nome = nome
def __repr__(self):
return '<Vinculo %r>' % self.id
class Sala(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(120), nullable=False)
capacidade = db.Column(db.Integer, nullable=True)
def __init__(self, nome, capacidade):
self.nome = nome
self.capacidade = capacidade
def __repr__(self):
return '<Sala %r>' % self.id
class Disciplina(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(120), nullable=False)
numero = db.Column(db.Integer, nullable=True)
sigla = db.Column(db.String(10), nullable=True)
turma = db.relationship('Turma', backref='disciplina', lazy=True)
def __init__(self, nome, numero, sigla):
self.nome = nome
self.numero = numero
self.sigla = sigla
def __repr__(self):
return '<Disciplina %r>' % self.id
class Turma(db.Model):
id = db.Column(db.Integer, primary_key=True)
id_disciplina = db.Column(db.Integer, db.ForeignKey('disciplina.id'))
id_departamento = db.Column(db.Integer, db.ForeignKey('departamento.id'))
codigo = db.Column(db.String(10), nullable=True)
numero = db.Column(db.Integer, nullable=True)
def __init__(self, id_disciplina, id_departamento, numero, codigo=''):
self.id_disciplina = id_disciplina
self.id_departamento = id_departamento
self.numero = numero
self.codigo = codigo
def __repr__(self):
return '<Turma %r>' % self.id
class Departamento(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(120), nullable=False)
sigla = db.Column(db.String(10), nullable=True)
codigo = db.Column(db.String(5), nullable=True)
professor = db.relationship('Professor', backref='departamento', lazy=True)
#turma = db.relationship('Turma', backref='departamento', lazy=True)
def __init__(self, nome, sigla, codigo):
self.nome = nome
self.sigla = sigla
self.codigo = codigo
def __repr__(self):
return '<Departamento %r>' % self.id
class Professor(db.Model):
id = db.Column(db.Integer, primary_key=True)
siape = db.Column(db.Integer, nullable=True)
nome = db.Column(db.String(120), nullable=False)
email = db.Column(db.String(120), nullable=True)
telefone = db.Column(db.String(15), nullable=True)
ramal = db.Column(db.String(15), nullable=True)
id_departamento = db.Column(db.Integer, db.ForeignKey('departamento.id'))
id_vinculo = db.Column(db.Integer, db.ForeignKey('vinculo.id'))
def __init__(self, siape, nome, email, telefone, ramal, id_departamento,
id_vinculo):
self.siape = siape
self.nome = nome
self.email = email
self.telefone = telefone
self.ramal = ramal
self.id_departamento = id_departamento
self.id_vinculo = id_vinculo
def __repr__(self):
return '<Professor %r>' % self.id
class Curso(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(120), nullable=False)
sigla = db.Column(db.String(10), nullable=True)
numero = db.Column(db.String(15), nullable=True)
responsavel = db.Column(db.String(120), nullable=True)
email_responsavel = db.Column(db.String(120), nullable=True)
def __init__(self, nome, sigla, numero, responsavel, email_responsavel):
self.nome = nome
self.sigla = sigla
self.numero = numero
self.responsavel = responsavel
self.email_responsavel = email_responsavel
def __repr__(self):
return '<Curso %r>' % self.id