Location: PHPKode > projects > matsLETS > matslets-beta-1/doc/database-schema.txt
List of tables:
+--------------------+
| Tables_in_matslets |
+--------------------+
| accounts           | 
| announcements      | 
| autopayinstances   | 
| autopaymenttypes   | 
| currencies         | 
| mapslets           | 
| members            | 
| peopleskills       | 
| system_messages    | 
| transactions       | 
| transactiontypes   | 
| transports         | 
+--------------------+


Table name: accounts
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(5)      | NO   | PRI | NULL    | auto_increment | 
| accountname | varchar(25) | NO   |     |         |                | 
| createdtime | int(11)     | NO   |     | 0       |                | 
+-------------+-------------+------+-----+---------+----------------+

Table name: announcements
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(5)       | NO   | PRI | NULL    | auto_increment | 
| subject     | text         | NO   |     |         |                | 
| content     | varchar(250) | NO   |     |         |                | 
| postedbyid  | int(5)       | NO   |     | 0       |                | 
| public      | int(1)       | NO   |     | 0       |                | 
| mailshot    | int(1)       | NO   |     | 0       |                | 
| skilltypeid | int(2)       | NO   |     |         |                | 
| timestamp   | int(11)      | NO   |     | 0       |                | 
| expiry      | int(10)      | NO   |     | 0       |                | 
+-------------+--------------+------+-----+---------+----------------+

Table name: autopayinstances
+------------+---------+------+-----+---------+-------+
| Field      | Type    | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| instanceid | int(11) | NO   | PRI |         |       | 
| payerid    | int(11) | NO   |     |         |       | 
| paymentid  | int(11) | NO   |     |         |       | 
+------------+---------+------+-----+---------+-------+

Table name: autopaymenttypes
+----------------------+-------------+------+-----+---------+----------------+
| Field                | Type        | Null | Key | Default | Extra          |
+----------------------+-------------+------+-----+---------+----------------+
| id                   | int(5)      | NO   | PRI | NULL    | auto_increment | 
| name                 | varchar(30) | NO   |     |         |                | 
| explanation          | text        | NO   |     |         |                | 
| quantity             | int(5)      | NO   |     |         |                | 
| ispercent            | int(1)      | NO   |     |         |                | 
| currencyid           | int(3)      | NO   |     |         |                | 
| frequency            | varchar(10) | NO   |     |         |                | 
| roundedup            | int(1)      | NO   |     |         |                | 
| minimum              | int(5)      | NO   |     |         |                | 
| maximum              | int(5)      | NO   |     |         |                | 
| destinationaccountid | int(11)     | NO   |     |         |                | 
| directly             | int(1)      | NO   |     |         |                | 
| universal            | int(1)      | NO   |     |         |                | 
| active               | int(1)      | NO   |     |         |                | 
+----------------------+-------------+------+-----+---------+----------------+

Table name: currencies
+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment | 
| name        | varchar(15)         | NO   | UNI |         |                | 
| color       | varchar(6)          | NO   |     |         |                | 
| convertible | int(11)             | NO   |     | 0       |                | 
| tradable    | int(1)              | NO   |     | 1       |                | 
| value       | float               | NO   |     | 0       |                | 
| min         | varchar(3)          | YES  |     | NULL    |                | 
| max         | varchar(3)          | YES  |     | NULL    |                | 
+-------------+---------------------+------+-----+---------+----------------+

Table name: mapslets
+----------+------------+------+-----+---------+-------+
| Field    | Type       | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| postcode | varchar(8) | NO   | PRI |         |       | 
| lat      | float      | NO   |     |         |       | 
| lon      | float      | NO   |     |         |       | 
+----------+------------+------+-----+---------+-------+

Table name: members
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id                | int(11)      | NO   | PRI |         |       | 
| fullname          | varchar(128) | YES  |     | NULL    |       | 
| trading_name      | varchar(128) | YES  |     | NULL    |       | 
| password          | varchar(32)  | NO   |     |         |       | 
| address1          | varchar(30)  | NO   |     |         |       | 
| address2          | varchar(30)  | NO   |     |         |       | 
| address3          | text         | NO   |     |         |       | 
| address4          | varchar(30)  | YES  |     | NULL    |       | 
| postcode          | varchar(8)   | NO   |     |         |       | 
| latitude          | float        | YES  |     | NULL    |       | 
| longitude         | float        | YES  |     | NULL    |       | 
| email             | varchar(128) | YES  |     | NULL    |       | 
| contact_method1   | varchar(128) | YES  |     | NULL    |       | 
| contact1          | varchar(30)  | NO   |     |         |       | 
| contact_method2   | varchar(128) | YES  |     | NULL    |       | 
| contact2          | varchar(30)  | NO   |     |         |       | 
| homeurl           | varchar(100) | NO   |     |         |       | 
| reference         | varchar(128) | YES  |     | NULL    |       | 
| aboutme           | text         | NO   |     |         |       | 
| dob_year          | int(11)      | YES  |     | NULL    |       | 
| gender            | varchar(128) | YES  |     | NULL    |       | 
| smoking           | varchar(128) | YES  |     | NULL    |       |
| diet              | varchar(128) | YES  |     | NULL    |       | 
| employment_status | varchar(128) | YES  |     | NULL    |       | 
| transportid       | varchar(128) | YES  |     | NULL    |       | 
| special_needs     | varchar(128) | YES  |     | NULL    |       | 
| computer_skills   | varchar(128) | YES  |     | NULL    |       | 
| origin            | varchar(128) | YES  |     | NULL    |       | 
| ethnicity         | varchar(128) | YES  |     | NULL    |       | 
| language          | varchar(128) | YES  |     | NULL    |       | 
| other_info        | varchar(128) | YES  |     | NULL    |       | 
| availability      | varchar(128) | YES  |     | NULL    |       | 
| privilege         | varchar(128) | YES  |     | NULL    |       | 
| active            | int(1)       | NO   |     | 1       |       | 
| responsibility    | text         | YES  |     | NULL    |       | 
| lastlogin         | int(10)      | NO   |     | 0       |       | 
+-------------------+--------------+------+-----+---------+-------+

Table name: peopleskills
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(5)       | NO   | PRI | NULL    | auto_increment | 
| personid    | int(5)       | NO   |     | 0       |                | 
| description | varchar(150) | NO   |     |         |                | 
| skilltypeid | int(2)       | NO   |     | 0       |                | 
+-------------+--------------+------+-----+---------+----------------+

Table name: system_messages
+---------------+---------------------+------+-----+-------------------+----------------+
| Field         | Type                | Null | Key | Default           | Extra          |
+---------------+---------------------+------+-----+-------------------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment | 
| poster_id     | int(11)             | NO   |     |                   |                | 
| receiver_id   | int(11)             | NO   |     |                   |                | 
| msg           | varchar(200)        | YES  |     | NULL              |                | 
| creation_time | timestamp           | NO   |     | CURRENT_TIMESTAMP |                | 
+---------------+---------------------+------+-----+-------------------+----------------+

Table name: transactions
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(7)       | NO   | PRI | NULL    | auto_increment | 
| transtypeid | int(1)       | NO   |     |         |                | 
| fromid      | int(5)       | NO   |     | 0       |                | 
| toid        | int(5)       | NO   |     | 0       |                | 
| quant       | float        | NO   |     | 0       |                | 
| currencyid  | int(2)       | NO   |     | 1       |                | 
| comment     | varchar(250) | NO   |     |         |                | 
| skilltypeid | int(2)       | NO   |     | 0       |                | 
| visible     | int(1)       | NO   |     | 0       |                | 
| time        | int(11)      | NO   |     |         |                | 
| completed   | int(1)       | NO   |     | 0       |                | 
| dependson   | int(7)       | NO   |     |         |                | 
+-------------+--------------+------+-----+---------+----------------+

Table name: transactiontypes
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id         | int(11)     | NO   | PRI |         |       | 
| noun       | varchar(12) | NO   |     |         |       | 
| verb       | varchar(12) | NO   |     |         |       | 
| participle | varchar(12) | NO   |     |         |       | 
| push       | int(11)     | NO   |     |         |       | 
| confirm    | int(11)     | NO   |     |         |       | 
| public     | int(11)     | NO   |     |         |       | 
+------------+-------------+------+-----+---------+-------+

Table name: transports
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | NO   | PRI |         |       | 
| means | text    | NO   |     |         |       | 
+-------+---------+------+-----+---------+-------+


Return current item: matsLETS