Character attributes (Database Table)

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 Field Type Unsigned Autoinc Null Key Default Value Description

Related Tags 25% This document has been partially completed. Database This document relates to the SWGANH Database Schema. DB Table This document relates to the SWGANH Database Schema.

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)