Table atlas.exposures Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
exp_id bigint 19  √ 
expname varchar 20  √  null
sitecam varchar 5  √  null
mjd0 double 22  √  null
nn int 10  √  null
object varchar 30  √  null
ra_deg double 22  √  null
dec_deg double 22  √  null
pa_deg float 12  √  null
az_deg double 22  √  null
alt_deg double 22  √  null
se_deg float 12  √  null
eb_deg float 12  √  null
el_deg float 12  √  null
gb_deg float 12  √  null
gl_deg float 12  √  null
filter_id char 1  √  null
exptime_sec float 12  √  null
focus float 12  √  null
dettem float 12  √  null
bckgnd_adu float 12  √  null
fwhm_px float 12  √  null
nstar int 10  √  null
zp_mag float 12  √  null
anet int 10  √  null
flags int 10  √  null
status char 1  √  N

Table contained 526,176 rows at Thu Aug 04 11:19 HST 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
exp_id Primary key Asc PRIMARY  
expname Must be unique Asc expname This unique column is also nullable
expname Performance Asc expname_2  
exptime_sec Performance Asc exptime_sec