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