Schema Overview
Schema pyros
Back to overview
Columns (254)
request
.id
request
.user_id
request
.scientificprogram_id
request
.name
request
.desc
request
.created
request
.updated
request
.is_alert
request
.type
request
.status
request
.target_or_theme
request
.priority
request
.autodeposit
request
.checkpoint
request
.flag
album
.id
album
.sequence_id
album
.detector_id
album
.name
album
.desc
album
.created
album
.updated
plan
.id
plan
.album_id
plan
.filter_id
plan
.name
plan
.desc
plan
.created
plan
.updated
plan
.duration
plan
.position
plan
.exposure_time
plan
.nb_images
plan
.dithering
sequence
.id
sequence
.request_id
sequence
.sequencetype_id
sequence
.schedule_id
sequence
.name
sequence
.desc
sequence
.created
sequence
.updated
sequence
.is_alert
sequence
.status
sequence
.duration
sequence
.pointing
sequence
.with_drift
sequence
.priority
sequence
.analysis_method
sequence
.exec_start
sequence
.exec_stop
sequence
.moon_min
sequence
.alt_min
sequence
.type
sequence
.img_current
sequence
.img_total
sequence
.not_obs
sequence
.obsolete
sequence
.processing
sequence
.flag
image
.id
image
.plan_id
image
.nrtanalysis_id
image
.name
image
.desc
image
.created
image
.updated
image
.date_from_gps
image
.level
image
.type
image
.quality
image
.flaggps
image
.exposure
image
.tempext
image
.pressure
image
.humidext
image
.wind
image
.wind_dir
image
.dwnimg
image
.dwncata
image
.dwn
image
.level0_fits_name
image
.level1a_fits_name
image
.level1b_fits_name
alert
.id
alert
.request_id
alert
.strategyobs_id
alert
.voevent_xml
alert
.type
alert
.client
alert
.burst_jd
alert
.burst_ra
alert
.burst_dec
alert
.equinox
alert
.jd_pkt
alert
.jd_send
alert
.jd_received
alert
.trigger_instrum
alert
.trigger_num
alert
.grb_error
alert
.def_not_grb
alert
.editor
alert
.flag
alert
.idgcn_notice
schedulehistory
.id
schedulehistory
.created
schedulehistory
.day_start
schedulehistory
.day_stop
schedulehistory
.flag
telescope
.id
telescope
.device_id
telescope
.mount_type
telescope
.diameter
telescope
.status
telescope
.latitude
telescope
.longitude
telescope
.sens
telescope
.altitude
telescope
.readout_time
telescope
.slew_time
telescope
.slew_dead
telescope
.slew_rate_max
telescope
.horizon_type
telescope
.horizon_def
telescope
.lim_dec_max
telescope
.lim_dec_min
telescope
.lim_ha_rise
telescope
.lim_ha_set
telescope
.address
telescope
.night_elev_sun
telescope
.mpc_code
weatherwatch
.id
weatherwatch
.updated
weatherwatch
.humid_int
weatherwatch
.humid_ext
weatherwatch
.wind
weatherwatch
.wind_dir
weatherwatch
.temp_int
weatherwatch
.temp_ext
weatherwatch
.pressure
weatherwatch
.rain
weatherwatch
.dwn
sitewatch
.id
sitewatch
.updated
sitewatch
.lights
sitewatch
.dome
sitewatch
.doors
sitewatch
.temperature
sitewatchhistory
.id
nrtanalysis
.id
nrtanalysis
.name
nrtanalysis
.desc
nrtanalysis
.created
nrtanalysis
.updated
nrtanalysis
.analysis
filter
.id
filter
.device_id
filter
.detector_id
filter
.category
filter
.transmission_curve_doc
detector
.id
detector
.device_id
detector
.telescope_id
detector
.status
detector
.nb_photo_x
detector
.nb_photo_y
detector
.photo_size_x
detector
.photo_size_y
detector
.has_shutter
detector
.equivalent_foc_len
detector
.acq_start
detector
.acq_stop
detector
.check_temp
detector
.gain
detector
.readout_noise
detector
.readout_time
detector
.idcam_readout_mode
user
.id
user
.country_id
user
.userlevel_id
user
.name
user
.desc
user
.created
user
.updated
user
.firstname
user
.email
user
.url
user
.tel1
user
.tel2
user
.address
user
.login
user
.pass
user
.last_connect
user
.cur_connect
user
.putvalid_beg
user
.putvalid_end
user
.acqvalid_beg
user
.acqvalid_end
user
.quota
user
.quota_rea
user
.u_priority
user
.p_priority
user
.dir_level
user
.can_del_void_req
country
.id
country
.name
country
.desc
country
.quota
scientificprogram
.id
scientificprogram
.name
scientificprogram
.desc
scientificprogram
.quota
scientificprogram
.priority
strategyobs
.id
strategyobs
.name
strategyobs
.desc
strategyobs
.json_file
device
.id
device
.name
device
.desc
device
.created
device
.updated
device
.is_online
device
.status
device
.maintenance_date
userlevel
.id
userlevel
.name
userlevel
.desc
userlevel
.priority
userlevel
.quota
sequencetype
.id
sequencetype
.name
sequencetype
.desc
sequencetype
.priority
weatherwatchhistory
.id
weatherwatchhistory
.datetime
weatherwatchhistory
.humid_int
weatherwatchhistory
.humid_ext
weatherwatchhistory
.wind
weatherwatchhistory
.wind_dir
weatherwatchhistory
.temp_int
weatherwatchhistory
.temp_ext
weatherwatchhistory
.pressure
weatherwatchhistory
.rain
weatherwatchhistory
.dwn
schedule_has_sequences
.schedulehistory_id
schedule_has_sequences
.sequence_id
schedule
.id
schedule
.created
schedule
.day_start
schedule
.day_stop
schedule
.flag
user_has_scientificprograms
.user_id
user_has_scientificprograms
.scientificprogram_id
Indices (0)
Foreign Keys ()
request
.fk_request_user
request
.fk_request_scientificprogram
album
.fk_album_sequence
album
.fk_album_detector
plan
.fk_plan_album
plan
.fk_plan_filter
sequence
.fk_sequence_sequencetype
sequence
.fk_sequence_request
sequence
.fk_sequence_schedule
image
.fk_image_plan
image
.fk_image_nrtanalysis
alert
.fk_reqalert_requests1
alert
.fk_alertrequests_strategyobs1
telescope
.fk_telescope_device
filter
.fk_filter_detector
filter
.fk_filter_device
detector
.fk_detector_telescope
detector
.fk_detector_device
user
.fk_user_country1
user
.fk_users_uprofile1
schedule_has_sequences
.fk_schedules_has_sequences_schedules1
schedule_has_sequences
.fk_schedules_has_sequences_sequences1
user_has_scientificprograms
.fk_users_has_scientificprograms_users1
user_has_scientificprograms
.fk_users_has_scientificprograms_scientificprograms1
Triggers (0)