podoc:files_sql_table
Database Table Description of "files"
Name
files
Description
Purpose
Table to keep track of individual image files.
Schema
CREATE TABLE files ( identifier INTEGER PRIMARY KEY, version INTEGER REFERENCES photo_version(identifier) NOT NULL, SIZE INTEGER NOT NULL, x_res INTEGER NOT NULL, y_res INTEGER NOT NULL, path text NOT NULL, created TIMESTAMP WITHOUT TIME zone NOT NULL, filesize INTEGER NOT NULL, params text NOT NULL, comments text, watermark INTEGER REFERENCES photo_version(identifier) );
References tables
- version references photo_version(identifier)
Is referenced by tables
- contact_info(state) references identifier
- location(state) references identifier
Related sequences
Related indexes
Related functions
None.
Related views
None.
History
Used first
Version 2.34
Used last
Still in use
Schema change history
= Version 2.34 =
-- Add a table to keep track of individual image files. CREATE TABLE files ( identifier INTEGER PRIMARY KEY, version INTEGER REFERENCES photo_version(identifier) NOT NULL, SIZE INTEGER NOT NULL, x_res INTEGER NOT NULL, y_res INTEGER NOT NULL, path text NOT NULL, created TIMESTAMP WITHOUT TIME zone NOT NULL, filesize INTEGER NOT NULL, params text NOT NULL, watermarked BOOLEAN NOT NULL, comments text );
-- Update the files table to be smarter about watermarks ALTER TABLE files DROP COLUMN watermarked; ALTER TABLE files ADD COLUMN watermark INTEGER REFERENCES photo_version(identifier);
Data change history
podoc/files_sql_table.txt · Last modified: 2007/10/19 20:48 by Luud