RapidPro schemas

CREATE TABLE contacts_contact
(
    id INTEGER DEFAULT nextval('contacts_contact_id_seq'::regclass) PRIMARY KEY NOT NULL,
    is_active BOOLEAN NOT NULL,
    created_on TIMESTAMP WITH TIME ZONE NOT NULL,
    modified_on TIMESTAMP WITH TIME ZONE NOT NULL,
    uuid VARCHAR(36) NOT NULL,
    name VARCHAR(128),
    is_blocked BOOLEAN NOT NULL,
    is_test BOOLEAN NOT NULL,
    is_stopped BOOLEAN NOT NULL,
    language VARCHAR(3),
    created_by_id INTEGER NOT NULL,
    modified_by_id INTEGER NOT NULL,
    org_id INTEGER NOT NULL,
    CONSTRAINT contacts_contact_created_by_id_57537352_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES auth_user (id),
    CONSTRAINT contacts_contact_modified_by_id_db5cbe12_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES auth_user (id),
    CONSTRAINT contacts_contact_org_id_01d86aa4_fk_orgs_org_id FOREIGN KEY (org_id) REFERENCES orgs_org (id)
);
CREATE UNIQUE INDEX contacts_contact_uuid_key ON contacts_contact (uuid);
CREATE INDEX contacts_contact_uuid_66fe2f01_like ON contacts_contact (uuid);
CREATE INDEX contacts_contact_e93cb7eb ON contacts_contact (created_by_id);
CREATE INDEX contacts_contact_b3da0983 ON contacts_contact (modified_by_id);
CREATE INDEX contacts_contact_org_modified_id_where_nontest_active ON contacts_contact (org_id, modified_on, id);
CREATE INDEX contacts_contact_org_modified_id_where_nontest_inactive ON contacts_contact (org_id, modified_on, id);
CREATE INDEX contacts_contact_9cf869aa ON contacts_contact (org_id);
CREATE INDEX org_test_contacts ON contacts_contact (org_id);

CREATE TABLE contacts_contactgroup_contacts
(
    id INTEGER DEFAULT nextval('contacts_contactgroup_contacts_id_seq'::regclass) PRIMARY KEY NOT NULL,
    contactgroup_id INTEGER NOT NULL,
    contact_id INTEGER NOT NULL,
    CONSTRAINT contacts_c_contactgroup_id_4366e864_fk_contacts_contactgroup_id FOREIGN KEY (contactgroup_id) REFERENCES contacts_contactgroup (id),
    CONSTRAINT contacts_contactgrou_contact_id_572f6e61_fk_contacts_contact_id FOREIGN KEY (contact_id) REFERENCES contacts_contact (id)
);
CREATE UNIQUE INDEX contacts_contactgroup_contacts_contactgroup_id_0f909f73_uniq ON contacts_contactgroup_contacts (contactgroup_id, contact_id);
CREATE INDEX contacts_contactgroup_contacts_0b1b2ae4 ON contacts_contactgroup_contacts (contactgroup_id);
CREATE INDEX contacts_contactgroup_contacts_6d82f13d ON contacts_contactgroup_contacts (contact_id);


CREATE TABLE values_value
(
    id INTEGER DEFAULT nextval('values_value_id_seq'::regclass) PRIMARY KEY NOT NULL,
    rule_uuid VARCHAR(255),
    category VARCHAR(128),
    string_value TEXT NOT NULL,
    decimal_value NUMERIC(36,8),
    datetime_value TIMESTAMP WITH TIME ZONE,
    media_value TEXT,
    created_on TIMESTAMP WITH TIME ZONE NOT NULL,
    modified_on TIMESTAMP WITH TIME ZONE NOT NULL,
    contact_id INTEGER NOT NULL,
    contact_field_id INTEGER,
    location_value_id INTEGER,
    org_id INTEGER NOT NULL,
    ruleset_id INTEGER,
    run_id INTEGER,
    CONSTRAINT values_value_contact_id_c160928a_fk_contacts_contact_id FOREIGN KEY (contact_id) REFERENCES contacts_contact (id),
    CONSTRAINT values_va_contact_field_id_d48e5ab7_fk_contacts_contactfield_id FOREIGN KEY (contact_field_id) REFERENCES contacts_contactfield (id),
    CONSTRAINT values_location_value_id_f669603a_fk_locations_adminboundary_id FOREIGN KEY (location_value_id) REFERENCES locations_adminboundary (id),
    CONSTRAINT values_value_org_id_ac514e4c_fk_orgs_org_id FOREIGN KEY (org_id) REFERENCES orgs_org (id),
    CONSTRAINT values_value_ruleset_id_ad05ba21_fk_flows_ruleset_id FOREIGN KEY (ruleset_id) REFERENCES flows_ruleset (id),
    CONSTRAINT values_value_run_id_fe1d25b9_fk_flows_flowrun_id FOREIGN KEY (run_id) REFERENCES flows_flowrun (id)
);
CREATE INDEX values_value_a3329707 ON values_value (rule_uuid);
CREATE INDEX values_value_rule_uuid_5b1a260a_like ON values_value (rule_uuid);
CREATE INDEX values_value_6d82f13d ON values_value (contact_id);
CREATE INDEX values_value_field_string_value_contact ON values_value (contact_field_id, contact_id);
CREATE INDEX values_value_contact_field_location_not_null ON values_value (contact_field_id, location_value_id);
CREATE INDEX values_value_9ff6aeda ON values_value (contact_field_id);
CREATE INDEX values_value_91709fb3 ON values_value (location_value_id);
CREATE INDEX values_value_9cf869aa ON values_value (org_id);
CREATE INDEX values_value_4d0a6d0f ON values_value (ruleset_id);
CREATE INDEX values_value_0acf093b ON values_value (run_id);