Python Column Examples

Example #1

class Member(db.Model):
    __tablename__ = 'member'

    id = db.Column(db.Integer, primary_key=True)
    nickname = db.Column(db.String(100),
                         nullable=False,
                         server_default=db.FetchedValue())
    mobile = db.Column(db.String(11),
                       nullable=False,
                       server_default=db.FetchedValue())
    sex = db.Column(db.Integer,
                    nullable=False,
                    server_default=db.FetchedValue())
    avatar = db.Column(db.String(200),
                       nullable=False,
                       server_default=db.FetchedValue())
    salt = db.Column(db.String(32),
                     nullable=False,
                     server_default=db.FetchedValue())
    reg_ip = db.Column(db.String(100),
                       nullable=False,
                       server_default=db.FetchedValue())
    status = db.Column(db.Integer,
                       nullable=False,
                       server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())

Example #2

class Member(db.Model):
    __tablename__ = 'member'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20))
    loginname = db.Column(db.String(20))
    password = db.Column(db.String(16))

Example #3

class OauthAccessToken(db.Model):
    __tablename__ = 'oauth_access_token'

    id = db.Column(db.Integer, primary_key=True)
    access_token = db.Column(db.String(600), nullable=False, server_default=db.FetchedValue())
    expired_time = db.Column(db.DateTime, nullable=False, index=True, server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())

Example #4

File: Oauth_member_bind.py Project: HuYu211/finaltest

class OauthMemberBind(db.Model):
    __tablename__ = 'oauth_member_bind'
    __table_args__ = (db.Index('idx_type_openid', 'type', 'openid'), )

    id = db.Column(db.Integer, primary_key=True)
    member_id = db.Column(db.Integer,
                          nullable=False,
                          server_default=db.FetchedValue())
    client_type = db.Column(db.String(20),
                            nullable=False,
                            server_default=db.FetchedValue())
    type = db.Column(db.Integer,
                     nullable=False,
                     server_default=db.FetchedValue())
    openid = db.Column(db.String(80),
                       nullable=False,
                       server_default=db.FetchedValue())
    unionid = db.Column(db.String(100),
                        nullable=False,
                        server_default=db.FetchedValue())
    extra = db.Column(db.Text, nullable=False)
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())

Example #5

class Card(db.Model):
    __tablename__ = 'card'

    id = db.Column(db.Integer, primary_key=True)
    member_id = db.Column(db.Integer,
                          nullable=False,
                          server_default=db.FetchedValue())
    card_name = db.Column(db.String(30),
                          nullable=False,
                          server_default=db.FetchedValue())
    card_content = db.Column(db.String(1000),
                             nullable=False,
                             server_default=db.FetchedValue())
    study_status = db.Column(db.Integer,
                             nullable=False,
                             server_default=db.FetchedValue())
    status = db.Column(db.Integer,
                       nullable=False,
                       server_default=db.FetchedValue())
    last_time = db.Column(db.DateTime,
                          nullable=False,
                          server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    fromid = db.Column(db.String(50))

Example #6

File: notice.py Project: HuYu211/hjSecondhand_Flask

class Notice(db.Model):
    __tablename__ = 'notice'

    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer,
                        nullable=False,
                        server_default=db.FetchedValue())
    information = db.Column(db.String(1000),
                            nullable=False,
                            server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())

Example #7

class MemberCollection(db.Model):
    __tablename__ = 'member_collection'

    id = db.Column(db.Integer, primary_key=True)
    member_id = db.Column(db.Integer,
                          nullable=False,
                          server_default=db.FetchedValue())
    commodity_id = db.Column(db.Integer,
                             nullable=False,
                             server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())

Example #8

class LeavingWord(db.Model):
    __tablename__ = 'leaving_word'

    id = db.Column(db.Integer, primary_key=True)
    member_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
    commidity_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
    information = db.Column(db.String(10000), nullable=False, server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
    formid = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue())
    replyid = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())

Example #9

File: commodity_cat.py Project: HuYu211/hjSecondhand_Flask

class CommodityCat(db.Model):
    __tablename__ = 'commodity_cat'

    id = db.Column(db.Integer, primary_key=True, unique=True)
    name = db.Column(db.String(50),
                     nullable=False,
                     server_default=db.FetchedValue())
    weight = db.Column(db.Integer,
                       nullable=False,
                       server_default=db.FetchedValue())
    status = db.Column(db.Integer,
                       nullable=False,
                       server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())

Example #10

File: user.py Project: HuYu211/hjSecondhand_Flask

class User(db.Model):
    __tablename__ = 'user'

    id = db.Column(db.BigInteger, primary_key=True)
    nickname = db.Column(db.String(100),
                         nullable=False,
                         server_default=db.FetchedValue())
    mobile = db.Column(db.String(20),
                       nullable=False,
                       server_default=db.FetchedValue())
    email = db.Column(db.String(100),
                      nullable=False,
                      server_default=db.FetchedValue())
    sex = db.Column(db.Integer,
                    nullable=False,
                    server_default=db.FetchedValue())
    avatar = db.Column(db.String(64),
                       nullable=False,
                       server_default=db.FetchedValue())
    login_name = db.Column(db.String(20),
                           nullable=False,
                           unique=True,
                           server_default=db.FetchedValue())
    login_pwd = db.Column(db.String(32),
                          nullable=False,
                          server_default=db.FetchedValue())
    login_salt = db.Column(db.String(32),
                           nullable=False,
                           server_default=db.FetchedValue())
    status = db.Column(db.Integer,
                       nullable=False,
                       server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())

Example #11

File: commodity_information.py Project: HuYu211/hjSecondhand_Flask

class CommodityInformation(db.Model):
    __tablename__ = 'commodity_information'

    id = db.Column(db.Integer, primary_key=True)
    authorId = db.Column(db.Integer)
    name = db.Column(db.String(100),
                     nullable=False,
                     server_default=db.FetchedValue())
    price = db.Column(db.String(6),
                      nullable=False,
                      server_default=db.FetchedValue())
    image = db.Column(db.String(1000),
                      nullable=False,
                      server_default=db.FetchedValue())
    area_tab = db.Column(db.String(20),
                         nullable=False,
                         server_default=db.FetchedValue())
    summary = db.Column(db.String(10000),
                        nullable=False,
                        server_default=db.FetchedValue())
    tab = db.Column(db.String(20),
                    nullable=False,
                    server_default=db.FetchedValue())
    type = db.Column(db.String(50),
                     nullable=False,
                     server_default=db.FetchedValue())
    contacts = db.Column(db.String(2000),
                         nullable=False,
                         server_default=db.FetchedValue())
    qqnumber = db.Column(db.String(30),
                         nullable=False,
                         server_default=db.FetchedValue())
    phonenumber = db.Column(db.String(30),
                            nullable=False,
                            server_default=db.FetchedValue())
    status = db.Column(db.String(20),
                       nullable=False,
                       server_default=db.FetchedValue())
    view_count = db.Column(db.Integer,
                           nullable=False,
                           server_default=db.FetchedValue())
    release_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    created_time = db.Column(db.DateTime,
                             nullable=False,
                             server_default=db.FetchedValue())
    formid = db.Column(db.String(50),
                       nullable=False,
                       server_default=db.FetchedValue())
    last_count = db.Column(db.Integer,
                           nullable=False,
                           server_default=db.FetchedValue())