Python ForeignKey 예제들

예제 #1

파일: models.py 프로젝트: rohitthakur2590/zerowrite

class Note(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    date_posted = db.Column(db.DateTime,
                            nullable=False,
                            default=datetime.utcnow)
    content = db.Column(db.Text, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

예제 #2

파일: models.py 프로젝트: rohitthakur2590/zerowrite

class Subscription(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    firstname = db.Column(db.String(20))
    lastname = db.Column(db.String(20))
    username = db.Column(db.String(50), unique=True)
    image_file = db.Column(db.String(20),
                           nullable=False,
                           default='default.jpg')
    date_added = db.Column(db.DateTime,
                           nullable=False,
                           default=datetime.utcnow)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)