User belongs to an Organization

As defined in our blueprints, a user will belong to a single Organization. This means we need to add a users.organization_id column.

We want this column to have the following properties:

  • Not nullable
  • Foreign key to organizations table
  • No default value
  • Validate foreign key above

When adding the column, we'll backfill this column to have the value of the default org ID (1).

The organization_users entries operate independently of the Users organization_id entry. At least for now.

Edited by tim mccarthy