llo_e12 database schema:
| Table |
Column Information |
| CALIB_INFO |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CALDATA |
BLOB |
1048576 |
CALTYPE |
INTEGER |
4 |
CHANNEL |
VARCHAR |
64 |
COMMENT |
VARCHAR |
256 |
INSERTION_TIME |
TIMESTAMP |
10 |
ORIGIN |
VARCHAR |
128 |
ORIGIN_TIME |
INTEGER |
4 |
SUBMITTER |
VARCHAR |
48 |
UNITS |
VARCHAR |
64 |
VALID_END |
INTEGER |
4 |
VALID_START |
INTEGER |
4 |
|
| Table |
Column Information |
| COINC_SNGL |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COINC_ID |
CHARACTER |
13 |
COINC_QUALITY |
REAL |
4 |
COINC_TIME |
INTEGER |
4 |
COINC_TIME_NS |
INTEGER |
4 |
CREATOR_DB |
INTEGER |
4 |
GRB_ID |
VARCHAR |
64 |
GRB_SKY_DEC |
REAL |
4 |
GRB_SKY_RA |
REAL |
4 |
GRB_TIME |
INTEGER |
4 |
GRB_TIME_NS |
INTEGER |
4 |
H1_BURST_CDB |
INTEGER |
4 |
H1_BURST_ID |
CHARACTER |
13 |
H1_GDSTRIG_CDB |
INTEGER |
4 |
H1_GDSTRIG_ID |
CHARACTER |
13 |
H1_INSPIRAL_CDB |
INTEGER |
4 |
H1_INSPIRAL_ID |
CHARACTER |
13 |
H1_RINGDOWN_CDB |
INTEGER |
4 |
H1_RINGDOWN_ID |
CHARACTER |
13 |
H1_UNMODELED_CDB |
INTEGER |
4 |
H1_UNMODELED_ID |
CHARACTER |
13 |
H2_BURST_CDB |
INTEGER |
4 |
H2_BURST_ID |
CHARACTER |
13 |
H2_GDSTRIG_CDB |
INTEGER |
4 |
H2_GDSTRIG_ID |
CHARACTER |
13 |
H2_INSPIRAL_CDB |
INTEGER |
4 |
H2_INSPIRAL_ID |
CHARACTER |
13 |
H2_RINGDOWN_CDB |
INTEGER |
4 |
H2_RINGDOWN_ID |
CHARACTER |
13 |
H2_UNMODELED_CDB |
INTEGER |
4 |
H2_UNMODELED_ID |
CHARACTER |
13 |
INSERTION_TIME |
TIMESTAMP |
10 |
INSPIRAL_MASS1 |
REAL |
4 |
INSPIRAL_MASS2 |
REAL |
4 |
L1_BURST_CDB |
INTEGER |
4 |
L1_BURST_ID |
CHARACTER |
13 |
L1_GDSTRIG_CDB |
INTEGER |
4 |
L1_GDSTRIG_ID |
CHARACTER |
13 |
L1_INSPIRAL_CDB |
INTEGER |
4 |
L1_INSPIRAL_ID |
CHARACTER |
13 |
L1_RINGDOWN_CDB |
INTEGER |
4 |
L1_RINGDOWN_ID |
CHARACTER |
13 |
L1_UNMODELED_CDB |
INTEGER |
4 |
L1_UNMODELED_ID |
CHARACTER |
13 |
LIGO_ANGLE |
REAL |
4 |
LIGO_ANGLE_SIG |
REAL |
4 |
LIGO_AXIS_DEC |
REAL |
4 |
LIGO_AXIS_RA |
REAL |
4 |
OTHER_EXTERNAL |
VARCHAR |
80 |
PROCESS_ID |
CHARACTER |
13 |
RINGDOWN_FREQ |
REAL |
4 |
RINGDOWN_MASS |
REAL |
4 |
RINGDOWN_Q |
REAL |
4 |
|
| Table |
Column Information |
| EXTTRIG_SEARCH |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DURATION |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
EXTTRIG_ID |
VARCHAR |
40 |
EXTTRIG_TYPE |
VARCHAR |
32 |
IFOS |
VARCHAR |
18 |
INSERTION_TIME |
TIMESTAMP |
10 |
LAG_1_2 |
REAL |
4 |
LAG_1_3 |
REAL |
4 |
LAG_1_4 |
REAL |
4 |
PERCENT_BAD |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
REF_DELAY |
REAL |
4 |
SEGMENT_TYPE |
INTEGER |
4 |
SNR |
REAL |
4 |
SOURCE_DEC |
REAL |
4 |
SOURCE_DEC_ERR |
REAL |
4 |
SOURCE_RA |
REAL |
4 |
SOURCE_RA_ERR |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
VAR_1 |
REAL |
4 |
VAR_2 |
REAL |
4 |
VAR_3 |
REAL |
4 |
VAR_4 |
REAL |
4 |
|
| Table |
Column Information |
| FILTER |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
FILTER_ID |
CHARACTER |
13 |
FILTER_NAME |
CHARACTER |
32 |
INSERTION_TIME |
TIMESTAMP |
10 |
PARAM_SET |
INTEGER |
4 |
PROCESS_ID |
CHARACTER |
13 |
PROGRAM |
CHARACTER |
16 |
START_TIME |
INTEGER |
4 |
|
| Table |
Column Information |
| FILTER_PARAMS |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
FILTER_ID |
CHARACTER |
13 |
FILTER_NAME |
CHARACTER |
32 |
INSERTION_TIME |
TIMESTAMP |
10 |
PARAM |
VARCHAR |
32 |
PROCESS_ID |
CHARACTER |
13 |
TYPE |
VARCHAR |
16 |
VALUE |
VARCHAR |
1024 |
|
| Table |
Column Information |
| FRAMESET |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CHANLIST_CDB |
INTEGER |
4 |
CHANLIST_ID |
CHARACTER |
13 |
CREATOR_DB |
INTEGER |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
FRAMESET_GROUP |
CHARACTER |
48 |
INSERTION_TIME |
TIMESTAMP |
10 |
MISSING_FRAMES |
INTEGER |
4 |
NAME |
VARCHAR |
80 |
N_BYTES |
INTEGER |
4 |
N_FRAMES |
INTEGER |
4 |
PROCESS_ID |
CHARACTER |
13 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
|
| Table |
Column Information |
| FRAMESET_CHANLIST |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CHANLIST |
CLOB |
524288 |
CHANLIST_ID |
CHARACTER |
13 |
CHANLIST_LENGTH |
INTEGER |
4 |
CREATOR_DB |
INTEGER |
4 |
END_TIME |
INTEGER |
4 |
FRAMESET_GROUP |
CHARACTER |
48 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
START_TIME |
INTEGER |
4 |
|
| Table |
Column Information |
| FRAMESET_LOC |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
DECOMPRESS_CMD |
VARCHAR |
128 |
FILENUM |
INTEGER |
4 |
FULLNAME |
VARCHAR |
128 |
INSERTION_TIME |
TIMESTAMP |
10 |
MEDIA_LOC |
VARCHAR |
48 |
MEDIA_STATUS |
CHARACTER |
8 |
MEDIA_TYPE |
CHARACTER |
16 |
NAME |
VARCHAR |
80 |
NODE |
VARCHAR |
48 |
|
| Table |
Column Information |
| FRAMESET_WRITER |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
DATA_SOURCE |
VARCHAR |
240 |
FRAMESET_GROUP |
CHARACTER |
48 |
IFOS |
CHARACTER |
12 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
PROGRAM |
CHARACTER |
16 |
|
| Table |
Column Information |
| GDS_TRIGGER |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| BANDWIDTH |
REAL |
4 |
BINARYDATA |
VARCHAR |
1024 |
BINARYDATA_LENGTH |
INTEGER |
4 |
CONFIDENCE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DISPOSITION |
INTEGER |
4 |
DURATION |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
FREQUENCY |
REAL |
4 |
FREQ_AVERAGE |
REAL |
4 |
FREQ_PEAK |
REAL |
4 |
FREQ_SIGMA |
REAL |
4 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
NAME |
VARCHAR |
32 |
NOISE_POWER |
REAL |
4 |
PIXEL_COUNT |
REAL |
4 |
PRIORITY |
INTEGER |
4 |
PROCESS_ID |
CHARACTER |
13 |
SIGNAL_POWER |
REAL |
4 |
SIGNIFICANCE |
REAL |
4 |
SIZE |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
SUBTYPE |
VARCHAR |
64 |
TIME_AVERAGE |
REAL |
4 |
TIME_PEAK |
REAL |
4 |
TIME_SIGMA |
REAL |
4 |
|
| Table |
Column Information |
| MULTI_BURST |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
BANDWIDTH |
REAL |
4 |
CENTRAL_FREQ |
REAL |
4 |
CONFIDENCE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DURATION |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
IFOS |
CHARACTER |
12 |
INSERTION_TIME |
TIMESTAMP |
10 |
LIGO_ANGLE |
REAL |
4 |
LIGO_ANGLE_SIG |
REAL |
4 |
LIGO_AXIS_DEC |
REAL |
4 |
LIGO_AXIS_RA |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
SNR |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
|
| Table |
Column Information |
| MULTI_INSPIRAL |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
CHISQ |
REAL |
4 |
CHISQ_DOF |
INTEGER |
4 |
COA_PHASE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
EFF_DISTANCE |
REAL |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
ETA |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
IFOS |
CHARACTER |
12 |
IMPULSE_TIME |
INTEGER |
4 |
IMPULSE_TIME_NS |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
LIGO_ANGLE |
REAL |
4 |
LIGO_ANGLE_SIG |
REAL |
4 |
LIGO_AXIS_DEC |
REAL |
4 |
LIGO_AXIS_RA |
REAL |
4 |
MASS1 |
REAL |
4 |
MASS2 |
REAL |
4 |
MCHIRP |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
SEARCH |
VARCHAR |
16 |
SIGMASQ |
REAL |
4 |
SNR |
REAL |
4 |
TAU0 |
REAL |
4 |
TAU2 |
REAL |
4 |
TAU3 |
REAL |
4 |
TAU4 |
REAL |
4 |
TAU5 |
REAL |
4 |
TTOTAL |
REAL |
4 |
|
| Table |
Column Information |
| PROCESS |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
CVS_ENTRY_TIME |
INTEGER |
4 |
CVS_REPOSITORY |
VARCHAR |
256 |
DOMAIN |
VARCHAR |
64 |
END_TIME |
INTEGER |
4 |
IFOS |
CHARACTER |
12 |
INSERTION_TIME |
TIMESTAMP |
10 |
IS_ONLINE |
INTEGER |
4 |
JOBID |
INTEGER |
4 |
NODE |
VARCHAR |
64 |
PARAM_SET |
INTEGER |
4 |
PROCESS_ID |
CHARACTER |
13 |
PROGRAM |
CHARACTER |
16 |
START_TIME |
INTEGER |
4 |
UNIX_PROCID |
INTEGER |
4 |
USERNAME |
CHARACTER |
16 |
VERSION |
VARCHAR |
64 |
|
| Table |
Column Information |
| PROCESS_PARAMS |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
PARAM |
VARCHAR |
32 |
PROCESS_ID |
CHARACTER |
13 |
PROGRAM |
CHARACTER |
16 |
TYPE |
VARCHAR |
16 |
VALUE |
VARCHAR |
1024 |
|
| Table |
Column Information |
| RUNLIST |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
1024 |
CREATOR_DB |
INTEGER |
4 |
END_TIME |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
RUN |
INTEGER |
4 |
RUN_TYPE |
VARCHAR |
64 |
SITE |
CHARACTER |
4 |
START_TIME |
INTEGER |
4 |
|
| Table |
Column Information |
| SEARCH_SUMMARY |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
IN_END_TIME |
INTEGER |
4 |
IN_END_TIME_NS |
INTEGER |
4 |
IN_START_TIME |
INTEGER |
4 |
IN_START_TIME_NS |
INTEGER |
4 |
LALWRAPPER_CVS_TAG |
VARCHAR |
128 |
LAL_CVS_TAG |
VARCHAR |
128 |
NEVENTS |
INTEGER |
4 |
NNODES |
INTEGER |
4 |
OUT_END_TIME |
INTEGER |
4 |
OUT_END_TIME_NS |
INTEGER |
4 |
OUT_START_TIME |
INTEGER |
4 |
OUT_START_TIME_NS |
INTEGER |
4 |
PROCESS_ID |
CHARACTER |
13 |
SHARED_OBJECT |
VARCHAR |
64 |
|
| Table |
Column Information |
| SEARCH_SUMMVARS |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
NAME |
VARCHAR |
64 |
PROCESS_ID |
CHARACTER |
13 |
STRING |
VARCHAR |
256 |
VALUE |
DOUBLE |
8 |
|
| Table |
Column Information |
| SEGMENT |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
SEGMENT_GROUP |
VARCHAR |
64 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
VERSION |
INTEGER |
4 |
|
| Table |
Column Information |
| SEGMENT_DEFINER |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
IFOS |
CHARACTER |
12 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
PROGRAM |
CHARACTER |
16 |
SEGMENT_GROUP |
VARCHAR |
64 |
VERSION |
INTEGER |
4 |
|
| Table |
Column Information |
| SIM_INST |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
SIMULATION_ID |
CHARACTER |
13 |
SIM_TYPE |
INTEGER |
4 |
S_BURST_COUNT |
INTEGER |
4 |
|
| Table |
Column Information |
| SIM_INST_PARAMS |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
64 |
CREATOR_DB |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
NAME |
VARCHAR |
24 |
SIMULATION_ID |
CHARACTER |
13 |
VALUE |
DOUBLE |
8 |
|
| Table |
Column Information |
| SIM_TYPE |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
64 |
INSERTION_TIME |
TIMESTAMP |
10 |
NAME |
VARCHAR |
24 |
SIM_TYPE |
INTEGER |
4 |
|
| Table |
Column Information |
| SIM_TYPE_PARAMS |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
64 |
NAME |
VARCHAR |
24 |
SIM_TYPE |
INTEGER |
4 |
VALUE |
DOUBLE |
8 |
|
| Table |
Column Information |
| SNGL_BLOCK |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| BAND_INDEX |
INTEGER |
4 |
CHANNEL |
VARCHAR |
64 |
CREATOR_DB |
INTEGER |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
MEAN |
REAL |
4 |
MEAN_ZERO |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
RHO_N_END |
DOUBLE |
8 |
RHO_N_START |
DOUBLE |
8 |
SEARCH |
VARCHAR |
24 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
VARIANCE |
REAL |
4 |
VARIANCE_ZERO |
REAL |
4 |
|
| Table |
Column Information |
| SNGL_BURST |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
BANDWIDTH |
REAL |
4 |
CENTRAL_FREQ |
REAL |
4 |
CHANNEL |
VARCHAR |
64 |
CONFIDENCE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DURATION |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
FHIGH |
REAL |
4 |
FILTER_ID |
CHARACTER |
13 |
FLOW |
REAL |
4 |
HRSS |
REAL |
4 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
MS_BANDWIDTH |
REAL |
4 |
MS_CONFIDENCE |
REAL |
4 |
MS_DURATION |
REAL |
4 |
MS_FHIGH |
REAL |
4 |
MS_FLOW |
REAL |
4 |
MS_HRSS |
REAL |
4 |
MS_SNR |
REAL |
4 |
MS_START_TIME |
INTEGER |
4 |
MS_START_TIME_NS |
INTEGER |
4 |
MS_STOP_TIME |
INTEGER |
4 |
MS_STOP_TIME_NS |
INTEGER |
4 |
PARAM_ONE_NAME |
VARCHAR |
64 |
PARAM_ONE_VALUE |
DOUBLE |
8 |
PARAM_THREE_NAME |
VARCHAR |
64 |
PARAM_THREE_VALUE |
DOUBLE |
8 |
PARAM_TWO_NAME |
VARCHAR |
64 |
PARAM_TWO_VALUE |
DOUBLE |
8 |
PEAK_FREQUENCY |
REAL |
4 |
PEAK_FREQUENCY_ERROR |
REAL |
4 |
PEAK_STRAIN |
REAL |
4 |
PEAK_STRAIN_ERROR |
REAL |
4 |
PEAK_TIME |
INTEGER |
4 |
PEAK_TIME_ERROR |
REAL |
4 |
PEAK_TIME_NS |
INTEGER |
4 |
PROCESS_ID |
CHARACTER |
13 |
SEARCH |
VARCHAR |
24 |
SNR |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
STOP_TIME |
INTEGER |
4 |
STOP_TIME_NS |
INTEGER |
4 |
TFVOLUME |
REAL |
4 |
TIME_LAG |
REAL |
4 |
|
| Table |
Column Information |
| SNGL_DATASOURCE |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CHANNELS |
VARCHAR |
512 |
CREATOR_DB |
INTEGER |
4 |
DATA_SOURCE |
VARCHAR |
240 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
EVENT_ID |
CHARACTER |
13 |
EVENT_TABLE |
CHARACTER |
18 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
|
| Table |
Column Information |
| SNGL_DPERIODIC |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
CHANNEL |
VARCHAR |
64 |
CONFIDENCE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DURATION |
REAL |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
FREQUENCY |
DOUBLE |
8 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
PHASE |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
SEARCH |
VARCHAR |
24 |
SKY_DEC |
DOUBLE |
8 |
SKY_RA |
DOUBLE |
8 |
SNR |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
STAT_NAME |
VARCHAR |
32 |
STAT_PROB |
REAL |
4 |
STAT_VALUE |
REAL |
4 |
TARGET_NAME |
CHARACTER |
32 |
|
| Table |
Column Information |
| SNGL_INSPIRAL |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| ALPHA |
REAL |
4 |
AMPLITUDE |
REAL |
4 |
CHANNEL |
VARCHAR |
64 |
CHISQ |
REAL |
4 |
CHISQ_DOF |
INTEGER |
4 |
COA_PHASE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
EFF_DISTANCE |
REAL |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_GMST |
DOUBLE |
8 |
END_TIME_NS |
INTEGER |
4 |
ETA |
REAL |
4 |
EVENT_DURATION |
DOUBLE |
8 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
F_FINAL |
REAL |
4 |
IFO |
CHARACTER |
2 |
IMPULSE_TIME |
INTEGER |
4 |
IMPULSE_TIME_NS |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
MASS1 |
REAL |
4 |
MASS2 |
REAL |
4 |
MCHIRP |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
PSI0 |
REAL |
4 |
PSI3 |
REAL |
4 |
SEARCH |
VARCHAR |
24 |
SIGMASQ |
DOUBLE |
8 |
SNR |
REAL |
4 |
TAU0 |
REAL |
4 |
TAU2 |
REAL |
4 |
TAU3 |
REAL |
4 |
TAU4 |
REAL |
4 |
TAU5 |
REAL |
4 |
TEMPLATE_DURATION |
DOUBLE |
8 |
TTOTAL |
REAL |
4 |
|
| Table |
Column Information |
| SNGL_MIME |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| COMMENT |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
DESCRIP |
VARCHAR |
64 |
EVENT_ID |
CHARACTER |
13 |
EVENT_TABLE |
CHARACTER |
18 |
FILENAME |
VARCHAR |
64 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
MIMEDATA |
BLOB |
1048576 |
MIMEDATA_LENGTH |
INTEGER |
4 |
MIMETYPE |
VARCHAR |
64 |
ORIGIN |
VARCHAR |
64 |
PROCESS_ID |
CHARACTER |
13 |
SNGL_MIME_ID |
CHARACTER |
13 |
SUBMITTER |
VARCHAR |
48 |
|
| Table |
Column Information |
| SNGL_RINGDOWN |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
CHANNEL |
VARCHAR |
64 |
CONFIDENCE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DURATION |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
FREQUENCY |
REAL |
4 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
MASS |
REAL |
4 |
PROCESS_ID |
CHARACTER |
13 |
Q |
REAL |
4 |
SNR |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
|
| Table |
Column Information |
| SNGL_TRANSDATA |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
DATA_TYPE |
CHARACTER |
16 |
DATA_UNITS |
CHARACTER |
16 |
DIMENSIONS |
INTEGER |
4 |
EVENT_ID |
CHARACTER |
13 |
EVENT_TABLE |
CHARACTER |
18 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
TRANSDATA |
BLOB |
1048576 |
TRANSDATA_LENGTH |
INTEGER |
4 |
TRANSDATA_NAME |
VARCHAR |
32 |
X_BINS |
INTEGER |
4 |
X_END |
DOUBLE |
8 |
X_START |
DOUBLE |
8 |
X_UNITS |
CHARACTER |
16 |
Y_BINS |
INTEGER |
4 |
Y_END |
DOUBLE |
8 |
Y_START |
DOUBLE |
8 |
Y_UNITS |
CHARACTER |
16 |
|
| Table |
Column Information |
| SNGL_UNMODELED |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| AMPLITUDE |
REAL |
4 |
CHANNEL |
VARCHAR |
64 |
CONFIDENCE |
REAL |
4 |
CREATOR_DB |
INTEGER |
4 |
DURATION |
REAL |
4 |
EVENT_ID |
CHARACTER |
13 |
FILTER_ID |
CHARACTER |
13 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
SEARCH |
VARCHAR |
24 |
SNR |
REAL |
4 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
|
| Table |
Column Information |
| SNGL_UNMODELED_V |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
EVENT_ID |
CHARACTER |
13 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
NAME |
VARCHAR |
32 |
PROCESS_ID |
CHARACTER |
13 |
VALUE |
REAL |
4 |
|
| Table |
Column Information |
| SUMM_COMMENT |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CREATOR_DB |
INTEGER |
4 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
FRAMESET_GROUP |
VARCHAR |
48 |
IFO |
CHARACTER |
2 |
INSERTION_TIME |
TIMESTAMP |
10 |
PROCESS_ID |
CHARACTER |
13 |
PROGRAM |
CHARACTER |
16 |
SEGMENT_GROUP |
VARCHAR |
64 |
START_TIME |
INTEGER |
4 |
START_TIME_NS |
INTEGER |
4 |
SUBMITTER |
VARCHAR |
48 |
SUMM_COMMENT_ID |
CHARACTER |
13 |
TEXT |
VARCHAR |
1000 |
VERSION |
INTEGER |
4 |
|
| Table |
Column Information |
| SUMM_CSD |
| Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
Column |
Type |
Size |
| CHANNEL1 |
VARCHAR |
240 |
CHANNEL2 |
VARCHAR |
240 |
CREATOR_DB |
INTEGER |
4 |
DELTA_FREQUENCY |
DOUBLE |
8 |
END_TIME |
INTEGER |
4 |
END_TIME_NS |
INTEGER |
4 |
FRAMESET_GROUP |
VARCHAR |
48 |
FRAMES_USED |
INTEGER |
4 |
INSERTION_TIME |
TIMESTAMP |
10 |
MIMETYPE |
VARCHAR |
64 |
PRO |
|