CREATE TABLE pinds_blog_entries ( entry_id integer PRIMARY KEY NOT NULL, package_id integer, title varchar(500), title_url varchar(500), category_id integer, content varchar(32000), content_format varchar(50) DEFAULT 'text/html'::character varying NOT NULL, entry_date timestamptz, draft_p char(1) DEFAULT 'f'::bpchar, deleted_p char(1) DEFAULT 'f'::bpchar, CONSTRAINT pinds_blog_entries_deleted_ck REFERENCES pinds_blog_categories (), CONSTRAINT pinds_blog_entries_draft_ck REFERENCES pinds_blog_categories (), CONSTRAINT pinds_blog_entries_pk REFERENCES pinds_blog_categories (), CONSTRAINT pinds_blog_entry_category_fk REFERENCES pinds_blog_categories (), CONSTRAINT pinds_blog_entry_id_fk REFERENCES pinds_blog_categories (), CONSTRAINT pinds_blog_entry_package_id_kf REFERENCES pinds_blog_categories (), CONSTRAINT pinds_blog_entries_deleted_ck REFERENCES acs_objects (), CONSTRAINT pinds_blog_entries_draft_ck REFERENCES acs_objects (), CONSTRAINT pinds_blog_entries_pk REFERENCES acs_objects (), CONSTRAINT pinds_blog_entry_category_fk REFERENCES acs_objects (), CONSTRAINT pinds_blog_entry_id_fk REFERENCES acs_objects (), CONSTRAINT pinds_blog_entry_package_id_kf REFERENCES acs_objects (), CONSTRAINT pinds_blog_entry_package_id_kf REFERENCES apm_packages (), CONSTRAINT pinds_blog_entries_deleted_ck REFERENCES apm_packages (), CONSTRAINT pinds_blog_entries_draft_ck REFERENCES apm_packages (), CONSTRAINT pinds_blog_entries_pk REFERENCES apm_packages (), CONSTRAINT pinds_blog_entry_category_fk REFERENCES apm_packages (), CONSTRAINT pinds_blog_entry_id_fk REFERENCES apm_packages () ); CREATE INDEX pinds_blog_entry_pck_entr_idx ON pinds_blog_entries (package_id, entry_date); CREATE TRIGGER RI_ConstraintTrigger_c_342819 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342820 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342824 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342825 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342834 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342835 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 40,960 bytes -- Table rows: 69
Begin main content
