Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Here is the list of all tables created in the database.
Clic on a table name for more informations.
The table file_meta corresponds to a file in a file_list_element. Each file can have several versions (which are stored in the table file_version).
Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
:——— | :——— | :————- | :—————- | :—————- | :———— |
id_file | integer | X | X | This is the primary key of the table. | |
datedeleted | timestamp(0) | When the user ask the server to delete a file, this column is set to the current date. Deleted files can be retrieved because they are not really deleted. They are always stored in order to prevent a mistake from the user. | |||
name | text | X | This is the global name of the file. |