Convention for Database Tables

From Chorke Wiki
Revision as of 12:10, 12 January 2018 by Shahed (talk | contribs)
Jump to navigation Jump to search

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┘