| Schema Name | pyros |
| Table Name | request |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | 0 |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 0 = routine 1 = alert |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | ENUM('alert', 'routine', 'svom TOO', 'svom GP') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | ENUM('INCOMPLETE', 'SUBMITTED', 'PLANNED', 'EXECUTING', 'EXECUTED') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | =1 si automatic =0 si manual (web) |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | request |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | album |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | plan |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | ENUM('INCOMPLETE', 'SUBMITTED', 'TOBEPLANNED', 'OBSERVABLE', 'PLANNED', 'EXECUTING', 'EXECUTED') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 20 mn max (mmss) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | u_priotity + r_priority |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 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] |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | angle de garde à la lune |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | angle de garde par rapport à l'horizon |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | Image, alerte; dark,Bias, flat |
| Datatype | ENUM('image', 'alerte', 'dark', 'bias', 'flat') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | sequence |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | flag de synchro |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | Foreign key |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | =1 : heure donnée par le GPS,=0 heure donnée par le PC |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 0 = level 0 1 = level 1a (+ corrections) 2 = level 1b (+ analysis) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | ENUM('image', 'dark', 'flat', 'bias') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | name of FITS image level 0 on disk |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | name of FITS image level 1a on disk (after corrections) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | image |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | name of FITS image level 1b on disk (after analysis) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | LONGTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | alert type |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | Right ascension (deg) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | declinaison (deg) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | JD of packet creation by GCN |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | JD of packet send by GCN |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | JD of packet received |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | error box (arcmin) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | =1 if not GRB |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | client that sent the notice |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | Flag de synchro |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | alert |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | identifiant notice |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedulehistory |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedulehistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedulehistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedulehistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedulehistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | flag de synchro |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | equ or altaz |
| Datatype | ENUM('slewing', 'observing') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | aperture diameter (m) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | E ou W |
| Datatype | VARCHAR(1) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | (m) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | controler read out (s) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | tipical delay for pointing (s) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | delay after pointing (s) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | most rapid slew for pointing (deg/s) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | type of coordinates for horizondef (altaz or hadec) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | define horizon elevation amers |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | highest limit of declination (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | lowest limit of declination (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | eastern rotation limit (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | western rotation limit (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | post address |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | Max elevation of the sun to observe (deg) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | telescope |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | Minor Planet Center code of the observatory |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | (m/s) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 'N=0 E=90 S=180 W=270' |
| Datatype | VARCHAR(1) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatch |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatch |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sitewatchhistory |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | nrtanalysis |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | nrtanalysis |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | nrtanalysis |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | nrtanalysis |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | nrtanalysis |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | nrtanalysis |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | LONGTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | filter |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | filter |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | filter |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | filter |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | One letter to describe the filter family : 'E,F,G,H,I,J,K...' |
| Datatype | CHAR(1) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | filter |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | pdf doc that describes the transmission curve |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | ENUM('idle', 'working', 'hs') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | number of photosite along X |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | number of photosite along Y |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | size of photosite along X (um/photosite) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | size of photosite along Y (um/photosite) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | equivalent focal lenght (m) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | date of beginning acquisition |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | date of stopping acquisition |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | operating temperature (Celsius) |
| Datatype | DOUBLE |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | gain (electron/ADU) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | readout noise (electron) |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | sec delay for coder reading |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | detector |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | mode of pixel reading |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | (ros leveladmin) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | ( |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(15) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | current time during connection |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | permission first date of connection |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | permission last date of connection |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | first date to acquire images |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | last date to acquire images |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | quota in % of allocated observation time |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | default priority level for requests (average level) |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | default priority level for image processing queue |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | if <0 ability to explore data system |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | ALLOW_TO_DELETE_EMPTY_REQUEST_(WITHOUT_SCENE) |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | country |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | country |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | country |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | country |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | scientificprogram |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | scientificprogram |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | scientificprogram |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | scientificprogram |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | scientificprogram |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | strategyobs |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | strategyobs |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | strategyobs |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | MEDIUMTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | strategyobs |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | 1 |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 1=online, 0=offline |
| Datatype | BOOLEAN |
| Is User Type | Yes |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | ENUM('online', 'offline', 'maintenance', 'dead', 'busy', 'paused') |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | device |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | userlevel |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | userlevel |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | userlevel |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | MEDIUMTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | userlevel |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | userlevel |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | FLOAT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequencetype |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequencetype |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequencetype |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | TINYTEXT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | sequencetype |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | (m/s) |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | 'N=0 E=90 S=180 W=270' |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | weatherwatchhistory |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule_has_sequences |
| Key Part | Primary key, Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule_has_sequences |
| Key Part | Primary key, Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule |
| Key Part | Primary key |
| Nullable | No |
| Default Value | |
| Auto Increment | Yes |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | DATETIME |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | schedule |
| Key Part | |
| Nullable | Yes |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment | flag de synchro |
| Datatype | VARCHAR(45) |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user_has_scientificprograms |
| Key Part | Primary key, Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Schema Name | pyros |
| Table Name | user_has_scientificprograms |
| Key Part | Primary key, Foreign key |
| Nullable | No |
| Default Value | |
| Auto Increment | No |
| Character Set | Schema Default |
| Collation Name | Schema Default |
| Comment |
| Datatype | INT |
| Is User Type | No |
| Parent Table | user |
| Child Table | request |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | scientificprogram |
| Child Table | request |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | sequence |
| Child Table | album |
| Cardinality | 1:n |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | detector |
| Child Table | album |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | album |
| Child Table | plan |
| Cardinality | 1:n |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | filter |
| Child Table | plan |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | sequencetype |
| Child Table | sequence |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | request |
| Child Table | sequence |
| Cardinality | 1:n |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | schedule |
| Child Table | sequence |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | plan |
| Child Table | image |
| Cardinality | 1:n |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | nrtanalysis |
| Child Table | image |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | request |
| Child Table | alert |
| Cardinality | 1:1 |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | strategyobs |
| Child Table | alert |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | device |
| Child Table | telescope |
| Cardinality | 1:1 |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | detector |
| Child Table | filter |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | device |
| Child Table | filter |
| Cardinality | 1:1 |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | telescope |
| Child Table | detector |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | device |
| Child Table | detector |
| Cardinality | 1:1 |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | country |
| Child Table | user |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | No |
| Parent Table | userlevel |
| Child Table | user |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | schedulehistory |
| Child Table | schedule_has_sequences |
| Cardinality | 1:n |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | sequence |
| Child Table | schedule_has_sequences |
| Cardinality | 1:n |
| Delete Rule | CASCADE |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | user |
| Child Table | user_has_scientificprograms |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |
| Parent Table | scientificprogram |
| Child Table | user_has_scientificprograms |
| Cardinality | 1:n |
| Delete Rule | NO ACTION |
| Update Rule | NO ACTION |
| Is Mandatory | Yes |