]> git.mxchange.org Git - friendica.git/blob - doc/database/db_event.md
add $contact.change_member to the js template. At the present time we don't make...
[friendica.git] / doc / database / db_event.md
1 Table event
2 ===========
3
4 | Field      | Description                                            | Type                | Null | Key | Default             | Extra           |
5 | ---------- | ----------------------------------------------- -------| ------------------- | ---- | --- | ------------------- | --------------- |
6 | id         | sequential ID                                          | int(11)             | NO   | PRI | NULL                | auto_increment  |
7 | uid        | user_id of the owner of this data                      | int(11)             | NO   | MUL | 0                   |                 |
8 | cid        | contact_id (ID of the contact in contact table)        | int(11)             | NO   |     | 0                   |                 |
9 | uri        |                                                        | varchar(255)        | NO   |     |                     |                 |
10 | created    |  creation time                                         | datetime            | NO   |     | 0001-01-01 00:00:00 |                 |
11 | edited     | last edit time                                         | datetime            | NO   |     | 0001-01-01 00:00:00 |                 |
12 | start      | event start time                                       | datetime            | NO   |     | 0001-01-01 00:00:00 |                 |
13 | finish     | event end time                                         | datetime            | NO   |     | 0001-01-01 00:00:00 |                 |
14 | summary    |  short description or title of the event               | text                | NO   |     | NULL                |                 |
15 | desc       | event description                                      | text                | NO   |     | NULL                |                 |
16 | location   | event location                                         | text                | NO   |     | NULL                |                 |
17 | type       | event or birthday                                      | varchar(255)        | NO   |     |                     |                 |
18 | nofinish   | if event does have no end this is 1                    | tinyint(1)          | NO   |     | 0                   |                 |
19 | adjust     | adjust to timezone of the recipient (0 or 1)           | tinyint(1)          | NO   |     | 1                   |                 |
20 | ignore     | 0 or 1                                                 | tinyint(1) unsigned | NO   |     | 0                   |                 |
21 | allow_cid  | Access Control - list of allowed contact.id '<19><78>' | mediumtext          | NO   |     | NULL                |                 |
22 | allow_gid  | Access Control - list of allowed groups                | mediumtext          | NO   |     | NULL                |                 |
23 | deny_cid   | Access Control - list of denied contact.id             | mediumtext          | NO   |     | NULL                |                 |
24 | deny_gid   | Access Control - list of denied groups                 | mediumtext          | NO   |     | NULL                |                 |
25
26 Return to [database documentation](help/database)