Python ForeignKey示例

示例#1

class Questionnaire(db.Model):
    __tablename__ = 'questionnaire'

    id = db.Column(UUID(as_uuid=True), primary_key=True)
    project_id = db.Column(db.ForeignKey('project.id'))
    user_filler = db.Column(db.ForeignKey('user.id'))
    to_date = db.Column(db.DateTime)
    is_transition_completed = db.Column(db.Integer)
    is_transition_charges_paied = db.Column(db.Integer)
    is_transformation_completed = db.Column(db.Integer)
    missed_kpi = db.Column(db.Integer)
    missed_service_level = db.Column(db.Integer)
    moved_service_level = db.Column(db.Integer)
    payable_service_credits = db.Column(db.Numeric)
    paied_service_credits = db.Column(db.Numeric)
    is_paied_passed = db.Column(db.Integer)
    pay_back = db.Column(db.Numeric)
    is_customer_satisfaction_report = db.Column(db.Integer)
    customer_satisfaction_result = db.Column(db.Integer)
    is_additional_governance = db.Column(db.Integer)
    additional_governance_cause = db.Column(db.Integer)
    initiated_CCNs = db.Column(db.Integer)
    signed_CCNs = db.Column(db.Integer)
    signed_CCNs_type = db.Column(db.Integer)
    key_personnel_changed = db.Column(db.Integer)
    supplier_personnel_changed = db.Column(db.Integer)
    customer_personnel_changed = db.Column(db.Integer)
    service_level_missed_target = db.Column(db.Integer)
    service_level_missed_target_value = db.Column(db.Integer)
    service_level_missed_target_max = db.Column(db.Integer)
    costs_incurred = db.Column(db.Numeric)
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime,
                           server_default=db.func.now(),
                           server_onupdate=db.func.now())

    project = db.relationship('Project')
    user = db.relationship('User')

示例#2

文件： models.py 项目： elishakrasz1/effort

class Bespoke(db.Model):
    __tablename__ = 'bespoke'

    id = db.Column(db.Integer, primary_key=True)
    type = db.Column(db.Integer)
    project_id = db.Column(db.ForeignKey('project.id'))
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(
        db.DateTime, server_default=db.func.now(), server_onupdate=db.func.now())
    
    project = db.relationship('Project')

示例#3

文件： models.py 项目： elishakrasz1/effort

class ContractValue(db.Model):
    __tablename__ = 'contract_value'

    id = db.Column(db.Integer, primary_key=True)
    year = db.Column(db.Integer)
    contract_value_usd = db.Column(db.Numeric)
    project_id = db.Column(db.ForeignKey('project.id'))
    estimated_cost_usd = db.Column(db.Numeric)
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime, server_default=db.func.now(), server_onupdate=db.func.now())
    
    project = db.relationship('Project')

示例#4

class Dispute(db.Model):
    __tablename__ = 'dispute'

    id = db.Column(UUID(as_uuid=True), primary_key=True)
    subject = db.Column(db.Integer)
    questionnaire_id = db.Column(db.ForeignKey('questionnaire.id'))
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime,
                           server_default=db.func.now(),
                           server_onupdate=db.func.now())

    questionnaire = db.relationship('Questionnaire')

示例#5

class Governance(db.Model):
    __tablename__ = 'governance'

    id = db.Column(UUID(as_uuid=True), primary_key=True)
    type = db.Column(db.Integer)
    how_often = db.Column(db.Integer)
    project_id = db.Column(db.ForeignKey('project.id'))
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime,
                           server_default=db.func.now(),
                           server_onupdate=db.func.now())

    project = db.relationship('Project')

示例#6

class Charge(db.Model):
    __tablename__ = 'charges'

    id = db.Column(UUID(as_uuid=True), primary_key=True)
    invoiced_charges = db.Column(db.Integer)
    questionnaire_id = db.Column(db.ForeignKey('questionnaire.id'))
    invoice_date = db.Column(db.DateTime)
    amount = db.Column(db.Numeric)
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime,
                           server_default=db.func.now(),
                           server_onupdate=db.func.now())

    questionnaire = db.relationship('Questionnaire')

示例#7

class Change(db.Model):
    __tablename__ = 'changes'

    id = db.Column(UUID(as_uuid=True), primary_key=True)
    subject = db.Column(db.Integer)
    questionnaire_id = db.Column(db.ForeignKey('questionnaire.id'))
    month_impact = db.Column(db.Integer)
    charges_impact = db.Column(db.Numeric)
    effective_date = db.Column(db.DateTime)
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime,
                           server_default=db.func.now(),
                           server_onupdate=db.func.now())

    questionnaire = db.relationship('Questionnaire')

示例#8

class Milestone(db.Model):
    __tablename__ = 'milestone'

    id = db.Column(UUID(as_uuid=True), primary_key=True)
    type = db.Column(db.Integer)
    project_id = db.Column(db.ForeignKey('project.id'))
    is_payment = db.Column(db.Integer)
    completion_date = db.Column(db.DateTime)
    charges = db.Column(db.Numeric)
    is_paied = db.Column(db.Integer)
    CREATED_BY = db.Column(db.Integer)
    UPDATED_BY = db.Column(db.Integer)
    UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now())
    CREATED_AT = db.Column(db.DateTime,
                           server_default=db.func.now(),
                           server_onupdate=db.func.now())

    project = db.relationship('Project')

示例#9

文件： models.py 项目： goodking-bq/flask-sqlalchemy-graphene-example

from example_app.extensions import db

from sqlalchemy import func
from sqlalchemy.ext.hybrid import hybrid_property
from sqlalchemy.ext.associationproxy import association_proxy

user_role = db.Table(
    "user_role",
    db.metadata,
    db.Column("user_id", db.Integer, db.ForeignKey("user.id")),
    db.Column("role_id", db.Integer, db.ForeignKey("role.id")),
    db.UniqueConstraint("user_id", "role_id"),
)


class User(db.Model):
    __tablename__ = "user"
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20))
    password = db.Column(db.String(100), nullable=False)
    roles = db.relationship("Role", secondary=user_role, back_populates="users")
    role_names = key_ids = association_proxy("roles", "name")


class Role(db.Model):
    __tablename__ = "role"
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255))

    users = db.relationship("User", secondary=user_role, back_populates="roles")