Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:file_version
Table of Contents
Table file\_version
Remarks
The table file_version contains all versions of each file. Each version is stored in the filesystem and can be retrieved with this table. Deleted versions in the database are not deleted on the filesystem in order to retrieve them if the user had made a mistake. But these files are hidden from the view.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_file_version | integer | X | X | This is the primary key of the table. | |
| added_date | timestamp(0) | X | This column corresponds to the date of the upload of this file version | ||
| comments | text | It contains some comments on the file version. | |||
| datedeleted | timestamp(0) | When a file version is deleted, this column take the current date. | |||
| extension | character varying(1024) | It contains the extension of the file (like .jpg, .doc, …) | |||
| name | text | X | This is the name of the file without the extension | ||
| path | text | X | This column contains the UUID in which the file is renamed in the filesystem | ||
| size | bigint | X | It corresponds to the size of the file in bytes. | ||
| version_number | integer | X | It corresponds the the number of this version. The version with the higher version_number is the current file. | ||
| id_author | integer | X | userlogin(userid) | This is a foreign key to the table userlogin. It corresponds to the uploader of the file. | |
| id_file | integer | X | file\_meta(id_file) | This is a foreign key to the table file_meta. It corresponds to the linked file. |
Diagram
model/file_version.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
