Last active
August 24, 2023 17:27
-
-
Save AlanCoding/c41897886940a5a3a37cb2c92b0397ab to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| awx=# \d main_organization; | |
| Table "public.main_organization" | |
| Column | Type | Collation | Nullable | Default | |
| -------------------------------------+--------------------------+-----------+----------+---------------------------------- | |
| id | integer | | not null | generated by default as identity | |
| created | timestamp with time zone | | not null | | |
| modified | timestamp with time zone | | not null | | |
| description | text | | not null | | |
| name | character varying(512) | | not null | | |
| created_by_id | integer | | | | |
| modified_by_id | integer | | | | |
| admin_role_id | integer | | | | |
| auditor_role_id | integer | | | | |
| member_role_id | integer | | | | |
| read_role_id | integer | | | | |
| custom_virtualenv | character varying(100) | | | | |
| execute_role_id | integer | | | | |
| job_template_admin_role_id | integer | | | | |
| credential_admin_role_id | integer | | | | |
| inventory_admin_role_id | integer | | | | |
| project_admin_role_id | integer | | | | |
| workflow_admin_role_id | integer | | | | |
| notification_admin_role_id | integer | | | | |
| max_hosts | integer | | not null | | |
| approval_role_id | integer | | | | |
| default_environment_id | integer | | | | |
| execution_environment_admin_role_id | integer | | | | |
| Indexes: | |
| "main_organization_admin_role_id_e3ffdd41" btree (admin_role_id) | |
| "main_organization_approval_role_id_14c1d96f" btree (approval_role_id) | |
| "main_organization_auditor_role_id_f912df0a" btree (auditor_role_id) | |
| "main_organization_created_by_id_141da798" btree (created_by_id) | |
| "main_organization_credential_admin_role_id_55733eb5" btree (credential_admin_role_id) | |
| "main_organization_default_environment_id_1696aac2" btree (default_environment_id) | |
| "main_organization_execute_role_id_76038d3c" btree (execute_role_id) | |
| "main_organization_execution_environment_admin_role_id_f2351549" btree (execution_environment_admin_role_id) | |
| "main_organization_inventory_admin_role_id_dae5c7e2" btree (inventory_admin_role_id) | |
| "main_organization_job_template_admin_role_id_25a265c4" btree (job_template_admin_role_id) | |
| "main_organization_member_role_id_201ff67a" btree (member_role_id) | |
| "main_organization_modified_by_id_dec7a500" btree (modified_by_id) | |
| "main_organization_name_3afd4fc6_like" btree (name varchar_pattern_ops) | |
| "main_organization_name_key" UNIQUE CONSTRAINT, btree (name) | |
| "main_organization_notification_admin_role_id_c36d2f0e" btree (notification_admin_role_id) | |
| "main_organization_project_admin_role_id_442cfebe" btree (project_admin_role_id) | |
| "main_organization_read_role_id_e143c386" btree (read_role_id) | |
| "main_organization_workflow_admin_role_id_52011cd3" btree (workflow_admin_role_id) | |
| Check constraints: | |
| "main_organization_max_hosts_check" CHECK (max_hosts >= 0) | |
| Foreign-key constraints: | |
| "main_organization_admin_role_id_e3ffdd41_fk_main_rbac_roles_id" FOREIGN KEY (admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_approval_role_id_14c1d96f_fk_main_rbac" FOREIGN KEY (approval_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_auditor_role_id_f912df0a_fk_main_rbac" FOREIGN KEY (auditor_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_created_by_id_141da798_fk_auth_user_id" FOREIGN KEY (created_by_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_credential_admin_rol_55733eb5_fk_main_rbac" FOREIGN KEY (credential_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_default_environment__1696aac2_fk_main_exec" FOREIGN KEY (default_environment_id) REFERENCES main_executionenvironment(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_execute_role_id_76038d3c_fk_main_rbac" FOREIGN KEY (execute_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_execution_environmen_f2351549_fk_main_rbac" FOREIGN KEY (execution_environment_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_inventory_admin_role_dae5c7e2_fk_main_rbac" FOREIGN KEY (inventory_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_job_template_admin_r_25a265c4_fk_main_rbac" FOREIGN KEY (job_template_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_member_role_id_201ff67a_fk_main_rbac_roles_id" FOREIGN KEY (member_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_modified_by_id_dec7a500_fk_auth_user_id" FOREIGN KEY (modified_by_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_notification_admin_r_c36d2f0e_fk_main_rbac" FOREIGN KEY (notification_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_project_admin_role_i_442cfebe_fk_main_rbac" FOREIGN KEY (project_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_read_role_id_e143c386_fk_main_rbac_roles_id" FOREIGN KEY (read_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_workflow_admin_role__52011cd3_fk_main_rbac" FOREIGN KEY (workflow_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| awx=# \d main_organization; | |
| Table "public.main_organization" | |
| Column | Type | Collation | Nullable | Default | |
| -------------------------------------+--------------------------+-----------+----------+---------------------------------- | |
| id | integer | | not null | generated by default as identity | |
| created | timestamp with time zone | | not null | | |
| modified | timestamp with time zone | | not null | | |
| description | text | | not null | | |
| name | character varying(512) | | not null | | |
| created_by_id | integer | | | | |
| modified_by_id | integer | | | | |
| admin_role_id | integer | | | | |
| auditor_role_id | integer | | | | |
| member_role_id | integer | | | | |
| read_role_id | integer | | | | |
| custom_virtualenv | character varying(100) | | | | |
| execute_role_id | integer | | | | |
| job_template_admin_role_id | integer | | | | |
| credential_admin_role_id | integer | | | | |
| inventory_admin_role_id | integer | | | | |
| project_admin_role_id | integer | | | | |
| workflow_admin_role_id | integer | | | | |
| notification_admin_role_id | integer | | | | |
| max_hosts | integer | | not null | | |
| approval_role_id | integer | | | | |
| default_environment_id | integer | | | | |
| execution_environment_admin_role_id | integer | | | | |
| Indexes: | |
| "main_organization_pkey" PRIMARY KEY, btree (id) | |
| "main_organization_admin_role_id_e3ffdd41" btree (admin_role_id) | |
| "main_organization_approval_role_id_14c1d96f" btree (approval_role_id) | |
| "main_organization_auditor_role_id_f912df0a" btree (auditor_role_id) | |
| "main_organization_created_by_id_141da798" btree (created_by_id) | |
| "main_organization_credential_admin_role_id_55733eb5" btree (credential_admin_role_id) | |
| "main_organization_default_environment_id_1696aac2" btree (default_environment_id) | |
| "main_organization_execute_role_id_76038d3c" btree (execute_role_id) | |
| "main_organization_execution_environment_admin_role_id_f2351549" btree (execution_environment_admin_role_id) | |
| "main_organization_inventory_admin_role_id_dae5c7e2" btree (inventory_admin_role_id) | |
| "main_organization_job_template_admin_role_id_25a265c4" btree (job_template_admin_role_id) | |
| "main_organization_member_role_id_201ff67a" btree (member_role_id) | |
| "main_organization_modified_by_id_dec7a500" btree (modified_by_id) | |
| "main_organization_name_3afd4fc6_like" btree (name varchar_pattern_ops) | |
| "main_organization_name_key" UNIQUE CONSTRAINT, btree (name) | |
| "main_organization_notification_admin_role_id_c36d2f0e" btree (notification_admin_role_id) | |
| "main_organization_project_admin_role_id_442cfebe" btree (project_admin_role_id) | |
| "main_organization_read_role_id_e143c386" btree (read_role_id) | |
| "main_organization_workflow_admin_role_id_52011cd3" btree (workflow_admin_role_id) | |
| Check constraints: | |
| "main_organization_max_hosts_check" CHECK (max_hosts >= 0) | |
| Foreign-key constraints: | |
| "main_organization_admin_role_id_e3ffdd41_fk_main_rbac_roles_id" FOREIGN KEY (admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_approval_role_id_14c1d96f_fk_main_rbac" FOREIGN KEY (approval_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_auditor_role_id_f912df0a_fk_main_rbac" FOREIGN KEY (auditor_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_created_by_id_141da798_fk_auth_user_id" FOREIGN KEY (created_by_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_credential_admin_rol_55733eb5_fk_main_rbac" FOREIGN KEY (credential_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_default_environment__1696aac2_fk_main_exec" FOREIGN KEY (default_environment_id) REFERENCES main_executionenvironment(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_execute_role_id_76038d3c_fk_main_rbac" FOREIGN KEY (execute_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_execution_environmen_f2351549_fk_main_rbac" FOREIGN KEY (execution_environment_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_inventory_admin_role_dae5c7e2_fk_main_rbac" FOREIGN KEY (inventory_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_job_template_admin_r_25a265c4_fk_main_rbac" FOREIGN KEY (job_template_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_member_role_id_201ff67a_fk_main_rbac_roles_id" FOREIGN KEY (member_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_modified_by_id_dec7a500_fk_auth_user_id" FOREIGN KEY (modified_by_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_notification_admin_r_c36d2f0e_fk_main_rbac" FOREIGN KEY (notification_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_project_admin_role_i_442cfebe_fk_main_rbac" FOREIGN KEY (project_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_read_role_id_e143c386_fk_main_rbac_roles_id" FOREIGN KEY (read_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| "main_organization_workflow_admin_role__52011cd3_fk_main_rbac" FOREIGN KEY (workflow_admin_role_id) REFERENCES main_rbac_roles(id) DEFERRABLE INITIALLY DEFERRED | |
| Referenced by: | |
| TABLE "main_activitystream_organization" CONSTRAINT "main_activitystream__organization_id_8ccdfd12_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_credential" CONSTRAINT "main_credential_organization_id_18d4ae89_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_executionenvironment" CONSTRAINT "main_executionenviro_organization_id_66056df5_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_inventory" CONSTRAINT "main_inventory_organization_id_3ee77ea9_fk_main_organization_id" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_label" CONSTRAINT "main_label_organization_id_78a1bd27_fk_main_organization_id" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_notificationtemplate" CONSTRAINT "main_notificationtem_organization_id_15933abb_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_oauth2application" CONSTRAINT "main_oauth2applicati_organization_id_5e579421_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_organization_notification_templates_approvals" CONSTRAINT "main_organization_no_organization_id_44a19957_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_organization_notification_templates_started" CONSTRAINT "main_organization_no_organization_id_48a058ac_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_organization_notification_templates_error" CONSTRAINT "main_organization_no_organization_id_94b63d49_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_organization_notification_templates_success" CONSTRAINT "main_organization_no_organization_id_96635cd6_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_organizationgalaxycredentialmembership" CONSTRAINT "main_organizationgal_organization_id_0fd9495c_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_organizationinstancegroupmembership" CONSTRAINT "main_organizationins_organization_id_35633383_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_team" CONSTRAINT "main_team_organization_id_8b31bbc1_fk_main_organization_id" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_unifiedjob" CONSTRAINT "main_unifiedjob_organization_id_cbfa01d3_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED | |
| TABLE "main_unifiedjobtemplate" CONSTRAINT "main_unifiedjobtempl_organization_id_c63fa1a4_fk_main_orga" FOREIGN KEY (organization_id) REFERENCES main_organization(id) DEFERRABLE INITIALLY DEFERRED |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ALTER TABLE main_organization DROP CONSTRAINT main_organization_pkey CASCADE; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment