ZiDocument: Database
The supported database
The supported database management systems are:
- MySQL
- 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)? |