Character attributes (Database Table)
From SWGANH Wiki
Database Table - character_attributes
SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.
Table Structure
|
Related Tags
|
Table Create Script
CREATE TABLE `character_attributes` ( `character_id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Character - ID', `faction_id` int(8) unsigned NOT NULL default '0' COMMENT 'Character - Faction ID', `health_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Max', `strength_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Max', `constitution_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Max', `action_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Max', `quickness_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Max', `stamina_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina Max', `mind_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Max', `focus_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Max', `willpower_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Max', `health_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Fill', `strength_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Fill', `constitution_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Fill', `action_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Fill', `quickness_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Fill', `stamina_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina Fill', `mind_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Fill', `focus_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Fill', `willpower_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Fill', `health_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Wounds', `strength_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Wounds', `constitution_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Wounds', `action_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Wounds', `quickness_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Wounds', `stamina_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina wounds', `mind_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind wounds', `focus_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Wounds', `willpower_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Wounds', `health_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Encumberance', `action_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Encumberance', `mind_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Encumberance', `battlefatigue` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Battle Fatigue', `posture` int(3) unsigned NOT NULL default '0', `moodId` int(11) unsigned NOT NULL default '0', `title` char(255) default NULL, `base_speed` float NOT NULL default '5.75', `base_acceleration` float NOT NULL default '1', `character_flags` int(11) unsigned NOT NULL default '0', KEY `fk_attributes_char_char` (`character_id`), KEY `fk_attributes_fac_fac` (`faction_id`), KEY `fk_charattributes_mood_mood` (`moodId`), CONSTRAINT `character_attributes_ibfk_1` FOREIGN KEY (`faction_id`) REFERENCES `faction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `character_attributes_ibfk_2` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_charattributes_mood_mood` FOREIGN KEY (`moodId`) REFERENCES `moods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table Describe
mysql> desc character_attributes; +----------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+-------+ | character_id | bigint(20) unsigned | NO | MUL | 0 | | | faction_id | int(8) unsigned | NO | MUL | 0 | | | health_max | int(6) unsigned | NO | | 0 | | | strength_max | int(6) unsigned | NO | | 0 | | | constitution_max | int(6) unsigned | NO | | 0 | | | action_max | int(6) unsigned | NO | | 0 | | | quickness_max | int(6) unsigned | NO | | 0 | | | stamina_max | int(6) unsigned | NO | | 0 | | | mind_max | int(6) unsigned | NO | | 0 | | | focus_max | int(6) unsigned | NO | | 0 | | | willpower_max | int(6) unsigned | NO | | 0 | | | health_current | int(6) unsigned | NO | | 0 | | | strength_current | int(6) unsigned | NO | | 0 | | | constitution_current | int(6) unsigned | NO | | 0 | | | action_current | int(6) unsigned | NO | | 0 | | | quickness_current | int(6) unsigned | NO | | 0 | | | stamina_current | int(6) unsigned | NO | | 0 | | | mind_current | int(6) unsigned | NO | | 0 | | | focus_current | int(6) unsigned | NO | | 0 | | | willpower_current | int(6) unsigned | NO | | 0 | | | health_wounds | int(6) unsigned | NO | | 0 | | | strength_wounds | int(6) unsigned | NO | | 0 | | | constitution_wounds | int(6) unsigned | NO | | 0 | | | action_wounds | int(6) unsigned | NO | | 0 | | | quickness_wounds | int(6) unsigned | NO | | 0 | | | stamina_wounds | int(6) unsigned | NO | | 0 | | | mind_wounds | int(6) unsigned | NO | | 0 | | | focus_wounds | int(6) unsigned | NO | | 0 | | | willpower_wounds | int(6) unsigned | NO | | 0 | | | health_encum | int(6) unsigned | NO | | 0 | | | action_encum | int(6) unsigned | NO | | 0 | | | mind_encum | int(6) unsigned | NO | | 0 | | | battlefatigue | int(6) unsigned | NO | | 0 | | | posture | int(3) unsigned | NO | | 0 | | | moodId | int(11) unsigned | NO | MUL | 0 | | | title | char(255) | YES | | NULL | | | base_speed | float | NO | | 5.75 | | | base_acceleration | float | NO | | 1 | | | character_flags | int(11) unsigned | NO | | 0 | | +----------------------+---------------------+------+-----+---------+-------+ 39 rows in set (0.00 sec)
