Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| shift_dataset | varchar | 2147483647 | √ | null |
|
|
File dataset name |
||||
| shift_dx | float4 | 8,8 | √ | null |
|
|
X shift, pix |
||||
| shift_dy | float4 | 8,8 | √ | null |
|
|
Y shift, pix |
||||
| shift_n | int4 | 10 | √ | null |
|
|
Number of matched sources used for shift |
||||
| shift_xrms | float4 | 8,8 | √ | null |
|
|
X rms of shift fit, pix |
||||
| shift_yrms | float4 | 8,8 | √ | null |
|
|
Y rms of shift fit, pix |
||||
| shift_modtime | float4 | 8,8 | √ | null |
|
|
Processing timestamp |
||||
| shift_parent | varchar | 2147483647 | √ | null |
|
|
Parent visit name for exposure group |
||||
| shift_assoc | varchar | 2147483647 | √ | null |
|
|
Association name |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| shifts_log_shift_dataset_idx | Performance | Asc | shift_dataset |
Relationships
Close relationships within degrees of separation
