Difference between revisions of "Cells (Database Table)"

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 `cells` (
  `id` bigint(20) unsigned NOT NULL default '0',
  `parent_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `fk_st_cells_parent_parent` (`parent_id`),
  CONSTRAINT `fk_cells_building_building` FOREIGN KEY (`parent_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe

mysql> desc cells;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| id        | bigint(20) unsigned | NO   | PRI | 0       |       | 
| parent_id | bigint(20) unsigned | NO   | MUL | 0       |       | 
+-----------+---------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)