Table zot.profile 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 int 10  √ 
notify.id Implied Constraint R
profile_guid char 64
aid int unsigned 10 0
uid int 10 0
profile_name char 255
is_default bit 0 0
hide_friends bit 0 0
name char 255
pdesc char 255
chandesc text 65535
dob char 32 0000-00-00
dob_tz char 255 UTC
address char 255
locality char 255
region char 255
postal_code char 32
country_name char 255
hometown char 255
gender char 32
marital char 255
with text 65535
howlong datetime 19 0000-00-00 00:00:00
sexual char 255
politic char 255
religion char 255
keywords text 65535
likes text 65535
dislikes text 65535
about text 65535
summary char 255
music text 65535
book text 65535
tv text 65535
film text 65535
interest text 65535
romance text 65535
work text 65535
education text 65535
contact text 65535
channels text 65535
homepage char 255
photo char 255
thumb char 255
publish bit 0 0

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
aid Performance Asc aid
country_name Performance Asc country_name
gender Performance Asc gender
profile_guid + uid Must be unique Asc/Asc guid
hide_friends Performance Asc hide_friends
hometown Performance Asc hometown
is_default Performance Asc is_default
locality Performance Asc locality
marital Performance Asc marital
postal_code Performance Asc postal_code
profile_guid Performance Asc profile_guid
publish Performance Asc publish
sexual Performance Asc sexual
uid Performance Asc uid

Close relationships: