app=# \d ABCD.IPADDRESS_TABLE; Table "ABCD.IPADDRESS_TABLE" Column | Type | Collation | Nullable | Default -------------------------+--------------------------+-----------+----------+-------------------------------------------------------- id | bigint | | not null | nextval('ABCD.IPADDRESS_TABLE_id_seq'::regclass) created | timestamp with time zone | | | last_updated | timestamp with time zone | | | address | inet | | not null | description | character varying(200) | | not null | assigned_object_id | bigint | | | nat_inside_id | bigint | | | vrf_id | bigint | | | tenant_id | bigint | | | status | character varying(50) | | not null | role | character varying(50) | | not null | dns_name | character varying(255) | | not null | assigned_object_type_id | integer | | | custom_field_data | jsonb | | not null | system_tenant_id | bigint | | not null | Indexes: "IPADDRESS_TABLE_pkey" PRIMARY KEY, btree (id) "IPADDRESS_TABLE_assigned_object_type_id_02354370" btree (assigned_object_type_id) "IPADDRESS_TABLE_nat_inside_id_key" UNIQUE CONSTRAINT, btree (nat_inside_id) "IPADDRESS_TABLE_tenant_id_ac55acfd" btree (tenant_id) "IPADDRESS_TABLE_vrf_id_51fcc59b" btree (vrf_id) Check constraints: "IPADDRESS_TABLE_assigned_object_id_cff64474_check" CHECK (assigned_object_id >= 0) "IPADDRESS_TABLE_system_tenant_id_check" CHECK (system_tenant_id >= 0) Foreign-key constraints: "IPADDRESS_TABLE_assigned_object_type_02354370_fk_django_co" FOREIGN KEY (assigned_object_type_id) REFERENCES ABCD.django_content_type(id) DEFERRABLE INITIALLY DEFERRED "IPADDRESS_TABLE_nat_inside_id_a45fb7c5_fk" FOREIGN KEY (nat_inside_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED "IPADDRESS_TABLE_tenant_id_ac55acfd_fk" FOREIGN KEY (tenant_id) REFERENCES ABCD.tenancy_tenant(id) DEFERRABLE INITIALLY DEFERRED "IPADDRESS_TABLE_vrf_id_51fcc59b_fk" FOREIGN KEY (vrf_id) REFERENCES ABCD.ipam_vrf(id) DEFERRABLE INITIALLY DEFERRED Referenced by: TABLE "ABCD.TABLE_2" CONSTRAINT "TABLE_2_primary_ip4_id_2ccd943a_fk" FOREIGN KEY (primary_ip4_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED TABLE "ABCD.TABLE_2" CONSTRAINT "TABLE_2_primary_ip6_id_d180fe91_fk" FOREIGN KEY (primary_ip6_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED TABLE "ABCD.IPADDRESS_TABLE" CONSTRAINT "IPADDRESS_TABLE_nat_inside_id_a45fb7c5_fk" FOREIGN KEY (nat_inside_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED TABLE "ABCD.TABLE_3" CONSTRAINT "TABLE_3_ipaddress_id_b4138c6d_fk" FOREIGN KEY (ipaddress_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED TABLE "ABCD.TABLE_4" CONSTRAINT "TABLE_4_primary_ip4_id_942e42ae_fk" FOREIGN KEY (primary_ip4_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED TABLE "ABCD.TABLE_4" CONSTRAINT "TABLE_4_primary_ip6_id_b7904e73_fk" FOREIGN KEY (primary_ip6_id) REFERENCES ABCD.IPADDRESS_TABLE(id) DEFERRABLE INITIALLY DEFERRED