-- -- Table for storing custom fields of albums within content repository. -- A pa_album is used to group zero or more pa_photos. -- CREATE TABLE pa_albums ( pa_album_id integer PRIMARY KEY NOT NULL, -- -- Story behind the album. In postgresql we use the text datatype -- and there is no limit on text length. This differs from the varchar2 with -- Oracle. -- story text(-5), -- -- The photographer who took the pictures. -- photographer varchar(200), -- -- The date the photos were taken (end of range) -- taken_start timestamp, taken_end timestamp, -- -- The photo to use as the cover photo for this album. If it is null a -- default icon is chosen -- iconic integer, ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT pa_albums_iconic_fk REFERENCES cr_items (), CONSTRAINT pa_albums_id_fk REFERENCES cr_items (), CONSTRAINT pa_albums_id_pk REFERENCES cr_items () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT pa_albums_id_pk REFERENCES cr_revisions (), CONSTRAINT pa_albums_iconic_fk REFERENCES cr_revisions (), CONSTRAINT pa_albums_id_fk REFERENCES cr_revisions () ); CREATE TRIGGER RI_ConstraintTrigger_c_342739 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342740 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342744 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342745 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 32
Begin main content
