22 lines
1.1 KiB
Python
22 lines
1.1 KiB
Python
from extensions import db
|
|
|
|
class Address(db.Model):
|
|
__tablename__ = "address"
|
|
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
street = db.Column(db.String(255), nullable=False) # Rua
|
|
number = db.Column(db.String(20), nullable=True) # Número
|
|
complement = db.Column(db.String(255), nullable=True) # Complemento
|
|
neighborhood = db.Column(db.String(100), nullable=False) # Bairro
|
|
city = db.Column(db.String(100), nullable=False) # Cidade
|
|
state = db.Column(db.String(100), nullable=False) # Estado
|
|
zip_code = db.Column(db.String(20), nullable=False) # CEP
|
|
country = db.Column(db.String(100), nullable=False) # País
|
|
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) # Relacionamento com o usuário
|
|
address_type_id = db.Column(db.Integer, db.ForeignKey('address_type.id'), nullable=True) # Tipo de endereço
|
|
|
|
address_type = db.relationship('AddressType', backref='addresses') # Relacionamento com AddressType
|
|
|
|
def __repr__(self):
|
|
return f"<Address {self.street}, {self.city}, Type: {self.address_type.name}>"
|