DATABASE PROGRAMMING SCHEMA DIAGRAM
DBP_HOLIDAY
PK
DATE
DATETIME
NEM_RM16 table is the table that will be used to deliver the AEMO data to you. You have select privileges only to this table. There is a public synonym created to make access to the table transparent
NEM_RM16
COMPANY_CODE SETTLEMENT_CASE_ID SETTLEMENT_RUN_ID STATEMENT_TYPE
TNI
METERTYPE FRMP
LR
MDP CHANGE_DATE DAY
VALUE TRANSACTION_ID
VARCHAR(25) INTEGER INTEGER VARCHAR(25) VARCHAR(25) VARCHAR(25) VARCHAR(25) VARCHAR(25) VARCHAR(25) DATETIME DATETIME RM16_DAY VARCHAR(25)
DBP_MESSAGE_LOG
PK
MSG_LOG_ID
INTEGER
STUDENT_ID MSG_DATE MSG_ID MESSAGE
VARCHAR(50) DATETIME VARCHAR(35) VARCHAR(2000)
RM16_HH
HH VOLUME
INTEGER DOUBLE
RM16_DAY
DAY
rm16_hh
DBP_PARAMETER
=== ===== ===== ===== ===== =====
CATEGORY CODE VALUE ACTIVE MODIFIED
VARCHAR2(35) VARCHAR2(35) VARCHAR2(35) VARCHAR2(1) ¡®Y¡¯ DATE (sysdate)
V_NEM_RM16
COMPANY_CODE SETTLEMENT_CASE_ID SETTLEMENT_RUN_ID STATEMENT_TYPE
TNI
METERTYPE FRMP
LR
MDP CHANGE_DATE DAY
HH
VALUE TRANSACTION_ID
TEXT(25) LONG LONG TEXT(25) TEXT(25) TEXT(25) TEXT(25) TEXT(25) TEXT(25) DATETIME DATETIME LONG SINGLE TEXT(25)
LOCAL_RM16
COMPANY_CODE SETTLEMENT_CASE_ID SETTLEMENT_RUN_ID STATEMENT_TYPE
TNI
METERTYPE FRMP
LR
MDP CHANGE_DATE DAY
VALUE TRANSACTION_ID
VARCHAR(25) INTEGER INTEGER VARCHAR(25) VARCHAR(25) VARCHAR(25) VARCHAR(25) VARCHAR(25) VARCHAR(25) DATETIME DATETIME RM16_DAY VARCHAR(25)
RUN_TABLE
===========================
RUN_ID NUMBER RUN_START DATE
RUN_END OUTCOME REMARKS
DATE VARCHAR2(15) VARCHAR2(255)
The Object V-NEM_RM16 is a VIEW
The purpose of the View is to Unwrap the Objects in the NEM_PRM16 table
The data is the same in the two Objects and you can use either as the source of data for your forecasting
LOCAL_RM16 table is the table that you will create to store your data.
C:\Laurie\uni\Database Programming\2020\Assignment\AEMO Table Diagram.vsd