ZiDocument: Database

The supported database

The supported database management systems are:

  1. MySQL
  2. Mariadb

For MySQL, it requires the latest version (minimum version is MySQL 8.0 with JSON type support).

To install or update the database, use the following command:

php artisan migrate

Table list

Table Note
_zi_log_action Store the history of user actions in the admin section
_zi_log_api Store request and response history of api
_zi_log_table Store data change history of some important tables
failed_jobs https://laravel.com/docs/10.x/queues#main-content
jobs https://laravel.com/docs/10.x/queues#main-content
migrations https://laravel.com/docs/10.x/migrations#main-content
users This table stores user accounts
zi_role Store Role and permissions
zi_category This table stores categories and tags for objects: post, faq, product...
zi_category_ables Table of relationships between categories and other objects such as posts, faqs, products...
zi_config Store system configurations, data encrypted and protected by AES algorithm
zi_file Store files and images
zi_file_ables Table of relationships between files and other objects such as news articles, categories, tags, faqs, products...
zi_document Store all documents
zi_document_comments Store all comments
zi_document_mails Store email sending history, schedule email sending from documents
zi_document_share Decentralized information storage and document sharing
including details: which documents? Share with whom? right to edit or just view? Up to what point (for how long)?
Đang thực hiện vui lòng đợi...
© LaraziCms.
Developed by Codezi.pro