Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| 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 | poco urlchar(255) | NO | MUL | |||
| xchan_follow | url template for following %schar(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 |
Return to database documentation