Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| __id | int8 | 19 | √ | null |
|
|
||||||||
| __cf | bool | 1 | true |
|
|
|||||||||
| __start | timestamptz | 35,6 | null |
|
|
|||||||||
| __source | varchar | 63 | null |
|
|
|||||||||
| __origin | varchar | 63 | ''::character varying |
|
|
|||||||||
| id | uuid | 2147483647 | null |
|
|
|||||||||
| snapshot_id | uuid | 2147483647 | √ | null |
|
|
||||||||
| matched_id | uuid | 2147483647 | √ | null |
|
|
||||||||
| generation | int4 | 10 | √ | null |
|
|
||||||||
| record_type | varchar | 8 | √ | null |
|
|
||||||||
| external_id | uuid | 2147483647 | √ | null |
|
|
||||||||
| state | varchar | 6 | √ | null |
|
|
||||||||
| leader_record_status | varchar | 1 | √ | null |
|
|
||||||||
| order | int4 | 10 | √ | null |
|
|
||||||||
| suppress_discovery | bool | 1 | √ | null |
|
|
||||||||
| created_by_user_id | uuid | 2147483647 | √ | null |
|
|
||||||||
| created_date | timestamptz | 35,6 | √ | null |
|
|
||||||||
| updated_by_user_id | uuid | 2147483647 | √ | null |
|
|
||||||||
| updated_date | timestamptz | 35,6 | √ | null |
|
|
||||||||
| external_hrid | varchar | 11 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| records_lb_pkey | Primary key | Asc | id |
| records_lb___origin_idx | Performance | Asc | __origin |
| records_lb___source_idx | Performance | Asc | __source |
| records_lb___start_idx | Performance | Asc | __start |
| records_lb_created_by_user_id_idx | Performance | Asc | created_by_user_id |
| records_lb_created_date_idx | Performance | Asc | created_date |
| records_lb_external_hrid_idx | Performance | Asc | external_hrid |
| records_lb_external_id_idx | Performance | Asc | external_id |
| records_lb_generation_idx | Performance | Asc | generation |
| records_lb_id_idx | Performance | Asc | id |
| records_lb_leader_record_status_idx | Performance | Asc | leader_record_status |
| records_lb_matched_id_idx | Performance | Asc | matched_id |
| records_lb_order_idx | Performance | Asc | order |
| records_lb_record_type_idx | Performance | Asc | record_type |
| records_lb_snapshot_id_idx | Performance | Asc | snapshot_id |
| records_lb_state_idx | Performance | Asc | state |
| records_lb_suppress_discovery_idx | Performance | Asc | suppress_discovery |
| records_lb_updated_by_user_id_idx | Performance | Asc | updated_by_user_id |
| records_lb_updated_date_idx | Performance | Asc | updated_date |
Relationships
Close relationships within degrees of separation
