CREATE TABLE workflow_deputies (
user_id integer PRIMARY KEY NOT NULL,
deputy_user_id integer,
start_date timestamptz NOT NULL,
end_date timestamptz NOT NULL,
message varchar(4000),
CONSTRAINT workflow_deputies_duid_fk REFERENCES users (),
CONSTRAINT workflow_deputies_pk REFERENCES users (),
CONSTRAINT workflow_deputies_uid_fk REFERENCES users (),
CONSTRAINT workflow_deputies_uid_fk REFERENCES users (),
CONSTRAINT workflow_deputies_duid_fk REFERENCES users (),
CONSTRAINT workflow_deputies_pk REFERENCES users ()
);
CREATE INDEX workflow_deputies_deputy_idx ON workflow_deputies (deputy_user_id);
CREATE INDEX workflow_deputies_end_date_idx ON workflow_deputies (end_date);
CREATE INDEX workflow_deputies_start_date_idx ON workflow_deputies (start_date);
CREATE TRIGGER RI_ConstraintTrigger_c_343634 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343635 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343639 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343640 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 0 bytes
-- Table rows: 0
Tables: