Labs/Joey/database

Joey » Database

Schema Diagram (png)

Schema SQL (txt)

Field descriptions

	THIS PAGE MAY BE OUTDATED
	This article is in parts, or in its entirety, outdated. Hence, the information presented on this page may be incorrect, and should be treated with due caution until this flag has been lifted. Help by editing the article, or discuss its contents on the talk page.

Use the links above for the latest information.

users

+------------------+------------------+------+-----+---------+----------------+
| Field            | Description                                              |
+------------------+------------------+------+-----+---------+----------------+
| id               |                                                          |
| username         |                                                          |
| password         |                                                          |
| email            |                                                          |
| confirmationcode | If needed to confirm email, it's used.  Otherwise, null. |
| phone_id         |                                                          |
| operator_id      |                                                          |
| phonenumber      |                                                          |
| notes            |                                                          |
| disabled         |                                                          |
| created          |                                                          |
| modified         |                                                          |
+------------------+------------------+------+-----+---------+----------------+

operators

+-------------+------------------+------+-----+---------+-------------+
| Field       | Description                                           |
+-------------+------------------+------+-----+---------+-------------+
| id          |                                                       |
| provider    | Name of the provider (eg. T-Mobile, Nextel, etc.)     |
| emaildomain | The domain+tld if email SMS is supported              |
| created     |                                                       |
| modified    |                                                       |
+----------+------------------+------+-----+---------+----------------+

uploads

+----------+------------------+------+-----+---------+----------------+
| Field    | Description                                              |
+----------+------------------+------+-----+---------+----------------+
| id       |                                                          |
| user_id  |                                                          |
| title    | Defaults to referrer title, can be modified              |
| referrer | The source URL that this object was uploaded from        |
| created  |                                                          |
| modified |                                                          |
+----------+------------------+------+-----+---------+----------------+

files

+-----------+------------------+------+-----+---------+----------------+
| Field     | Description
+-----------+------------------+------+-----+---------+----------------+
| id        |                                                          |
| upload_id |                                                          |
| name      | The filename on disk                                     |
| size      | The size of the file on disk                             |
| type      | The type of the file (eg. image/png)                     |
| preview   | The filename of the preview on disk (always an image/png)|
| created   |                                                          |
| modified  |                                                          |
+-----------+------------------+------+-----+---------+----------------+

contentsources

+----------------------+------------------+------+-----+---------+-------+
| Field                | Description                                     |
+----------------------+------------------+------+-----+---------+-------+
| id                   |                                                 |
| upload_id            |                                                 |
| source               | Textual representation. Can be XML, a URL, etc. |
| contentsourcetype_id |                                                 |
| created              |                                                 |
| modified             |                                                 |
+----------------------+------------------+------+-----+---------+-------+

This table gets a bonus explanation. The `source` column is basically a pointer to information elsewhere on the web. As the project grows, the types of content (specified in `contentsourcetypes`) in this field can grow. The two supported types right now are microsummaries (XML) and RSS (URL).

contentsourcetypes

+----------+------------------+------+-----+---------+-----+
| Field    | Description                                   |
+----------+------------------+------+-----+---------+-----+
| id       |                                               |
| name     | The type of content (eg. application/rss+xml) |
| created  |                                               |
| modified |                                               |
+----------+------------------+------+-----+---------+-----+

phones

+----------+-------------------+
| Field    | Description       |
+----------+-------------------+
| id       |                   |
| name     | Name of the phone |
| created  |                   |
| modified |                   |
+----------+-------------------+

This is a table that will hold information about phones. It will expand as we get more information on the phones. If a phone doesn't exist, there will be a "generic" type with some safe defaults.