Table mangos.npc_text Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID mediumint unsigned 8 0
gossip_menu.text_id Defined in XML R
locales_npc_text.entry Defined in XML R
npc_gossip.textid Defined in XML R
text0_0 longtext 2147483647  √  null
text0_1 longtext 2147483647  √  null
lang0 tinyint unsigned 3 0
prob0 float 12 0
em0_0 smallint unsigned 5 0
em0_1 smallint unsigned 5 0
em0_2 smallint unsigned 5 0
em0_3 smallint unsigned 5 0
em0_4 smallint unsigned 5 0
em0_5 smallint unsigned 5 0
text1_0 longtext 2147483647  √  null
text1_1 longtext 2147483647  √  null
lang1 tinyint unsigned 3 0
prob1 float 12 0
em1_0 smallint unsigned 5 0
em1_1 smallint unsigned 5 0
em1_2 smallint unsigned 5 0
em1_3 smallint unsigned 5 0
em1_4 smallint unsigned 5 0
em1_5 smallint unsigned 5 0
text2_0 longtext 2147483647  √  null
text2_1 longtext 2147483647  √  null
lang2 tinyint unsigned 3 0
prob2 float 12 0
em2_0 smallint unsigned 5 0
em2_1 smallint unsigned 5 0
em2_2 smallint unsigned 5 0
em2_3 smallint unsigned 5 0
em2_4 smallint unsigned 5 0
em2_5 smallint unsigned 5 0
text3_0 longtext 2147483647  √  null
text3_1 longtext 2147483647  √  null
lang3 tinyint unsigned 3 0
prob3 float 12 0
em3_0 smallint unsigned 5 0
em3_1 smallint unsigned 5 0
em3_2 smallint unsigned 5 0
em3_3 smallint unsigned 5 0
em3_4 smallint unsigned 5 0
em3_5 smallint unsigned 5 0
text4_0 longtext 2147483647  √  null
text4_1 longtext 2147483647  √  null
lang4 tinyint unsigned 3 0
prob4 float 12 0
em4_0 smallint unsigned 5 0
em4_1 smallint unsigned 5 0
em4_2 smallint unsigned 5 0
em4_3 smallint unsigned 5 0
em4_4 smallint unsigned 5 0
em4_5 smallint unsigned 5 0
text5_0 longtext 2147483647  √  null
text5_1 longtext 2147483647  √  null
lang5 tinyint unsigned 3 0
prob5 float 12 0
em5_0 smallint unsigned 5 0
em5_1 smallint unsigned 5 0
em5_2 smallint unsigned 5 0
em5_3 smallint unsigned 5 0
em5_4 smallint unsigned 5 0
em5_5 smallint unsigned 5 0
text6_0 longtext 2147483647  √  null
text6_1 longtext 2147483647  √  null
lang6 tinyint unsigned 3 0
prob6 float 12 0
em6_0 smallint unsigned 5 0
em6_1 smallint unsigned 5 0
em6_2 smallint unsigned 5 0
em6_3 smallint unsigned 5 0
em6_4 smallint unsigned 5 0
em6_5 smallint unsigned 5 0
text7_0 longtext 2147483647  √  null
text7_1 longtext 2147483647  √  null
lang7 tinyint unsigned 3 0
prob7 float 12 0
em7_0 smallint unsigned 5 0
em7_1 smallint unsigned 5 0
em7_2 smallint unsigned 5 0
em7_3 smallint unsigned 5 0
em7_4 smallint unsigned 5 0
em7_5 smallint unsigned 5 0

Table contained 5,779 rows at Fri Feb 11 23:15 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY

Close relationships  within of separation: