doc/database/db_photo.md

   1 Table photo
   2 ===========
   3
   4 | Field       | Description                                            | Type             | Null | Key | Default             | Extra           |
   5 | ----------- | ------------------------------------------------------ | ---------------- | ---- | --- | ------------------- | --------------- |
   6 | id          | sequential ID                                          | int(10) unsigned | NO   | PRI | NULL                | auto_increment  |
   7 | uid         | user.id of the owner of this data                      | int(10) unsigned | NO   | MUL | 0                   |                 |
   8 | contact-id  | contact.id                                             | int(10) unsigned | NO   |     | 0                   |                 |
   9 | guid        | A unique identifier for this photo                     | varchar(64)      | NO   | MUL |                     |                 |
  10 | resource-id |                                                        | varchar(255)     | NO   | MUL |                     |                 |
  11 | created     | creation date                                          | datetime         | NO   |     | 0001-01-01 00:00:00 |                 |
  12 | edited      | last edited date                                       | datetime         | NO   |     | 0001-01-01 00:00:00 |                 |
  13 | title       |                                                        | varchar(255)     | NO   |     |                     |                 |
  14 | desc        |                                                        | text             | NO   |     | NULL                |                 |
  15 | album       | The name of the album to which the photo belongs       | varchar(255)     | NO   |     |                     |                 |
  16 | filename    |                                                        | varchar(255)     | NO   |     |                     |                 |
  17 | type        |  image type                                            | varchar(128)     | NO   |     | image/jpeg          |                 |
  18 | height      |                                                        | smallint(6)      | NO   |     | 0                   |                 |
  19 | width       |                                                        | smallint(6)      | NO   |     | 0                   |                 |
  20 | size        |                                                        | int(10) unsigned | NO   |     | 0                   |                 |
  21 | data        |                                                        | mediumblob       | NO   |     | NULL                |                 |
  22 | scale       |                                                        | tinyint(3)       | NO   |     | 0                   |                 |
  23 | profile     |                                                        | tinyint(1)       | NO   |     | 0                   |                 |
  24 | allow_cid   | Access Control - list of allowed contact.id '<19><78>' | mediumtext       | NO   |     | NULL                |                 |
  25 | allow_gid   | Access Control - list of allowed groups                | mediumtext       | NO   |     | NULL                |                 |
  26 | deny_cid    | Access Control - list of denied contact.id             | mediumtext       | NO   |     | NULL                |                 |
  27 | deny_gid    | Access Control - list of denied groups                 | mediumtext       | NO   |     | NULL                |                 |
  28
  29 Return to [database documentation](help/database)