Difference between revisions of "Appendix 5: Database objects"

From Agri4castWiki
Jump to: navigation, search
(Created page with "__NOTOC__ {{Expert}} ==MY_OBJECT_NAME== *Description: short description of the type of data. *Type: e.g. Table, View on {{Object|MY_OTHER_OBJECT_NAME}}, {{Object|MY_YET_ANOTHE...")
 
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 
{{Expert}}
 
{{Expert}}
==MY_OBJECT_NAME==
 
*Description: short description of the type of data.
 
*Type: e.g. Table, View on {{Object|MY_OTHER_OBJECT_NAME}}, {{Object|MY_YET_ANOTHER_OBJECT_NAME}}, etc. or synonym to {{Object|MY_OTHER_OBJECT_NAME}}
 
*Use: short description of the use of the data.
 
*Remarks: any other remark
 
  
{|class="collapsing_table collapsible collapsed"
+
* [[{{BASEPAGENAME}}/CGMS14xxx|CGMS14xxx database objects]]
!Structure
+
* [[{{BASEPAGENAME}}/CGMS14SYS|CGMS14SYS database objects]]
|-
+
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects]]<br>
|
+
* [[Appendix_5:_CGMS_tables|CGMS12xxx database objects (legacy)]]
{|class="wikitable"
 
!Attribute !! Contraint !! Type !! Unit
 
|-
 
| MY_ATTRIBUTE_1  ||NOT NULL||VARCHAR2(10)        ||
 
|-
 
| MY_ATTRIBUTE_2  ||NOT NULL||VARCHAR2(250)        ||
 
|-
 
| MY_ATTRIBUTE_3  ||NOT NULL||NUMBER              ||
 
|-
 
| MY_ATTRIBUTE_4  ||NOT NULL||VARCHAR2(10)        ||
 
|}
 
|}
 
<br>
 
 
 
==MY_OTHER_OBJECT_NAME==
 
*Description: short description of the type of data.
 
*Type: e.g. Table, View on... or synonym to ...
 
*Use: short description of the use of the data.
 
*Remarks: any other remark
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
!Attribute !! Contraint !! Type !! Unit
 
|-
 
| MY_ATTRIBUTE_1  ||NOT NULL||VARCHAR2(10)        ||
 
|-
 
| MY_ATTRIBUTE_2  ||NOT NULL||VARCHAR2(250)        ||
 
|-
 
| MY_ATTRIBUTE_3  ||NOT NULL||NUMBER              ||
 
|-
 
| MY_ATTRIBUTE_4  ||NOT NULL||VARCHAR2(10)        ||
 
|}
 
|}
 
<br>
 
 
 
 
 
[[Category:Appendixes]]
 

Revision as of 16:12, 28 January 2016