Table Structure of PeopleAggregator
From PeopleAggregator
[edit] announcements
This table is used to store the announcements made by network admin.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| content_id | int(11) | (NULL) | NO | select,insert,update,references | ||||
| announcement_time | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| announcement_time_end | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| position | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| status | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| is_active | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
[edit] audios
Audio is one of the content type.'audios' table is used to store audio specific information ie file name, file path of a content. The basic information ie title, description of an audio content is stored in master table say content table. Here content_id is related to master table.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| content_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| audio_file | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| audio_perm | int(2) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
[edit] blog_badges
'blog_badges' table is used to store badge related information.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| user_id | int(11) | (NULL) | NO | PRI | select,insert,update,references | |||
| badge_tag | varchar(32) | latin1_swedish_ci | NO | PRI | select,insert,update,references | |||
| badge_config | text | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| blog_badges | 0 | PRIMARY | 1 | user_id | A | (NULL) | (NULL) | (NULL) | BTREE | ||
| blog_badges | 0 | PRIMARY | 2 | badge_tag | A | 0 | (NULL) | (NULL) | BTREE |
[edit] boardmessages
'boardmessages' table is used to store the message of a group forum. 'user_id' relates group forum message to user table. 'parent_id' keeps track of messages, whether it is a new message or reply for a message.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| boardmessage_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| title | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| body | longtext | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| created | int(11) | (NULL) | YES | 0 | select,insert,update,references | |||
| changed | int(11) | (NULL) | YES | 0 | select,insert,update,references | |||
| user_id | int(11) | (NULL) | YES | 0 | select,insert,update,references | |||
| allow_anonymous | tinyint(1) | (NULL) | YES | 1 | select,insert,update,references | |||
| user_name | varchar(100) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| varchar(100) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | ||||
| homepage | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| parent_id | int(11) | (NULL) | YES | 0 | select,insert,update,references | |||
| parent_type | varchar(50) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| boardmessages | 0 | PRIMARY | 1 | boardmessage_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] categories
'categories' table stores basic category information such as network category, boardmessage category etc.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| category_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| position | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| name | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| description | text | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| is_active | tinyint(1) | (NULL) | YES | 0 | select,insert,update,references | |||
| created | int(11) | (NULL) | YES | 0 | select,insert,update,references | |||
| changed | int(11) | (NULL) | YES | 0 | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| categories | 0 | PRIMARY | 1 | category_id | A | 56 | (NULL) | (NULL) | BTREE |
[edit] categories_boardmessages
'categories_boardmessages' table relates boardmessages to its category. Here category_id relates this table to 'categories' table and boardmessage_id to 'boardmessages' table.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| category_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| boardmessage_id | int(11) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
[edit] comments
'comments' table is used to keep track of user comments for contents. Here content_id relates comment to 'content' table and user_id relates comment to 'users' table. For anonymous users, it keeps track of their basic information such as name, email, homepage.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| comment_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| content_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| user_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| subject | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| comment | longtext | latin1_swedish_ci | NO | select,insert,update,references | ||||
| created | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| changed | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| is_active | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| name | varchar(100) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| varchar(100) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | ||||
| homepage | varchar(100) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| ip_addr | varchar(32) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| referrer | text | latin1_swedish_ci | NO | select,insert,update,references | ||||
| user_agent | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| spam_state | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| akismet_spam | tinyint(1) | (NULL) | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| comments | 0 | PRIMARY | 1 | comment_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] content_routing_destinations
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| index_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| user_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| blog_name | varchar(50) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| blog_url | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| user_name | varchar(50) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| password | varchar(20) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| blog_type | char(2) | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| content_routing_destinations | 0 | PRIMARY | 1 | index_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] content_types
'content_types' defines types for content. Content type can be an image, an audio, video etc.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| type_id | int(2) | (NULL) | NO | PRI | 0 | select,insert,update,references | ||
| name | varchar(50) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| description | text | latin1_swedish_ci | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| content_types | 0 | PRIMARY | 1 | type_id | A | 8 | (NULL) | (NULL) | BTREE |
[edit] contentcollection_types
'contentcollection_types' defines whether a content belongs to a group or album. In this table, type id '1' stands for group and type id '2' stands for album.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| type_id | int(11) | (NULL) | NO | PRI | 0 | select,insert,update,references | ||
| name | varchar(50) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| description | text | latin1_swedish_ci | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| contentcollection_types | 0 | PRIMARY | 1 | type_id | A | 2 | (NULL) | (NULL) | BTREE |
[edit] contentcollections
'contentcollections' stores information of content collection type, ie group, album. Here type field relates to 'contentcollection_types'.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| collection_id | int(11) | (NULL) | NO | PRI | 0 | select,insert,update,references | ||
| type | int(2) | (NULL) | NO | 0 | select,insert,update,references | |||
| title | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| author_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| description | longtext | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| is_active | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| created | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| changed | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| picture | text | latin1_swedish_ci | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| contentcollections | 0 | PRIMARY | 1 | collection_id | A | 1 | (NULL) | (NULL) | BTREE |
[edit] contentcollections_albumtype
'contentcollections_albumtype' table stores the information of album type content collection.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| contentcollection_id | int(11) | (NULL) | NO | select,insert,update,references | ||||
| album_type_id | int(2) | (NULL) | NO | select,insert,update,references |
| Indexes |
[edit] contents
This table is used to store the information about the contents. 'author_id' relates 'contents' to 'users' table. collection_id relates 'contents' to 'contentcollections' table.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| content_id | int(11) | (NULL) | NO | PRI | 0 | select,insert,update,references | ||
| author_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| type | int(2) | (NULL) | NO | 0 | select,insert,update,references | |||
| title | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| is_active | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| body | longtext | latin1_swedish_ci | NO | select,insert,update,references | ||||
| allow_comments | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| collection_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| created | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| changed | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| trackbacks | text | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| display_on | tinyint(1) | (NULL) | YES | 0 | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| contents | 0 | PRIMARY | 1 | content_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] contents_sbmicrocontents
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| content_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| microcontent_id | int(11) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
[edit] domains_in_comments
[edit] external_feed
'external_feed' table is used to store information about external blogs.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| feed_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| import_url | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| max_posts | smallint(4) | (NULL) | YES | 5 | select,insert,update,references | |||
| is_active | int(2) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| feed_type | varchar(100) | latin1_swedish_ci | NO | user | select,insert,update,references | |||
| last_build_date | int(11) | (NULL) | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| external_feed | 0 | PRIMARY | 1 | feed_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] feed_data
'feed_data' table stores contents, blog posts of external feed ie external blogs.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| feed_data_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| feed_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| title | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| description | text | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| original_url | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| feed_data | 0 | PRIMARY | 1 | feed_data_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] forgot_password
'forgot_password' table keeps some information about user, if user forgets its password. Here forgot_password_id is unique which identifies the validity of url.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| user_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| forgot_password_id | varchar(255) | latin1_swedish_ci | NO | 0 | select,insert,update,references | |||
| status | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
[edit] groups
'groups' table keeps track of a group inforamation, such as group_id, access type, registration type etc.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| group_id | int(11) | (NULL) | NO | PRI | 0 | select,insert,update,references | ||
| access_type | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| reg_type | int(2) | (NULL) | NO | 0 | select,insert,update,references | |||
| is_moderated | tinyint(1) | (NULL) | NO | 0 | select,insert,update,references | |||
| category_id | int(11) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| groups | 0 | PRIMARY | 1 | group_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] groups_users
'groups_users' keeps track relation between the group and users. Here relationship type is many to many.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| group_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| user_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| user_type | varchar(50) | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
[edit] images
Image is one of the content type.'images' table is used to store image specific information ie file name, file permission of a content. The basic information ie title, description of an image content is stored in master table say content table. Here content_id is related to master table.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| content_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| image_file | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| image_perm | int(2) | (NULL) | NO | 0 | select,insert,update,references |
| Indexes |
[edit] invitations
'invitations' keeps track the information regarding invitation sent. inv_collection_id field identifies whether it is group invitation or invitation to join PeopleAggregator. 'inv_status' field states that whether the invitation is pending or accepted.
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| inv_id | varchar(255) | latin1_swedish_ci | NO | PRI | select,insert,update,references | |||
| user_id | int(11) | (NULL) | NO | select,insert,update,references | ||||
| inv_user_id | int(11) | (NULL) | NO | select,insert,update,references | ||||
| inv_user_email | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| inv_collection_id | int(11) | (NULL) | NO | select,insert,update,references | ||||
| inv_status | int(2) | (NULL) | NO | select,insert,update,references | ||||
| inv_data | longtext | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| invitations | 0 | PRIMARY | 1 | inv_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] linkcategories
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| category_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| category_name | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| user_id | int(11) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| created | int(11) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| changed | int(11) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| is_active | tinyint(1) | (NULL) | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| linkcategories | 0 | PRIMARY | 1 | category_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] links
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| link_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| title | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| url | varchar(255) | latin1_swedish_ci | YES | (NULL) | select,insert,update,references | |||
| category_id | int(11) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| created | int(11) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| changed | int(11) | (NULL) | YES | (NULL) | select,insert,update,references | |||
| is_active | tinyint(1) | (NULL) | YES | (NULL) | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| links | 0 | PRIMARY | 1 | link_id | A | 0 | (NULL) | (NULL) | BTREE |
[edit] mc_feeds
[edit] message_folder
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| fid | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references | |
| uid | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| name | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
| message_folder | 0 | PRIMARY | 1 | fid | A | 0 | (NULL) | (NULL) | BTREE |
[edit] moderation_queue
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| collection_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| item_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| type | varchar(20) | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
[edit] modules_settings
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| module_name | varchar(255) | latin1_swedish_ci | NO | select,insert,update,references | ||||
| module_id | int(11) | (NULL) | NO | 0 | select,insert,update,references | |||
| is_active | tinyint(2) | (NULL) | NO | 1 | select,insert,update,references | |||
| title | varchar(100) | latin1_swedish_ci | NO | select,insert,update,references |
| Indexes |
[edit] network_linkcategories
| Field | Type | Collation |