Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| tile | int8 | 19 | √ | null |
|
|
Tile identifier |
||||
| subx | int8 | 19 | √ | null |
|
|
x index of subtile |
||||
| suby | int8 | 19 | √ | null |
|
|
y index of subtile |
||||
| subra | float8 | 17,17 | √ | null |
|
|
RA of subtile |
||||
| subdec | float8 | 17,17 | √ | null |
|
|
DEC of subtile |
||||
| expid | int8 | 19 | √ | null |
|
|
Exposure identifier |
||||
| in_mosaic | int8 | 19 | √ | null |
|
|
Exposure is included in the drizzled subtile |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| mosaic_tiles_exposures_expid_idx | Performance | Asc | expid |
| mosaic_tiles_exposures_expid_idx1 | Performance | Asc | expid |
| mosaic_tiles_exposures_expid_idx2 | Performance | Asc | expid |
| mosaic_tiles_exposures_expid_in_mosaic_idx | Performance | Asc/Asc | expid + in_mosaic |
| mosaic_tiles_exposures_expid_in_mosaic_tile_subx_suby_idx | Performance | Asc/Asc/Asc/Asc/Asc | expid + in_mosaic + tile + subx + suby |
| mosaic_tiles_exposures_tile_subx_suby_idx | Performance | Asc/Asc/Asc | tile + subx + suby |
Relationships
Close relationships within degrees of separation
