Python Column Examples

Example #1

File: model.py Project: zxhpy1234/homekit

class Reads(db.Model):
    """
    已读表
    """
    id = db.Column(db.Integer, primary_key=True)
    newsId = db.Column(db.Integer, nullable=True)
    belongUserId = db.Column(db.Integer, nullable=True)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<News %r>' % self.id

Example #2

File: model.py Project: zxhpy1234/homekit

class Group(db.Model):
    """
    分组表
    """
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    avatar = db.Column(db.String(256), nullable=True)
    desc = db.Column(db.String(256), nullable=False)
    belongUserId = db.Column(db.Integer, nullable=True)
    isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
    checkCode = db.Column(db.String(4), nullable=True)
    isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<Group %r>' % self.name

Example #3

File: model.py Project: zxhpy1234/homekit

class Marks(db.Model):
    """
    标记表
    """
    id = db.Column(db.Integer, primary_key=True)
    belongUserId = db.Column(db.Integer, nullable=True)
    belongGroupId = db.Column(db.Integer, nullable=True)
    spaceId = db.Column(db.Integer, nullable=True)
    positionId = db.Column(db.Integer, nullable=True)
    goodsId = db.Column(db.Integer, nullable=True)
    isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
    isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<Marks %r>' % self.id

Example #4

File: model.py Project: zxhpy1234/homekit

class GroupUser(db.Model):
    """
    用户分组关联表
    """
    id = db.Column(db.Integer, primary_key=True)
    userId = db.Column(db.Integer, nullable=False)
    groupId = db.Column(db.Integer, nullable=False)
    isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
    isAudit = db.Column(db.SmallInteger, default=0, nullable=False)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<GroupUser %r>' % self.id

Example #5

File: model.py Project: zxhpy1234/homekit

class Position(db.Model):
    """
    位置表
    """
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    avatar = db.Column(db.String(256), nullable=True)
    belongUserId = db.Column(db.Integer, nullable=True)
    belongGroupId = db.Column(db.Integer, nullable=True)
    spaceId = db.Column(db.Integer, nullable=True)
    isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
    coordinate = db.Column(db.String(256), nullable=True)
    isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<Group %r>' % self.name

Example #6

File: model.py Project: zxhpy1234/homekit

class News(db.Model):
    """
    动态表
    """
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    content = db.Column(db.String(1024), nullable=False)
    type = db.Column(db.Integer, nullable=False)
    belongUserId = db.Column(db.Integer, nullable=True)
    belongGroupId = db.Column(db.Integer, nullable=True)
    spaceId = db.Column(db.Integer, nullable=True)
    positionId = db.Column(db.Integer, nullable=True)
    avatar = db.Column(db.String(80), nullable=False)
    goodsId = db.Column(db.Integer, nullable=True)
    isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
    isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<News %r>' % self.id

Example #7

File: model.py Project: zxhpy1234/homekit

class User(db.Model):
    """
    用户表
    """
    id = db.Column(db.Integer, primary_key=True)
    firstName = db.Column(db.String(80), nullable=True)
    lastName = db.Column(db.String(80), nullable=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    checkCode = db.Column(db.String(4), nullable=True)
    password = db.Column(db.String(256), nullable=True)
    defaultGroupId = db.Column(db.Integer, nullable=True)
    avatar = db.Column(db.String(256), nullable=True)
    sessionToken = db.Column(db.String(256), nullable=True)
    isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
    createdAt = db.Column(db.DateTime, nullable=True)
    updatedAt = db.Column(db.DateTime, nullable=True)

    def __repr__(self):
        return '<User %r>' % self.username