Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of zot - Columns | Generated by SchemaSpy

Generated by SchemaSpy on on aug 19 21:08 CEST 2015 |
Legend: |
Primary key columns
Columns with indexes
Comments Legend

zot contains 705 columns - click on heading to sort:

Table | Column | Type | Size | Nulls | Auto | Default | Comments
--- | --- | --- | --- | --- | --- | --- | ---
abook | abook_id | int unsigned | 10 |  | √ |  |
account | account_id | int unsigned | 10 |  | √ |  |
channel | channel_id | int unsigned | 10 |  | √ |  |
chat | chat_id | int unsigned | 10 |  | √ |  |
chatpresence | cp_id | int unsigned | 10 |  | √ |  |
chatroom | cr_id | int unsigned | 10 |  | √ |  |
hubloc | hubloc_id | int unsigned | 10 |  | √ |  |
addon | id | int | 10 |  | √ |  |
app | id | int | 10 |  | √ |  |
attach | id | int unsigned | 10 |  | √ |  |
config | id | int unsigned | 10 |  | √ |  |
conv | id | int unsigned | 10 |  | √ |  |
event | id | int | 10 |  | √ |  |
fcontact | id | int unsigned | 10 |  | √ |  |
ffinder | id | int unsigned | 10 |  | √ |  |
fserver | id | int | 10 |  | √ |  |
fsuggest | id | int | 10 |  | √ |  |
group_member | id | int unsigned | 10 |  | √ |  |
groups | id | int unsigned | 10 |  | √ |  |
hook | id | int | 10 |  | √ |  |
item | id | int unsigned | 10 |  | √ |  |
item_id | id | int unsigned | 10 |  | √ |  |
likes | id | int unsigned | 10 |  | √ |  |
mail | id | int unsigned | 10 |  | √ |  |
manage | id | int | 10 |  | √ |  |
notify | id | int | 10 |  | √ |  |
pconfig | id | int | 10 |  | √ |  |
photo | id | int unsigned | 10 |  | √ |  |
profdef | id | int unsigned | 10 |  | √ |  |
profext | id | int unsigned | 10 |  | √ |  |
profile | id | int | 10 |  | √ |  |
profile_check | id | int unsigned | 10 |  | √ |  |
register | id | int unsigned | 10 |  | √ |  |
session | id | bigint unsigned | 20 |  | √ |  |
sign | id | int unsigned | 10 |  | √ |  |
spam | id | int | 10 |  | √ |  |
sys_perms | id | int unsigned | 10 |  | √ |  |
verify | id | int unsigned | 10 |  | √ |  |
xconfig | id | int unsigned | 10 |  | √ |  |
xign | id | int unsigned | 10 |  | √ |  |
issue | issue_id | int unsigned | 10 |  | √ |  |
menu | menu_id | int unsigned | 10 |  | √ |  |
menu_item | mitem_id | int unsigned | 10 |  | √ |  |
obj | obj_id | int unsigned | 10 |  | √ |  |
poll_elm | pelm_id | int unsigned | 10 |  | √ |  |
poll | poll_id | int unsigned | 10 |  | √ |  |
shares | share_id | int unsigned | 10 |  | √ |  |
source | src_id | int unsigned | 10 |  | √ |  |
term | tid | int unsigned | 10 |  | √ |  |
updates | ud_id | int unsigned | 10 |  | √ |  |
vote | vote_id | int unsigned | 10 |  | √ |  |
xchat | xchat_id | int unsigned | 10 |  | √ |  |
xlink | xlink_id | int unsigned | 10 |  | √ |  |
xperm | xp_id | int unsigned | 10 |  | √ |  |
xtag | xtag_id | int unsigned | 10 |  | √ |  |
abook | abook_account | int unsigned | 10 |  |  | 0 |
abook | abook_archived | tinyint | 3 |  |  | 0 |
abook | abook_blocked | tinyint | 3 |  |  | 0 |
abook | abook_channel | int unsigned | 10 |  |  | 0 |
abook | abook_closeness | tinyint unsigned | 3 |  |  | 99 |
abook | abook_connected | datetime | 19 |  |  | 0000-00-00 00:00:00 |
abook | abook_created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
abook | abook_dob | datetime | 19 |  |  | 0000-00-00 00:00:00 |
abook | abook_excl | text | 65535 |  |  |  |
abook | abook_feed | tinyint | 3 |  |  | 0 |
abook | abook_flags | int | 10 |  |  | 0 |
abook | abook_hidden | tinyint | 3 |  |  | 0 |
abook | abook_ignored | tinyint | 3 |  |  | 0 |
abook | abook_incl | text | 65535 |  |  |  |
abook | abook_my_perms | int | 10 |  |  | 0 |
abook | abook_pending | tinyint | 3 |  |  | 0 |
abook | abook_profile | char | 64 |  |  |  |
abook | abook_self | tinyint | 3 |  |  | 0 |
abook | abook_their_perms | int | 10 |  |  | 0 |
abook | abook_unconnected | tinyint | 3 |  |  | 0 |
abook | abook_updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
abook | abook_xchan | char | 255 |  |  |  |
profile | about | text | 65535 |  |  |  |
account | account_created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
account | account_default_channel | int unsigned | 10 |  |  | 0 |
account | account_email | char | 255 |  |  |  |
account | account_expire_notified | datetime | 19 |  |  | 0000-00-00 00:00:00 |
account | account_expires | datetime | 19 |  |  | 0000-00-00 00:00:00 |
account | account_external | char | 255 |  |  |  |
account | account_flags | int unsigned | 10 |  |  | 0 |
mail | account_id | int unsigned | 10 |  |  | 0 |
account | account_language | char | 16 |  |  | en |
account | account_lastlog | datetime | 19 |  |  | 0000-00-00 00:00:00 |
account | account_level | int unsigned | 10 |  |  | 0 |
account | account_parent | int unsigned | 10 |  |  | 0 |
account | account_password | char | 255 |  |  |  |
account | account_password_changed | datetime | 19 |  |  | 0000-00-00 00:00:00 |
account | account_reset | char | 255 |  |  |  |
account | account_roles | int unsigned | 10 |  |  | 0 |
account | account_salt | char | 32 |  |  |  |
account | account_service_class | char | 32 |  |  |  |
fcontact | addr | char | 255 |  |  |  |
profile | address | char | 255 |  |  |  |
event | adjust | bit | 0 |  |  | 1 |
attach | aid | int unsigned | 10 |  |  | 0 |
event | aid | int unsigned | 10 |  |  | 0 |
item | aid | int unsigned | 10 |  |  | 0 |
notify | aid | int | 10 |  |  | 0 |
photo | aid | int unsigned | 10 |  |  | 0 |
profile | aid | int unsigned | 10 |  |  | 0 |
term | aid | int unsigned | 10 |  |  | 0 |
photo | album | char | 255 |  |  |  |
fcontact | alias | char | 255 |  |  |  |
attach | allow_cid | mediumtext | 16777215 |  |  |  |
chatroom | allow_cid | mediumtext | 16777215 |  |  |  |
event | allow_cid | mediumtext | 16777215 |  |  |  |
item | allow_cid | mediumtext | 16777215 |  |  |  |
menu_item | allow_cid | mediumtext | 16777215 |  |  |  |
obj | allow_cid | mediumtext | 16777215 |  |  |  |
photo | allow_cid | mediumtext | 16777215 |  |  |  |
attach | allow_gid | mediumtext | 16777215 |  |  |  |
chatroom | allow_gid | mediumtext | 16777215 |  |  |  |
event | allow_gid | mediumtext | 16777215 |  |  |  |
item | allow_gid | mediumtext | 16777215 |  |  |  |
menu_item | allow_gid | mediumtext | 16777215 |  |  |  |
obj | allow_gid | mediumtext | 16777215 |  |  |  |
photo | allow_gid | mediumtext | 16777215 |  |  |  |
item | app | char | 255 |  |  |  |
app | app_addr | char | 255 |  |  |  |
app | app_author | char | 255 |  |  |  |
app | app_channel | int | 10 |  |  | 0 |
app | app_desc | text | 65535 |  |  |  |
app | app_id | char | 255 |  |  |  |
app | app_name | char | 255 |  |  |  |
app | app_page | char | 255 |  |  |  |
app | app_photo | char | 255 |  |  |  |
app | app_price | char | 255 |  |  |  |
app | app_requires | char | 255 |  |  |  |
app | app_sig | char | 255 |  |  |  |
app | app_url | char | 255 |  |  |  |
app | app_version | char | 255 |  |  |  |
item | attach | mediumtext | 16777215 |  |  |  |
mail | attach | mediumtext | 16777215 |  |  |  |
item | author_xchan | char | 255 |  |  |  |
fcontact | batch | char | 255 |  |  |  |
item | body | mediumtext | 16777215 |  |  |  |
mail | body | mediumtext | 16777215 |  |  |  |
profile | book | text | 65535 |  |  |  |
config | cat | char | 255 |  |  |  |
pconfig | cat | char | 255 |  |  |  |
sys_perms | cat | char | 255 |  |  |  |
xconfig | cat | char | 255 |  |  |  |
profile | chandesc | text | 65535 |  |  |  |
item | changed | datetime | 19 |  |  | 0000-00-00 00:00:00 |
verify | channel | int unsigned | 10 |  |  | 0 |
channel | channel_a_delegate | int unsigned | 10 |  |  | 0 |
channel | channel_a_republish | int unsigned | 10 |  |  | 0 |
channel | channel_account_id | int unsigned | 10 |  |  | 0 |
channel | channel_address | char | 255 |  |  |  |
channel | channel_allow_cid | mediumtext | 16777215 |  |  |  |
channel | channel_allow_gid | mediumtext | 16777215 |  |  |  |
channel | channel_default_group | char | 255 |  |  |  |
channel | channel_deleted | datetime | 19 |  |  | 0000-00-00 00:00:00 |
channel | channel_deny_cid | mediumtext | 16777215 |  |  |  |
channel | channel_deny_gid | mediumtext | 16777215 |  |  |  |
channel | channel_dirdate | datetime | 19 |  |  | 0000-00-00 00:00:00 |
channel | channel_expire_days | int | 10 |  |  | 0 |
channel | channel_guid | char | 255 |  |  |  |
channel | channel_guid_sig | text | 65535 |  |  |  |
channel | channel_hash | char | 255 |  |  |  |
likes | channel_id | int unsigned | 10 |  |  | 0 |
mail | channel_id | int unsigned | 10 |  |  | 0 |
profext | channel_id | int unsigned | 10 |  |  | 0 |
channel | channel_lastpost | datetime | 19 |  |  | 0000-00-00 00:00:00 |
channel | channel_location | char | 255 |  |  |  |
channel | channel_max_anon_mail | int unsigned | 10 |  |  | 10 |
channel | channel_max_friend_req | int unsigned | 10 |  |  | 10 |
channel | channel_name | char | 255 |  |  |  |
channel | channel_notifyflags | int unsigned | 10 |  |  | 65535 |
channel | channel_pageflags | int unsigned | 10 |  |  | 0 |
channel | channel_passwd_reset | char | 255 |  |  |  |
channel | channel_primary | bit | 0 |  |  | 0 |
channel | channel_prvkey | text | 65535 |  |  |  |
channel | channel_pubkey | text | 65535 |  |  |  |
channel | channel_r_abook | int unsigned | 10 |  |  | 0 |
channel | channel_r_pages | int unsigned | 10 |  |  | 0 |
channel | channel_r_photos | int unsigned | 10 |  |  | 0 |
channel | channel_r_profile | int unsigned | 10 |  |  | 0 |
channel | channel_r_storage | int unsigned | 10 |  |  | 0 |
channel | channel_r_stream | int unsigned | 10 |  |  | 0 |
channel | channel_removed | bit | 0 |  |  | 0 |
channel | channel_startpage | char | 255 |  |  |  |
channel | channel_system | bit | 0 |  |  | 0 |
channel | channel_theme | char | 255 |  |  |  |
channel | channel_timezone | char | 128 |  |  | UTC |
channel | channel_w_chat | int unsigned | 10 |  |  | 0 |
channel | channel_w_comment | int unsigned | 10 |  |  | 0 |
channel | channel_w_like | int unsigned | 10 |  |  | 0 |
channel | channel_w_mail | int unsigned | 10 |  |  | 0 |
channel | channel_w_pages | int unsigned | 10 |  |  | 0 |
channel | channel_w_photos | int unsigned | 10 |  |  | 0 |
channel | channel_w_storage | int unsigned | 10 |  |  | 0 |
channel | channel_w_stream | int unsigned | 10 |  |  | 0 |
channel | channel_w_tagwall | int unsigned | 10 |  |  | 0 |
channel | channel_w_wall | int unsigned | 10 |  |  | 0 |
profile | channels | text | 65535 |  |  |  |
chat | chat_room | int unsigned | 10 |  |  | 0 |
chat | chat_text | mediumtext | 16777215 |  |  |  |
chat | chat_xchan | char | 255 |  |  |  |
ffinder | cid | int unsigned | 10 |  |  |  |
fsuggest | cid | int | 10 |  |  | 0 |
profile_check | cid | int unsigned | 10 |  |  | 0 |
auth_codes | client_id | varchar | 20 |  |  |  |
clients | client_id | varchar | 20 |  |  |  |
tokens | client_id | varchar | 20 |  |  |  |
item | comment_policy | char | 255 |  |  |  |
item | commented | datetime | 19 |  |  | 0000-00-00 00:00:00 |
item | comments_closed | datetime | 19 |  |  | 0000-00-00 00:00:00 |
fcontact | confirm | char | 255 |  |  |  |
profile | contact | text | 65535 |  |  |  |
mail | convid | int unsigned | 10 |  |  | 0 |
item | coord | char | 255 |  |  |  |
profile | country_name | char | 255 |  |  |  |
chatpresence | cp_client | char | 128 |  |  |  |
chatpresence | cp_last | datetime | 19 |  |  | 0000-00-00 00:00:00 |
chatpresence | cp_room | int unsigned | 10 |  |  | 0 |
chatpresence | cp_status | char | 255 |  |  |  |
chatpresence | cp_xchan | char | 255 |  |  |  |
chatroom | cr_aid | int unsigned | 10 |  |  | 0 |
chatroom | cr_created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
chatroom | cr_edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
chatroom | cr_expire | int unsigned | 10 |  |  | 0 |
chatroom | cr_name | char | 255 |  |  |  |
chatroom | cr_uid | int unsigned | 10 |  |  | 0 |
attach | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
chat | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
conv | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
event | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
fsuggest | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
item | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
mail | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
photo | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
register | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
verify | created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
attach | creator | char | 128 |  |  |  |
conv | creator | char | 255 |  |  |  |
attach | data | longblob | 2147483647 |  |  |  |
photo | data | mediumblob | 16777215 |  |  |  |
session | data | text | 65535 |  |  |  |
notify | date | datetime | 19 |  |  | 0000-00-00 00:00:00 |
spam | date | datetime | 19 |  |  | 0000-00-00 00:00:00 |
groups | deleted | bit | 0 |  |  | 0 |
attach | deny_cid | mediumtext | 16777215 |  |  |  |
chatroom | deny_cid | mediumtext | 16777215 |  |  |  |
event | deny_cid | mediumtext | 16777215 |  |  |  |
item | deny_cid | mediumtext | 16777215 |  |  |  |
menu_item | deny_cid | mediumtext | 16777215 |  |  |  |
obj | deny_cid | mediumtext | 16777215 |  |  |  |
photo | deny_cid | mediumtext | 16777215 |  |  |  |
attach | deny_gid | mediumtext | 16777215 |  |  |  |
chatroom | deny_gid | mediumtext | 16777215 |  |  |  |
event | deny_gid | mediumtext | 16777215 |  |  |  |
item | deny_gid | mediumtext | 16777215 |  |  |  |
menu_item | deny_gid | mediumtext | 16777215 |  |  |  |
obj | deny_gid | mediumtext | 16777215 |  |  |  |
photo | deny_gid | mediumtext | 16777215 |  |  |  |
event | description | text | 65535 |  |  |  |
photo | description | text | 65535 |  |  |  |
profile_check | dfrn_id | char | 255 |  |  |  |
item | diaspora_meta | mediumtext | 16777215 |  |  |  |
profile | dislikes | text | 65535 |  |  |  |
attach | display_path | mediumtext | 16777215 |  |  |  |
photo | display_path | mediumtext | 16777215 |  |  |  |
profile | dob | char | 32 |  |  | 0000-00-00 |
profile | dob_tz | char | 255 |  |  | UTC |
attach | edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
event | edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
item | edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
photo | edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
profile | education | text | 65535 |  |  |  |
event | event_hash | char | 255 |  |  |  |
event | event_percent | smallint | 5 |  |  | 0 |
event | event_repeat | text | 65535 |  |  |  |
event | event_sequence | smallint | 5 |  |  | 0 |
event | event_status | char | 255 |  |  |  |
event | event_status_date | datetime | 19 |  |  | 0000-00-00 00:00:00 |
event | event_xchan | char | 255 |  |  |  |
profile_check | expire | int | 10 |  |  | 0 |
session | expire | bigint unsigned | 20 |  |  | 0 |
auth_codes | expires | int | 10 |  |  | 0 |
item | expires | datetime | 19 |  |  | 0000-00-00 00:00:00 |
mail | expires | datetime | 19 |  |  | 0000-00-00 00:00:00 |
tokens | expires | bigint unsigned | 20 |  |  | 0 |
ffinder | fid | int unsigned | 10 |  |  |  |
profdef | field_desc | char | 255 |  |  |  |
profdef | field_help | char | 255 |  |  |  |
profdef | field_inputs | mediumtext | 16777215 |  |  |  |
profdef | field_name | char | 255 |  |  |  |
profdef | field_type | char | 16 |  |  |  |
hook | file | char | 255 |  |  |  |
attach | filename | char | 255 |  |  |  |
photo | filename | char | 255 |  |  |  |
attach | filesize | int unsigned | 10 |  |  | 0 |
attach | filetype | char | 64 |  |  |  |
profile | film | text | 65535 |  |  |  |
event | finish | datetime | 19 |  |  | 0000-00-00 00:00:00 |
attach | flags | int unsigned | 10 |  |  | 0 |
attach | folder | char | 64 |  |  |  |
mail | from_xchan | char | 255 |  |  |  |
hook | function | char | 255 |  |  |  |
profile | gender | char | 32 |  |  |  |
group_member | gid | int unsigned | 10 |  |  | 0 |
conv | guid | char | 255 |  |  |  |
spam | ham | int | 10 |  |  | 0 |
attach | hash | char | 64 |  |  |  |
groups | hash | char | 255 |  |  |  |
notify | hash | char | 64 |  |  |  |
profext | hash | char | 255 |  |  |  |
register | hash | char | 255 |  |  |  |
photo | height | smallint | 5 |  |  | 0 |
addon | hidden | bit | 0 |  |  | 0 |
profile | hide_friends | bit | 0 |  |  | 0 |
profile | homepage | char | 255 |  |  |  |
profile | hometown | char | 255 |  |  |  |
hook | hook | char | 255 |  |  |  |
profile | howlong | datetime | 19 |  |  | 0000-00-00 00:00:00 |
item | html | mediumtext | 16777215 |  |  |  |
hubloc | hubloc_addr | char | 255 |  |  |  |
hubloc | hubloc_callback | char | 255 |  |  |  |
hubloc | hubloc_connect | char | 255 |  |  |  |
hubloc | hubloc_connected | datetime | 19 |  |  | 0000-00-00 00:00:00 |
hubloc | hubloc_deleted | bit | 0 |  |  | 0 |
hubloc | hubloc_error | bit | 0 |  |  | 0 |
hubloc | hubloc_flags | int unsigned | 10 |  |  | 0 |
hubloc | hubloc_guid | char | 255 |  |  |  |
hubloc | hubloc_guid_sig | text | 65535 |  |  |  |
hubloc | hubloc_hash | char | 255 |  |  |  |
hubloc | hubloc_host | char | 255 |  |  |  |
hubloc | hubloc_network | char | 32 |  |  |  |
hubloc | hubloc_orphancheck | bit | 0 |  |  | 0 |
hubloc | hubloc_primary | bit | 0 |  |  | 0 |
hubloc | hubloc_sitekey | text | 65535 |  |  |  |
hubloc | hubloc_status | int unsigned | 10 |  |  | 0 |
hubloc | hubloc_updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
hubloc | hubloc_url | char | 255 |  |  |  |
hubloc | hubloc_url_sig | text | 65535 |  |  |  |
clients | icon | text | 65535 | √ |  | null |
auth_codes | id | varchar | 40 |  |  |  |
tokens | id | varchar | 40 |  |  |  |
event | ignore | bit | 0 |  |  | 0 |
item_id | iid | int | 10 |  |  | 0 |
likes | iid | int unsigned | 10 |  |  | 0 |
sign | iid | int unsigned | 10 |  |  | 0 |
term | imgurl | char | 255 |  |  |  |
addon | installed | bit | 0 |  |  | 0 |
profile | interest | text | 65535 |  |  |  |
profile | is_default | bit | 0 |  |  | 0 |
attach | is_dir | bit | 0 |  |  | 0 |
photo | is_nsfw | bit | 0 |  |  | 0 |
attach | is_photo | bit | 0 |  |  | 0 |
issue | issue_assigned | char | 255 |  |  |  |
issue | issue_component | char | 255 |  |  |  |
issue | issue_created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
issue | issue_priority | int | 10 |  |  | 0 |
issue | issue_status | int | 10 |  |  | 0 |
issue | issue_updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
item | item_blocked | bit | 0 |  |  | 0 |
item | item_consensus | bit | 0 |  |  | 0 |
item | item_delayed | bit | 0 |  |  | 0 |
item | item_deleted | bit | 0 |  |  | 0 |
item | item_flags | int | 10 |  |  | 0 |
item | item_hidden | bit | 0 |  |  | 0 |
item | item_mentionsme | bit | 0 |  |  | 0 |
item | item_nocomment | bit | 0 |  |  | 0 |
item | item_notshown | bit | 0 |  |  | 0 |
item | item_nsfw | bit | 0 |  |  | 0 |
item | item_obscured | bit | 0 |  |  | 0 |
item | item_origin | bit | 0 |  |  | 0 |
item | item_pending_remove | bit | 0 |  |  | 0 |
item | item_private | bit | 0 |  |  | 0 |
item | item_relay | bit | 0 |  |  | 0 |
item | item_restrict | int | 10 |  |  | 0 |
item | item_retained | bit | 0 |  |  | 0 |
item | item_rss | bit | 0 |  |  | 0 |
item | item_starred | bit | 0 |  |  | 0 |
item | item_thread_top | bit | 0 |  |  | 0 |
item | item_type | int | 10 |  |  | 0 |
item | item_unpublished | bit | 0 |  |  | 0 |
item | item_unseen | bit | 0 |  |  | 0 |
item | item_uplink | bit | 0 |  |  | 0 |
item | item_verified | bit | 0 |  |  | 0 |
item | item_wall | bit | 0 |  |  | 0 |
cache | k | char | 255 |  |  |  |
config | k | char | 255 |  |  |  |
pconfig | k | char | 255 |  |  |  |
profext | k | char | 255 |  |  |  |
sys_perms | k | char | 255 |  |  |  |
xconfig | k | char | 255 |  |  |  |
fserver | key | text | 65535 |  |  |  |
profile | keywords | text | 65535 |  |  |  |
item | lang | char | 64 |  |  |  |
register | language | char | 16 |  |  |  |
item | layout_mid | char | 255 |  |  |  |
likes | likee | char | 128 |  |  |  |
likes | liker | char | 128 |  |  |  |
profile | likes | text | 65535 |  |  |  |
notify | link | char | 255 |  |  |  |
item | llink | char | 255 |  |  |  |
profile | locality | char | 255 |  |  |  |
event | location | text | 65535 |  |  |  |
item | location | char | 255 |  |  |  |
mail | mail_deleted | tinyint | 3 |  |  | 0 |
mail | mail_flags | int unsigned | 10 |  |  | 0 |
mail | mail_isreply | tinyint | 3 |  |  | 0 |
mail | mail_obscured | smallint | 5 |  |  | 0 |
mail | mail_recalled | tinyint | 3 |  |  | 0 |
mail | mail_replied | tinyint | 3 |  |  | 0 |
mail | mail_seen | tinyint | 3 |  |  | 0 |
profile | marital | char | 255 |  |  |  |
menu | menu_channel_id | int unsigned | 10 |  |  | 0 |
menu | menu_created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
menu | menu_desc | char | 255 |  |  |  |
menu | menu_edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
menu | menu_flags | int | 10 |  |  | 0 |
menu | menu_name | char | 255 |  |  |  |
verify | meta | char | 255 |  |  |  |
item | mid | char | 255 |  |  |  |
mail | mid | char | 255 |  |  |  |
item | mimetype | char | 255 |  |  |  |
menu_item | mitem_channel_id | int unsigned | 10 |  |  | 0 |
menu_item | mitem_desc | char | 255 |  |  |  |
menu_item | mitem_flags | int | 10 |  |  | 0 |
menu_item | mitem_link | char | 255 |  |  |  |
menu_item | mitem_menu_id | int unsigned | 10 |  |  | 0 |
menu_item | mitem_order | int | 10 |  |  | 0 |
notify | msg | mediumtext | 16777215 |  |  |  |
profile | music | text | 65535 |  |  |  |
addon | name | char | 255 |  |  |  |
clients | name | text | 65535 | √ |  | null |
fcontact | name | char | 255 |  |  |  |
fsuggest | name | char | 255 |  |  |  |
groups | name | char | 255 |  |  |  |
notify | name | char | 255 |  |  |  |
profile | name | char | 255 |  |  |  |
fcontact | network | char | 32 |  |  |  |
fcontact | nick | char | 255 |  |  |  |
event | nofinish | bit | 0 |  |  | 0 |
fsuggest | note | text | 65535 |  |  |  |
fcontact | notify | char | 255 |  |  |  |
obj | obj_channel | int unsigned | 10 |  |  | 0 |
obj | obj_obj | char | 255 |  |  |  |
obj | obj_page | char | 64 |  |  |  |
item | obj_type | char | 255 |  |  |  |
obj | obj_type | int unsigned | 10 |  |  | 0 |
obj | obj_verb | char | 255 |  |  |  |
item | object | text | 65535 |  |  |  |
term | oid | int unsigned | 10 |  |  | 0 |
attach | os_path | mediumtext | 16777215 |  |  |  |
photo | os_path | mediumtext | 16777215 |  |  |  |
attach | os_storage | bit | 0 |  |  | 0 |
photo | os_storage | bit | 0 |  |  | 0 |
notify | otype | char | 16 |  |  |  |
term | otype | tinyint unsigned | 3 |  |  | 0 |
outq | outq_account | int unsigned | 10 |  |  | 0 |
outq | outq_async | bit | 0 |  |  | 0 |
outq | outq_channel | int unsigned | 10 |  |  | 0 |
outq | outq_created | datetime | 19 |  |  | 0000-00-00 00:00:00 |
outq | outq_delivered | bit | 0 |  |  | 0 |
outq | outq_driver | char | 32 |  |  |  |
outq | outq_hash | char | 255 |  |  |  |
outq | outq_msg | mediumtext | 16777215 |  |  |  |
outq | outq_notify | mediumtext | 16777215 |  |  |  |
outq | outq_posturl | char | 255 |  |  |  |
outq | outq_priority | smallint | 5 |  |  | 0 |
outq | outq_updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
item | owner_xchan | char | 255 |  |  |  |
item | parent | int unsigned | 10 |  |  | 0 |
notify | parent | char | 255 |  |  |  |
term | parent_hash | char | 255 |  |  |  |
item | parent_mid | char | 255 |  |  |  |
mail | parent_mid | char | 255 |  |  |  |
register | password | char | 255 |  |  |  |
profile | pdesc | char | 255 |  |  |  |
poll_elm | pelm_desc | text | 65535 |  |  |  |
poll_elm | pelm_flags | int | 10 |  |  | 0 |
poll_elm | pelm_poll | int unsigned | 10 |  |  | 0 |
poll_elm | pelm_result | float | 12 |  |  | 0 |
fcontact | photo | char | 255 |  |  |  |
fsuggest | photo | char | 255 |  |  |  |
notify | photo | char | 255 |  |  |  |
profile | photo | char | 255 |  |  |  |
photo | photo_flags | int unsigned | 10 |  |  | 0 |
photo | photo_usage | smallint | 5 |  |  | 0 |
item | plink | char | 255 |  |  |  |
addon | plugin_admin | bit | 0 |  |  | 0 |
profile | politic | char | 255 |  |  |  |
fcontact | poll | char | 255 |  |  |  |
poll | poll_channel | int unsigned | 10 |  |  | 0 |
poll | poll_desc | text | 65535 |  |  |  |
poll | poll_flags | int | 10 |  |  | 0 |
poll | poll_votes | int | 10 |  |  | 0 |
profile | postal_code | char | 32 |  |  |  |
item | postopts | text | 65535 |  |  |  |
fserver | posturl | char | 255 |  |  |  |
fcontact | priority | bit | 0 |  |  |  |
hook | priority | int unsigned | 10 |  |  | 0 |
photo | profile | bit | 0 |  |  | 0 |
profile | profile_guid | char | 64 |  |  |  |
profile | profile_name | char | 255 |  |  |  |
fcontact | pubkey | text | 65535 |  |  |  |
sys_perms | public_perm | bit | 0 |  |  | 0 |
item | public_policy | char | 255 |  |  |  |
profile | publish | bit | 0 |  |  | 0 |
clients | pw | varchar | 20 |  |  |  |
item | received | datetime | 19 |  |  | 0000-00-00 00:00:00 |
conv | recips | mediumtext | 16777215 |  |  |  |
auth_codes | redirect_uri | varchar | 200 |  |  |  |
clients | redirect_uri | varchar | 200 |  |  |  |
profile | region | char | 255 |  |  |  |
profile | religion | char | 255 |  |  |  |
fcontact | request | char | 255 |  |  |  |
fsuggest | request | char | 255 |  |  |  |
item | resource_id | char | 255 |  |  |  |
photo | resource_id | char | 255 |  |  |  |
item | resource_type | char | 16 |  |  |  |
sign | retract_iid | int unsigned | 10 |  |  | 0 |
attach | revision | int unsigned | 10 |  |  | 0 |
item | revision | int unsigned | 10 |  |  | 0 |
profile | romance | text | 65535 |  |  |  |
item | route | text | 65535 |  |  |  |
photo | scale | tinyint | 3 |  |  | 0 |
auth_codes | scope | varchar | 250 |  |  |  |
tokens | scope | varchar | 200 |  |  |  |
profile_check | sec | char | 255 |  |  |  |
tokens | secret | text | 65535 |  |  |  |
notify | seen | bit | 0 |  |  | 0 |
fserver | server | char | 255 |  |  |  |
item_id | service | char | 255 |  |  |  |
profile | sexual | char | 255 |  |  |  |
shares | share_target | int unsigned | 10 |  |  | 0 |
shares | share_type | int | 10 |  |  | 0 |
shares | share_xchan | char | 255 |  |  |  |
item_id | sid | char | 255 |  |  |  |
session | sid | char | 255 |  |  |  |
item | sig | text | 65535 |  |  |  |
mail | sig | text | 65535 |  |  |  |
sign | signature | text | 65535 |  |  |  |
sign | signed_text | mediumtext | 16777215 |  |  |  |
sign | signer | char | 255 |  |  |  |
site | site_access | int | 10 |  |  | 0 |
site | site_dead | smallint | 5 |  |  | 0 |
site | site_directory | char | 255 |  |  |  |
site | site_flags | int | 10 |  |  | 0 |
site | site_location | char | 255 |  |  |  |
site | site_pull | datetime | 19 |  |  | 0000-00-00 00:00:00 |
site | site_realm | char | 255 |  |  |  |
site | site_register | int | 10 |  |  | 0 |
site | site_sellpage | char | 255 |  |  |  |
site | site_sync | datetime | 19 |  |  | 0000-00-00 00:00:00 |
site | site_update | datetime | 19 |  |  | 0000-00-00 00:00:00 |
site | site_url | char | 255 |  |  |  |
site | site_valid | smallint | 5 |  |  | 0 |
photo | size | int unsigned | 10 |  |  | 0 |
item | source_xchan | char | 255 |  |  |  |
spam | spam | int | 10 |  |  | 0 |
source | src_channel_id | int unsigned | 10 |  |  | 0 |
source | src_channel_xchan | char | 255 |  |  |  |
source | src_patt | mediumtext | 16777215 |  |  |  |
source | src_xchan | char | 255 |  |  |  |
event | start | datetime | 19 |  |  | 0000-00-00 00:00:00 |
conv | subject | mediumtext | 16777215 |  |  |  |
event | summary | text | 65535 |  |  |  |
profile | summary | char | 255 |  |  |  |
item | target | text | 65535 |  |  |  |
likes | target | mediumtext | 16777215 |  |  |  |
likes | target_id | char | 128 |  |  |  |
likes | target_type | char | 255 |  |  |  |
spam | term | char | 255 |  |  |  |
term | term | char | 255 |  |  |  |
term | term_hash | char | 255 |  |  |  |
item | tgt_type | char | 255 |  |  |  |
item | thr_parent | char | 255 |  |  |  |
profile | thumb | char | 255 |  |  |  |
addon | timestamp | bigint | 19 |  |  | 0 |
item | title | text | 65535 |  |  |  |
mail | title | text | 65535 |  |  |  |
photo | title | char | 255 |  |  |  |
mail | to_xchan | char | 255 |  |  |  |
verify | token | char | 255 |  |  |  |
profile | tv | text | 65535 |  |  |  |
event | type | char | 255 |  |  |  |
notify | type | int | 10 |  |  | 0 |
photo | type | char | 128 |  |  | image/jpeg |
term | type | tinyint unsigned | 3 |  |  | 0 |
verify | type | char | 32 |  |  |  |
updates | ud_addr | char | 255 |  |  |  |
updates | ud_date | datetime | 19 |  |  | 0000-00-00 00:00:00 |
updates | ud_flags | int | 10 |  |  | 0 |
updates | ud_guid | char | 255 |  |  |  |
updates | ud_hash | char | 128 |  |  |  |
updates | ud_last | datetime | 19 |  |  | 0000-00-00 00:00:00 |
attach | uid | int unsigned | 10 |  |  | 0 |
clients | uid | int | 10 |  |  | 0 |
conv | uid | int | 10 |  |  | 0 |
event | uid | int | 10 |  |  | 0 |
ffinder | uid | int unsigned | 10 |  |  |  |
fsuggest | uid | int | 10 |  |  | 0 |
group_member | uid | int unsigned | 10 |  |  | 0 |
groups | uid | int unsigned | 10 |  |  | 0 |
item | uid | int unsigned | 10 |  |  | 0 |
item_id | uid | int | 10 |  |  | 0 |
manage | uid | int | 10 |  |  | 0 |
notify | uid | int | 10 |  |  | 0 |
pconfig | uid | int | 10 |  |  | 0 |
photo | uid | int unsigned | 10 |  |  | 0 |
profile | uid | int | 10 |  |  | 0 |
profile_check | uid | int unsigned | 10 |  |  | 0 |
register | uid | int unsigned | 10 |  |  | 0 |
spam | uid | int | 10 |  |  | 0 |
term | uid | int unsigned | 10 |  |  | 0 |
tokens | uid | int | 10 |  |  | 0 |
xign | uid | int | 10 |  |  | 0 |
cache | updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
conv | updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
fcontact | updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
fcontact | url | char | 255 |  |  |  |
fsuggest | url | char | 255 |  |  |  |
notify | url | char | 255 |  |  |  |
term | url | char | 255 |  |  |  |
cache | v | text | 65535 |  |  |  |
config | v | text | 65535 |  |  |  |
pconfig | v | mediumtext | 16777215 |  |  |  |
profext | v | mediumtext | 16777215 |  |  |  |
sys_perms | v | mediumtext | 16777215 |  |  |  |
xconfig | v | mediumtext | 16777215 |  |  |  |
item | verb | char | 255 |  |  |  |
likes | verb | char | 255 |  |  |  |
notify | verb | char | 255 |  |  |  |
addon | version | char | 255 |  |  |  |
groups | visible | bit | 0 |  |  | 0 |
vote | vote_element | int | 10 |  |  | 0 |
vote | vote_poll | int | 10 |  |  | 0 |
vote | vote_result | text | 65535 |  |  |  |
vote | vote_xchan | char | 255 |  |  |  |
photo | width | smallint | 5 |  |  | 0 |
profile | with | text | 65535 |  |  |  |
profile | work | text | 65535 |  |  |  |
group_member | xchan | char | 255 |  |  |  |
manage | xchan | char | 255 |  |  |  |
photo | xchan | char | 255 |  |  |  |
xconfig | xchan | char | 255 |  |  |  |
xign | xchan | char | 255 |  |  |  |
xchan | xchan_addr | char | 255 |  |  |  |
xchan | xchan_censored | bit | 0 |  |  | 0 |
xchan | xchan_connpage | char | 255 |  |  |  |
xchan | xchan_connurl | char | 255 |  |  |  |
xchan | xchan_deleted | bit | 0 |  |  | 0 |
xchan | xchan_flags | int unsigned | 10 |  |  | 0 |
xchan | xchan_follow | char | 255 |  |  |  |
xchan | xchan_guid | char | 255 |  |  |  |
xchan | xchan_guid_sig | text | 65535 |  |  |  |
xchan | xchan_hash | char | 255 |  |  |  |
xchan | xchan_hidden | bit | 0 |  |  | 0 |
xchan | xchan_instance_url | char | 255 |  |  |  |
xchan | xchan_name | char | 255 |  |  |  |
xchan | xchan_name_date | datetime | 19 |  |  | 0000-00-00 00:00:00 |
xchan | xchan_network | char | 255 |  |  |  |
xchan | xchan_orphan | bit | 0 |  |  | 0 |
xchan | xchan_photo_date | datetime | 19 |  |  | 0000-00-00 00:00:00 |
xchan | xchan_photo_l | char | 255 |  |  |  |
xchan | xchan_photo_m | char | 255 |  |  |  |
xchan | xchan_photo_mimetype | char | 32 |  |  | image/jpeg |
xchan | xchan_photo_s | char | 255 |  |  |  |
xchan | xchan_pubforum | bit | 0 |  |  | 0 |
xchan | xchan_pubkey | text | 65535 |  |  |  |
xchan | xchan_selfcensored | bit | 0 |  |  | 0 |
xchan | xchan_system | bit | 0 |  |  | 0 |
xchan | xchan_url | char | 255 |  |  |  |
xchat | xchat_desc | char | 255 |  |  |  |
xchat | xchat_edited | datetime | 19 |  |  | 0000-00-00 00:00:00 |
xchat | xchat_url | char | 255 |  |  |  |
xchat | xchat_xchan | char | 255 |  |  |  |
xlink | xlink_link | char | 255 |  |  |  |
xlink | xlink_rating | int | 10 |  |  | 0 |
xlink | xlink_rating_text | text | 65535 |  |  |  |
xlink | xlink_sig | text | 65535 |  |  |  |
xlink | xlink_static | bit | 0 |  |  | 0 |
xlink | xlink_updated | datetime | 19 |  |  | 0000-00-00 00:00:00 |
xlink | xlink_xchan | char | 255 |  |  |  |
xperm | xp_channel | int unsigned | 10 |  |  | 0 |
xperm | xp_client | varchar | 20 |  |  |  |
xperm | xp_perm | varchar | 64 |  |  |  |
xprof | xprof_about | text | 65535 |  |  |  |
xprof | xprof_age | tinyint unsigned | 3 |  |  | 0 |
xprof | xprof_country | char | 255 |  |  |  |
xprof | xprof_desc | char | 255 |  |  |  |
xprof | xprof_dob | char | 12 |  |  |  |
xprof | xprof_gender | char | 255 |  |  |  |
xprof | xprof_hash | char | 255 |  |  |  |
xprof | xprof_homepage | char | 255 |  |  |  |
xprof | xprof_hometown | char | 255 |  |  |  |
xprof | xprof_keywords | text | 65535 |  |  |  |
xprof | xprof_locale | char | 255 |  |  |  |
xprof | xprof_marital | char | 255 |  |  |  |
xprof | xprof_postcode | char | 32 |  |  |  |
xprof | xprof_region | char | 255 |  |  |  |
xprof | xprof_sexual | char | 255 |  |  |  |
xtag | xtag_flags | int | 10 |  |  | 0 |
xtag | xtag_hash | char | 255 |  |  |  |
xtag | xtag_term | char | 255 |  |  |  |