Character skillsTable: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
|  Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | character_id | integer |  |  |- | skill_id | integer |  |  |- | skill_z | integer |  |  |- | skill_y | integer | …' | No edit summary | ||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| {|  | |||
| {| class="wikitable" | |||
| |+ | |||
| !UE | |||
| !Field | |||
| !Type | |||
| !Key Type | |||
| !Default | |||
| !Extra | |||
| !Description | |||
| |- | |- | ||
| | | |||
| |character_id | |||
| |int(10) unsigned | |||
| |PRI | |||
| | | |0 | ||
| |  | | | ||
| |  | |||
| |   | |||
| |   | |   | ||
| |- | |- | ||
| | skill_id | | | ||
| |  | |skill_id | ||
| |   | |int(10) unsigned | ||
| |   | |PRI | ||
| |0 | |||
| | | |||
| | Skill from skills table. | |||
| |- | |- | ||
| |  | | | ||
| |  | |skill_Z | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| |0 | |||
| | | |||
| | Practice value. Ignored in stats (Str, Wil, ...), used by Skills (Herbal, Cooking, ...) | |||
| |- | |- | ||
| |  | | | ||
| |  | |skill_Y | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| |0 | |||
| | | |||
| | Knowledge Level. Ignored by all. | |||
| |- | |- | ||
| |  | | | ||
| |  | |skill_Rank | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| |0 | |||
| | | |||
| | Current player rank in the given skill. | |||
| |} | |} | ||
| [[Category:Engine documents]] | |||
Latest revision as of 17:48, 6 May 2023
| UE | Field | Type | Key Type | Default | Extra | Description | 
|---|---|---|---|---|---|---|
| character_id | int(10) unsigned | PRI | 0 | |||
| skill_id | int(10) unsigned | PRI | 0 | Skill from skills table. | ||
| skill_Z | int(10) unsigned | 0 | Practice value. Ignored in stats (Str, Wil, ...), used by Skills (Herbal, Cooking, ...) | |||
| skill_Y | int(10) unsigned | 0 | Knowledge Level. Ignored by all. | |||
| skill_Rank | int(10) unsigned | 0 | Current player rank in the given skill. |