\d assignments

gistfile1.txt

| Column                     | Type                     | Modifiers   |
|----------------------------+--------------------------+-------------|
| id                         | uuid                     |  not null   |
| assignment_type            | character varying(20)    |  not null   |
| created_date               | timestamp with time zone |  not null   |
| created_by_id              | uuid                     |  not null   |
| updated_date               | timestamp with time zone |  not null   |
| updated_by_id              | uuid                     |  not null   |
| organization_id            | uuid                     |  not null   |
| organization_membership_id | uuid                     |  not null   |
| task_id                    | uuid                     |             |
| checklist_id               | uuid                     |             |
+----------------------------+--------------------------+-------------+
Indexes:
    "assignments_pkey" PRIMARY KEY, btree (id)
    "assignments_checklist_id_organization_membership_idx" UNIQUE, btree (checklist_id, organization_membership_id) WHERE checklis
    "assignments_task_id_organization_membership_idx" UNIQUE, btree (task_id, organization_membership_id) WHERE task_id IS NOT NUL
    "assignments_created_by_id_idx" btree (created_by_id)
    "assignments_organization_membership_id_idx" btree (organization_membership_id)
    "assignments_updated_by_id_idx" btree (updated_by_id)
Check constraints:
    "assignments_type_check" CHECK (assignment_type::text = ANY (ARRAY['Task'::character varying, 'Checklist'::character varying]:
Foreign-key constraints:
    "assignments_checklist_id_fkey" FOREIGN KEY (organization_id, checklist_id) REFERENCES checklists(organization_id, id)
    "assignments_created_by_id_fkey" FOREIGN KEY (created_by_id) REFERENCES users(id)
    "assignments_organization_membership_id_fkey" FOREIGN KEY (organization_membership_id) REFERENCES organization_memberships(id)
    "assignments_task_id_fkey" FOREIGN KEY (organization_id, task_id) REFERENCES tasks(organization_id, id)
    "assignments_updated_by_id_fkey" FOREIGN KEY (updated_by_id) REFERENCES users(id)