class Zone(db.Model):
__tablename__ = 'dns_zones'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), index=True)
is_inner = db.Column(db.Integer)
z_type = db.Column(db.String(64))
views = db.Column(db.String(64))
forwarders = db.Column(db.String(64))
records = db.relationship('Record', backref='zone', lazy='dynamic')
view_id = db.Column(db.Integer, db.ForeignKey('dns_views.id'))
class Record(db.Model):
__tablename__ = 'dns_records'
id = db.Column(db.Integer, primary_key=True)
record_id = db.Column(db.String(64), index=True)
host = db.Column(db.String(64))
record_type = db.Column(db.String(64))
TTL = db.Column(db.String(64))
value = db.Column(db.String(64))
line_type = db.Column(db.String(64), default='')
comment = db.Column(db.String(64))
creator = db.Column(db.String(64))
updator = db.Column(db.String(64))
status = db.Column(db.String(64), default='enabled')
enabled = db.Column(db.String(64), default='1')
alive = db.Column(db.String(64), default='ON')
create_time = db.Column(db.DateTime(), default=datetime.now)
update_time = db.Column(db.DateTime(), default=datetime.now)
zone_id = db.Column(db.Integer, db.ForeignKey('dns_zones.id'))