Activity #2236
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
Create table for dashboard management
100%
Description
Create table dashboard_status with the following fields
dashboard_status_id (PK)
dashboard_id (number)
panel_id (number)
start_datetime (timestamp)
end_datetime (timestamp)
refresh_rate (float)
unit char(1) (s, m, h, d)
last_data_fetch_datetime (timestamp)
active char(1)
Update DB design document https://docs.google.com/document/d/1sBwmCzt8VvHZlRBCAxi8HsVvRWGwPeLT/edit
Updated by Siji Mathew over 2 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
The dashboard_status table has been created, and the changes have been updated in the https://docs.google.com/document/d/1sBwmCzt8VvHZlRBCAxi8HsVvRWGwPeLT/edit
Updated by Thara S Pillai over 2 years ago
- Status changed from Resolved to Closed
Updated by Thara S Pillai over 2 years ago
- Subject changed from create table for dashboard management to Create table for dashboard management