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