CREATE TABLE bt_components (
component_id integer PRIMARY KEY NOT NULL,
project_id integer NOT NULL,
component_name varchar(500) NOT NULL,
description text(-5),
maintainer integer,
url_name text(-5),
CONSTRAINT bt_components_maintainer_fk REFERENCES users (),
CONSTRAINT bt_components_pk REFERENCES users ()
);
CREATE TRIGGER RI_ConstraintTrigger_a_340877 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340878 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340909 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340910 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340942 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340943 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340947 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340948 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to bt_components:
--bt_bug_revisions(bt_components_maintainer_fk)
--bt_bug_revisions(bt_components_pk)
--bt_keyword_component_map(bt_components_maintainer_fk)
--bt_keyword_component_map(bt_components_pk)
--bt_patches(bt_components_maintainer_fk)
--bt_patches(bt_components_pk)
-- Table size: 32,768 bytes
-- Table rows: 219
Tables: