Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| file | text | 2147483647 | √ | null |
|
|
File rootname |
||||
| dataset | text | 2147483647 | √ | null |
|
|
Dataset key |
||||
| extension | text | 2147483647 | √ | null |
|
|
File extension |
||||
| filter | text | 2147483647 | √ | null |
|
|
Filter name |
||||
| parent | text | 2147483647 | √ | null |
|
|
CHArGE field name that uses this exposure |
||||
| awspath | text | 2147483647 | √ | null |
|
|
Path to the file on AWS S3 |
||||
| product | text | 2147483647 | √ | null |
|
|
CHArGE visit name |
||||
| ra | float8 | 17,17 | √ | null |
|
|
Rough footprint centroid, RA |
||||
| dec | float8 | 17,17 | √ | null |
|
|
Rough footprint centroid, Dec |
||||
| area | float8 | 17,17 | √ | null |
|
|
Exposure footprint area, arcmin2 |
||||
| footprint | _float8 | 17,17 | √ | null |
|
|
Exposure footprint corners array |
||||
| mdrizsky | float8 | 17,17 | √ | null |
|
|
Background pedestal level, detector units |
||||
| exptime | float8 | 17,17 | √ | null |
|
|
Exposure time, seconds |
||||
| expstart | float8 | 17,17 | √ | null |
|
|
MJD of exposure start |
||||
| ndq | int4 | 10 | √ | null |
|
|
Number of DQ=0 pixels |
||||
| expflag | varchar | 2147483647 | √ | null |
|
|
Exposure flag |
||||
| sunangle | float8 | 17,17 | √ | null |
|
|
Angular separation to the sun, degrees |
||||
| gsky101 | float4 | 8,8 | √ | null |
|
|
Grism sky component 1, electrons per sec |
||||
| gsky102 | float4 | 8,8 | √ | null |
|
|
Grism sky component 2, electrons per sec |
||||
| persnpix | int4 | 10 | √ | null |
|
|
Number of pixels above persistence threshold |
||||
| perslevl | float4 | 8,8 | √ | null |
|
|
Persistence threshold, ERR of FLT/FLC exposure |
||||
| gsky103 | float4 | 8,8 | √ | null |
|
|
Grism sky component 3, electrons per sec |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| exposure_log_parent | Performance | Asc | parent |
Relationships
Close relationships within degrees of separation
