logproplist — List of possible meta-data for journal entries.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| propid | tinyint unsigned auto_increment | |||
| name | varchar(50) | YES | ||
| prettyname | varchar(60) | YES | ||
| sortorder | mediumint unsigned | YES | ||
| datatype | enum('char','num','bool') | char | ||
| des | varchar(255) | YES | ||
| scope | enum('general','local') | general |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| name | UNIQUE |