Character discoveriesTable
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| ADD | id | int(11) | PRI | auto_increment | ||
| ADD | character_id | int(11) | the player who discovered this item | |||
| ADD | knowledge_type | tinyint(4) | 1 = codexCreatures, 2 = codexPlantMinerals, 3 = codexLocationsLoc, 4 = codexLocationsNPC, 5= codexStory, 6= codexFactions | |||
| ADD | childtable_id | int(11) | Points to the ID of the specific table based on the type |