18F/openFEC

{
  "constraints": {
    "dimcmteproperties": [
      {
        "referred_schema": null,
        "referred_table": "dimcmte",
        "referred_columns": ["cmte_sk"],
        "constrained_columns": ["cmte_sk"]
      }
    ],
    "facthousesenate_f3": [
      {
        "referred_schema": null,
        "referred_table": "dimcmte",
        "referred_columns": ["cmte_sk"],
        "constrained_columns": ["cmte_sk"]
      }
    ],
    "factpacsandparties_f3x": [
      {
        "referred_schema": null,
        "referred_table": "dimcmte",
        "referred_columns": ["cmte_sk"],
        "constrained_columns": ["cmte_sk"]
      }
    ],
    "factpresidential_f3p": [
      {
        "referred_schema": null,
        "referred_table": "dimcmte",
        "referred_columns": ["cmte_sk"],
        "constrained_columns": ["cmte_sk"]
      }
    ],
    "factindpexpcontb_f5": [
      {
        "referred_schema": null,
        "referred_table": "dimcmte",
        "referred_columns": ["cmte_sk"],
        "constrained_columns": ["indv_org_sk"]
      }
    ],
    "cand_cmte_linkage": [
      {
        "referred_schema": null,
        "referred_table": "disclosure.cand_valid_fec_yr",
        "referred_columns": ["cand_id"],
        "constrained_columns": ["cand_id"]
      },
      {
        "referred_schema": null,
        "referred_table": "disclosure.cmte_valid_fec_yr",
        "referred_columns": ["cmte_id"],
        "constrained_columns": ["cmte_id"]
      }
    ],
    "sched_b": [
      {
        "referred_schema": null,
        "referred_table": "form_94",
        "referred_columns": ["link_id"],
        "constrained_columns": ["link_id"]
      }
    ]
  }
}