podoc:orientations_sql_table
Database Table Description of "orientations"
Name
orientations
Description
Purpose
Schema
CREATE TABLE orientations ( identifier INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100), im_transform VARCHAR(100) );
References tables
None.
Is referenced by tables
- photo_version(photo) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
None.
History
Used first
Version 2.26
Used last
Still in use
Schema change history
= Version 2.26 =
CREATE TABLE orientations ( identifier INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100), im_transform VARCHAR(100) );
Data change history
= Version 2.26 =
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Normal (0 deg)', ' '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Mirrored', ' -flop '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Upsidedown', ' -rotate 180 '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Upsidedown Mirrored', ' -flip '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CW Mirrored', ' -flip -rotate 90 '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CCW', ' -rotate 270 '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CCW Mirrored', ' -flop -rotate 90 '); INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CW', ' -rotate 90 ');
podoc/orientations_sql_table.txt · Last modified: 2007/04/20 14:10 by Luud