CREATE TABLE bm_urls (
url_id integer PRIMARY KEY NOT NULL,
url_title varchar(500),
host_url varchar(100) NOT NULL,
complete_url varchar(500) NOT NULL,
meta_keywords text(-5),
meta_description text(-5),
last_checked_date timestamptz,
last_live_date timestamptz,
CONSTRAINT bm_urls_url_id_fk REFERENCES acs_objects (),
CONSTRAINT bm_urls_url_id_pk REFERENCES acs_objects ()
);
CREATE TRIGGER RI_ConstraintTrigger_a_340852 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340853 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340864 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340865 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Tables with foreign keys that refer to bm_urls:
--bm_bookmarks(bm_urls_url_id_fk)
--bm_bookmarks(bm_urls_url_id_pk)
-- Table size: 442,368 bytes
-- Table rows: 2,867
Tables: