friendica_2021.01_tupambae_.../doc/database/db_clients.md

Table clients
===========

OAuth usage

Fields
------

| Field        | Description | Type               | Null | Key | Default | Extra |
| ------------ | ----------- | ------------------ | ---- | --- | ------- | ----- |
| client_id    |             | varchar(20)        | NO   | PRI | NULL    |       |
| pw           |             | varchar(20)        | NO   |     |         |       |
| redirect_uri |             | varchar(200)       | NO   |     |         |       |
| name         |             | text               | YES  |     | NULL    |       |
| icon         |             | text               | YES  |     | NULL    |       |
| uid          | User id     | mediumint unsigned | NO   |     | 0       |       |

Indexes
------------

| Name    | Fields    |
| ------- | --------- |
| PRIMARY | client_id |
| uid     | uid       |

Foreign Keys
------------

| Field | Target Table | Target Field |
|-------|--------------|--------------|
| uid | [user](help/database/db_user) | uid |

Return to [database documentation](help/database)
docu - add schema of each db table 2015-12-28 02:50:25 +01:00			`Table clients`
Updates database structure documentation 2021-06-13 22:33:50 +02:00			`===========`
Trailing whitespace removed 2021-06-14 08:10:11 +02:00
Updates database structure documentation 2021-06-13 22:33:50 +02:00			`OAuth usage`
docu - add schema of each db table 2015-12-28 02:50:25 +01:00
Indexes and foreign keys added 2021-06-14 10:53:37 +02:00			`Fields`
			`------`

Trailing whitespace removed 2021-06-14 08:10:11 +02:00			`\| Field \| Description \| Type \| Null \| Key \| Default \| Extra \|`
			`\| ------------ \| ----------- \| ------------------ \| ---- \| --- \| ------- \| ----- \|`
			`\| client_id \| \| varchar(20) \| NO \| PRI \| NULL \| \|`
			`\| pw \| \| varchar(20) \| NO \| \| \| \|`
			`\| redirect_uri \| \| varchar(200) \| NO \| \| \| \|`
			`\| name \| \| text \| YES \| \| NULL \| \|`
			`\| icon \| \| text \| YES \| \| NULL \| \|`
			`\| uid \| User id \| mediumint unsigned \| NO \| \| 0 \| \|`
docu - add schema of each db table 2015-12-28 02:50:25 +01:00
Indexes and foreign keys added 2021-06-14 10:53:37 +02:00			`Indexes`
			`------------`

Formatted index list 2021-06-14 14:15:10 +02:00			`\| Name \| Fields \|`
			`\| ------- \| --------- \|`
Indexes and foreign keys added 2021-06-14 10:53:37 +02:00			`\| PRIMARY \| client_id \|`
Formatted index list 2021-06-14 14:15:10 +02:00			`\| uid \| uid \|`
Indexes and foreign keys added 2021-06-14 10:53:37 +02:00
			`Foreign Keys`
			`------------`

			`\| Field \| Target Table \| Target Field \|`
			`\|-------\|--------------\|--------------\|`
			`\| uid \| [user](help/database/db_user) \| uid \|`

docu - add schema of each db table 2015-12-28 02:50:25 +01:00			`Return to [database documentation](help/database)`