Python ForeignKey 예제들

예제 #1

class Notifications_v2(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(600), nullable=False)
    email = db.Column(db.String(600), nullable=False)
    subscribed_to = db.Column(db.Integer,
                              db.ForeignKey('users_v2.id'),
                              nullable=False)

예제 #2

파일: models.py 프로젝트: thepurplecape/capstone-scheduler

class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    event_name = db.Column(db.String(500), nullable=False)
    details = db.Column(db.String(2000))
    start_time = db.Column(db.DateTime)
    end_time = db.Column(db.DateTime)
    owner_id = db.Column(db.Integer, db.ForeignKey("user.id"))

예제 #3

class Comments(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    comment = db.Column(db.String(600), nullable=False)
    commenter_name = db.Column(db.String(600), nullable=False)
    comment_time = db.Column(db.String(600), nullable=False)
    comment_likes = db.Column(db.Integer)
    comment_message = db.Column(db.Integer,
                                db.ForeignKey('messages.id'),
                                nullable=False)

예제 #4

class Groups(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    group_name = db.Column(db.String(500))
    group_emails = db.Column(db.String(500))
    owner_id = db.Column(db.Integer, db.ForeignKey("user.id"))

예제 #5

class Invites(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    invitee_email = db.Column(db.String(500))
    accepted = db.Column(db.Boolean, default=False)
    event_id = db.Column(db.Integer, db.ForeignKey("event.id"))