class Pattern(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), unique=True, nullable=False)
description = db.Column(db.String(200), nullable=False)
price = db.Column(db.Float, unique=True, nullable=False)
room = db.relationship('Room', backref='pattern', lazy=True)
def __repr__(self):
return f"Padrão: {self.name}\nDescrição: {self.description}"
class Style(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
description = db.Column(db.String(200), nullable=False)
price = db.Column(db.Float, nullable=False)
room = db.relationship('Room', backref='style', lazy=True)
def __repr__(self):
return f"Tipo: {self.name}\nDescrição: {self.description}"
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey('employee.id'),
unique=True,
nullable=False)
def __repr__(self):
return f"Usuario('{self.id}, {self.username}')"
class Employee(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
email = db.Column(db.String(20), unique=True, nullable=False)
cpf = db.Column(db.String(11), unique=True, nullable=False)
role = db.Column(db.String(20), nullable=False)
rg = db.Column(db.String(14), unique=True, nullable=False)
birthdate = db.Column(db.Date, nullable=False)
phone = db.Column(db.String(11), nullable=False)
sex = db.Column(db.String(20), nullable=False)
address = db.Column(db.String(120), nullable=False)
username = db.relationship('User', backref='employee', lazy=True)
booking = db.relationship('Booking', backref='employee', lazy=True)
def __repr__(self):
return f"Funcionario('{self.id}', '{self.name}', '{self.cpf}','{self.email}')"
class Client(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
email = db.Column(db.String(20), unique=True, nullable=False)
cpf = db.Column(db.String(11), unique=True, nullable=False)
rg = db.Column(db.String(14), unique=True, nullable=False)
birthdate = db.Column(db.Date, nullable=False)
phone = db.Column(db.String(11), unique=True, nullable=False)
sex = db.Column(db.String(20), nullable=False, default='Não declarado')
address = db.Column(db.String(120), nullable=False)
booking = db.relationship('Booking', backref='client', lazy=True)
def __repr__(self):
return f"Cliente('{self.id}', '{self.name}', '{self.cpf}')"
class Products(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), unique=True, nullable=False)
price = db.Column(db.Float, unique=True, nullable=False)
booking = db.relationship('Booking_Products', backref='product', lazy=True)