Character bind (Database Table)

Database Table - biography_faction

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 id BIGINT(20) NULL ID character_id BIGINT(20) Character ID (swganh.characters) bank_planet_id INT(2) NULL Planet ID (swganh.planets) bind_oX FLOAT(10,6) NULL Bind Location X bind_oY FLOAT(10,6) NULL Bind Location Y bind_oZ FLOAT(10,6) NULL Bind Location Z clone_city_id INT(10) NULL Clone Location (swganh.spawn_clone)

Related Tags 100% This document is complete. 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_bind` (
  `id` bigint(20) NOT NULL auto_increment COMMENT 'ID',
  `character_id` bigint(20) unsigned NOT NULL COMMENT 'Character ID',
  `bank_planet_id` int(2) default NULL COMMENT 'Planet ID for Bank',
  `bind_oX` float(10,6) default NULL COMMENT 'X Location - Bind',
  `bind_oY` float(10,6) default NULL COMMENT 'Y Location - Bind',
  `bind_oZ` float(10,6) default NULL COMMENT 'Z Location - Bind',
  `clone_city_id` int(10) unsigned default NULL COMMENT 'Clone City ID',
  PRIMARY KEY  (`id`),
  KEY `FK_character_bind_1` (`character_id`),
  KEY `FK_character_bind_2` (`bank_planet_id`),
  KEY `FK_character_bind_3` (`clone_city_id`),
  CONSTRAINT `FK_character_bind_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_character_bind_2` FOREIGN KEY (`bank_planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_character_bind_3` FOREIGN KEY (`clone_city_id`) REFERENCES `spawn_clone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Character Bind Data';

Table Describe

mysql> desc character_bind;
+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| id             | bigint(20)          | NO   | PRI | NULL    | auto_increment | 
| character_id   | bigint(20) unsigned | NO   | MUL |         |                | 
| bank_planet_id | int(2)              | NO   | MUL |         |                | 
| bind_oX        | float(10,6)         | NO   |     |         |                | 
| bind_oY        | float(10,6)         | NO   |     |         |                | 
| bind_oZ        | float(10,6)         | NO   |     |         |                | 
| clone_city_id  | int(10) unsigned    | NO   | MUL |         |                | 
+----------------+---------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)