| xchan_hash | calculated hash of this extended channel | char(255) | NO | PRI | NULL | |
| xchan_guid | channel_guid of this extended channel | char(255) | NO | MUL | | |
| xchan_guid_sig | base64url encoded signature of the guid | text | NO | | NULL | |
| xchan_pubkey | public key for verifying signed data and assertions | text | NO | | NULL | |
| xchan_photo_mimetype | mimetype of the profile photo | char(32) | NO | | image/jpeg | |
| xchan_photo_l | photo url 300px | char(255) | NO | | | |
| xchan_photo_m | photo url 80 px | char(255) | NO | | | |
| xchan_photo_s | photo url 48 px | char(255) | NO | | | |
| xchan_addr | user@host | char(255) | NO | MUL | | |
| xchan_url | url of channel page on primary hub location | char(255) | NO | MUL | | |
| xchan_connurl | | char(255) | NO | MUL | | |
| xchan_follow | | char(255) | NO | MUL | | |
| xchan_connpage | for premium channels url of channel to display when connecting | char(255) | NO | | | |
| xchan_name | human readabl name of channel | char(255) | NO | MUL | | |
| xchan_network | network of channel for instance ‘zot’, ‘diaspora’, ‘unknown’ | char(255) | NO | MUL | | |
| xchan_instance_url | no longer used | char(255) | NO | MUL | | |
| xchan_flags | no longer used | int(10) unsigned | NO | MUL | 0 | |
| xchan_photo_date | timestamp of last photo change in GMT | datetime | NO | | 0000-00-00 00:00:00 | |
| xchan_name_date | timestamp of last name change in GMT | datetime | NO | | 0000-00-00 00:00:00 | |
| xchan_hidden | flag - channel is hidden | int(10) unsigned | NO | MUL | 0 | |
| xchan_orphan | flag - channel has no known hubloc locations | int(10) unsigned | NO | MUL | 0 | |
| xchan_censored | flag - channel has been censored | int(10) unsigned | NO | MUL | 0 | |
| xchan_selfcensored | flag - channel is self censored (adult or nsfw) | int(10) unsigned | NO | MUL | 0 | |
| xchan_system | flag - this represents a system channel | int(10) unsigned | NO | MUL | 0 | |
| xchan_pubforum | flag - channel is a public forum | int(10) unsigned | NO | MUL | 0 | |
| xchan_deleted | flag - channel was deleted | int(10) unsigned | NO | MUL | 0 | |