Difference between revisions of "Database patterns"
From ProgClub
| Line 14: | Line 14: | ||
If you're extending a [[PHPBOM]] lookup table you should code from the max enum down. | If you're extending a [[PHPBOM]] lookup table you should code from the max enum down. | ||
| + | |||
| + | = Database types = | ||
| + | |||
| + | == DBT_UINT8 == | ||
| + | |||
| + | A [[#DBT_UINT8|DBT_UINT8]] is an integer from 0 to 255. | ||
| + | |||
| + | == DBT_ASCII_CHAR_BIN == | ||
| + | |||
| + | A [[#DBT_ASCII_CHAR_BIN|DBT_ASCII_CHAR_BIN]] is a single case-sensitive ASCII character. | ||
Revision as of 07:06, 18 March 2020
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.
Database types
DBT_UINT8
A DBT_UINT8 is an integer from 0 to 255.
DBT_ASCII_CHAR_BIN
A DBT_ASCII_CHAR_BIN is a single case-sensitive ASCII character.
