Best Practice for Creating Custom Tables - Revision history

Paul_thompson@infosys.com: /* Overview */

2009-08-20T12:07:48Z

‎Overview

2008-08-08T21:15:56Z

‎Columns ''NOT'' to Add

2008-08-06T06:09:51Z

2008-07-26T19:01:05Z

2008-07-26T05:23:02Z

2008-07-25T20:53:21Z

2008-07-25T15:51:23Z

2008-07-25T15:48:38Z

2008-07-25T15:48:01Z

‎Columns to ''always'' Add

2008-07-18T13:56:00Z

@@ Line 7: / Line 7: @@
 == Overview ==
 This article contains best practices for creating custom tables. It is highly recommend that all custom tables are created via the [[Schema Designer]] utility available as a subcomponent of the [[Web Screen Painter]].
 == Basics ==

@@ Line 14: / Line 14: @@
 === Columns ''NOT'' to Add ===
-All custom tables created via the Schema Designer are give an id, last_mod_by, and last_mod_dt column when the table is published to the database. Keep this in mind when adding columns to your custom table.
+All custom tables created via the Schema Designer are given an id, last_mod_by, and last_mod_dt column when the table is published to the database. Keep this in mind when adding columns to your custom table.
 === Columns to ''always'' Add ===

@@ Line 1: / Line 1: @@
 __NOTOC__
 {{Global Header}}
 {{Global Announcement}}

@@ Line 1: / Line 1: @@
 __NOTOC__
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Overview ==

@@ Line 5: / Line 5: @@
 == Overview ==
 This article contains best practices for creating custom tables. It is highly recommend that all custom tables are created via the [[Schema Designer]] utility available as a subcomponent of the [[Web Screen Painter]].
 == Basics ==
 === Begin all Tables with a '''Z''' ===
 It is standard practice to add a ''z'' at the beginning of all custom table names. (zchg_type, zxfer_reason, etc.)
 === Columns ''NOT'' to Add ===
 All custom tables created via the Schema Designer are give an id, last_mod_by, and last_mod_dt column when the table is published to the database. Keep this in mind when adding columns to your custom table.
 === Columns to ''always'' Add ===
 The following columns should be added to all custom tables. While you are certainly free to deviate from this listing, you will find that most tables contain these fields with the parameters given and by adding them you are maintaining consistency.
@@ Line 27: / Line 19: @@
 *'''description''' provides an area for more detail.
 *'''sym''' is the field that is displayed.
 {|
@@ Line 117: / Line 108: @@
 |-
 |}
 === Table Parameters ===
@@ Line 162: / Line 151: @@
 |-
 |}
 == Example ==
@@ Line 198: / Line 186: @@
    };
 };</source>
 == See Also ==
 [[Adding Nodes to Administration Tab]]

← Older revision		Revision as of 15:51, 25 July 2008
Line 196:		Line 196:
	};		};
	};</source>		};</source>
		+
		+
		+
		+	== See Also ==
		+
		+	[[Adding Nodes to Administration Tab]]
		+

@@ Line 24: / Line 24: @@
 *'''delete_flag''' is used to set items active or inactive.
 *'''description''' provides an area for more detail.
-*'''sym''' is the field that that is displayed.
+*'''sym''' is the field that is displayed.
@@ Line 115: / Line 115: @@
 |-
 |}
 === Table Parameters ===