Database patterns

From ProgClub
Revision as of 07:04, 18 March 2020 by John (talk | contribs) (Created page with "= Patterns = == about === The about tables contain database meta data. == lookup == The lookup tables contain hard-coded reference data. A lookup t...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Patterns

about =

The about tables contain database meta data.

lookup

The lookup tables contain hard-coded reference data.

A lookup table must contain a 'a_{name}_enum' column which identifies a row. The 'a_{name}_enum' column is usually be a DBT_UINT8.

If an optional 'a_{name}_char' column exists it must be of type DBT_ASCII_CHAR_BIN. The PHPBOM library will use lowercase char codes and applications can use uppercase char codes.

If you're extending a PHPBOM lookup table you should code from the max enum down.