Convention for Database Tables: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 14: | Line 14: | ||
| S || Serial || Transactional Sequence Tables || T00S00 ~ TZZSZZ || | | S || Serial || Transactional Sequence Tables || T00S00 ~ TZZSZZ || | ||
|} | |} | ||
==Nomenclature== | |||
[T]{1}─────────T─┐ | |||
├─T00┐ | |||
[0-9A-Z]{2}────00┘ │ | |||
├─T00DYZ | |||
[D|E|I|J|S]{1}─D─┐ │ | |||
├─DYZ┘ | |||
[0-9A-Z]{2}────YZ┘ | |||
Revision as of 12:10, 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 |
Nomenclature
[T]{1}─────────T─┐
├─T00┐
[0-9A-Z]{2}────00┘ │
├─T00DYZ
[D|E|I|J|S]{1}─D─┐ │
├─DYZ┘
[0-9A-Z]{2}────YZ┘