X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_tag.md;h=8c742917a748061e171a9f6ae3a7e6d5ad3aff37;hb=6a7fc07cbfb3d088891b90a873947d31e56d73fc;hp=8d7ae354f17268a4d4d963d6e9b76b26596a4711;hpb=a827f948c867ceebf60d82b0740032512be23302;p=friendica.git diff --git a/doc/database/db_tag.md b/doc/database/db_tag.md index 8d7ae354f1..8c742917a7 100644 --- a/doc/database/db_tag.md +++ b/doc/database/db_tag.md @@ -1,11 +1,25 @@ Table tag =========== + tags and mentions -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| id | | int unsigned | NO | PRI | NULL | auto_increment | -| name | | varchar(96) | NO | | | | -| url | | varbinary(255) | NO | | | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ----- | ----------- | -------------- | ---- | --- | ------- | -------------- | +| id | | int unsigned | NO | PRI | NULL | auto_increment | +| name | | varchar(96) | NO | | | | +| url | | varbinary(255) | NO | | | | + +Indexes +------------ + +| Name | Fields | +| ------------- | ----------------- | +| PRIMARY | id | +| type_name_url | UNIQUE, name, url | +| url | url | + Return to [database documentation](help/database)