Confirmed users, Bureaucrats and Sysops emeriti
1,737
edits
Labs/Joey/database: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 3: | Line 3: | ||
[http://people.mozilla.org/~clouserw/public/joey/joey.schema.png Schema Diagram] (png) | [http://people.mozilla.org/~clouserw/public/joey/joey.schema.png Schema Diagram] (png) | ||
[http://svn.mozilla.org/labs/joey/trunk/servers/ | [http://svn.mozilla.org/labs/joey/trunk/servers/site/app/config/sql/joey.sql Schema SQL] (txt) | ||
== Field descriptions == | == Field descriptions == | ||
| Line 73: | Line 73: | ||
| modified | | | | 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.'' | |||
'''phones_users''' | |||
+-----------+-------------+ | |||
| Field | Description | | |||
+-----------+-------------+ | |||
| phones_id | | | |||
| users_id | | | |||
| created | | | |||
| modified | | | |||
+-----------+-------------+ | |||