phoenix_kit

1.7.103

1.7.208 1.7.207 1.7.206 1.7.205 1.7.204 1.7.203 1.7.202 1.7.201 1.7.200 1.7.199 1.7.198 1.7.197 1.7.196 1.7.194 1.7.193 1.7.192 1.7.191 1.7.190 1.7.189 1.7.187 1.7.186 1.7.185 1.7.184 1.7.183 1.7.182 1.7.181 1.7.180 1.7.179 1.7.178 1.7.177 1.7.176 1.7.175 1.7.174 1.7.173 1.7.172 1.7.171 1.7.170 1.7.169 1.7.168 1.7.167 1.7.166 1.7.165 1.7.164 1.7.162 1.7.161 1.7.160 1.7.159 1.7.157 1.7.156 1.7.155 1.7.154 1.7.153 1.7.152 1.7.151 1.7.150 1.7.149 1.7.146 1.7.145 1.7.144 1.7.143 1.7.138 1.7.133 1.7.132 1.7.131 1.7.130 1.7.128 1.7.126 1.7.125 1.7.121 1.7.120 1.7.119 1.7.118 1.7.117 1.7.116 1.7.115 1.7.114 1.7.113 1.7.112 1.7.111 1.7.110 1.7.109 1.7.108 1.7.107 1.7.106 1.7.105 1.7.104 1.7.103 1.7.102 1.7.101 1.7.100 1.7.99 1.7.98 1.7.97 1.7.96 1.7.95 1.7.94 1.7.93 1.7.92 1.7.91 1.7.90 1.7.89 1.7.88 1.7.87 1.7.86 1.7.85 1.7.84 1.7.83 1.7.82 1.7.81 1.7.80 1.7.79 1.7.78 1.7.77 1.7.76 1.7.75 1.7.74 1.7.71 1.7.70 1.7.69 1.7.66 1.7.65 1.7.64 1.7.63 1.7.62 1.7.61 1.7.59 1.7.58 1.7.57 1.7.56 1.7.55 1.7.54 1.7.53 1.7.52 1.7.51 1.7.49 1.7.44 1.7.43 1.7.42 1.7.41 1.7.39 1.7.38 1.7.37 1.7.36 1.7.34 1.7.33 1.7.31 1.7.30 1.7.29 1.7.28 1.7.27 1.7.26 1.7.25 1.7.24 1.7.23 1.7.22 1.7.21 1.7.20 1.7.19 1.7.18 1.7.17 1.7.16 1.7.15 1.7.14 1.7.13 1.7.12 1.7.11 1.7.10 1.7.9 1.7.8 1.7.7 1.7.6 1.7.5 1.7.4 1.7.3 1.7.2 1.7.1 1.7.0 1.6.20 1.6.19 1.6.18 1.6.17 1.6.16 1.6.15 1.6.14 1.6.13 1.6.12 1.6.11 1.6.10 1.6.9 1.6.8 1.6.7 1.6.6 1.6.5 1.6.4 1.6.3 1.5.2 1.5.1 1.5.0 1.4.9 1.4.8 1.4.7 1.4.6 1.4.5 1.4.4 1.4.3 1.4.2 1.4.1 1.4.0 1.3.2 1.3.1 1.3.0 1.2.10 1.2.9 1.2.8 1.2.7 1.2.5 1.2.4 1.2.2 1.2.1 1.2.0 1.1.0 1.0.0

A foundation for building Elixir Phoenix apps — SaaS, social networks, ERP systems, marketplaces, and more

HexDocs

Current section

Files

Jump to

Readme 222 Versions 42 Dependencies Dependants Files Activity

phoenix_kit lib phoenix_kit migrations postgres v100.ex

Raw

lib/phoenix_kit/migrations/postgres/v100.ex

defmodule PhoenixKit.Migrations.Postgres.V100 do
  @moduledoc """
  V100: Staff module tables.

  Creates four tables used by `phoenix_kit_staff`:

  - `phoenix_kit_staff_departments` — top-level org units
  - `phoenix_kit_staff_teams` — teams inside a department
  - `phoenix_kit_staff_people` — staff profiles, each linked 1:1 to a
    `phoenix_kit_users` row (required FK)
  - `phoenix_kit_staff_team_memberships` — join table for team membership

  UUIDv7 primary keys, `timestamptz` timestamps, cascading deletes
  department → team → team_memberships; person deletion cascades to
  team_memberships; user deletion cascades to the staff person profile.

  Departments and teams are identified by UUID only — no slug columns.
  A team's name must be unique within its department.
  """

  use Ecto.Migration

  def up(opts) do
    prefix = Map.get(opts, :prefix, "public")
    p = prefix_str(prefix)

    execute("""
    CREATE TABLE IF NOT EXISTS #{p}phoenix_kit_staff_departments (
      uuid UUID PRIMARY KEY DEFAULT uuid_generate_v7(),
      name VARCHAR(255) NOT NULL,
      description TEXT,
      inserted_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
      updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
    )
    """)

    execute("""
    CREATE UNIQUE INDEX IF NOT EXISTS phoenix_kit_staff_departments_name_index
    ON #{p}phoenix_kit_staff_departments (lower(name))
    """)

    execute("""
    CREATE TABLE IF NOT EXISTS #{p}phoenix_kit_staff_teams (
      uuid UUID PRIMARY KEY DEFAULT uuid_generate_v7(),
      department_uuid UUID NOT NULL REFERENCES #{p}phoenix_kit_staff_departments(uuid) ON DELETE CASCADE,
      name VARCHAR(255) NOT NULL,
      description TEXT,
      inserted_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
      updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
    )
    """)

    execute("""
    CREATE UNIQUE INDEX IF NOT EXISTS phoenix_kit_staff_teams_department_name_index
    ON #{p}phoenix_kit_staff_teams (department_uuid, lower(name))
    """)

    execute("""
    CREATE INDEX IF NOT EXISTS phoenix_kit_staff_teams_department_index
    ON #{p}phoenix_kit_staff_teams (department_uuid)
    """)

    execute("""
    CREATE TABLE IF NOT EXISTS #{p}phoenix_kit_staff_people (
      uuid UUID PRIMARY KEY DEFAULT uuid_generate_v7(),
      user_uuid UUID NOT NULL REFERENCES #{p}phoenix_kit_users(uuid) ON DELETE CASCADE,
      primary_department_uuid UUID REFERENCES #{p}phoenix_kit_staff_departments(uuid) ON DELETE SET NULL,
      status VARCHAR(20) NOT NULL DEFAULT 'active',
      job_title VARCHAR(255),
      employment_type VARCHAR(20),
      employment_start_date DATE,
      employment_end_date DATE,
      work_location VARCHAR(255),
      work_phone VARCHAR(50),
      personal_phone VARCHAR(50),
      bio TEXT,
      skills TEXT,
      notes TEXT,
      date_of_birth DATE,
      personal_email VARCHAR(255),
      emergency_contact_name VARCHAR(255),
      emergency_contact_phone VARCHAR(50),
      emergency_contact_relationship VARCHAR(100),
      inserted_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
      updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
    )
    """)

    execute("""
    CREATE UNIQUE INDEX IF NOT EXISTS phoenix_kit_staff_people_user_index
    ON #{p}phoenix_kit_staff_people (user_uuid)
    """)

    execute("""
    CREATE INDEX IF NOT EXISTS phoenix_kit_staff_people_primary_department_index
    ON #{p}phoenix_kit_staff_people (primary_department_uuid)
    """)

    execute("""
    CREATE INDEX IF NOT EXISTS phoenix_kit_staff_people_status_index
    ON #{p}phoenix_kit_staff_people (status)
    """)

    execute("""
    CREATE TABLE IF NOT EXISTS #{p}phoenix_kit_staff_team_memberships (
      uuid UUID PRIMARY KEY DEFAULT uuid_generate_v7(),
      team_uuid UUID NOT NULL REFERENCES #{p}phoenix_kit_staff_teams(uuid) ON DELETE CASCADE,
      staff_person_uuid UUID NOT NULL REFERENCES #{p}phoenix_kit_staff_people(uuid) ON DELETE CASCADE,
      inserted_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
    )
    """)

    execute("""
    CREATE UNIQUE INDEX IF NOT EXISTS phoenix_kit_staff_team_memberships_team_person_index
    ON #{p}phoenix_kit_staff_team_memberships (team_uuid, staff_person_uuid)
    """)

    execute("""
    CREATE INDEX IF NOT EXISTS phoenix_kit_staff_team_memberships_person_index
    ON #{p}phoenix_kit_staff_team_memberships (staff_person_uuid)
    """)

    execute("COMMENT ON TABLE #{p}phoenix_kit IS '100'")
  end

  @doc """
  Drops all four staff tables.

  **Lossy rollback:** all staff data (departments, teams, people, and
  their team memberships) is permanently destroyed. Back up before
  rolling back in production.
  """
  def down(opts) do
    prefix = Map.get(opts, :prefix, "public")
    p = prefix_str(prefix)

    execute("DROP TABLE IF EXISTS #{p}phoenix_kit_staff_team_memberships")
    execute("DROP TABLE IF EXISTS #{p}phoenix_kit_staff_people")
    execute("DROP TABLE IF EXISTS #{p}phoenix_kit_staff_teams")
    execute("DROP TABLE IF EXISTS #{p}phoenix_kit_staff_departments")

    execute("COMMENT ON TABLE #{p}phoenix_kit IS '99'")
  end

  defp prefix_str("public"), do: "public."
  defp prefix_str(prefix), do: "#{prefix}."
end

Operator	Description	Example
name:	Match package name. Supports * wildcards and repo/package form	name:phx* or name:hexpm/phoenix
description:	Full-text search of package descriptions	description:auth
depends:	Packages depending on a given package. Supports repo:package form	depends:ecto or depends:hexpm:ecto
build_tool:	Filter by build tool	build_tool:mix
updated_after:	Packages updated after an ISO8601 datetime	updated_after:2025-01-01T00:00:00Z
extra:	Match custom metadata (key,value). Nested keys are separated by commas	extra:license,MIT