Difference between revisions of "Attributes (Database Table)"

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description id int(11) NO Primary Null Attribute ID name char(255) YES Unique Null Attribute Name internal tinyint(3) NO 0 Attribute Description attribute_internal_description text NO Null Attribute Description

Related Tags 75% This document is nearing completion. Database This document relates to the SWGANH Database Schema. DB Table This document relates to the SWGANH Database Schema.

Table Create Script

DROP TABLE IF EXISTS `swganh`.`attributes`;
CREATE TABLE  `swganh`.`attributes` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` char(255) default NULL,
  `internal` tinyint(3) unsigned NOT NULL default '0',
  `attribute_internal_description` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `pk_attributes_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=837 DEFAULT CHARSET=utf8;

Table Describe

mysql> desc attributes;
+--------------------------------+---------------------+------+-----+---------+----------------+
| Field                          | Type                | Null | Key | Default | Extra          |
+--------------------------------+---------------------+------+-----+---------+----------------+
| id                             | int(11) unsigned    | NO   | PRI | NULL    | auto_increment |
| name                           | char(255)           | YES  | UNI | NULL    |                |
| internal                       | tinyint(3) unsigned | NO   |     | 0       |                |
| attribute_internal_description | text                | NO   |     | NULL    |                |
+--------------------------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)