コード例 #1
0
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)
コード例 #2
0
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())