Table zot.xchan 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
xchan_hash char 255
abook.abook_xchan Defined in XML R
attach.hash Defined in XML R
channel.channel_hash Defined in XML R
chat.chat_xchan Defined in XML R
chatpresence.cp_xchan Defined in XML R
dreport.dreport_xchan Defined in XML R
event.event_hash Defined in XML R
event.event_xchan Defined in XML R
group_member.xchan Defined in XML R
groups.hash Defined in XML R
hubloc.hubloc_hash Defined in XML R
item.author_xchan Defined in XML R
item.owner_xchan Defined in XML R
item.source_xchan Defined in XML R
mail.from_xchan Defined in XML R
mail.to_xchan Defined in XML R
manage.xchan Defined in XML R
notify.hash Defined in XML R
outq.outq_hash Defined in XML R
photo.xchan Defined in XML R
profext.hash Defined in XML R
register.hash Defined in XML R
shares.share_xchan Defined in XML R
source.src_channel_xchan Defined in XML R
source.src_xchan Defined in XML R
term.parent_hash Defined in XML R
term.term_hash Defined in XML R
updates.ud_hash Defined in XML R
vote.vote_xchan Defined in XML R
xchat.xchat_xchan Defined in XML R
xconfig.xchan Defined in XML R
xign.xchan Defined in XML R
xlink.xlink_xchan Defined in XML R
xprof.xprof_hash Defined in XML R
xtag.xtag_hash Defined in XML R
hubloc.hubloc_hash Defined in XML R
channel.channel_hash Defined in XML R
xchan_guid char 255
xchan_guid_sig text 65535
xchan_pubkey text 65535
xchan_photo_mimetype char 32 image/jpeg
xchan_photo_l char 255
xchan_photo_m char 255
xchan_photo_s char 255
xchan_addr char 255
xchan_url char 255
xchan_connurl char 255
xchan_follow char 255
xchan_connpage char 255
xchan_name char 255
xchan_network char 255
xchan_instance_url char 255
xchan_flags int unsigned 10 0
xchan_photo_date datetime 19 0000-00-00 00:00:00
xchan_name_date datetime 19 0000-00-00 00:00:00
xchan_hidden bit 0 0
xchan_orphan bit 0 0
xchan_censored bit 0 0
xchan_selfcensored bit 0 0
xchan_system bit 0 0
xchan_pubforum bit 0 0
xchan_deleted bit 0 0

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

Indexes:
Column(s) Type Sort Constraint Name
xchan_hash Primary key Asc PRIMARY
xchan_addr Performance Asc xchan_addr
xchan_censored Performance Asc xchan_censored
xchan_connurl Performance Asc xchan_connurl
xchan_deleted Performance Asc xchan_deleted
xchan_flags Performance Asc xchan_flags
xchan_follow Performance Asc xchan_follow
xchan_guid Performance Asc xchan_guid
xchan_hidden Performance Asc xchan_hidden
xchan_instance_url Performance Asc xchan_instance_url
xchan_name Performance Asc xchan_name
xchan_network Performance Asc xchan_network
xchan_orphan Performance Asc xchan_orphan
xchan_pubforum Performance Asc xchan_pubforum
xchan_selfcensored Performance Asc xchan_selfcensored
xchan_system Performance Asc xchan_system
xchan_url Performance Asc xchan_url

Close relationships: