1.- Review of pending requests: =============================== 1.1.- Request #10 (D. Given): ----------------------------- --> Add new column "nread" to NETMAG table. ------------------------------------------------------------------------ ==> Request has been approved but the implementation is on hold until: 1.- NC is done migrating to the new CISN software. 2.- SC is done migrating to the leap seconds compliant code. ------------------------------------------------------------------------ 1.2.- Request #119 (E. Yu): --------------------------- --> Remove amp02 constraint (amplitude > 0) from amp table. ------------------------------------------------------------------------ ==> SCWG wants to have Standards group opinion. Standards group members unanimously agreed that there is no value in preserving the sign of an amplitude; P. Friberg agreed to withdraw the request. ------------------------------------------------------------------------ ------------------------------------------------------------------------ ==> Withdrawn. ------------------------------------------------------------------------ 1.3.- Request #53 (D. Given): ----------------------------- --> Add integer attribute for each channel to hold COSMOS "Table 6" value. ------------------------------------------------------------------------ ==> A. Walter is currently involved in NSMP project. We should wait until he has more information concerning this matter. ------------------------------------------------------------------------ 1.4.- Request #19 (D. Given): ----------------------------- --> Add "timequality" to WAVEFORM. ------------------------------------------------------------------------ ==> D. Neuhauser sent an email to Egill about his concerns. Request was clarified by Egill during the Standards call; Clock quality would be associated with a pick, not a waveform. ------------------------------------------------------------------------ ------------------------------------------------------------------------ ==> Discussed. D.Neuhauser will send email to Egill. Should we store the datalogger type as well? Different dataloggers have different representations of the quality. ------------------------------------------------------------------------ 2.- New requests: ================= 2.1.- Request #109 (E. Yu): --------------------------- ----------------------------------------------------------------- --> Change lddate to include timezone (change datatype to timestamp with time zone). To prevent confusion and proper handling of timestamps, the lddate column should include timezone information. The decision to implement this should be independent of whether this column is populated uniformly. ----------------------------------------------------------------- ------------------------------------------------------------------------ ==> Withdrawn. ------------------------------------------------------------------------ 2.2.- Request #4 (B. Worden): ----------------------------- ----------------------------------------------------------------- --> Add new association table between amps and events. Need to associate amplitudes with events. (The schema originally had this association, and it was removed at Caltech's request, due to performance implications in the real-time system when events were merged). ----------------------------------------------------------------- ------------------------------------------------------------------------ ==> Discussed. ------------------------------------------------------------------------