1 SEDmdb Read table & column comments as mouse-over tooltips. Fk allocation_program allocation ref program ( program_id -> id ) program_id Fk fk_astrometry_observation astrometry ref observation ( observation_id -> id ) observation_id Fk classification_object classification ref object ( object_id -> id ) object_id Fk classification_spec classification ref spec ( spec_id -> id ) spec_id Fk object_earth_satellite earth_satellite ref object ( object_id -> id ) object_id Fk object_elliptical_heliocentric elliptical_heliocentric ref object ( object_id -> id ) object_id Fk flexure_spec flexure ref spec ( spec_id_1 -> id ) spec_id_1 Fk spec_flexure flexure ref spec ( spec_id_2 -> id ) spec_id_2 Fk object_hyperbolic_heliocentric hyperbolic_heliocentric ref object ( object_id -> id ) object_id Fk metrics_phot_phot metrics_phot ref phot ( phot_id -> id ) phot_id Fk fk_news_groups news ref groups ( displaygroup -> id ) displaygroup Fk fk_news_users news ref users ( newsuser -> id ) newsuser Fk observation_object observation ref object ( object_id -> id ) object_id Fk observation_request observation ref request ( request_id -> id ) request_id Fk object_parabolic_heliocentric parabolic_heliocentric ref object ( object_id -> id ) object_id Fk object_periodic periodic ref object ( object_id -> id ) object_id Fk phot_observation phot ref observation ( observation_id -> id ) observation_id Fk phot_phot_calib phot ref phot_calib ( phot_calib_id -> id ) phot_calib_id Fk program_groups program ref groups ( group_id -> id ) group_id Fk ref_stars_phot ref_stars ref phot ( phot_id -> id ) phot_id Fk request_allocation request ref allocation ( allocation_id -> id ) allocation_id Fk requests_objects request ref object ( object_id -> id ) object_id Fk users_request request ref users ( user_id -> id ) user_id Fk spec_observation spec ref observation ( observation_id -> id ) observation_id Fk spec_spec_calib spec ref spec_calib ( spec_calib_id -> id ) spec_calib_id Fk telescope_stats_observation telescope_stats ref observation ( observation_id -> id ) observation_id Fk usergroups_groups usergroups ref groups ( group_id -> id ) group_id Fk usergroups_users usergroups ref users ( user_id -> id ) user_id Fk fk_catalogform_object catalogform ref object ( object_id -> id ) object_id allocationTable public.allocation Pk allocation_pkey ( id ) idid * bigint Referred by request ( allocation_id -> id ) inidateinidate timestamp d enddateenddate timestamp d time_spenttime_spent interval time_allocatedtime_allocated interval colorcolor text t Unq allocation_designator_key ( designator ) designatordesignator text t program_idprogram_id * bigint References program ( program_id -> id ) activeactive bool default true b astrometryTable public.astrometry Pk pk_astrometry_astid ( id ) idid * bigint # object_idobject_id bigint # idx_astrometry_observation_id ( observation_id ) observation_idobservation_id bigint References observation ( observation_id -> id ) output_fileoutput_file varchar(50) t abpairabpair bool b crpix1crpix1 integer # crpix2crpix2 integer # a_ra_offa_ra_off numeric(8,4) # a_dec_offa_dec_off numeric(8,4) # b_ra_offb_ra_off numeric(8,4) # b_dec_offb_dec_off numeric(8,4) # solvedsolved bool b solved_timesolved_time float8 # reducerreducer varchar(50) t classificationTable public.classification Pk classification_pkey ( id ) idid * bigint # classification_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) classification_spec_id_key ( spec_id ) spec_idspec_id * bigint References spec ( spec_id -> id ) classification_classification_key ( classification ) classificationclassification text t classification_redshift_key ( redshift ) redshiftredshift numeric(7,4) # redshift_errredshift_err numeric(7,5) # phasephase numeric(5,2) # phase_errphase_err numeric(5,2) # classifierclassifier text t scorescore numeric(5,2) # earth_satelliteTable public.earth_satellite Pk earth_satellite_pkey ( id ) idid * bigint # Unq earth_satellite_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) tt timestamp d inclinationinclination numeric(12,8) # rara numeric(12,8) # ee numeric(10,8) # pedigreepedigree numeric(12,8) # mm numeric(12,8) # nn numeric(12,8) # decaydecay numeric(10,8) # reforbitreforbit integer # dragdrag numeric(10,8) # elliptical_heliocentricTable public.elliptical_heliocentric Pk elliptical_heliocentric_pkey ( id ) idid * bigint # Unq elliptical_heliocentric_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) inclinationinclination numeric(12,8) # longascnode_olongascnode_o numeric(12,8) # perihelion_operihelion_o numeric(12,8) # aa numeric(13,8) # nn numeric(10,8) # ee numeric(10,8) # mm numeric(12,8) # mjdepochmjdepoch numeric(14,8) # dd numeric(7,2) # m1m1 numeric(7,4) # m2m2 numeric(7,4) # ss numeric(10,8) # flexureTable public.flexure Pk flexure_pkey ( id ) idid * bigint # rmsrms numeric(8,4) # flexure_spec_id_1_key ( spec_id_1 ) spec_id_1spec_id_1 * bigint References spec ( spec_id_1 -> id ) spec_id_2spec_id_2 * bigint References spec ( spec_id_2 -> id ) timestamp1timestamp1 * timestamp d timestamp2timestamp2 * timestamp d groupsTable public.groups Pk groups_pkey ( id ) idid * bigint Referred by news ( displaygroup -> id ) Referred by program ( group_id -> id ) Referred by usergroups ( group_id -> id ) Unq groups_designator_key ( designator ) designatordesignator * text t growthTable public.growth Pk pk_growth_id ( id ) idid * bigserial # statusstatus char(20) c usernameusername varchar(100) t enddateenddate date d programnameprogramname varchar(100) t startdatestartdate date d sourceidsourceid integer # followupfollowup varchar(100) t prior_photometryprior_photometry text t prioritypriority integer # sourcenamesourcename varchar(100) t requestidrequestid * integer # filtersfilters varchar(100) t rara real # decdec real # createdcreated * timestamp default now() d Unq idx_growth_request_filename ( request_filename ) request_filenamerequest_filename varchar(100) t last_mag_filterlast_mag_filter varchar(10) t last_mag_jdlast_mag_jd real # last_mag_exptimelast_mag_exptime real # last_mag_obsdatelast_mag_obsdate date d last_mag_maglast_mag_mag real # hyperbolic_heliocentricTable public.hyperbolic_heliocentric Pk hyperbolic_heliocentric_pkey ( id ) idid * bigint # Unq hyperbolic_heliocentric_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) tt timestamp d inclinationinclination numeric(12,8) # longascnode_olongascnode_o numeric(12,8) # perihelion_operihelion_o numeric(12,8) # ee numeric(10,8) # qq numeric(13,8) # dd numeric(7,2) # m1m1 numeric(7,4) # m2m2 numeric(7,4) # ss numeric(10,8) # metrics_photTable public.metrics_phot Pk metrics_phot_pkey ( id ) idid * bigint # Unq metrics_phot_phot_id_key ( phot_id ) phot_idphot_id * bigint References phot ( phot_id -> id ) fwhmfwhm numeric(5,2) # backgroundbackground numeric(6,2) # zpzp numeric(5,2) # zperrzperr numeric(5,2) # ellipticityellipticity numeric(5,2) # nsourcesnsources integer # newsTable public.news Pk pk_news_id ( id ) idid * bigserial # createdatecreatedate timestamp d lastdisplaydatelastdisplaydate timestamp d idx_news_newsuser ( newsuser ) newsusernewsuser bigint References users ( newsuser -> id ) idx_news_displaygroup ( displaygroup ) displaygroupdisplaygroup * bigserial References groups ( displaygroup -> id ) comment_typecomment_type varchar(20) t comment_textcomment_text text t observationTable public.observation Pk observation_pkey ( id ) idid * bigint Referred by astrometry ( observation_id -> id ) Referred by phot ( observation_id -> id ) Referred by spec ( observation_id -> id ) Referred by telescope_stats ( observation_id -> id ) observation_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) observation_request_id_key ( request_id ) request_idrequest_id * bigint References request ( request_id -> id ) mjdmjd * numeric(14,8) # airmassairmass * numeric(5,2) # exptimeexptime numeric(7,2) # time_elapsedtime_elapsed interval Unq observation_fitsfile_key ( fitsfile ) fitsfilefitsfile * text t imtypeimtype text t filterfilter text t rara numeric(12,8) # decdec numeric(12,8) # cameracamera text t lstlst varchar(20) t parabolic_heliocentricTable public.parabolic_heliocentric Pk parabolic_heliocentric_pkey ( id ) idid * bigint # Unq parabolic_heliocentric_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) tt timestamp d inclinationinclination numeric(12,8) # perihelion_operihelion_o numeric(12,8) # qq numeric(13,8) # longascnode_olongascnode_o numeric(12,8) # dd numeric(7,2) # m1m1 numeric(7,4) # m2m2 numeric(7,4) # ss numeric(10,8) # periodicTable public.periodic Pk periodic_pkey ( id ) idid * bigint # periodic_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) mjd0mjd0 numeric(14,8) # phasedaysphasedays numeric(12,8) # photTable public.phot Pk phot_pkey ( id ) idid * bigint Referred by metrics_phot ( phot_id -> id ) Referred by ref_stars ( phot_id -> id ) phot_calib_idphot_calib_id * bigint References phot_calib ( phot_calib_id -> id ) Unq phot_observation_id_key ( observation_id ) observation_idobservation_id * bigint References observation ( observation_id -> id ) astrometryastrometry * bool b filterfilter * text t reducedfilereducedfile text t sexfilesexfile text t maskfilemaskfile text t pipelinepipeline text t phot_marshal_phot_id ( marshal_phot_id ) marshal_phot_idmarshal_phot_id bigint # phot_calibTable public.phot_calib Pk phot_calib_pkey ( id ) idid * bigint Referred by phot ( phot_calib_id -> id ) biasbias text t flatflat text t programTable public.program Pk program_pkey ( id ) idid * bigint Referred by allocation ( program_id -> id ) Unq program_designator_key ( designator ) designatordesignator * text t namename text t group_idgroup_id * bigint References groups ( group_id -> id ) pipi text t time_allocatedtime_allocated interval prioritypriority numeric(5,2) # inidateinidate timestamp d enddateenddate timestamp d colorcolor text t ref_starsTable public.ref_stars Pk ref_stars_pkey ( id ) idid * bigint # phot_idphot_id * bigint References phot ( phot_id -> id ) rara numeric(12,8) # decdec numeric(12,8) # surveysurvey * text t ref_stars_filter_key ( filter ) filterfilter * text t ref_stars_mag_key ( mag ) magmag numeric(7,4) # magerrmagerr numeric(5,2) # instmaginstmag * numeric(5,2) # istmagerristmagerr numeric(5,2) # mjdmjd * numeric(14,8) # xx integer # yy integer #--more-- requestTable public.request Pk request_pkey ( id ) idid * bigint Referred by observation ( request_id -> id ) request_object_id_key ( object_id ) object_idobject_id * bigint References object ( object_id -> id ) user_iduser_id * bigint References users ( user_id -> id ) marshal_idmarshal_id bigint # exptimeexptime * integer[] [] maxairmassmaxairmass numeric(5,2) default 2.5 # max_fwhmmax_fwhm numeric(5,3) # min_moon_distmin_moon_dist numeric(5,2) # max_moon_illummax_moon_illum numeric(5,4) # max_cloud_covermax_cloud_cover numeric(5,2) # request_status_key ( status ) statusstatus text default 'PENDING'::text t prioritypriority * numeric(5,2) # inidateinidate * timestamp d enddateenddate * timestamp d cadencecadence numeric(5,2) # phasesamplesphasesamples numeric(5,2) # sampletolerancesampletolerance numeric(5,2) # filtersfilters _text default '{ifu,u,g,r,i}'::text[] [] nexposuresnexposures integer[] [] obs_seqobs_seq _text [] seq_repeatsseq_repeats integer # seq_completedseq_completed integer # last_obs_jdlast_obs_jd float8 # creationdatecreationdate timestamp default now() d lastmodifiedlastmodified timestamp default now() d allocation_idallocation_id * bigint References allocation ( allocation_id -> id ) specTable public.spec Pk spec_pkey ( id ) idid * bigint Referred by classification ( spec_id -> id ) Referred by flexure ( spec_id_1 -> id ) Referred by flexure ( spec_id_2 -> id ) spec_calib_idspec_calib_id * bigint References spec_calib ( spec_calib_id -> id ) Unq spec_observation_id_key ( observation_id ) observation_idobservation_id * bigint References observation ( observation_id -> id ) asciifileasciifile text t npyfilenpyfile text t fitsfilefitsfile text t imgsetimgset text t qualityquality * integer # cubefilecubefile text t standardfilestandardfile text t spec_marshal_spec_id_key ( marshal_spec_id ) marshal_spec_idmarshal_spec_id bigint # skysubskysub * bool b fwhmfwhm numeric(5,2) # backgroundbackground numeric(7,2) # line_fwhmline_fwhm numeric(5,3) # extract_xextract_x float8 # extract_yextract_y float8 # extract_paextract_pa float8 # extract_aextract_a float8 # extract_bextract_b float8 # ad_redad_red float8 # ad_bluead_blue float8 # prlltcprlltc float8 # flexure_x_corr_nmflexure_x_corr_nm float8 # flexure_y_corr_pixflexure_y_corr_pix float8 # reducerreducer float8 # spec_calibTable public.spec_calib Pk spec_calib_pkey ( id ) idid * bigint Referred by spec ( spec_calib_id -> id ) dome_masterdome_master text t bias_slow_masterbias_slow_master text t flatflat text t cosmic_filtercosmic_filter bool b drpverdrpver text t hg_masterhg_master text t cd_mastercd_master text t xe_masterxe_master text t avg_rmsavg_rms float8 # min_rmsmin_rms float8 # max_rmsmax_rms float8 # bias_fast_masterbias_fast_master text t telescope_statsTable public.telescope_stats Pk telescope_stats_pkey ( id ) idid * bigint # Unq telescope_stats_observation_id_key ( observation_id ) observation_idobservation_id * bigint References observation ( observation_id -> id ) telescope_stats_date_key ( date ) datedate * timestamp d dome_statusdome_status text t in_tempin_temp numeric(5,2) # in_humin_hum numeric(5,2) # in_dewin_dew numeric(5,2) # out_tempout_temp numeric(5,2) # out_humout_hum numeric(5,2) # out_dewout_dew numeric(5,2) # wind_dirwind_dir numeric(5,2) # wsp_curwsp_cur numeric(5,2) # wsp_avgwsp_avg numeric(5,2) # mir_tempmir_temp numeric(5,2) # top_airtop_air numeric(5,2) # pri_temppri_temp numeric(5,2) # sec_tempsec_temp numeric(5,2) # flo_tempflo_temp numeric(5,2) # bot_tempbot_temp numeric(5,2) # mid_tempmid_temp numeric(5,2) # top_temptop_temp numeric(5,2) # focposfocpos numeric(5,3) # ifufocusifufocus numeric(5,2) # ifufoc2ifufoc2 numeric(5,2) # usergroupsTable public.usergroups Pk user_groups ( user_id, group_id ) user_iduser_id * bigint References users ( user_id -> id ) Pk user_groups ( user_id, group_id ) group_idgroup_id * bigint References groups ( group_id -> id ) usersTable public.users Pk users_pkey ( id ) idid * bigint Referred by news ( newsuser -> id ) Referred by request ( user_id -> id ) Referred by usergroups ( user_id -> id ) Unq users_username_key ( username ) usernameusername * text t namename text t emailemail text t passwordpassword * text t objectTable public.object Pk object_pkey ( id ) idid * bigint Referred by catalogform ( object_id -> id ) Referred by classification ( object_id -> id ) Referred by earth_satellite ( object_id -> id ) Referred by elliptical_heliocentric ( object_id -> id ) Referred by hyperbolic_heliocentric ( object_id -> id ) Referred by observation ( object_id -> id ) Referred by parabolic_heliocentric ( object_id -> id ) Referred by periodic ( object_id -> id ) Referred by request ( object_id -> id ) Unq object_marshal_id_key ( marshal_id ) marshal_idmarshal_id bigint # object_name_key ( name ) namename * text t Unq object_iauname_key ( iauname ) iaunameiauname text t rara numeric(12,8) # decdec numeric(12,8) # typedesigtypedesig varchar(1) t epochepoch text t magnitudemagnitude numeric(7,5) # creationdatecreationdate * timestamp default now() d discovery_datediscovery_date timestamp d--more-- catalogformTable public.catalogform Pk pk_catalogform_id ( id ) idid * bigint # elemlineelemline text t idx_catalogform_object_id ( object_id ) object_idobject_id bigint References object ( object_id -> id )


Table allocation
IndexesField NameData TypeDescription
* id bigint
  inidate timestamp
  enddate timestamp
  time_spent interval
  time_allocated interval
  color text
designator text
* program_id bigint
  active bool DEFAULT true
Indexes
allocation_pkey ON id
allocation_designator_key ON designator
Foreign Keys
allocation_program ( program_id ) ref program (id)


Table astrometry
IndexesField NameData TypeDescription
* id bigint
  object_id bigint
observation_id bigint
  output_file varchar( 50 )
  abpair bool
  crpix1 integer
  crpix2 integer
  a_ra_off numeric( 8, 4 )
  a_dec_off numeric( 8, 4 )
  b_ra_off numeric( 8, 4 )
  b_dec_off numeric( 8, 4 )
  solved bool
  solved_time float8
  reducer varchar( 50 )
Indexes
pk_astrometry_astid ON id
idx_astrometry_observation_id ON observation_id
Foreign Keys
fk_astrometry_observation ( observation_id ) ref observation (id)


Table catalogform
IndexesField NameData TypeDescription
* id bigint
  elemline text
object_id bigint
Indexes
pk_catalogform_id ON id
idx_catalogform_object_id ON object_id
Foreign Keys
fk_catalogform_object ( object_id ) ref object (id)


Table classification
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
* spec_id bigint
classification text
redshift numeric( 7, 4 )
  redshift_err numeric( 7, 5 )
  phase numeric( 5, 2 )
  phase_err numeric( 5, 2 )
  classifier text
  score numeric( 5, 2 )
Indexes
classification_pkey ON id
classification_classification_key ON classification
classification_object_id_key ON object_id
classification_redshift_key ON redshift
classification_spec_id_key ON spec_id
Foreign Keys
classification_object ( object_id ) ref object (id)
classification_spec ( spec_id ) ref spec (id)


Table earth_satellite
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
  t timestamp
  inclination numeric( 12, 8 )
  ra numeric( 12, 8 )
  e numeric( 10, 8 )
  pedigree numeric( 12, 8 )
  m numeric( 12, 8 )
  n numeric( 12, 8 )
  decay numeric( 10, 8 )
  reforbit integer
  drag numeric( 10, 8 )
Indexes
earth_satellite_pkey ON id
earth_satellite_object_id_key ON object_id
Foreign Keys
object_earth_satellite ( object_id ) ref object (id)


Table elliptical_heliocentric
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
  inclination numeric( 12, 8 )
  longascnode_o numeric( 12, 8 )
  perihelion_o numeric( 12, 8 )
  a numeric( 13, 8 )
  n numeric( 10, 8 )
  e numeric( 10, 8 )
  m numeric( 12, 8 )
  mjdepoch numeric( 14, 8 )
  d numeric( 7, 2 )
  m1 numeric( 7, 4 )
  m2 numeric( 7, 4 )
  s numeric( 10, 8 )
Indexes
elliptical_heliocentric_pkey ON id
elliptical_heliocentric_object_id_key ON object_id
Foreign Keys
object_elliptical_heliocentric ( object_id ) ref object (id)


Table flexure
IndexesField NameData TypeDescription
* id bigint
  rms numeric( 8, 4 )
* spec_id_1 bigint
* spec_id_2 bigint
* timestamp1 timestamp
* timestamp2 timestamp
Indexes
flexure_pkey ON id
flexure_spec_id_1_key ON spec_id_1
Foreign Keys
flexure_spec ( spec_id_1 ) ref spec (id)
spec_flexure ( spec_id_2 ) ref spec (id)


Table groups
IndexesField NameData TypeDescription
* id bigint
* designator text
Indexes
groups_pkey ON id
groups_designator_key ON designator


Table growth
IndexesField NameData TypeDescription
* id bigserial
  status char( 20 )
  username varchar( 100 )
  enddate date
  programname varchar( 100 )
  startdate date
  sourceid integer
  followup varchar( 100 )
  prior_photometry text
  priority integer
  sourcename varchar( 100 )
* requestid integer
  filters varchar( 100 )
  ra real
  dec real
* created timestamp DEFAULT now()
request_filename varchar( 100 )
  last_mag_filter varchar( 10 )
  last_mag_jd real
  last_mag_exptime real
  last_mag_obsdate date
  last_mag_mag real
Indexes
pk_growth_id ON id
idx_growth_request_filename ON request_filename


Table hyperbolic_heliocentric
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
  t timestamp
  inclination numeric( 12, 8 )
  longascnode_o numeric( 12, 8 )
  perihelion_o numeric( 12, 8 )
  e numeric( 10, 8 )
  q numeric( 13, 8 )
  d numeric( 7, 2 )
  m1 numeric( 7, 4 )
  m2 numeric( 7, 4 )
  s numeric( 10, 8 )
Indexes
hyperbolic_heliocentric_pkey ON id
hyperbolic_heliocentric_object_id_key ON object_id
Foreign Keys
object_hyperbolic_heliocentric ( object_id ) ref object (id)


Table metrics_phot
IndexesField NameData TypeDescription
* id bigint
* phot_id bigint
  fwhm numeric( 5, 2 )
  background numeric( 6, 2 )
  zp numeric( 5, 2 )
  zperr numeric( 5, 2 )
  ellipticity numeric( 5, 2 )
  nsources integer
Indexes
metrics_phot_pkey ON id
metrics_phot_phot_id_key ON phot_id
Foreign Keys
metrics_phot_phot ( phot_id ) ref phot (id)


Table news
IndexesField NameData TypeDescription
* id bigserial
  createdate timestamp
  lastdisplaydate timestamp
newsuser bigint
* displaygroup bigserial
  comment_type varchar( 20 )
  comment_text text
Indexes
pk_news_id ON id
idx_news_displaygroup ON displaygroup
idx_news_newsuser ON newsuser
Foreign Keys
fk_news_groups ( displaygroup ) ref groups (id)
fk_news_users ( newsuser ) ref users (id)


Table object
IndexesField NameData TypeDescription
* id bigint
marshal_id bigint
* name text
iauname text
  ra numeric( 12, 8 )
  dec numeric( 12, 8 )
  typedesig varchar( 1 )
  epoch text
  magnitude numeric( 7, 5 )
* creationdate timestamp DEFAULT now()
  discovery_date timestamp
q3c_ang2ipix((ra)::double precision, ("dec")::double precision) varchar
Indexes
object_pkey ON id
object_iauname_key ON iauname
object_marshal_id_key ON marshal_id
coords_q3c ON q3c_ang2ipix((ra)::double precision, ("dec")::double precision)
object_name_key ON name


Table observation
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
* request_id bigint
* mjd numeric( 14, 8 )
* airmass numeric( 5, 2 )
  exptime numeric( 7, 2 )
  time_elapsed interval
* fitsfile text
  imtype text
  filter text
  ra numeric( 12, 8 )
  dec numeric( 12, 8 )
  camera text
  lst varchar( 20 )
Indexes
observation_pkey ON id
observation_fitsfile_key ON fitsfile
observation_object_id_key ON object_id
observation_request_id_key ON request_id
Foreign Keys
observation_object ( object_id ) ref object (id)
observation_request ( request_id ) ref request (id)


Table parabolic_heliocentric
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
  t timestamp
  inclination numeric( 12, 8 )
  perihelion_o numeric( 12, 8 )
  q numeric( 13, 8 )
  longascnode_o numeric( 12, 8 )
  d numeric( 7, 2 )
  m1 numeric( 7, 4 )
  m2 numeric( 7, 4 )
  s numeric( 10, 8 )
Indexes
parabolic_heliocentric_pkey ON id
parabolic_heliocentric_object_id_key ON object_id
Foreign Keys
object_parabolic_heliocentric ( object_id ) ref object (id)


Table periodic
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
  mjd0 numeric( 14, 8 )
  phasedays numeric( 12, 8 )
Indexes
periodic_pkey ON id
periodic_object_id_key ON object_id
Foreign Keys
object_periodic ( object_id ) ref object (id)


Table phot
IndexesField NameData TypeDescription
* id bigint
* phot_calib_id bigint
* observation_id bigint
* astrometry bool
* filter text
  reducedfile text
  sexfile text
  maskfile text
  pipeline text
marshal_phot_id bigint
Indexes
phot_pkey ON id
phot_observation_id_key ON observation_id
phot_marshal_phot_id ON marshal_phot_id
Foreign Keys
phot_observation ( observation_id ) ref observation (id)
phot_phot_calib ( phot_calib_id ) ref phot_calib (id)


Table phot_calib
IndexesField NameData TypeDescription
* id bigint
  bias text
  flat text
Indexes
phot_calib_pkey ON id


Table program
IndexesField NameData TypeDescription
* id bigint
* designator text
  name text
* group_id bigint
  pi text
  time_allocated interval
  priority numeric( 5, 2 )
  inidate timestamp
  enddate timestamp
  color text
Indexes
program_pkey ON id
program_designator_key ON designator
Foreign Keys
program_groups ( group_id ) ref groups (id)


Table ref_stars
IndexesField NameData TypeDescription
* id bigint
* phot_id bigint
  ra numeric( 12, 8 )
  dec numeric( 12, 8 )
* survey text
* filter text
mag numeric( 7, 4 )
  magerr numeric( 5, 2 )
* instmag numeric( 5, 2 )
  istmagerr numeric( 5, 2 )
* mjd numeric( 14, 8 )
  x integer
  y integer
q3c_ang2ipix((ra)::double precision, ("dec")::double precision) varchar
Indexes
ref_stars_pkey ON id
ref_stars_coordsq3c ON q3c_ang2ipix((ra)::double precision, ("dec")::double precision)
ref_stars_filter_key ON filter
ref_stars_mag_key ON mag
Foreign Keys
ref_stars_phot ( phot_id ) ref phot (id)


Table request
IndexesField NameData TypeDescription
* id bigint
* object_id bigint
* user_id bigint
  marshal_id bigint
* exptime integer[]
  maxairmass numeric( 5, 2 ) DEFAULT 2.5
  max_fwhm numeric( 5, 3 )
  min_moon_dist numeric( 5, 2 )
  max_moon_illum numeric( 5, 4 )
  max_cloud_cover numeric( 5, 2 )
status text DEFAULT 'PENDING'::text
* priority numeric( 5, 2 )
* inidate timestamp
* enddate timestamp
  cadence numeric( 5, 2 )
  phasesamples numeric( 5, 2 )
  sampletolerance numeric( 5, 2 )
  filters _text DEFAULT '{ifu,u,g,r,i}'::text[]
  nexposures integer[]
  obs_seq _text
  seq_repeats integer
  seq_completed integer
  last_obs_jd float8
  creationdate timestamp DEFAULT now()
  lastmodified timestamp DEFAULT now()
* allocation_id bigint
Indexes
request_pkey ON id
request_object_id_key ON object_id
request_status_key ON status
Foreign Keys
request_allocation ( allocation_id ) ref allocation (id)
requests_objects ( object_id ) ref object (id)
users_request ( user_id ) ref users (id)


Table spec
IndexesField NameData TypeDescription
* id bigint
* spec_calib_id bigint
* observation_id bigint
  asciifile text
  npyfile text
  fitsfile text
  imgset text
* quality integer
  cubefile text
  standardfile text
marshal_spec_id bigint
* skysub bool
  fwhm numeric( 5, 2 )
  background numeric( 7, 2 )
  line_fwhm numeric( 5, 3 )
  extract_x float8
  extract_y float8
  extract_pa float8
  extract_a float8
  extract_b float8
  ad_red float8
  ad_blue float8
  prlltc float8
  flexure_x_corr_nm float8
  flexure_y_corr_pix float8
  reducer float8
Indexes
spec_pkey ON id
spec_observation_id_key ON observation_id
spec_marshal_spec_id_key ON marshal_spec_id
Foreign Keys
spec_observation ( observation_id ) ref observation (id)
spec_spec_calib ( spec_calib_id ) ref spec_calib (id)


Table spec_calib
IndexesField NameData TypeDescription
* id bigint
  dome_master text
  bias_slow_master text
  flat text
  cosmic_filter bool
  drpver text
  hg_master text
  cd_master text
  xe_master text
  avg_rms float8
  min_rms float8
  max_rms float8
  bias_fast_master text
Indexes
spec_calib_pkey ON id


Table telescope_stats
IndexesField NameData TypeDescription
* id bigint
* observation_id bigint
* date timestamp
  dome_status text
  in_temp numeric( 5, 2 )
  in_hum numeric( 5, 2 )
  in_dew numeric( 5, 2 )
  out_temp numeric( 5, 2 )
  out_hum numeric( 5, 2 )
  out_dew numeric( 5, 2 )
  wind_dir numeric( 5, 2 )
  wsp_cur numeric( 5, 2 )
  wsp_avg numeric( 5, 2 )
  mir_temp numeric( 5, 2 )
  top_air numeric( 5, 2 )
  pri_temp numeric( 5, 2 )
  sec_temp numeric( 5, 2 )
  flo_temp numeric( 5, 2 )
  bot_temp numeric( 5, 2 )
  mid_temp numeric( 5, 2 )
  top_temp numeric( 5, 2 )
  focpos numeric( 5, 3 )
  ifufocus numeric( 5, 2 )
  ifufoc2 numeric( 5, 2 )
Indexes
telescope_stats_pkey ON id
telescope_stats_observation_id_key ON observation_id
telescope_stats_date_key ON date
Foreign Keys
telescope_stats_observation ( observation_id ) ref observation (id)


Table usergroups
IndexesField NameData TypeDescription
* user_id bigint
* group_id bigint
Indexes
user_groups ON user_id, group_id
Foreign Keys
usergroups_groups ( group_id ) ref groups (id)
usergroups_users ( user_id ) ref users (id)


Table users
IndexesField NameData TypeDescription
* id bigint
* username text
  name text
  email text
* password text
Indexes
users_pkey ON id
users_username_key ON username

Powered by DbSchema