Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| audit_deleted_date_at | timestamptz | 35,6 | √ | null |
|
|
|||||
| audit_created_at | timestamptz | 35,6 | now() |
|
|
||||||
| audit_updated_at | timestamptz | 35,6 | √ | now() |
|
|
|||||
| audit_created_by | varchar | 2147483647 | null |
|
|
||||||
| audit_updated_by | varchar | 2147483647 | √ | null |
|
|
|||||
| uuid | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| file_number | varchar | 2147483647 | null |
|
|
File number of the application |
|||||
| type | varchar | 2147483647 | null |
|
|
Type of Amendment, Inclusion or Exclusion |
|||||
| area | numeric | 15,5 | √ | null |
|
|
Area in hectares of the amendment |
||||
| year | int4 | 10 | √ | null |
|
|
Year the amendment took place |
||||
| period | int2 | 5 | √ | null |
|
|
Period of the year the amendment took place (1 - 4) |
||||
| oats_component_id | int8 | 19 | √ | null |
|
|
This column is NOT related to any functionality in ALCS. It is only used for ETL and backtracking of imported data from OATS. It links oats.oats_alr_appl_components to alcs.application_boundary_amendment. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_dd163805033c64ed3fa474ada55 | Primary key | Asc | uuid |
Relationships
Close relationships within degrees of separation
