CREATE TABLE auth_batch_jobs (
job_id integer PRIMARY KEY NOT NULL,
job_start_time timestamptz DEFAULT ('now'::text)::timestamp(6) with time zone,
job_end_time timestamptz,
interactive_p bool NOT NULL,
snapshot_p bool,
authority_id integer,
message text(-5),
creation_user integer,
doc_start_time timestamptz,
doc_end_time timestamptz,
doc_status text(-5),
doc_message text(-5),
document text(-5),
ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL,
CONSTRAINT auth_batch_job_user_fk REFERENCES users (),
CONSTRAINT auth_batch_jobs_auth_fk REFERENCES users (),
CONSTRAINT auth_batch_jobs_pk REFERENCES users () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT auth_batch_jobs_pk REFERENCES auth_authorities (),
CONSTRAINT auth_batch_job_user_fk REFERENCES auth_authorities (),
CONSTRAINT auth_batch_jobs_auth_fk REFERENCES auth_authorities ()
);
CREATE INDEX auth_batch_jobs_auth_idx ON auth_batch_jobs (authority_id);
CREATE INDEX auth_batch_jobs_user_idx ON auth_batch_jobs (creation_user);
CREATE TRIGGER RI_ConstraintTrigger_a_340807 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340808 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340819 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340820 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340824 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340825 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Tables with foreign keys that refer to auth_batch_jobs:
--auth_batch_job_entries(auth_batch_job_user_fk)
--auth_batch_job_entries(auth_batch_jobs_auth_fk)
--auth_batch_job_entries(auth_batch_jobs_pk)
-- Table size: 0 bytes
-- Table rows: 0
Begin main content
