Convention for Database Tables: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Types of Tables== {| class="wikitable sortable" |- ! Type Identifier !! Table Purpose !! Description !! Tables !! Views |- | D || Datum || MetaData Tables || T00D00 ~ TFFD...") |
|||
| Line 4: | Line 4: | ||
! Type Identifier !! Table Purpose !! Description !! Tables !! Views | ! Type Identifier !! Table Purpose !! Description !! Tables !! Views | ||
|- | |- | ||
| D || Datum || MetaData Tables || T00D00 ~ | | D || Datum || MetaData Tables || T00D00 ~ TZZDZZ || | ||
|- | |- | ||
| E || Entries || Transactions Tables || T00E00 ~ | | E || Entries || Transactions Tables || T00E00 ~ TZZEZZ || V00E00 ~ VZZEZZ | ||
|- | |- | ||
| I || Initialization || Setup Tables || T00I00 ~ | | I || Initialization || Setup Tables || T00I00 ~ TZZIZZ || V00I00 ~ VZZIZZ | ||
|- | |- | ||
| J || Join || Many to Many Join || T00J00 ~ | | J || Join || Many to Many Join || T00J00 ~ TZZJZZ || | ||
|- | |- | ||
| S || Serial || Transactional Sequence Tables || T00S00 ~ | | S || Serial || Transactional Sequence Tables || T00S00 ~ TZZSZZ || | ||
|} | |} | ||
Revision as of 12:03, 12 January 2018
Types of Tables
| Type Identifier | Table Purpose | Description | Tables | Views |
|---|---|---|---|---|
| D | Datum | MetaData Tables | T00D00 ~ TZZDZZ | |
| E | Entries | Transactions Tables | T00E00 ~ TZZEZZ | V00E00 ~ VZZEZZ |
| I | Initialization | Setup Tables | T00I00 ~ TZZIZZ | V00I00 ~ VZZIZZ |
| J | Join | Many to Many Join | T00J00 ~ TZZJZZ | |
| S | Serial | Transactional Sequence Tables | T00S00 ~ TZZSZZ |