Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
intervention unique identifier |
||||
| dynamic_framework_contract_id | uuid | 2147483647 | null |
|
|
dynamic framework unique identifier |
||||
| created_at | timestamptz | 35,6 | null |
|
|
when the record was added |
||||
| title | text | 2147483647 | null |
|
|
intervention name |
||||
| description | text | 2147483647 | null |
|
|
intervention description |
||||
| incoming_referral_distribution_email | text | 2147483647 | '__no_data__'::text |
|
|
email address receiving notifications about new referrals |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| intervention_pkey | Primary key | Asc | id |
| idx_intervention_dynamic_framework_contract_id | Must be unique | Asc | dynamic_framework_contract_id |
Relationships
Close relationships within degrees of separation
