Schema pyros
(1/1)
DDL script
CREATE SCHEMA IF NOT EXISTS `pyros` DEFAULT CHARACTER SET utf8
Table request
(1/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
user_id INT Yes
scientificprogram_id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
created DATETIME No
updated DATETIME No
is_alert BOOLEAN No 0 0 = routine 1 = alert
type ENUM('alert', 'routine', 'svom TOO', 'svom GP') No
status ENUM('INCOMPLETE', 'SUBMITTED', 'PLANNED', 'EXECUTING', 'EXECUTED') No
target_or_theme VARCHAR(45) No
priority INT No
autodeposit BOOLEAN No =1 si automatic =0 si manual (web)
checkpoint VARCHAR(45) No
flag VARCHAR(45) No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_request_user Non-Identifying user request 1:n
fk_request_scientificprogram Non-Identifying scientificprogram request 1:n
fk_sequence_request Non-Identifying request sequence 1:n
fk_reqalert_requests1 Non-Identifying request alert 1:1
Table Comments
A complete observation (set of sequences) Includes at least one sequence and meets following criteria: • Observation of the same target or eventually a set of coherent targets or a specific field for calibration • The sequences of a request are not executed contiguously in time • Any observation demand is defined as one or several Requests • The observer is the request owner
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`request` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `user_id` INT NOT NULL,
  `scientificprogram_id` INT NOT NULL,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `is_alert` TINYINT(1) NULL DEFAULT 0 COMMENT '\n0 = routine\n1 = alert',
  `type` ENUM('alert', 'routine', 'svom TOO', 'svom GP') NULL,
  `status` ENUM('INCOMPLETE', 'SUBMITTED', 'PLANNED', 'EXECUTING', 'EXECUTED') NULL,
  `target_or_theme` VARCHAR(45) NULL,
  `priority` INT NULL,
  `autodeposit` TINYINT(1) NULL COMMENT '\n=1 si automatic =0 si manual (web)',
  `checkpoint` VARCHAR(45) NULL,
  `flag` VARCHAR(45) NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_request_user_idx` (`user_id` ASC),
  INDEX `fk_request_scientificprogram_idx` (`scientificprogram_id` ASC),
  CONSTRAINT `fk_request_user`
    FOREIGN KEY (`user_id`)
    REFERENCES `pyros`.`user` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_request_scientificprogram`
    FOREIGN KEY (`scientificprogram_id`)
    REFERENCES `pyros`.`scientificprogram` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'A complete observation (set of sequences)' /* comment truncated */ /*
Includes at least one sequence and meets following criteria:

• Observation of the same target or eventually a set of coherent targets or a specific field for calibration

• The sequences of a request are not executed contiguously in time

• Any observation demand is defined as one or several Requests

• The observer is the request owner
*/
Table album
(2/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
sequence_id INT Yes
detector_id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
created DATETIME No
updated DATETIME No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_album_sequence Non-Identifying sequence album 1:n
fk_album_detector Non-Identifying detector album 1:n
fk_plan_album Non-Identifying album plan 1:n
Table Comments
Series of Plans belonging to a Sequence and observed with the same detector
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`album` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `sequence_id` INT NOT NULL,
  `detector_id` INT NOT NULL,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_album_detector_idx` (`detector_id` ASC),
  INDEX `fk_album_sequence_idx` (`sequence_id` ASC),
  CONSTRAINT `fk_album_sequence`
    FOREIGN KEY (`sequence_id`)
    REFERENCES `pyros`.`sequence` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_album_detector`
    FOREIGN KEY (`detector_id`)
    REFERENCES `pyros`.`detector` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Series of Plans belonging to a Sequence and observed with th' /* comment truncated */ /*e same detector*/
Table plan
(3/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
album_id INT Yes
filter_id INT Yes
name VARCHAR(45) No
desc VARCHAR(45) No
created DATETIME No
updated DATETIME No
duration FLOAT No
position VARCHAR(45) No
exposure_time FLOAT No
nb_images INT No
dithering BOOLEAN No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_plan_album Non-Identifying album plan 1:n
fk_plan_filter Non-Identifying filter plan 1:n
fk_image_plan Non-Identifying plan image 1:n
Table Comments
Acquisition of a series of images by one of the instruments of the focal plane with the same features: • Same filter for all the duration of a Plan • Same exposure time • Number of images defined • Same mode Dithering/ or not for NIR instrument
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`plan` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `album_id` INT NOT NULL,
  `filter_id` INT NOT NULL,
  `name` VARCHAR(45) NULL,
  `desc` VARCHAR(45) NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `duration` FLOAT NULL,
  `position` VARCHAR(45) NULL,
  `exposure_time` FLOAT NULL,
  `nb_images` INT NULL,
  `dithering` TINYINT(1) NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_plan_album_idx` (`album_id` ASC),
  INDEX `fk_plan_filter_idx` (`filter_id` ASC),
  CONSTRAINT `fk_plan_album`
    FOREIGN KEY (`album_id`)
    REFERENCES `pyros`.`album` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_plan_filter`
    FOREIGN KEY (`filter_id`)
    REFERENCES `pyros`.`filter` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Acquisition of a series of images by one of the instruments ' /* comment truncated */ /*f the focal plane with the same features:

• Same filter for all the duration of a Plan
• Same exposure time
• Number of images defined
• Same mode Dithering/ or not for NIR instrument
*/
Table sequence
(4/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
request_id INT Yes
sequencetype_id INT Yes
schedule_id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
created DATETIME No
updated DATETIME No
is_alert BOOLEAN No
status ENUM('INCOMPLETE', 'SUBMITTED', 'TOBEPLANNED', 'OBSERVABLE', 'PLANNED', 'EXECUTING', 'EXECUTED') No
duration FLOAT No 20 mn max (mmss)
pointing VARCHAR(45) No
with_drift BOOLEAN No
priority INT No u_priotity + r_priority
analysis_method VARCHAR(45) No
exec_start DATETIME Yes if exec_start_datetime only, then sequence must start at a precise date and time if exec_stop_datetime is not null, then sequence must start between a time slot [exec_start_datetime, exec_stop_datetime]
exec_stop DATETIME No
moon_min INT No angle de garde à la lune
alt_min INT No angle de garde par rapport à l'horizon
type ENUM('image', 'alerte', 'dark', 'bias', 'flat') No Image, alerte; dark,Bias, flat
img_current VARCHAR(45) No
img_total VARCHAR(45) No
not_obs BOOLEAN No
obsolete BOOLEAN No
processing BOOLEAN No
flag VARCHAR(45) No flag de synchro
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_sequence_sequencetype Non-Identifying sequencetype sequence 1:n
fk_sequence_request Non-Identifying request sequence 1:n
fk_sequence_schedule Non-Identifying schedule sequence 1:n
fk_album_sequence Non-Identifying sequence album 1:n
fk_schedules_has_sequences_sequences1 Non-Identifying sequence schedule_has_sequences 1:n
Table Comments
Collection of Albums, and thus of Plans with the following features: • Same pointing with or without drift • The sequence is endowed with a priority; its execution will be conditioned by the planning of other sequences with more priority; during execution, the sequence can be interrupted every time to give way to a higher priority sequence • The observations are carried out with one or two cameras • The length of a sequence is variable and cannot exceed 20 minutes (TBC) • The sequence can include parameters that indicate which method must be used to analyze data (RT or remote) • For each sequence the observer defines an execution date and time. It is a time slot or a precise time for starting the observation • The sequence ends synchronously for all involved instruments. • The sequence includes several Albums, one per detector • The owner of the sequence is a heritage of the Request owner
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`sequence` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `request_id` INT NOT NULL,
  `sequencetype_id` INT NOT NULL,
  `schedule_id` INT NOT NULL,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `is_alert` TINYINT(1) NULL,
  `status` ENUM('INCOMPLETE', 'SUBMITTED', 'TOBEPLANNED', 'OBSERVABLE', 'PLANNED', 'EXECUTING', 'EXECUTED') NULL,
  `duration` FLOAT NULL COMMENT '\n20 mn max (mmss)',
  `pointing` VARCHAR(45) NULL,
  `with_drift` TINYINT(1) NULL,
  `priority` INT NULL COMMENT '\nu_priotity + r_priority',
  `analysis_method` VARCHAR(45) NULL,
  `exec_start` DATETIME NOT NULL COMMENT '\nif exec_start_datetime only, then sequence must start at a precise date and time\n\nif exec_stop_datetime is not null, then sequence must start between a time slot [exec_start_datetime, exec_stop_datetime]',
  `exec_stop` DATETIME NULL,
  `moon_min` INT NULL COMMENT '\nangle de garde à la lune',
  `alt_min` INT NULL COMMENT '\nangle de garde par rapport à l\'horizon',
  `type` ENUM('image', 'alerte', 'dark', 'bias', 'flat') NULL COMMENT '\nImage, alerte; dark,Bias, flat',
  `img_current` VARCHAR(45) NULL,
  `img_total` VARCHAR(45) NULL,
  `not_obs` TINYINT(1) NULL,
  `obsolete` TINYINT(1) NULL,
  `processing` TINYINT(1) NULL,
  `flag` VARCHAR(45) NULL COMMENT '\nflag de synchro',
  PRIMARY KEY (`id`),
  INDEX `fk_sequence_sequencetype_idx` (`sequencetype_id` ASC),
  INDEX `fk_sequence_request_idx` (`request_id` ASC),
  INDEX `fk_sequence_schedule_idx` (`schedule_id` ASC),
  CONSTRAINT `fk_sequence_sequencetype`
    FOREIGN KEY (`sequencetype_id`)
    REFERENCES `pyros`.`sequencetype` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_sequence_request`
    FOREIGN KEY (`request_id`)
    REFERENCES `pyros`.`request` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_sequence_schedule`
    FOREIGN KEY (`schedule_id`)
    REFERENCES `pyros`.`schedule` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Collection of Albums, and thus of Plans with the following f' /* comment truncated */ /*atures:

• Same pointing with or without drift

• The sequence is endowed with a priority; its execution will be conditioned by the
planning of other sequences with more priority; during execution, the sequence
can be interrupted every time to give way to a higher priority sequence

• The observations are carried out with one or two cameras

• The length of a sequence is variable and cannot exceed 20 minutes (TBC)

• The sequence can include parameters that indicate which method must be used to
analyze data (RT or remote)

• For each sequence the observer defines an execution date and time. It is a time
slot or a precise time for starting the observation

• The sequence ends synchronously for all involved instruments. 

• The sequence includes several Albums, one per detector

• The owner of the sequence is a heritage of the Request owner
*/
Table image
(5/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
plan_id INT Yes
nrtanalysis_id INT No
name VARCHAR(45) No
desc TINYTEXT No
created DATETIME No
updated DATETIME No
date_from_gps VARCHAR(45) No =1 : heure donnée par le GPS,=0 heure donnée par le PC
level INT No 0 = level 0 1 = level 1a (+ corrections) 2 = level 1b (+ analysis)
type ENUM('image', 'dark', 'flat', 'bias') No
quality VARCHAR(45) No
flaggps VARCHAR(45) No
exposure VARCHAR(45) No
tempext VARCHAR(45) No
pressure VARCHAR(45) No
humidext VARCHAR(45) No
wind VARCHAR(45) No
wind_dir VARCHAR(45) No
dwnimg VARCHAR(45) No
dwncata VARCHAR(45) No
dwn VARCHAR(45) No
level0_fits_name VARCHAR(45) No name of FITS image level 0 on disk
level1a_fits_name VARCHAR(45) No name of FITS image level 1a on disk (after corrections)
level1b_fits_name VARCHAR(45) No name of FITS image level 1b on disk (after analysis)
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_image_plan Non-Identifying plan image 1:n
fk_image_nrtanalysis Non-Identifying nrtanalysis image 1:n
Table Comments
Basis component. Its acquisition can be interrupted by an interruption of sequence but it must be saved before quitting
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `plan_id` INT NOT NULL,
  `nrtanalysis_id` INT NULL,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `date_from_gps` VARCHAR(45) NULL COMMENT '\n =1 : heure donnée par le GPS,=0  heure donnée par le PC',
  `level` INT NULL COMMENT '0 = level 0\n1 = level 1a (+ corrections)\n2 = level 1b (+ analysis)',
  `type` ENUM('image', 'dark', 'flat', 'bias') NULL,
  `quality` VARCHAR(45) NULL,
  `flaggps` VARCHAR(45) NULL,
  `exposure` VARCHAR(45) NULL,
  `tempext` VARCHAR(45) NULL,
  `pressure` VARCHAR(45) NULL,
  `humidext` VARCHAR(45) NULL,
  `wind` VARCHAR(45) NULL,
  `wind_dir` VARCHAR(45) NULL,
  `dwnimg` VARCHAR(45) NULL,
  `dwncata` VARCHAR(45) NULL,
  `dwn` VARCHAR(45) NULL,
  `level0_fits_name` VARCHAR(45) NULL COMMENT 'name of FITS image level 0 on disk',
  `level1a_fits_name` VARCHAR(45) NULL COMMENT 'name of FITS image level 1a on disk (after corrections)',
  `level1b_fits_name` VARCHAR(45) NULL COMMENT 'name of FITS image level 1b on disk (after analysis)',
  PRIMARY KEY (`id`),
  INDEX `fk_image_plan_idx` (`plan_id` ASC),
  INDEX `fk_image_nrtanalysis_idx` (`nrtanalysis_id` ASC),
  CONSTRAINT `fk_image_plan`
    FOREIGN KEY (`plan_id`)
    REFERENCES `pyros`.`plan` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_image_nrtanalysis`
    FOREIGN KEY (`nrtanalysis_id`)
    REFERENCES `pyros`.`nrtanalysis` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Basis component. Its acquisition can be interrupted by an in' /* comment truncated */ /*terruption of sequence but it must be saved before quitting*/
Table alert
(6/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
request_id INT Yes
strategyobs_id INT Yes
voevent_xml LONGTEXT No
type VARCHAR(45) No alert type
client VARCHAR(45) No
burst_jd VARCHAR(45) No
burst_ra VARCHAR(45) No Right ascension (deg)
burst_dec VARCHAR(45) No declinaison (deg)
equinox VARCHAR(45) No
jd_pkt INT No JD of packet creation by GCN
jd_send INT No JD of packet send by GCN
jd_received INT No JD of packet received
trigger_instrum VARCHAR(45) No
trigger_num VARCHAR(45) No
grb_error VARCHAR(45) No error box (arcmin)
def_not_grb BOOLEAN No =1 if not GRB
editor VARCHAR(45) No client that sent the notice
flag VARCHAR(45) No Flag de synchro
idgcn_notice INT No identifiant notice
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_reqalert_requests1 Non-Identifying request alert 1:1
fk_alertrequests_strategyobs1 Non-Identifying strategyobs alert 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`alert` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `request_id` INT NOT NULL,
  `strategyobs_id` INT NOT NULL,
  `voevent_xml` LONGTEXT NULL,
  `type` VARCHAR(45) NULL COMMENT '\nalert type',
  `client` VARCHAR(45) NULL,
  `burst_jd` VARCHAR(45) NULL,
  `burst_ra` VARCHAR(45) NULL COMMENT '\nRight ascension (deg)',
  `burst_dec` VARCHAR(45) NULL COMMENT '\ndeclinaison (deg)',
  `equinox` VARCHAR(45) NULL,
  `jd_pkt` INT NULL COMMENT '\n JD of packet creation by GCN',
  `jd_send` INT NULL COMMENT '\nJD of packet send by GCN',
  `jd_received` INT NULL COMMENT '\nJD of packet received',
  `trigger_instrum` VARCHAR(45) NULL,
  `trigger_num` VARCHAR(45) NULL,
  `grb_error` VARCHAR(45) NULL COMMENT '\nerror box (arcmin)',
  `def_not_grb` TINYINT(1) NULL COMMENT '\n =1 if not GRB',
  `editor` VARCHAR(45) NULL COMMENT '\n\nclient that sent the notice',
  `flag` VARCHAR(45) NULL COMMENT '\n\nFlag de synchro',
  `idgcn_notice` INT NULL COMMENT '\nidentifiant notice',
  PRIMARY KEY (`id`),
  INDEX `fk_reqalert_request1_idx` (`request_id` ASC),
  INDEX `fk_alertrequests_strategyobs1_idx` (`strategyobs_id` ASC),
  CONSTRAINT `fk_reqalert_requests1`
    FOREIGN KEY (`request_id`)
    REFERENCES `pyros`.`request` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_alertrequests_strategyobs1`
    FOREIGN KEY (`strategyobs_id`)
    REFERENCES `pyros`.`strategyobs` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
Table schedulehistory
(7/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
created DATETIME No
day_start DATETIME No
day_stop DATETIME No
flag VARCHAR(45) No flag de synchro
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_schedules_has_sequences_schedules1 Non-Identifying schedulehistory schedule_has_sequences 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`schedulehistory` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `created` DATETIME NULL,
  `day_start` DATETIME NULL,
  `day_stop` DATETIME NULL,
  `flag` VARCHAR(45) NULL COMMENT '\nflag de synchro',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table telescope
(8/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
device_id INT Yes
mount_type ENUM('slewing', 'observing') No equ or altaz
diameter FLOAT No aperture diameter (m)
status VARCHAR(45) No
latitude DOUBLE No (deg)
longitude DOUBLE No (deg)
sens VARCHAR(1) No E ou W
altitude FLOAT No (m)
readout_time INT No controler read out (s)
slew_time INT No tipical delay for pointing (s)
slew_dead INT No delay after pointing (s)
slew_rate_max FLOAT No most rapid slew for pointing (deg/s)
horizon_type VARCHAR(45) No type of coordinates for horizondef (altaz or hadec)
horizon_def DOUBLE No define horizon elevation amers
lim_dec_max DOUBLE No highest limit of declination (deg)
lim_dec_min DOUBLE No lowest limit of declination (deg)
lim_ha_rise DOUBLE No eastern rotation limit (deg)
lim_ha_set DOUBLE No western rotation limit (deg)
address VARCHAR(45) No post address
night_elev_sun DOUBLE No Max elevation of the sun to observe (deg)
mpc_code VARCHAR(45) No Minor Planet Center code of the observatory
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_telescope_device Non-Identifying device telescope 1:1
fk_detector_telescope Non-Identifying telescope detector 1:n
Table Comments
Convention pour LIMHARISE et LIMASSET En asimuth : 0 --> sud 90 --> est
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`telescope` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `device_id` INT NOT NULL,
  `mount_type` ENUM('slewing', 'observing') NULL COMMENT '\nequ or altaz',
  `diameter` FLOAT NULL COMMENT '\naperture diameter (m)',
  `status` VARCHAR(45) NULL,
  `latitude` DOUBLE NULL COMMENT '\n(deg)',
  `longitude` DOUBLE NULL COMMENT '\n(deg)',
  `sens` VARCHAR(1) NULL COMMENT '\nE ou W',
  `altitude` FLOAT NULL COMMENT '\n(m)',
  `readout_time` INT NULL COMMENT '\ncontroler read out (s)',
  `slew_time` INT NULL COMMENT '\ntipical delay for pointing (s)',
  `slew_dead` INT NULL COMMENT '\ndelay after pointing (s)',
  `slew_rate_max` FLOAT NULL COMMENT '\nmost rapid slew for pointing (deg/s)',
  `horizon_type` VARCHAR(45) NULL COMMENT '\ntype of coordinates for horizondef (altaz or hadec)',
  `horizon_def` DOUBLE NULL COMMENT '\ndefine horizon elevation amers',
  `lim_dec_max` DOUBLE NULL COMMENT '\nhighest limit of declination (deg)',
  `lim_dec_min` DOUBLE NULL COMMENT '\nlowest limit of declination  (deg)',
  `lim_ha_rise` DOUBLE NULL COMMENT '\neastern rotation limit (deg)',
  `lim_ha_set` DOUBLE NULL COMMENT '\nwestern rotation limit (deg)',
  `address` VARCHAR(45) NULL COMMENT '\npost address',
  `night_elev_sun` DOUBLE NULL COMMENT '\nMax elevation of the sun to observe (deg)',
  `mpc_code` VARCHAR(45) NULL COMMENT '\nMinor Planet Center code of the observatory',
  PRIMARY KEY (`id`),
  INDEX `fk_telescope_device_idx` (`device_id` ASC),
  CONSTRAINT `fk_telescope_device`
    FOREIGN KEY (`device_id`)
    REFERENCES `pyros`.`device` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Convention pour LIMHARISE et LIMASSET\rEn asimuth :\r0 --> sud' /* comment truncated */ /*
90 --> est

*/
Table weatherwatch
(9/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
updated DATETIME No
humid_int FLOAT No
humid_ext FLOAT No
wind FLOAT No (m/s)
wind_dir VARCHAR(1) No 'N=0 E=90 S=180 W=270'
temp_int FLOAT No
temp_ext FLOAT No
pressure FLOAT No
rain FLOAT No
dwn VARCHAR(45) No
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`weatherwatch` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `updated` DATETIME NULL,
  `humid_int` FLOAT NULL,
  `humid_ext` FLOAT NULL,
  `wind` FLOAT NULL COMMENT '\n(m/s)',
  `wind_dir` VARCHAR(1) NULL COMMENT '\n \'N=0 E=90 S=180 W=270\'',
  `temp_int` FLOAT NULL,
  `temp_ext` FLOAT NULL,
  `pressure` FLOAT NULL,
  `rain` FLOAT NULL,
  `dwn` VARCHAR(45) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table sitewatch
(10/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
updated DATETIME No
lights VARCHAR(45) No
dome VARCHAR(45) No
doors VARCHAR(45) No
temperature FLOAT No
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`sitewatch` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `updated` DATETIME NULL,
  `lights` VARCHAR(45) NULL,
  `dome` VARCHAR(45) NULL,
  `doors` VARCHAR(45) NULL,
  `temperature` FLOAT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table sitewatchhistory
(11/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`sitewatchhistory` (
  `id` INT NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table nrtanalysis
(12/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
created DATETIME No
updated DATETIME No
analysis LONGTEXT No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_image_nrtanalysis Non-Identifying nrtanalysis image 1:n
Table Comments
Level 1b analysis results
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`nrtanalysis` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `analysis` LONGTEXT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
COMMENT = 'Level 1b analysis results'
Table filter
(13/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
device_id INT Yes
detector_id INT Yes
category CHAR(1) No One letter to describe the filter family : 'E,F,G,H,I,J,K...'
transmission_curve_doc VARCHAR(45) No pdf doc that describes the transmission curve
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_filter_detector Non-Identifying detector filter 1:n
fk_filter_device Non-Identifying device filter 1:1
fk_plan_filter Non-Identifying filter plan 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`filter` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `device_id` INT NOT NULL,
  `detector_id` INT NOT NULL,
  `category` CHAR(1) NULL COMMENT '\nOne letter to describe the filter family :\n\'E,F,G,H,I,J,K...\'',
  `transmission_curve_doc` VARCHAR(45) NULL COMMENT '\npdf doc that describes the transmission curve',
  PRIMARY KEY (`id`),
  INDEX `fk_filter_detector_idx` (`detector_id` ASC),
  INDEX `fk_filter_device_idx` (`device_id` ASC),
  CONSTRAINT `fk_filter_detector`
    FOREIGN KEY (`detector_id`)
    REFERENCES `pyros`.`detector` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_filter_device`
    FOREIGN KEY (`device_id`)
    REFERENCES `pyros`.`device` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
Table detector
(14/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
device_id INT Yes
telescope_id INT Yes
status ENUM('idle', 'working', 'hs') No
nb_photo_x INT No number of photosite along X
nb_photo_y INT No number of photosite along Y
photo_size_x INT No size of photosite along X (um/photosite)
photo_size_y INT No size of photosite along Y (um/photosite)
has_shutter BOOLEAN No
equivalent_foc_len VARCHAR(45) No equivalent focal lenght (m)
acq_start DATETIME No date of beginning acquisition
acq_stop DATETIME No date of stopping acquisition
check_temp DOUBLE No operating temperature (Celsius)
gain FLOAT No gain (electron/ADU)
readout_noise FLOAT No readout noise (electron)
readout_time FLOAT No sec delay for coder reading
idcam_readout_mode INT No mode of pixel reading
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_detector_telescope Non-Identifying telescope detector 1:n
fk_detector_device Non-Identifying device detector 1:1
fk_album_detector Non-Identifying detector album 1:n
fk_filter_detector Non-Identifying detector filter 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`detector` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `device_id` INT NOT NULL,
  `telescope_id` INT NOT NULL,
  `status` ENUM('idle', 'working', 'hs') NULL,
  `nb_photo_x` INT NULL COMMENT '\nnumber  of photosite along X',
  `nb_photo_y` INT NULL COMMENT '\nnumber of photosite along Y',
  `photo_size_x` INT NULL COMMENT '\nsize of photosite along X (um/photosite)',
  `photo_size_y` INT NULL COMMENT '\nsize of photosite along Y (um/photosite)',
  `has_shutter` TINYINT(1) NULL,
  `equivalent_foc_len` VARCHAR(45) NULL COMMENT '\nequivalent focal lenght (m)',
  `acq_start` DATETIME NULL COMMENT '\ndate of beginning acquisition',
  `acq_stop` DATETIME NULL COMMENT '\ndate of stopping acquisition',
  `check_temp` DOUBLE NULL COMMENT '\noperating temperature (Celsius)',
  `gain` FLOAT NULL COMMENT '\ngain (electron/ADU)',
  `readout_noise` FLOAT NULL COMMENT '\nreadout noise (electron)',
  `readout_time` FLOAT NULL COMMENT '\nsec delay for coder reading',
  `idcam_readout_mode` INT NULL COMMENT '\n\nmode of pixel reading',
  PRIMARY KEY (`id`),
  INDEX `fk_detector_telescope_idx` (`telescope_id` ASC),
  INDEX `fk_detector_device_idx` (`device_id` ASC),
  CONSTRAINT `fk_detector_telescope`
    FOREIGN KEY (`telescope_id`)
    REFERENCES `pyros`.`telescope` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_detector_device`
    FOREIGN KEY (`device_id`)
    REFERENCES `pyros`.`device` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
Table user
(15/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
country_id INT Yes
userlevel_id INT Yes (ros leveladmin)
name VARCHAR(45) No (
desc TINYTEXT No
created DATETIME No
updated DATETIME No
firstname VARCHAR(45) No
email VARCHAR(45) No
url VARCHAR(45) No
tel1 VARCHAR(45) No
tel2 VARCHAR(45) No
address VARCHAR(45) No
login VARCHAR(15) No
pass VARCHAR(45) No
last_connect DATETIME No
cur_connect DATETIME No current time during connection
putvalid_beg DATETIME No permission first date of connection
putvalid_end DATETIME No permission last date of connection
acqvalid_beg VARCHAR(45) No first date to acquire images
acqvalid_end VARCHAR(45) No last date to acquire images
quota FLOAT No quota in % of allocated observation time
quota_rea FLOAT No
u_priority INT No default priority level for requests (average level)
p_priority INT No default priority level for image processing queue
dir_level INT No if <0 ability to explore data system
can_del_void_req BOOLEAN No ALLOW_TO_DELETE_EMPTY_REQUEST_(WITHOUT_SCENE)
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_user_country1 Non-Identifying country user 1:n
fk_users_uprofile1 Non-Identifying userlevel user 1:n
fk_request_user Non-Identifying user request 1:n
fk_users_has_scientificprograms_users1 Non-Identifying user user_has_scientificprograms 1:n
Table Comments
Default user for a SVOM alert is « SVOM_alert »
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`user` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `country_id` INT NOT NULL,
  `userlevel_id` INT NOT NULL COMMENT '\n(ros leveladmin)',
  `name` VARCHAR(45) NULL COMMENT '\n(',
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `firstname` VARCHAR(45) NULL,
  `email` VARCHAR(45) NULL,
  `url` VARCHAR(45) NULL,
  `tel1` VARCHAR(45) NULL,
  `tel2` VARCHAR(45) NULL,
  `address` VARCHAR(45) NULL,
  `login` VARCHAR(15) NULL,
  `pass` VARCHAR(45) NULL,
  `last_connect` DATETIME NULL,
  `cur_connect` DATETIME NULL COMMENT '\ncurrent time during connection',
  `putvalid_beg` DATETIME NULL COMMENT '\npermission first date of connection',
  `putvalid_end` DATETIME NULL COMMENT '\npermission last date of connection',
  `acqvalid_beg` VARCHAR(45) NULL COMMENT '\nfirst date to acquire images',
  `acqvalid_end` VARCHAR(45) NULL COMMENT '\nlast date to acquire images',
  `quota` FLOAT NULL COMMENT '\nquota in % of allocated observation time',
  `quota_rea` FLOAT NULL,
  `u_priority` INT NULL COMMENT '\ndefault priority level for requests (average level)',
  `p_priority` INT NULL COMMENT '\ndefault priority level for image processing queue ',
  `dir_level` INT NULL COMMENT '\nif <0 ability to explore data system',
  `can_del_void_req` TINYINT(1) NULL COMMENT '\nALLOW_TO_DELETE_EMPTY_REQUEST_(WITHOUT_SCENE)',
  PRIMARY KEY (`id`),
  INDEX `fk_user_country1_idx` (`country_id` ASC),
  INDEX `fk_users_uprofile1_idx` (`userlevel_id` ASC),
  CONSTRAINT `fk_user_country1`
    FOREIGN KEY (`country_id`)
    REFERENCES `pyros`.`country` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_uprofile1`
    FOREIGN KEY (`userlevel_id`)
    REFERENCES `pyros`.`userlevel` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Default user for a SVOM alert is « SVOM_alert »'
Table country
(16/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
quota FLOAT No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_user_country1 Non-Identifying country user 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`country` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `quota` FLOAT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table scientificprogram
(17/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
quota FLOAT No
priority INT No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_request_scientificprogram Non-Identifying scientificprogram request 1:n
fk_users_has_scientificprograms_scientificprograms1 Non-Identifying scientificprogram user_has_scientificprograms 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`scientificprogram` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `quota` FLOAT NULL,
  `priority` INT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table strategyobs
(18/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc MEDIUMTEXT No
json_file VARCHAR(45) No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_alertrequests_strategyobs1 Non-Identifying strategyobs alert 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`strategyobs` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` MEDIUMTEXT NULL,
  `json_file` VARCHAR(45) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table device
(19/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
created DATETIME No
updated DATETIME No
is_online BOOLEAN No 1 1=online, 0=offline
status ENUM('online', 'offline', 'maintenance', 'dead', 'busy', 'paused') No
maintenance_date DATETIME No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_telescope_device Non-Identifying device telescope 1:1
fk_filter_device Non-Identifying device filter 1:1
fk_detector_device Non-Identifying device detector 1:1
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`device` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `created` DATETIME NULL,
  `updated` DATETIME NULL,
  `is_online` TINYINT(1) NULL DEFAULT 1 COMMENT '1=online, 0=offline',
  `status` ENUM('online', 'offline', 'maintenance', 'dead', 'busy', 'paused') NULL,
  `maintenance_date` DATETIME NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table userlevel
(20/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc MEDIUMTEXT No
priority INT No
quota FLOAT No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_users_uprofile1 Non-Identifying userlevel user 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`userlevel` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` MEDIUMTEXT NULL,
  `priority` INT NULL,
  `quota` FLOAT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table sequencetype
(21/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
name VARCHAR(45) No
desc TINYTEXT No
priority INT No
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_sequence_sequencetype Non-Identifying sequencetype sequence 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`sequencetype` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `desc` TINYTEXT NULL,
  `priority` INT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table weatherwatchhistory
(22/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
datetime DATETIME No
humid_int VARCHAR(45) No
humid_ext VARCHAR(45) No
wind VARCHAR(45) No (m/s)
wind_dir VARCHAR(45) No 'N=0 E=90 S=180 W=270'
temp_int VARCHAR(45) No
temp_ext VARCHAR(45) No
pressure VARCHAR(45) No
rain VARCHAR(45) No
dwn VARCHAR(45) No
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`weatherwatchhistory` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `datetime` DATETIME NULL,
  `humid_int` VARCHAR(45) NULL,
  `humid_ext` VARCHAR(45) NULL,
  `wind` VARCHAR(45) NULL COMMENT '\n(m/s)',
  `wind_dir` VARCHAR(45) NULL COMMENT '\n \'N=0 E=90 S=180 W=270\'',
  `temp_int` VARCHAR(45) NULL,
  `temp_ext` VARCHAR(45) NULL,
  `pressure` VARCHAR(45) NULL,
  `rain` VARCHAR(45) NULL,
  `dwn` VARCHAR(45) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table schedule_has_sequences
(23/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
FK schedulehistory_id INT Yes
FK sequence_id INT Yes
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_schedules_has_sequences_schedules1 Identifying schedulehistory schedule_has_sequences 1:n
fk_schedules_has_sequences_sequences1 Identifying sequence schedule_has_sequences 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`schedule_has_sequences` (
  `schedulehistory_id` INT NOT NULL,
  `sequence_id` INT NOT NULL,
  PRIMARY KEY (`schedulehistory_id`, `sequence_id`),
  INDEX `fk_schedules_has_sequences_sequences1_idx` (`sequence_id` ASC),
  INDEX `fk_schedules_has_sequences_schedules1_idx` (`schedulehistory_id` ASC),
  CONSTRAINT `fk_schedules_has_sequences_schedules1`
    FOREIGN KEY (`schedulehistory_id`)
    REFERENCES `pyros`.`schedulehistory` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_schedules_has_sequences_sequences1`
    FOREIGN KEY (`sequence_id`)
    REFERENCES `pyros`.`sequence` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
Table schedule
(24/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
PK id INT Yes
created DATETIME No
day_start DATETIME No
day_stop DATETIME No
flag VARCHAR(45) No flag de synchro
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_sequence_schedule Non-Identifying schedule sequence 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`schedule` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `created` DATETIME NULL,
  `day_start` DATETIME NULL,
  `day_stop` DATETIME NULL,
  `flag` VARCHAR(45) NULL COMMENT '\nflag de synchro',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
Table user_has_scientificprograms
(25/25)
Table Properties
Average Row Length n/a Use Check Sum no
Connection String n/a Default Character Set n/a
Default Collation n/a Delay Key Updates no
Minimal Row Count n/a Maximum Row Count n/a
Union Tables n/a Merge Method n/a
Pack Keys n/a Has Password no
Data Directory n/a Index Directory n/a
Engine InnoDB Row Format n/a
Columns
Key Column Name Datatype Not Null Default Comment
FK user_id INT Yes
FK scientificprogram_id INT Yes
Relationships
Relationship Name Relationship Type Parent Table Child Table Card.
fk_users_has_scientificprograms_users1 Identifying user user_has_scientificprograms 1:n
fk_users_has_scientificprograms_scientificprograms1 Identifying scientificprogram user_has_scientificprograms 1:n
DDL script
CREATE TABLE IF NOT EXISTS `pyros`.`user_has_scientificprograms` (
  `user_id` INT NOT NULL,
  `scientificprogram_id` INT NOT NULL,
  PRIMARY KEY (`user_id`, `scientificprogram_id`),
  INDEX `fk_users_has_scientificprograms_scientificprograms1_idx` (`scientificprogram_id` ASC),
  INDEX `fk_users_has_scientificprograms_users1_idx` (`user_id` ASC),
  CONSTRAINT `fk_users_has_scientificprograms_users1`
    FOREIGN KEY (`user_id`)
    REFERENCES `pyros`.`user` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_has_scientificprograms_scientificprograms1`
    FOREIGN KEY (`scientificprogram_id`)
    REFERENCES `pyros`.`scientificprogram` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB