Convention for Database Tables: Difference between revisions
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
! Order !! Code !! Types !! Purpose !! Tables !! Views | ! Order !! Code !! Types !! Purpose !! Tables !! Views | ||
|- | |- | ||
| F || A || Audit || Audit Tables || | | <code>F</code> || <code>A</code> || Audit || Audit Tables || <code>M00TA00X00 ~ MZZTAZZX00</code> || <code>M00VA00X00 ~ MZZVAZZX00</code> | ||
|- | |- | ||
| D || E || Entries || Entries Tables || | | <code>D</code> || <code>E</code> || Entries || Entries Tables || <code>M00TE00X00 ~ MZZTEZZX00</code> || <code>M00VE00X00 ~ MZZVEZZX00</code> | ||
|- | |- | ||
| A || I || Identity || Identity Tables || | | <code>A</code> || <code>I</code> || Identity || Identity Tables || <code>M00TI00X00 ~ MZZTIZZX00</code> || <code>M00VI00X00 ~ MZZVIZZX00</code> | ||
|- | |- | ||
| E || J || Join || Join Tables '''n - n''' || | | <code>E</code> || <code>J</code> || Join || Join Tables '''n - n''' || <code>M00TJ00X00 ~ MZZTJZZX00</code> || <code>M00VJ00X00 ~ MZZVJZZX00</code> | ||
|- | |- | ||
| G || L || Local || Local Tables || | | <code>G</code> || <code>L</code> || Local || Local Tables || <code>M00TL00X00 ~ M00TLZZX00</code> || <code>M00VL00X00 ~ M00VLZZX00</code> | ||
|- | |- | ||
| B || M || Metadata || Metadata Tables || | | <code>B</code> || <code>M</code> || Metadata || Metadata Tables || <code>M00TM00X00 ~ MZZTMZZX00</code> || <code>M00VM00X00 ~ MZZVMZZX00</code> | ||
|- | |- | ||
| C || S || Settings || Settings Tables || | | <code>C</code> || <code>S</code> || Settings || Settings Tables || <code>M00TS00X00 ~ MZZTSZZX00</code> || <code>M00VS00X00 ~ MZZVSZZX00</code> | ||
|- | |- | ||
| H || V || Versions || Versions Tables || | | <code>H</code> || <code>V</code> || Versions || Versions Tables || <code>M00TV00X00 ~ MZZTVZZX00</code> || <code>M00VV00X00 ~ MZZVVZZX00</code> | ||
|} | |} | ||
Revision as of 09:58, 15 September 2019
Types of Table
| Order | Code | Types | Purpose | Tables | Views |
|---|---|---|---|---|---|
F |
A |
Audit | Audit Tables | M00TA00X00 ~ MZZTAZZX00 |
M00VA00X00 ~ MZZVAZZX00
|
D |
E |
Entries | Entries Tables | M00TE00X00 ~ MZZTEZZX00 |
M00VE00X00 ~ MZZVEZZX00
|
A |
I |
Identity | Identity Tables | M00TI00X00 ~ MZZTIZZX00 |
M00VI00X00 ~ MZZVIZZX00
|
E |
J |
Join | Join Tables n - n | M00TJ00X00 ~ MZZTJZZX00 |
M00VJ00X00 ~ MZZVJZZX00
|
G |
L |
Local | Local Tables | M00TL00X00 ~ M00TLZZX00 |
M00VL00X00 ~ M00VLZZX00
|
B |
M |
Metadata | Metadata Tables | M00TM00X00 ~ MZZTMZZX00 |
M00VM00X00 ~ MZZVMZZX00
|
C |
S |
Settings | Settings Tables | M00TS00X00 ~ MZZTSZZX00 |
M00VS00X00 ~ MZZVSZZX00
|
H |
V |
Versions | Versions Tables | M00TV00X00 ~ MZZTVZZX00 |
M00VV00X00 ~ MZZVVZZX00
|
Nomenclature
[T]{1}───────────────T─┐
├─T00┐
[0-9A-Z]{2}──────────00┘ │
├─T00AYZ
[A|E|I|J|L|M|S|V]{1}─A─┐ │
├─AYZ┘
[0-9A-Z]{2}──────────YZ┘
Audit Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00AYZ
[A]{1}──────A─┐ │
├─AYZ┘
[0-9A-Z]{2}─YZ┘
Entries Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00EYZ
[E]{1}──────E─┐ │
├─EYZ┘
[0-9A-Z]{2}─YZ┘
Identity Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00IYZ
[I]{1}──────I─┐ │
├─IYZ┘
[0-9A-Z]{2}─YZ┘
Join Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00JYZ
[J]{1}──────J─┐ │
├─JYZ┘
[0-9A-Z]{2}─YZ┘
Local Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00LYZ
[L]{1}──────L─┐ │
├─JYZ┘
[0-9A-Z]{2}─YZ┘
Metadata Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00MYZ
[M]{1}──────M─┐ │
├─MYZ┘
[0-9A-Z]{2}─YZ┘
Settings Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00SYZ
[S]{1}──────S─┐ │
├─SYZ┘
[0-9A-Z]{2}─YZ┘
Versions Tables
[T]{1}──────T─┐
├─T00┐
[0-9A-Z]{2}─00┘ │
├─T00VYZ
[V]{1}──────V─┐ │
├─VYZ┘
[0-9A-Z]{2}─YZ┘