Table zot.xprof 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
xprof_hash char 255
hubloc.hubloc_hash Defined in XML R
channel.channel_hash Defined in XML R
xchan.xchan_hash Defined in XML R
xprof_age tinyint unsigned 3 0
xprof_desc char 255
xprof_dob char 12
xprof_gender char 255
xprof_marital char 255
xprof_sexual char 255
xprof_locale char 255
xprof_region char 255
xprof_postcode char 32
xprof_country char 255
xprof_keywords text 65535
xprof_about text 65535
xprof_homepage char 255
xprof_hometown char 255

Table contained 0 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
xprof_hash Primary key Asc PRIMARY
xprof_age Performance Asc xprof_age
xprof_country Performance Asc xprof_country
xprof_desc Performance Asc xprof_desc
xprof_dob Performance Asc xprof_dob
xprof_gender Performance Asc xprof_gender
xprof_hometown Performance Asc xprof_hometown
xprof_locale Performance Asc xprof_locale
xprof_marital Performance Asc xprof_marital
xprof_postcode Performance Asc xprof_postcode
xprof_region Performance Asc xprof_region
xprof_sexual Performance Asc xprof_sexual

Close relationships  within of separation: