class Base(db.Model): __abstract__ = True id = db.Column(db.Integer, primary_key=True) created_date = db.Column(db.DateTime(), default=datetime.now()) modified_date = db.Column(db.DateTime(), default=datetime.now(), onupdate=datetime.now()) is_deleted = db.Column(db.Boolean(), default=False)
class Person(Base): __tablename__ = 'people' id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(50)) middle_name = db.Column(db.String(50),nullable=True) last_name = db.Column(db.String(50)) email_address = db.Column(db.String(50)) phone_number = db.Column(db.String(20)) gender = db.Column('gender', Enum(GenderType)) date_of_birth = db.Column(db.DateTime(), default=datetime.now())