]> git.mxchange.org Git - friendica.git/blob - doc/database/db_tag.md
Merge remote-tracking branch 'upstream/develop' into api-edit
[friendica.git] / doc / database / db_tag.md
1 Table tag
2 ===========
3
4 tags and mentions
5
6 Fields
7 ------
8
9 | Field | Description                                                                   | Type             | Null | Key | Default | Extra          |
10 | ----- | ----------------------------------------------------------------------------- | ---------------- | ---- | --- | ------- | -------------- |
11 | id    |                                                                               | int unsigned     | NO   | PRI | NULL    | auto_increment |
12 | name  |                                                                               | varchar(96)      | NO   |     |         |                |
13 | url   |                                                                               | varbinary(383)   | NO   |     |         |                |
14 | type  | Type of the tag (Unknown, General Collection, Follower Collection or Account) | tinyint unsigned | YES  |     | NULL    |                |
15
16 Indexes
17 ------------
18
19 | Name          | Fields            |
20 | ------------- | ----------------- |
21 | PRIMARY       | id                |
22 | type_name_url | UNIQUE, name, url |
23 | url           | url               |
24
25
26 Return to [database documentation](help/database)