| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| xchan_hash | char(255) | NO | PRI | NULL | ||
| xchan_guid | char(255) | NO | MUL | |||
| xchan_guid_sig | text | NO | NULL | |||
| xchan_pubkey | text | NO | NULL | |||
| xchan_photo_mimetype | char(32) | NO | image/jpeg | |||
| xchan_photo_l | char(255) | NO | ||||
| xchan_photo_m | char(255) | NO | ||||
| xchan_photo_s | char(255) | NO | ||||
| xchan_addr | char(255) | NO | MUL | |||
| xchan_url | char(255) | NO | MUL | |||
| xchan_connurl | char(255) | NO | MUL | |||
| xchan_follow | char(255) | NO | MUL | |||
| xchan_connpage | char(255) | NO | ||||
| xchan_name | char(255) | NO | MUL | |||
| xchan_network | char(255) | NO | MUL | |||
| xchan_instance_url | char(255) | NO | MUL | |||
| xchan_flags | int(10) unsigned | NO | MUL | 0 | ||
| xchan_photo_date | datetime | NO | 0000-00-00 00:00:00 | |||
| xchan_name_date | datetime | NO | 0000-00-00 00:00:00 |
Return to database documentation