class Photo(db.Model): __tablename__ = 'Photo' photo_id = db.Column(db.Integer, primary_key=True) public_id = db.Column(db.VARCHAR) secure_url = db.Column(db.String) url = db.Column(db.String) def __init__(self, public_id='', secure_url='', url=''): self.public_id = public_id self.secure_url = secure_url self.url = url
class Attraction(db.Model): __tablename__ = 'attraction' attraction_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.VARCHAR) content = db.Column(db.VARCHAR) location = db.Column(db.VARCHAR) photo = db.Column(db.String) region_id = db.Column(db.Integer, db.ForeignKey('region.region_id')) destination_id = db.Column(db.Integer, db.ForeignKey('destination.destination_id'), nullable=True) write_id = db.Column(db.Integer, db.ForeignKey('write.write_id')) def __init__(self, name='', content='', location='', photo='', region_id='', destination_id='', write_id=''): self.name = name self.content = content self.location = location self.photo = photo self.region_id = region_id self.destination_id = destination_id self.write_id = write_id
class Region(db.Model): __tablename__ = 'region' region_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.VARCHAR) content = db.Column(db.VARCHAR) photo = db.Column(db.String) write_id = db.Column(db.Integer, db.ForeignKey('write.write_id')) destination = db.relationship('Destination', backref='destination_Region') attraction = db.relationship('Attraction', backref='attraction_Region') def __init__(self, name='', content='', photo='', write_id=''): self.name = name self.content = content self.photo = photo self.write_id = write_id
class Activitylogs(db.Model): __tablename__ = 'activitylogs' act_id = db.Column(db.Integer, primary_key=True) status = db.Column(db.VARCHAR) user_id = db.Column(db.Integer) client_id = db.Column(db.VARCHAR) role_id = db.Column(db.String(2)) date = db.Column(db.DateTime, default=datetime.datetime.now())
class Write(db.Model): __tablename__ = 'write' write_id = db.Column(db.Integer, primary_key=True) date = db.Column(db.DateTime, default=datetime.datetime.now()) author_id = db.Column(db.Integer, db.ForeignKey('user.id')) author_name = db.Column(db.VARCHAR) status = db.Column(db.VARCHAR) comment = db.Column(db.VARCHAR, nullable=True) region = db.relationship('Region', backref='region_Write') destination = db.relationship('Destination', backref='destination_Write') attraction = db.relationship('Attraction', backref='attraction_Write') def __init__(self, author_id='', author_name='', status=''): self.author_id = author_id self.author_name = author_name self.status = status
class Notifications(db.Model): __tablename__ = 'notifications' notification_id = db.Column(db.Integer, primary_key=True) status = db.Column(db.VARCHAR) write_id = db.Column(db.Integer) user_id = db.Column(db.Integer) last_open = db.Column(db.DateTime, nullable=True) editor_id = db.Column(db.Integer, nullable=True) date = db.Column(db.DateTime, default=datetime.datetime.now()) def __init__(self, status='', write_id='', user_id='', last_open='', editor_id=''): self.status = status self.write_id = write_id self.user_id = user_id self.last_open = last_open self.editor_id = editor_id
class User(db.Model): __tablename__ = 'user' id = db.Column(db.Integer(), primary_key=True) public_id = db.Column(db.String(50), unique=True) username = db.Column(db.String(32), unique=True, index=True) password_hash = db.Column(db.String(128)) firstname = db.Column(db.String(30)) middlename = db.Column(db.String(30)) lastname = db.Column(db.String(30)) age = db.Column(db.String(5)) contact = db.Column(db.String(15)) address = db.Column(db.TEXT()) birthday = db.Column(db.DATE) role_id = db.Column(db.String(2)) profile = db.Column(db.String(120)) write = db.relationship('Write', backref='write_User')