# Julia/ SearchLight.Migrations , how to add foreign key?

**URL:** https://discourse.julialang.org/t/julia-searchlight-migrations-how-to-add-foreign-key/126292
**Category:** General Usage
**Created:** [February 25, 2025, 12:58pm UTC](https://discourse.julialang.org/t/julia-searchlight-migrations-how-to-add-foreign-key/126292 "2025-02-25T12:58:08Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![andreh](https://avatars.discourse-cdn.com/v4/letter/a/958977/32.png) [@andreh](https://discourse.julialang.org/u/andreh)
#### Post date: [February 25, 2025, 12:58pm UTC](https://discourse.julialang.org/t/julia-searchlight-migrations-how-to-add-foreign-key/126292/1 "2025-02-25T12:58:08Z")

</div>

I am using Genie Framework and Julia to set up a basic database Migration

This is how my module looks inside the folder db/migrations

```julia
module CreateTableRolesUsers

import SearchLight.Migrations: create_table, column, primary_key, add_index, drop_table

function up()
  create_table(:rolesusers) do
    [
      column(:user_id, :string)
      column(:role_id, :integer)
      primary_key(:pk_roleusers)
      
    ]
  end

  add_index(:rolesusers, :role_id)
  add_index(:rolesusers, :user_id)

end

function down()
  drop_table(:rolesusers)
end

end

```

import SearchLight.Migrations does not offer a method “foreign\_key” or “add\_foreign\_key” like the one for declaring a “primary\_key”

how that can be done?