Python Column 예제들

예제 #1

파일: userModel.py 프로젝트: sajinchang/flask_tpp

class User(db.Model):
    u_id = db.Column(db.Integer, autoincrement=True, primary_key=True)
    u_name = db.Column(db.String(32), unique=True)
    u_passwd = db.Column(db.String(256), nullable=False)
    active = db.Column(db.Boolean, default=0)
    # 权限
    permission = db.Column(db.Integer)
    token = db.Column(db.String(128), unique=True)
    email = db.Column(db.String(64))

예제 #2

파일: letter_citiesModel.py 프로젝트: sandy183/flask_tpp

class Cities(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=False)
    parentId = db.Column(db.Integer, default=0)
    regionName = db.Column(db.String(32))
    cityCode = db.Column(db.Integer)
    pinYin = db.Column(db.String(32))
    letter_id = db.Column(db.Integer, db.ForeignKey(Letter.id))

예제 #3

class Orders(db.Model, Settings):
    id = db.Column(db.String(128), primary_key=True, autoincrement=False)
    total_price = db.Column(db.Float)
    user_id = db.Column(db.Integer, db.ForeignKey(User.u_id))
    movie_id = db.Column(db.Integer, db.ForeignKey(Movies.id))
    # order_time = db.Column(db.DateTime)
    pay_time = db.Column(db.DateTime)
    seat_num = db.Column(db.Integer)

예제 #4

class Cinemas(db.Model, Settings):

    id = db.Column(db.Integer, autoincrement=True, primary_key=True)
    name = db.Column(db.String(64))
    city = db.Column(db.String(32))
    district = db.Column(db.String(32))
    address = db.Column(db.String(128))
    phone = db.Column(db.String(32))
    score = db.Column(db.Float)
    hallnum = db.Column(db.Integer)
    servicecharge = db.Column(db.Float)
    astrict = db.Column(db.Integer)
    flag = db.Column(db.Integer)
    isdelete = db.Column(db.Boolean)

예제 #5

파일: letter_citiesModel.py 프로젝트: sandy183/flask_tpp

class Letter(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    letter = db.Column(db.String(2))

예제 #6

파일: movieModel.py 프로젝트: sandy183/flask_tpp

class Movies(db.Model,Settings):
    id = db.Column(db.Integer,primary_key=True,autoincrement=False)
    showname = db.Column(db.String(128))
    shownameen = db.Column(db.String(128))
    director = db.Column(db.String(64))
    leadingRole = db.Column(db.String(256))
    type = db.Column(db.String(64))
    country = db.Column(db.String(64))
    language = db.Column(db.String(64))
    duration = db.Column(db.Integer)
    screeningmodel = db.Column(db.String(32))
    openday = db.Column(db.Date)
    backgroundpicture = db.Column(db.String(64))
    flag = db.Column(db.Integer)
    isdelete = db.Column(db.Boolean)