Python ForeignKey Examples

Example #1

class Testimonial(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20), unique=True, nullable=False)
    desc = db.Column(db.String(30), unique=True, nullable=False)
    image_file = db.Column(db.String(20), nullable=False, default='recom.jpg')
    testimony = db.Column(db.String(1000), nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

Example #2

class Achievement(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)
    description = db.Column(db.String, nullable=False)
    year = db.Column(db.Integer, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f"Achievement('{self.name}', '{self.category}', '{self.winner}')"

Example #3

class Job(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    role = db.Column(db.String(30), unique=False, nullable=False)
    company = db.Column(db.String(30), unique=False, nullable=False)
    start = db.Column(db.DateTime, unique=False, nullable=True)
    end = db.Column(db.DateTime, unique=False, nullable=True)
    place = db.Column(db.String(30), unique=False, nullable=True)
    jd = db.Column(db.String(100), unique=False, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

Example #4

class Project(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    p_name = db.Column(db.String(50), unique=True, nullable=False)
    p_description = db.Column(db.String(200), unique=True, nullable=True)
    Organization = db.Column(db.String(200), unique=False, nullable=True)
    p_url = db.Column(db.String(200), unique=True, nullable=True)
    cred_id = db.Column(db.String(200), unique=True, nullable=True)
    certi_url = db.Column(db.String(200), unique=True, nullable=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

Example #5

class Project(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)
    year = db.Column(db.Integer, nullable=False)
    url = db.Column(db.String)
    description = db.Column(db.String, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f"Project('{self.name}', '{self.year}', '{self.creator}')"

Example #6

File: models.py Project: radekwarowny/python_exercises

class Post(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)

    def __repr__(self):
        return f"Post('{self.title}', '{self.date_posted}')"

Example #7

class Job(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    company_name = db.Column(db.String, nullable=False)
    start_date = db.Column(db.DateTime, nullable=False)
    end_date = db.Column(db.DateTime)
    role = db.Column(db.String, nullable=False)
    description = db.Column(db.String, nullable=False)
    volunteer = db.Column(db.Boolean)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f"Job('{self.company_name}', '{self.role}', '{self.employee}')"

Example #8

class Skills(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    sk_name = db.Column(db.String(20), unique=True, nullable=False)
    sk_value = db.Column(db.Integer, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)