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 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