6 | Field | Description | Type | Null | Key | Default | Extra |
7 | ---------------- | -------------------------------------------------- | ---------------- | ---- | --- | ------------------- | -------------- |
8 | id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment |
9 | url | | varchar(255) | NO | | | |
10 | nurl | | varchar(255) | NO | | | |
11 | version | | varchar(255) | NO | | | |
12 | site_name | | varchar(255) | NO | | | |
13 | info | | text | YES | | NULL | |
14 | register_policy | | tinyint | NO | | 0 | |
15 | registered-users | Number of registered users | int unsigned | NO | | 0 | |
16 | directory-type | Type of directory service (Poco, Mastodon) | tinyint | YES | | 0 | |
17 | poco | | varchar(255) | NO | | | |
18 | noscrape | | varchar(255) | NO | | | |
19 | network | | char(4) | NO | | | |
20 | protocol | The protocol of the server | tinyint unsigned | YES | | NULL | |
21 | platform | | varchar(255) | NO | | | |
22 | relay-subscribe | Has the server subscribed to the relay system | boolean | NO | | 0 | |
23 | relay-scope | The scope of messages that the server wants to get | varchar(10) | NO | | | |
24 | detection-method | Method that had been used to detect that server | tinyint unsigned | YES | | NULL | |
25 | created | | datetime | NO | | 0001-01-01 00:00:00 | |
26 | last_poco_query | | datetime | YES | | 0001-01-01 00:00:00 | |
27 | last_contact | Last successful connection request | datetime | YES | | 0001-01-01 00:00:00 | |
28 | last_failure | Last failed connection request | datetime | YES | | 0001-01-01 00:00:00 | |
29 | failed | Connection failed | boolean | YES | | NULL | |
30 | next_contact | Next connection request | datetime | YES | | 0001-01-01 00:00:00 | |
32 Return to [database documentation](help/database)