Activity #2482
closedFeature #1768: Software Design
Feature #3754: Design and development for oracle based Data storage and management system
Module #3755: Design of database tables
Module #1958: DB configuration
Activity #2226: Setup database with tables
Popuate data for unstructured data
100%
Description
create rows in miss_sensors for analog and digital hydrophones.
Create records in miss_dpl_sen to create miss_dpl_sen_id
update records in data_unstruct_store for miss_dpl_sen_id
Instead of multiple columns for different data locations, create the following:
1. DATA_TYPE column CHAR with values
A for Acoustic Noise Data –Live
O for Acoustic Noise 1/3rd Octave –Live
S for Acoustic Acoustic Noise Spectrogram –Live
P for Acoustic Noise PDF –Live
2. DATA_OR_LOC
The field stores either data itself or the location of data in NAS. To be retrieved based on DATA_TYPE column value
Updated by Thara S Pillai over 2 years ago
- Assignee changed from Shameera S L to Siji Mathew
Updated by Siji Mathew about 2 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Updated by Thara S Pillai almost 2 years ago
- Status changed from Resolved to Closed