structure

===Database nextcloud

== Tabellstruktur for tabell oc_accounts

|------
|Kolonne|Type|Null|Standard
|------
|//**uid**//|varchar(64)|Nei|
|data|longtext|Nei|
== Tabellstruktur for tabell oc_activity

|------
|Kolonne|Type|Null|Standard
|------
|//**activity_id**//|bigint(20)|Nei|
|timestamp|int(11)|Nei|0
|priority|int(11)|Nei|0
|type|varchar(255)|Ja|NULL
|user|varchar(64)|Ja|NULL
|affecteduser|varchar(64)|Nei|
|app|varchar(32)|Nei|
|subject|varchar(255)|Nei|
|subjectparams|longtext|Nei|
|message|varchar(255)|Ja|NULL
|messageparams|longtext|Ja|NULL
|file|varchar(4000)|Ja|NULL
|link|varchar(4000)|Ja|NULL
|object_type|varchar(255)|Ja|NULL
|object_id|bigint(20)|Nei|0
== Tabellstruktur for tabell oc_activity_mq

|------
|Kolonne|Type|Null|Standard
|------
|//**mail_id**//|bigint(20)|Nei|
|amq_timestamp|int(11)|Nei|0
|amq_latest_send|int(11)|Nei|0
|amq_type|varchar(255)|Nei|
|amq_affecteduser|varchar(64)|Nei|
|amq_appid|varchar(255)|Nei|
|amq_subject|varchar(255)|Nei|
|amq_subjectparams|varchar(4000)|Nei|
== Tabellstruktur for tabell oc_addressbookchanges

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|uri|varchar(255)|Ja|NULL
|synctoken|int(10)|Nei|1
|addressbookid|bigint(20)|Nei|
|operation|smallint(6)|Nei|
== Tabellstruktur for tabell oc_addressbooks

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**principaluri**|varchar(255)|Ja|NULL
|displayname|varchar(255)|Ja|NULL
|**uri**|varchar(255)|Ja|NULL
|description|varchar(255)|Ja|NULL
|synctoken|int(10)|Nei|1
== Tabellstruktur for tabell oc_admin_sections

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|varchar(64)|Nei|
|**class**|varchar(255)|Nei|
|priority|smallint(6)|Nei|0
== Tabellstruktur for tabell oc_admin_settings

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**class**|varchar(255)|Nei|
|section|varchar(64)|Ja|NULL
|priority|smallint(6)|Nei|0
== Tabellstruktur for tabell oc_announcements

|------
|Kolonne|Type|Null|Standard
|------
|//**announcement_id**//|int(11)|Nei|
|announcement_time|int(11)|Nei|0
|announcement_user|varchar(64)|Nei|
|announcement_subject|varchar(512)|Nei|
|announcement_message|longtext|Ja|NULL
|allow_comments|smallint(6)|Ja|1
== Tabellstruktur for tabell oc_announcements_groups

|------
|Kolonne|Type|Null|Standard
|------
|//**announcement_id**//|int(11)|Nei|
|//**gid**//|varchar(64)|Nei|
== Tabellstruktur for tabell oc_appconfig

|------
|Kolonne|Type|Null|Standard
|------
|//**appid**//|varchar(32)|Nei|
|//**configkey**//|varchar(64)|Nei|
|configvalue|longtext|Ja|NULL
== Tabellstruktur for tabell oc_authtoken

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|uid|varchar(64)|Nei|
|login_name|varchar(64)|Nei|
|password|longtext|Ja|NULL
|name|longtext|Nei|
|**token**|varchar(200)|Nei|
|type|smallint(5)|Nei|0
|last_activity|int(10)|Nei|0
|last_check|int(10)|Nei|0
|remember|smallint(5)|Nei|0
|scope|longtext|Ja|NULL
== Tabellstruktur for tabell oc_bruteforce_attempts

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|action|varchar(64)|Nei|
|occurred|int(10)|Nei|0
|ip|varchar(255)|Nei|
|subnet|varchar(255)|Nei|
|metadata|varchar(255)|Nei|
== Tabellstruktur for tabell oc_calendarchanges

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|uri|varchar(255)|Ja|NULL
|synctoken|int(10)|Nei|1
|calendarid|bigint(20)|Nei|
|operation|smallint(6)|Nei|
== Tabellstruktur for tabell oc_calendarobjects

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|calendardata|longblob|Ja|NULL
|**uri**|varchar(255)|Ja|NULL
|**calendarid**|bigint(20)|Nei|
|lastmodified|int(10)|Ja|NULL
|etag|varchar(32)|Ja|NULL
|size|bigint(20)|Nei|
|componenttype|varchar(8)|Ja|NULL
|firstoccurence|bigint(20)|Ja|NULL
|lastoccurence|bigint(20)|Ja|NULL
|uid|varchar(255)|Ja|NULL
|classification|int(11)|Ja|0
== Tabellstruktur for tabell oc_calendarobjects_props

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|calendarid|bigint(20)|Nei|0
|objectid|bigint(20)|Nei|0
|name|varchar(64)|Ja|NULL
|parameter|varchar(64)|Ja|NULL
|value|varchar(255)|Ja|NULL
== Tabellstruktur for tabell oc_calendars

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**principaluri**|varchar(255)|Ja|NULL
|displayname|varchar(255)|Ja|NULL
|**uri**|varchar(255)|Ja|NULL
|synctoken|int(10)|Nei|1
|description|varchar(255)|Ja|NULL
|calendarorder|int(10)|Nei|0
|calendarcolor|varchar(255)|Ja|NULL
|timezone|longtext|Ja|NULL
|components|varchar(64)|Ja|NULL
|transparent|smallint(6)|Nei|0
== Tabellstruktur for tabell oc_calendarsubscriptions

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**uri**|varchar(255)|Ja|NULL
|**principaluri**|varchar(255)|Ja|NULL
|source|varchar(255)|Ja|NULL
|displayname|varchar(100)|Ja|NULL
|refreshrate|varchar(10)|Ja|NULL
|calendarorder|int(10)|Nei|0
|calendarcolor|varchar(255)|Ja|NULL
|striptodos|smallint(6)|Ja|NULL
|stripalarms|smallint(6)|Ja|NULL
|stripattachments|smallint(6)|Ja|NULL
|lastmodified|int(10)|Ja|NULL
== Tabellstruktur for tabell oc_cards

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|addressbookid|bigint(20)|Nei|0
|carddata|longblob|Ja|NULL
|uri|varchar(255)|Ja|NULL
|lastmodified|bigint(20)|Ja|NULL
|etag|varchar(32)|Ja|NULL
|size|bigint(20)|Nei|
== Tabellstruktur for tabell oc_cards_properties

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|addressbookid|bigint(20)|Nei|0
|cardid|bigint(20)|Nei|0
|name|varchar(64)|Ja|NULL
|value|varchar(255)|Ja|NULL
|preferred|int(11)|Nei|1
== Tabellstruktur for tabell oc_comments

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|parent_id|bigint(20)|Nei|0
|topmost_parent_id|bigint(20)|Nei|0
|children_count|int(10)|Nei|0
|actor_type|varchar(64)|Nei|
|actor_id|varchar(64)|Nei|
|message|longtext|Ja|NULL
|verb|varchar(64)|Ja|NULL
|creation_timestamp|datetime|Ja|NULL
|latest_child_timestamp|datetime|Ja|NULL
|object_type|varchar(64)|Nei|
|object_id|varchar(64)|Nei|
== Tabellstruktur for tabell oc_comments_read_markers

|------
|Kolonne|Type|Null|Standard
|------
|//**user_id**//|varchar(64)|Nei|
|marker_datetime|datetime|Ja|NULL
|//**object_type**//|varchar(64)|Nei|
|//**object_id**//|varchar(64)|Nei|
== Tabellstruktur for tabell oc_credentials

|------
|Kolonne|Type|Null|Standard
|------
|//**user**//|varchar(64)|Nei|
|//**identifier**//|varchar(64)|Nei|
|credentials|longtext|Ja|NULL
== Tabellstruktur for tabell oc_dav_shares

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**principaluri**|varchar(255)|Ja|NULL
|**type**|varchar(255)|Ja|NULL
|access|smallint(6)|Ja|NULL
|**resourceid**|bigint(20)|Nei|
|**publicuri**|varchar(255)|Ja|NULL
== Tabellstruktur for tabell oc_external_applicable

|------
|Kolonne|Type|Null|Standard
|------
|//**applicable_id**//|bigint(20)|Nei|
|**mount_id**|bigint(20)|Nei|
|**type**|int(11)|Nei|
|**value**|varchar(64)|Ja|NULL
== Tabellstruktur for tabell oc_external_config

|------
|Kolonne|Type|Null|Standard
|------
|//**config_id**//|bigint(20)|Nei|
|**mount_id**|bigint(20)|Nei|
|**key**|varchar(64)|Nei|
|value|varchar(4096)|Ja|NULL
== Tabellstruktur for tabell oc_external_mounts

|------
|Kolonne|Type|Null|Standard
|------
|//**mount_id**//|bigint(20)|Nei|
|mount_point|varchar(128)|Nei|
|storage_backend|varchar(64)|Nei|
|auth_backend|varchar(64)|Nei|
|priority|int(11)|Nei|100
|type|int(11)|Nei|
== Tabellstruktur for tabell oc_external_options

|------
|Kolonne|Type|Null|Standard
|------
|//**option_id**//|bigint(20)|Nei|
|**mount_id**|bigint(20)|Nei|
|**key**|varchar(64)|Nei|
|value|varchar(256)|Nei|
== Tabellstruktur for tabell oc_federated_reshares

|------
|Kolonne|Type|Null|Standard
|------
|//**share_id**//|int(11)|Nei|
|remote_id|int(11)|Nei|
== Tabellstruktur for tabell oc_file_locks

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|lock|int(11)|Nei|0
|**key**|varchar(64)|Nei|
|ttl|int(11)|Nei|-1
== Tabellstruktur for tabell oc_filecache

|------
|Kolonne|Type|Null|Standard
|------
|//**fileid**//|bigint(20)|Nei|
|**storage**|bigint(20)|Nei|0
|path|varchar(4000)|Ja|NULL
|**path_hash**|varchar(32)|Nei|
|parent|bigint(20)|Nei|0
|name|varchar(250)|Ja|NULL
|mimetype|bigint(20)|Nei|0
|mimepart|bigint(20)|Nei|0
|size|bigint(20)|Nei|0
|mtime|int(11)|Nei|0
|storage_mtime|int(11)|Nei|0
|encrypted|int(11)|Nei|0
|unencrypted_size|bigint(20)|Nei|0
|etag|varchar(40)|Ja|NULL
|permissions|int(11)|Ja|0
|checksum|varchar(255)|Ja|NULL
== Tabellstruktur for tabell oc_files_trash

|------
|Kolonne|Type|Null|Standard
|------
|//**auto_id**//|int(11)|Nei|
|id|varchar(250)|Nei|
|user|varchar(64)|Nei|
|timestamp|varchar(12)|Nei|
|location|varchar(512)|Nei|
|type|varchar(4)|Ja|NULL
|mime|varchar(255)|Ja|NULL
== Tabellstruktur for tabell oc_flow_checks

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(11)|Nei|
|class|varchar(256)|Nei|
|operator|varchar(16)|Nei|
|value|longtext|Ja|NULL
|**hash**|varchar(32)|Nei|
== Tabellstruktur for tabell oc_flow_operations

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(11)|Nei|
|class|varchar(256)|Nei|
|name|varchar(256)|Nei|
|checks|longtext|Ja|NULL
|operation|longtext|Ja|NULL
== Tabellstruktur for tabell oc_group_admin

|------
|Kolonne|Type|Null|Standard
|------
|//**gid**//|varchar(64)|Nei|
|//**uid**//|varchar(64)|Nei|
== Tabellstruktur for tabell oc_group_user

|------
|Kolonne|Type|Null|Standard
|------
|//**gid**//|varchar(64)|Nei|
|//**uid**//|varchar(64)|Nei|
== Tabellstruktur for tabell oc_groups

|------
|Kolonne|Type|Null|Standard
|------
|//**gid**//|varchar(64)|Nei|
== Tabellstruktur for tabell oc_jobs

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|class|varchar(255)|Nei|
|argument|varchar(4000)|Nei|
|last_run|int(11)|Ja|0
|last_checked|int(11)|Ja|0
|reserved_at|int(11)|Ja|0
|execution_duration|int(11)|Nei|0
== Tabellstruktur for tabell oc_lucene_status

|------
|Kolonne|Type|Null|Standard
|------
|//**fileid**//|int(11)|Nei|0
|status|varchar(1)|Ja|NULL
== Tabellstruktur for tabell oc_migrations

|------
|Kolonne|Type|Null|Standard
|------
|//**app**//|varchar(255)|Nei|
|//**version**//|varchar(255)|Nei|
== Tabellstruktur for tabell oc_mimetypes

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**mimetype**|varchar(255)|Nei|
== Tabellstruktur for tabell oc_mounts

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|storage_id|int(11)|Nei|
|**root_id**|int(11)|Nei|
|**user_id**|varchar(64)|Nei|
|mount_point|varchar(4000)|Nei|
|mount_id|int(11)|Ja|NULL
== Tabellstruktur for tabell oc_news_feeds

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|user_id|varchar(64)|Nei|
|last_modified|bigint(20)|Ja|0
|url_hash|varchar(32)|Nei|
|url|longtext|Nei|
|location|longtext|Ja|NULL
|title|longtext|Nei|
|link|longtext|Ja|NULL
|favicon_link|longtext|Ja|NULL
|http_last_modified|longtext|Ja|NULL
|http_etag|longtext|Ja|NULL
|added|bigint(20)|Ja|0
|articles_per_update|bigint(20)|Nei|0
|update_error_count|bigint(20)|Nei|0
|last_update_error|longtext|Ja|NULL
|basic_auth_user|longtext|Ja|NULL
|basic_auth_password|longtext|Ja|NULL
|deleted_at|bigint(20)|Ja|0
|folder_id|bigint(20)|Nei|
|prevent_update|tinyint(1)|Nei|0
|pinned|tinyint(1)|Nei|0
|full_text_enabled|tinyint(1)|Nei|0
|ordering|int(11)|Nei|0
|update_mode|int(11)|Nei|0
== Tabellstruktur for tabell oc_news_folders

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|parent_id|bigint(20)|Ja|NULL
|name|varchar(100)|Nei|
|user_id|varchar(64)|Nei|
|opened|tinyint(1)|Nei|1
|deleted_at|bigint(20)|Ja|0
|last_modified|bigint(20)|Ja|0
== Tabellstruktur for tabell oc_news_items

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|guid_hash|varchar(32)|Nei|
|fingerprint|varchar(32)|Ja|NULL
|content_hash|varchar(32)|Ja|NULL
|rtl|tinyint(1)|Nei|0
|search_index|longtext|Ja|NULL
|guid|longtext|Nei|
|url|longtext|Ja|NULL
|title|longtext|Ja|NULL
|author|longtext|Ja|NULL
|pub_date|bigint(20)|Ja|NULL
|updated_date|bigint(20)|Ja|NULL
|body|longtext|Ja|NULL
|enclosure_mime|longtext|Ja|NULL
|enclosure_link|longtext|Ja|NULL
|feed_id|bigint(20)|Nei|
|status|bigint(20)|Nei|0
|last_modified|bigint(20)|Ja|0
|unread|tinyint(1)|Nei|0
|starred|tinyint(1)|Nei|0
== Tabellstruktur for tabell oc_notifications

|------
|Kolonne|Type|Null|Standard
|------
|//**notification_id**//|int(11)|Nei|
|app|varchar(32)|Nei|
|user|varchar(64)|Nei|
|timestamp|int(11)|Nei|0
|object_type|varchar(64)|Nei|
|object_id|varchar(64)|Nei|
|subject|varchar(64)|Nei|
|subject_parameters|longtext|Ja|NULL
|message|varchar(64)|Ja|NULL
|message_parameters|longtext|Ja|NULL
|link|varchar(4000)|Ja|NULL
|actions|longtext|Ja|NULL
|icon|varchar(4000)|Ja|NULL
== Tabellstruktur for tabell oc_notifications_pushtokens

|------
|Kolonne|Type|Null|Standard
|------
|//**uid**//|varchar(64)|Nei|
|//**token**//|int(11)|Nei|0
|deviceidentifier|varchar(128)|Nei|
|devicepublickey|varchar(512)|Nei|
|devicepublickeyhash|varchar(128)|Nei|
|pushtokenhash|varchar(128)|Nei|
|proxyserver|varchar(256)|Nei|
|apptype|varchar(32)|Nei|unknown
== Tabellstruktur for tabell oc_oauth2_access_tokens

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(10)|Nei|
|token_id|int(11)|Nei|
|client_id|int(11)|Nei|
|**hashed_code**|varchar(128)|Nei|
|encrypted_token|varchar(786)|Nei|
== Tabellstruktur for tabell oc_oauth2_clients

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(10)|Nei|
|name|varchar(64)|Nei|
|redirect_uri|varchar(2000)|Nei|
|client_identifier|varchar(64)|Nei|
|secret|varchar(64)|Nei|
== Tabellstruktur for tabell oc_ocsms_config

|------
|Kolonne|Type|Null|Standard
|------
|user|varchar(255)|Nei|
|key|varchar(255)|Nei|
|value|varchar(10240)|Ja|NULL
== Tabellstruktur for tabell oc_ocsms_conversation_read_states

|------
|Kolonne|Type|Null|Standard
|------
|user_id|varchar(64)|Nei|
|phone_number|varchar(64)|Nei|
|int_date|bigint(20)|Nei|
== Tabellstruktur for tabell oc_ocsms_sendmessage_queue

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|user_id|varchar(64)|Nei|
|sms_address|varchar(64)|Nei|
|sms_msg|varchar(2048)|Nei|
== Tabellstruktur for tabell oc_ocsms_smsdatas

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|user_id|varchar(64)|Nei|
|added|datetime|Nei|1970-01-01 00:00:00
|lastmodified|datetime|Nei|1970-01-01 00:00:00
|sms_id|bigint(20)|Nei|
|sms_address|varchar(64)|Nei|
|sms_msg|varchar(10240)|Nei|
|sms_date|bigint(20)|Nei|
|sms_flags|varchar(2)|Nei|00
|sms_mailbox|smallint(6)|Nei|
|sms_type|smallint(6)|Nei|
== Tabellstruktur for tabell oc_ocsms_user_datas

|------
|Kolonne|Type|Null|Standard
|------
|user_id|varchar(64)|Nei|
|datakey|varchar(64)|Nei|
|datavalue|varchar(64)|Nei|
== Tabellstruktur for tabell oc_passman_credentials

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|guid|varchar(64)|Ja|NULL
|user_id|varchar(64)|Ja|NULL
|vault_id|bigint(20)|Nei|
|label|longtext|Nei|
|description|longtext|Ja|NULL
|created|bigint(20)|Ja|0
|changed|bigint(20)|Ja|0
|tags|longtext|Ja|NULL
|email|longtext|Ja|NULL
|username|longtext|Ja|NULL
|password|longtext|Ja|NULL
|url|longtext|Ja|NULL
|favicon|longtext|Ja|NULL
|renew_interval|bigint(20)|Ja|NULL
|expire_time|bigint(20)|Ja|NULL
|delete_time|bigint(20)|Ja|NULL
|files|longtext|Ja|NULL
|custom_fields|longtext|Ja|NULL
|otp|longtext|Ja|NULL
|hidden|tinyint(1)|Ja|0
|shared_key|longtext|Ja|NULL
== Tabellstruktur for tabell oc_passman_delete_vault_request

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|vault_guid|varchar(64)|Nei|
|reason|varchar(64)|Nei|
|requested_by|varchar(64)|Ja|NULL
|created|bigint(20)|Ja|0
== Tabellstruktur for tabell oc_passman_files

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|guid|varchar(64)|Ja|NULL
|user_id|varchar(64)|Ja|NULL
|mimetype|varchar(255)|Nei|
|filename|longtext|Nei|
|size|bigint(20)|Nei|
|created|bigint(20)|Nei|
|file_data|longtext|Ja|NULL
== Tabellstruktur for tabell oc_passman_revisions

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|guid|varchar(64)|Nei|
|credential_id|bigint(20)|Nei|
|user_id|varchar(64)|Nei|
|created|bigint(20)|Ja|0
|credential_data|longtext|Nei|
|edited_by|varchar(64)|Nei|
== Tabellstruktur for tabell oc_passman_share_request

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|item_id|bigint(20)|Nei|
|item_guid|varchar(64)|Nei|
|target_user_id|varchar(64)|Ja|NULL
|from_user_id|varchar(64)|Ja|NULL
|target_vault_id|bigint(20)|Nei|
|target_vault_guid|varchar(64)|Nei|
|shared_key|longtext|Nei|
|permissions|smallint(5)|Nei|0
|created|bigint(20)|Ja|0
== Tabellstruktur for tabell oc_passman_sharing_acl

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|item_id|bigint(20)|Nei|
|item_guid|varchar(64)|Nei|
|vault_id|bigint(20)|Ja|NULL
|vault_guid|varchar(64)|Ja|NULL
|user_id|varchar(64)|Ja|NULL
|created|bigint(20)|Ja|0
|expire|bigint(20)|Ja|0
|expire_views|bigint(20)|Ja|0
|permissions|smallint(5)|Nei|0
|shared_key|longtext|Ja|NULL
== Tabellstruktur for tabell oc_passman_vaults

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|guid|varchar(64)|Nei|
|user_id|varchar(64)|Nei|
|name|varchar(100)|Nei|
|vault_settings|longtext|Ja|NULL
|created|bigint(20)|Ja|0
|last_access|bigint(20)|Ja|0
|public_sharing_key|longtext|Ja|NULL
|private_sharing_key|longtext|Ja|NULL
|sharing_keys_generated|bigint(20)|Ja|NULL
== Tabellstruktur for tabell oc_personal_sections

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|varchar(64)|Nei|
|**class**|varchar(255)|Nei|
|priority|int(11)|Nei|0
== Tabellstruktur for tabell oc_personal_settings

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**class**|varchar(255)|Nei|
|section|varchar(64)|Ja|NULL
|priority|int(11)|Nei|0
== Tabellstruktur for tabell oc_preferences

|------
|Kolonne|Type|Null|Standard
|------
|//**userid**//|varchar(64)|Nei|
|//**appid**//|varchar(32)|Nei|
|//**configkey**//|varchar(64)|Nei|
|configvalue|longtext|Ja|NULL
== Tabellstruktur for tabell oc_privatedata

|------
|Kolonne|Type|Null|Standard
|------
|//**keyid**//|int(10)|Nei|
|user|varchar(64)|Nei|
|app|varchar(255)|Nei|
|key|varchar(255)|Nei|
|value|varchar(255)|Nei|
== Tabellstruktur for tabell oc_properties

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|userid|varchar(64)|Nei|
|propertypath|varchar(255)|Nei|
|propertyname|varchar(255)|Nei|
|propertyvalue|longtext|Nei|
== Tabellstruktur for tabell oc_schedulingobjects

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|principaluri|varchar(255)|Ja|NULL
|calendardata|longblob|Ja|NULL
|uri|varchar(255)|Ja|NULL
|lastmodified|int(10)|Ja|NULL
|etag|varchar(32)|Ja|NULL
|size|bigint(20)|Nei|
== Tabellstruktur for tabell oc_share

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|share_type|smallint(6)|Nei|0
|share_with|varchar(255)|Ja|NULL
|uid_owner|varchar(64)|Nei|
|parent|bigint(20)|Ja|NULL
|item_type|varchar(64)|Nei|
|item_source|varchar(255)|Ja|NULL
|item_target|varchar(255)|Ja|NULL
|file_source|bigint(20)|Ja|NULL
|file_target|varchar(512)|Ja|NULL
|permissions|smallint(6)|Nei|0
|stime|bigint(20)|Nei|0
|accepted|smallint(6)|Nei|0
|expiration|datetime|Ja|NULL
|token|varchar(32)|Ja|NULL
|mail_send|smallint(6)|Nei|0
|uid_initiator|varchar(64)|Ja|NULL
|password|varchar(255)|Ja|NULL
|share_name|varchar(64)|Ja|NULL
== Tabellstruktur for tabell oc_share_external

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(11)|Nei|
|remote|varchar(512)|Nei|
|share_token|varchar(64)|Nei|
|password|varchar(64)|Ja|NULL
|name|varchar(64)|Nei|
|owner|varchar(64)|Nei|
|**user**|varchar(64)|Nei|
|mountpoint|varchar(4000)|Nei|
|**mountpoint_hash**|varchar(32)|Nei|
|remote_id|int(11)|Nei|-1
|accepted|int(11)|Nei|0
== Tabellstruktur for tabell oc_storages

|------
|Kolonne|Type|Null|Standard
|------
|**id**|varchar(64)|Ja|NULL
|//**numeric_id**//|bigint(20)|Nei|
|available|int(11)|Nei|1
|last_checked|int(11)|Ja|NULL
== Tabellstruktur for tabell oc_systemtag

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|**name**|varchar(64)|Nei|
|**visibility**|smallint(6)|Nei|1
|**editable**|smallint(6)|Nei|1
== Tabellstruktur for tabell oc_systemtag_group

|------
|Kolonne|Type|Null|Standard
|------
|//**systemtagid**//|bigint(20)|Nei|0
|//**gid**//|varchar(255)|Nei|
== Tabellstruktur for tabell oc_systemtag_object_mapping

|------
|Kolonne|Type|Null|Standard
|------
|//**objectid**//|varchar(64)|Nei|
|//**objecttype**//|varchar(64)|Nei|
|//**systemtagid**//|bigint(20)|Nei|0
== Tabellstruktur for tabell oc_talk_participants

|------
|Kolonne|Type|Null|Standard
|------
|user_id|varchar(255)|Ja|NULL
|room_id|int(10)|Nei|0
|last_ping|int(10)|Nei|0
|session_id|varchar(255)|Nei|
|participant_type|smallint(5)|Nei|0
|in_call|tinyint(1)|Nei|0
== Tabellstruktur for tabell oc_talk_rooms

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(11)|Nei|
|name|varchar(255)|Ja|
|**token**|varchar(32)|Ja|
|type|int(11)|Nei|
|password|varchar(255)|Ja|
|active_since|datetime|Ja|NULL
|active_guests|int(10)|Nei|0
== Tabellstruktur for tabell oc_talk_signaling

|------
|Kolonne|Type|Null|Standard
|------
|sender|varchar(255)|Nei|
|recipient|varchar(255)|Nei|
|message|longtext|Nei|
|timestamp|int(11)|Nei|
== Tabellstruktur for tabell oc_trusted_servers

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|int(11)|Nei|
|url|varchar(512)|Nei|
|**url_hash**|varchar(255)|Nei|
|token|varchar(128)|Ja|NULL
|shared_secret|varchar(256)|Ja|NULL
|status|int(11)|Nei|2
|sync_token|varchar(512)|Ja|NULL
== Tabellstruktur for tabell oc_twofactor_backupcodes

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|user_id|varchar(64)|Nei|
|code|varchar(64)|Nei|
|used|smallint(6)|Nei|0
== Tabellstruktur for tabell oc_users

|------
|Kolonne|Type|Null|Standard
|------
|//**uid**//|varchar(64)|Nei|
|displayname|varchar(64)|Ja|NULL
|password|varchar(255)|Nei|
== Tabellstruktur for tabell oc_users_external

|------
|Kolonne|Type|Null|Standard
|------
|//**backend**//|varchar(128)|Nei|
|//**uid**//|varchar(64)|Nei|
|displayname|varchar(64)|Ja|NULL
== Tabellstruktur for tabell oc_vcategory

|------
|Kolonne|Type|Null|Standard
|------
|//**id**//|bigint(20)|Nei|
|uid|varchar(64)|Nei|
|type|varchar(64)|Nei|
|category|varchar(255)|Nei|
== Tabellstruktur for tabell oc_vcategory_to_object

|------
|Kolonne|Type|Null|Standard
|------
|//**objid**//|bigint(20)|Nei|0
|//**categoryid**//|bigint(20)|Nei|0
|//**type**//|varchar(64)|Nei|