Python Column 예제들

예제 #1

파일: model_forest.py 프로젝트: SS-TIMER/Forest_park

class Forest_park(model.Model):
    num = model.Column(model.Integer, primary_key=True)
    Province = model.Column(model.Text)
    manager = model.Column(model.Text)
    name = model.Column(model.Text)
    name_short = model.Column(model.Text)
    time = model.Column(model.String)
    area_ha = model.Column(model.String)
    county = model.Column(model.Text)
    bd_lon = model.Column(model.String)
    bd_lat = model.Column(model.String)
    lon = model.Column(model.String)
    lat = model.Column(model.String)

예제 #2

파일: models.py 프로젝트: yuansuixin/learn-flask-city

class Provice(model.Model):
    pid = model.Column(model.Integer,primary_key=True,autoincrement=True)
    name = model.Column(model.String(32))
    cities = model.relationship('City',backref='Provice',lazy='dynamic')

예제 #3

파일: models.py 프로젝트: yuansuixin/learn-flask-city

class City(model.Model):
    cid = model.Column(model.Integer,primary_key=True,autoincrement=True)
    name = model.Column(model.String(32))
    provice = model.Column(model.Integer,model.ForeignKey(Provice.pid))
    villages = model.relationship('Village', backref='City', lazy='dynamic')

예제 #4

파일: models.py 프로젝트: yuansuixin/learn-flask-city

class Village(model.Model):
    vid = model.Column(model.Integer, primary_key=True, autoincrement=True)
    name = model.Column(model.String(32))
    city = model.Column(model.Integer, model.ForeignKey(City.cid))

예제 #5

class Student(model.Model):
    id = model.Column(model.Integer, primary_key=True, autoincrement=True)
    s_name = model.Column(model.String(16))