User Tools

Site Tools


Sidebar

Table listing

Here is the list of all tables created in the database.

Clic on a table name for more informations.

model:file_meta

Table file\_meta

Remarks

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).

Schema

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.

Diagram

model/file_meta.txt · Last modified: 2016/01/11 21:38 (external edit)