" 2200 standard public schema 7063 2015-12-03.16:23:38.493 18041 1089 16695 1061 18666 1221 18388 1103 17935 1087 17948 1087 17924 1087 18362 1103 18010 1089 18031 1089 18021 1089 17708 1064 18375 1103 17197 1063 17171 1063 18653 1221 17890 1085 16975 1061 17010 1061 17575 1063 16986 1061 16495 1003 16480 1003 16470 1003 16510 1003 16540 1003 16525 1003 16591 1003 16560 1003 16583 1003 18332 1101 18176 1096 17147 1063 17207 1063 17215 1063 17560 1063 18559 1126 18273 1099 17158 1063 17547 1063 17184 1063 16770 1092 16913 1061 17265 1063 17254 1063 17136 1063 18568 1126 17845 1079 17446 1053 18619 1220 18630 1220 17277 1045 17288 1045 17125 1045 17114 1045 17531 1060 17649 1061 18988 3824 16757 1030 16781 1030 16792 1030 16872 1097 18122 1094 16681 1030 16890 1032 16999 1038 16724 1030 19034 3844 16613 1003 185211120 180431089 166971230 186681221 183901103 179371087 179141114 179261229 179501103 183641103 180121090 172331073 172461101 172281073 180331089 180231104 172231104 172411073 177101221 183771103 171731089 171991116 169771225 186551231 178921085 170121221 169881061 175771063 164971003 164821003 164721003 165421003 165121003 165271003 188161246 187961241 188051242 190864390 165931003 188261304 165621003 165751003 165851003 183341102 181781097 171491063 172091099 172171099 175621099 185611126 182751099 171601125 178271085 175491063 171861126 174211079 177731246 178371079 167721098 169151236 172671063 172561063 171381076 185701236 178471079 175421063 175211063 175261063 175131063 174481053 186211220 186321220 172791222 172901059 173011054 171271045 171161045 175331060 169241033 176511238 189823824 167591030 167831239 187691236 167941097 169001032 166561234 168743824 181241100 170231038 166831233 168921097 167161061 167071030 170011040 167261030 190395918 166151003 16416 1002 FUNCTION 16404 1002 FUNCTION 16409 1002 FUNCTION 16408 1002 FUNCTION 16417 1002 FUNCTION 16431 1002 FUNCTION 16407 1002 FUNCTION 16406 1002 FUNCTION 16405 1002 FUNCTION 16430 1002 FUNCTION 16394 1002 FUNCTION 16393 1002 FUNCTION 16388 1002 FUNCTION 16395 1002 FUNCTION 16389 1002 FUNCTION 16390 1002 FUNCTION 16391 1002 FUNCTION 16433 1002 FUNCTION 16432 1002 FUNCTION 16458 1002 FUNCTION 16459 1002 FUNCTION 16460 1002 FUNCTION 16461 1002 FUNCTION 16462 1002 FUNCTION 16463 1002 FUNCTION 16464 1002 FUNCTION 1 16465 1002 FUNCTION 1 16467 1002 FUNCTION 16468 1002 FUNCTION 16466 1002 FUNCTION 16434 1002 FUNCTION 16446 1002 FUNCTION 16435 1002 FUNCTION 16447 1002 FUNCTION 16436 1002 FUNCTION 16448 1002 FUNCTION 16437 1002 FUNCTION 16449 1002 FUNCTION 16469 1002 FUNCTION 16450 BINARY citext text boolean texticregexne|citext,text 16438 BINARY citext citext boolean texticregexne|citext,citext 16452 BINARY citext text boolean texticregexne|citext,text 16440 BINARY citext citext boolean texticregexne|citext,citext 16454 BINARY citext text boolean texticnlike|citext,text 16442 BINARY citext citext boolean texticnlike|citext,citext 16456 BINARY citext text boolean texticnlike|citext,text 16444 BINARY citext citext boolean texticnlike|citext,citext 16414 BINARY citext citext boolean citext_lt|citext,citext 16415 BINARY citext citext boolean citext_le|citext,citext 16410 BINARY citext citext boolean citext_ne|citext,citext 16411 BINARY citext citext boolean citext_eq|citext,citext 16412 BINARY citext citext boolean citext_gt|citext,citext 16413 BINARY citext citext boolean citext_ge|citext,citext 16451 BINARY citext text boolean texticregexeq|citext,text 16439 BINARY citext citext boolean texticregexeq|citext,citext 16453 BINARY citext text boolean texticregexeq|citext,text 16441 BINARY citext citext boolean texticregexeq|citext,citext 16455 BINARY citext text boolean texticlike|citext,text 16443 BINARY citext citext boolean texticlike|citext,citext 16457 BINARY citext text boolean texticlike|citext,text 16445 BINARY citext citext boolean texticlike|citext,citext 1118 1 integer 1119 integer 1119 citext 1119 boolean 1120 1 text 18524 genericmobileclient_ptr_id 1 genericmobileclient_ptr_id android_client_pkey 1 genericmobileclient_ptr_id generic_genericmobileclient.generic_genericmobileclient_pkey restrict restrict 1089 1 integer nextval('apple_al_bypass_code_id_seq'::regclass) 1089 integer 1089 1 citext 1089 citext 1089 text 1089 citext 1089 text 1089 1 integer 1089 timestamp with time zone 18051 id 1 18053 udid 1 18088 device_id id apple_al_bypass_code_pkey 1 udid apple_al_bypass_code_udid_key device_id apple_ios_client.inventory_iosclient_pkey restrict restrict status status >= 0 1030 1 integer nextval('ios_applinks_id_seq'::regclass) 1030 1 integer 1033 integer 1041 text 1066 integer 1089 integer 1230 text 16705 id 1 18057 #25 1 16942 #13 1 17733 #23 id ios_applinks_pkey 1 #25 apple_applink_app_config_id_key #13 ios_applinks_kiosk_info_id_key #25 apple_ios_app_config.apple_ios_app_config_pkey restrict restrict #13 generic_kioskinfo.ios_kioskinfo_pkey restrict restrict #23 apple_itunesapp.apple_itunesapp_pkey restrict restrict 1221 1 integer nextval('apple_applink_vpp_asset_id_seq'::regclass) 1221 1 integer 1221 1 integer 1221 1 bigint 18672 id 1 18676 vpp_asset_id applink_id 1 18674 applink_id 1 18697 vpp_asset_id id apple_applink_vpp_asset_pkey 1 vpp_asset_id applink_id apple_applink_vpp_asset_vpp_asset_id_751c5fa371c7d8df_uniq applink_id apple_applink_vpp_asset_applink_id_key vpp_asset_id apple_vpp_organization_asset.apple_vpp_organization_asset_pkey restrict restrict applink_id apple_applink.ios_applinks_pkey restrict restrict 1103 1 bigint nextval('apple_clientmedia_id_seq'::regclass) 1103 1 integer 1103 1 integer 1103 citext 18397 id 1 18399 client_id media_id 18446 client_id 18452 media_id id apple_clientmedia_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict media_id apple_installedmedia.apple_installedmedia_pkey restrict restrict 1087 1 integer nextval('apple_dep_account_id_seq'::regclass) 1087 1 text 1087 text 1087 1 timestamp with time zone 1087 text 1087 text 1087 text 1087 text 1087 text 1087 text 1087 text 17944 id 1 17946 _token 1 17981 _token id apple_dep_account_pkey 1 _token apple_dep_account__token_key 1087 integer 1087 1 text 1087 1 text 1087 1 text 1087 1 text 1087 text 1087 1 text 1087 integer 1087 timestamp with time zone 1087 timestamp with time zone 1087 timestamp with time zone 1105 integer 1107 text 1107 text 1114 citext 17920 serial_number 1 18455 os 1 17968 account_id 17969 serial_number 17975 profile_id serial_number apple_dep_device_pkey 1 os apple_dep_device_client_id_key account_id apple_dep_account.apple_dep_account_pkey restrict restrict profile_id apple_dep_profile.apple_dep_profile_pkey restrict restrict os generic_genericclient.inventory_client_pkey restrict restrict 1087 1 integer nextval('apple_dep_profile_id_seq'::regclass) 1087 1 citext 1087 1 citext 1087 1 boolean 1087 1 boolean 1087 1 boolean 1087 1 boolean 1087 1 citext 1087 1 citext 1087 text 1087 text 1087 text 1087 1 citext 1088 citext 1088 1 boolean 1088 1 boolean 1113 1 citext 1117 1 boolean 1229 text 17933 id 1 id apple_dep_profile_pkey 1 1103 1 bigint nextval('apple_dep_profile_account_id_seq'::regclass) 1087 1 integer 1087 1 integer 1087 1 citext 18411 id 1 17959 profile_id account_id 1 17961 account_id profile_uuid 1 17987 profile_id 17993 account_id id apple_dep_profile_account_pkey 1 profile_id account_id apple_dep_profile_account_profile_id_7d6268baab1c0ac5_uniq account_id profile_uuid apple_dep_profile_account_account_id_15ae1e3432f1d677_uniq profile_id apple_dep_profile.apple_dep_profile_pkey restrict restrict account_id apple_dep_account.apple_dep_account_pkey restrict restrict 1103 1 integer nextval('apple_installedmedia_id_seq'::regclass) 1103 integer 1103 1 citext 1103 1 citext 1103 1 citext 1103 1 citext 1103 1 citext 18371 id 1 18497 itunes_media_id persistent_id kind version author title 1 18429 itunes_media_id id apple_installedmedia_pkey 1 itunes_media_id persistent_id kind version author title apple_installedmedia_itunes_media_id_298bf7856f43b4e0_uniq itunes_media_id apple_itunesapp.apple_itunesapp_pkey restrict restrict 1089 1 integer nextval('apple_ios_app_config_id_seq'::regclass) 1089 1 text 1089 1 boolean 18019 id 1 id apple_ios_app_config_pkey 1 1045 1 integer 1050 citext 1050 citext 1050 citext 1050 citext 1045 boolean 1050 citext 1050 citext 1050 citext 1050 citext 1050 citext 1050 citext 1050 citext 1045 integer 1045 boolean 1050 citext 1050 citext 1050 citext 1045 boolean 1060 text 1060 boolean 17239 iosclient_id 1 iosclient_id inventory_ioscarrier_pkey 1 iosclient_id apple_ios_client.inventory_iosclient_pkey restrict restrict 1073 1 integer 1050 citext 1050 citext 1045 double precision 1060 text 1060 text 1060 text 1060 text 1060 text 1060 text 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 text 1089 text 1089 boolean 1089 timestamp with time zone 17783 genericmobileclient_ptr_id 1 genericmobileclient_ptr_id inventory_iosclient_pkey 1 genericmobileclient_ptr_id generic_genericmobileclient.generic_genericmobileclient_pkey restrict restrict 1045 1 integer 1045 boolean 1045 boolean 1045 boolean 1045 integer 1045 integer 1045 integer 1045 integer 1045 integer 1045 integer 1045 integer 1045 boolean 17231 iosclient_id 1 iosclient_id inventory_iospasscode_pkey 1 iosclient_id apple_ios_client.inventory_iosclient_pkey restrict restrict 1089 1 integer nextval('apple_ios_profilepasscode_id_seq'::regclass) 1089 boolean 1089 boolean 1089 boolean 1089 integer 1089 integer 1089 integer 1089 integer 1089 integer 1089 integer 1089 integer 1089 boolean 1089 1 integer 1089 1 integer 18037 id 1 18039 iosclient_id profile_id 1 18076 iosclient_id 18082 profile_id id apple_ios_profilepasscode_pkey 1 iosclient_id profile_id apple_ios_profilepasscode_iosclient_id_540258260f354f92_uniq iosclient_id apple_ios_client.inventory_iosclient_pkey restrict restrict profile_id apple_profile.inventory_appleprofile_pkey restrict restrict 1089 1 integer nextval('apple_ios_profilerestrictions_id_seq'::regclass) 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 integer 1089 integer 1089 integer 1089 integer 1089 boolean 1089 boolean 1089 boolean 1089 boolean 1089 1 integer 1089 1 integer 1104 boolean 1104 boolean 1104 boolean 1104 boolean 18027 id 1 18029 iosclient_id profile_id 1 18064 iosclient_id 18070 profile_id id apple_ios_profilerestrictions_pkey 1 iosclient_id profile_id apple_ios_profilerestriction_iosclient_id_5890490e7a53f765_uniq iosclient_id apple_ios_client.inventory_iosclient_pkey restrict restrict profile_id apple_profile.inventory_appleprofile_pkey restrict restrict 1045 1 integer 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1045 integer 1045 integer 1045 integer 1045 integer 1045 boolean 1045 boolean 1045 boolean 1045 boolean 1104 boolean 1104 boolean 1104 boolean 1104 boolean 17226 iosclient_id 1 iosclient_id inventory_iosrestrictions_pkey 1 iosclient_id apple_ios_client.inventory_iosclient_pkey restrict restrict 1045 1 integer 1045 integer 1045 boolean 1045 boolean 1045 boolean 17244 iosclient_id 1 iosclient_id inventory_iossecurity_pkey 1 iosclient_id apple_ios_client.inventory_iosclient_pkey restrict restrict 1064 1 integer nextval('apple_itunesapp_id_seq'::regclass) 1064 1 integer 1064 text 1064 text 1064 text 1064 text 1064 text 1064 text 1064 timestamp with time zone 1064 text 1064 bigint 1064 text 1064 text 1064 text 1064 1 text 1064 double precision 1064 text 1064 text 1064 1 text 17717 id 1 17913 itunes_id id apple_itunesapp_pkey 1 1103 1 integer nextval('apple_media_id_seq'::regclass) 1103 integer 1103 1 citext 1103 1 citext 1103 1 citext 1103 1 citext 1103 1 citext 1103 1 bigint 1103 citext 1103 integer 18384 id 1 18386 kiosk_info_id 1 18435 itunes_media_id id apple_media_pkey 1 kiosk_info_id apple_media_kiosk_info_id_key itunes_media_id apple_itunesapp.apple_itunesapp_pkey restrict restrict kiosk_info_id generic_kioskinfo.ios_kioskinfo_pkey restrict restrict 1045 1 integer nextval('inventory_appleprofile_id_seq'::regclass) 1050 1 citext 1045 1 integer 1058 1 citext 1050 citext 1050 citext 1045 1 boolean 1045 1 boolean 1045 1 boolean 17180 id 1 17475 payload_identifier payload_display_name 1 id inventory_appleprofile_pkey 1 payload_identifier payload_display_name inventory_appleprofile_payload_identifier_667e9f4eab153e5_uniq 1103 1 bigint nextval('apple_profile_client_set_id_seq'::regclass) 1063 1 integer 1063 1 integer 1116 citext 18401 id 1 18510 genericclient_id profile_id user_name 1 17336 genericclient_id 17342 profile_id 18512 user_name id inventory_client_apple_profiles_pkey 1 genericclient_id profile_id user_name apple_profile_client_set_genericclient_id_782f9d99d053bb59_uniq genericclient_id generic_genericclient.inventory_client_pkey restrict restrict profile_id apple_profile.inventory_appleprofile_pkey restrict restrict 1038 1 integer nextval('ios_organization_id_seq'::regclass) 1038 1 text 1038 1 text 1038 1 timestamp with time zone 1038 text 1038 timestamp with time zone 1038 text 1038 timestamp with time zone 1082 1 citext 1082 citext 1082 citext 1082 citext 1083 integer 1225 timestamp with time zone 16984 id 1 17880 token 1 17878 token_name 1 id ios_organization_pkey 1 token apple_vpp_organization_token_uniq token_name apple_vpp_organization_token_name_key 1221 1 integer nextval('apple_vpp_organization_asset_id_seq'::regclass) 1221 1 text 1221 1 text 1221 1 bigint 1221 1 bigint 1221 1 boolean 1221 1 boolean 1226 bigint 1226 text 1221 1 bigint 1221 1 bigint 1221 integer 1221 integer 1231 text 18662 id 1 18664 adamIdStr pricingParam organization_id 1 18678 adamIdStr 18679 adamIdStr 18685 organization_id 18691 itunes_app_id id apple_vpp_organization_asset_pkey 1 adamIdStr pricingParam organization_id apple_vpp_organization_asset_adamIdStr_e1eb49a6821dc22_uniq organization_id apple_vpp_organization.ios_organization_pkey restrict restrict itunes_app_id apple_itunesapp.apple_itunesapp_pkey restrict restrict 1085 1 integer nextval('apple_vpp_organization_filewave_admins_id_seq'::regclass) 1085 1 integer 1085 1 integer 17896 id 1 17898 organization_id filewaveadmin_id 1 17905 organization_id 17911 filewaveadmin_id id apple_vpp_organization_filewave_admins_pkey 1 organization_id filewaveadmin_id apple_vpp_organization_fi_organization_id_7f0113b01afdfb16_uniq organization_id apple_vpp_organization.ios_organization_pkey restrict restrict filewaveadmin_id generic_filewave_admin.generic_filewave_admin_pkey restrict restrict 1038 1 integer nextval('ios_organizationlicense_id_seq'::regclass) 1232 bigint 1038 1 bigint 1038 integer 1038 integer 1038 1 text 1038 date 1110 timestamp with time zone 1221 integer 1221 text 17019 id 1 18722 licenseId #25 1 18724 licenseId 17912 adamId 17058 organization_user_id 17064 applink_id 18708 #25 id ios_organizationlicense_pkey 1 licenseId #25 apple_vpp_organization_license_licenseId_122c2ceab82e25a6_uniq #25 apple_vpp_organization_asset.apple_vpp_organization_asset_pkey restrict restrict organization_user_id apple_vpp_organization_user.ios_organizationuser_pkey restrict restrict applink_id apple_applink.ios_applinks_pkey restrict restrict 1038 1 integer nextval('ios_organizationuser_id_seq'::regclass) 1038 1 text 1038 text 1038 text 1038 text 1038 text 1038 text 1038 1 text 1038 bigint 1038 1 timestamp with time zone 1038 text 1038 integer 16995 id 1 16997 clientUserIdStr userId organization_id 1 18720 clientUserIdStr 17046 organization_id id ios_organizationuser_pkey 1 clientUserIdStr userId organization_id ios_organizationuser_clientUserIdStr_cfff314a9238380_uniq organization_id apple_vpp_organization.ios_organization_pkey restrict restrict 1060 1 integer nextval('inventory_client_organization_users_id_seq'::regclass) 1063 1 integer 1060 1 integer 17581 id 1 17583 genericclient_id organizationuser_id 1 17622 genericclient_id 17628 organizationuser_id id inventory_client_organization_users_pkey 1 genericclient_id organizationuser_id inventory_client_organization_u_client_id_5ab95699650cbec9_uniq genericclient_id generic_genericclient.inventory_client_pkey restrict restrict organizationuser_id apple_vpp_organization_user.ios_organizationuser_pkey restrict restrict 1003 1 integer nextval('auth_group_id_seq'::regclass) 1003 1 varchar(80) 16501 id 1 16503 name 1 16627 name id auth_group_pkey 1 name auth_group_name_key 1003 1 integer nextval('auth_group_permissions_id_seq'::regclass) 1003 1 integer 1003 1 integer 16486 id 1 16488 group_id permission_id 1 16625 group_id 16626 permission_id id auth_group_permissions_pkey 1 group_id permission_id auth_group_permissions_group_id_permission_id_key group_id auth_group.auth_group_pkey restrict restrict permission_id auth_permission.auth_permission_pkey restrict restrict 1003 1 integer nextval('auth_permission_id_seq'::regclass) 1003 1 varchar(50) 1003 1 integer 1003 1 varchar(100) 16476 id 1 16478 content_type_id codename 1 16624 content_type_id id auth_permission_pkey 1 content_type_id codename auth_permission_content_type_id_codename_key content_type_id django_content_type.django_content_type_pkey restrict restrict 1003 1 integer nextval('auth_user_id_seq'::regclass) 1003 1 varchar(128) 1003 1 timestamp with time zone 1003 1 boolean 1003 1 varchar(30) 1003 1 varchar(30) 1003 1 varchar(30) 1003 1 varchar(75) 1003 1 boolean 1003 1 boolean 1003 1 timestamp with time zone 16546 id 1 16548 username 1 16632 username id auth_user_pkey 1 username auth_user_username_key 1003 1 integer nextval('auth_user_groups_id_seq'::regclass) 1003 1 integer 1003 1 integer 16516 id 1 16518 user_id group_id 1 16628 user_id 16629 group_id id auth_user_groups_pkey 1 user_id group_id auth_user_groups_user_id_group_id_key user_id auth_user.auth_user_pkey restrict restrict group_id auth_group.auth_group_pkey restrict restrict 1003 1 integer nextval('auth_user_user_permissions_id_seq'::regclass) 1003 1 integer 1003 1 integer 16531 id 1 16533 user_id permission_id 1 16630 user_id 16631 permission_id id auth_user_user_permissions_pkey 1 user_id permission_id auth_user_user_permissions_user_id_permission_id_key user_id auth_user.auth_user_pkey restrict restrict permission_id auth_permission.auth_permission_pkey restrict restrict 1246 1 integer 18819 genericmobileclient_ptr_id 1 genericmobileclient_ptr_id chrome_chromebookclient_pkey 1 genericmobileclient_ptr_id generic_genericmobileclient.generic_genericmobileclient_pkey restrict restrict 1242 1 citext 1242 citext 1241 timestamp with time zone 18813 key 1 18815 key key dashboard_dashboarddata_pkey 1 1242 1 citext 1242 citext 18811 key 1 key dashboard_notificationsettings_pkey 1 3896 varchar(1024) 3896 1 varchar(1024) 3925 varchar(1024) 3925 integer 4390 varchar(1024) 4390 varchar(1024) 19213 mac_address 1 19092 mac_address 1 mac_address discovery_pkey 1 1003 1 integer nextval('django_admin_log_id_seq'::regclass) 1003 1 timestamp with time zone 1003 1 integer 1003 integer 1003 text 1003 1 varchar(200) 1003 1 smallint 1003 1 text 16601 id 1 16635 user_id 16636 content_type_id id django_admin_log_pkey 1 user_id auth_user.auth_user_pkey restrict restrict content_type_id django_content_type.django_content_type_pkey restrict restrict action_flag action_flag >= 0 1304 1 varchar(255) 1304 1 text 1304 1 timestamp with time zone 18832 cache_key 1 18834 expires cache_key django_cache_pkey 1 1003 1 integer nextval('django_content_type_id_seq'::regclass) 1003 1 varchar(100) 1003 1 varchar(100) 1003 1 varchar(100) 16566 id 1 16568 app_label model 1 id django_content_type_pkey 1 app_label model django_content_type_app_label_model_key 1003 1 varchar(40) 1003 1 text 1003 1 timestamp with time zone 16581 session_key 1 16633 session_key 16634 expire_date session_key django_session_pkey 1 1003 1 integer nextval('django_site_id_seq'::regclass) 1003 1 varchar(100) 1003 1 varchar(50) 16589 id 1 id django_site_pkey 1 1101 1 integer nextval('engage_engageprofilestatus_id_seq'::regclass) 1102 1 integer 1101 1 integer 1101 1 text 1101 1 integer 18342 id 1 18356 client_id 18355 profile_id id engage_engageprofilestatus_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict profile_id ios_profiles.ios_profiles_pkey restrict restrict status status >= 0 1096 1 integer nextval('engage_singleappmodeprofileinstallation_id_seq'::regclass) 1102 1 integer 1096 1 integer 1096 1 text 18185 id 1 18187 mdm_client_id 1 18199 profile_id id engage_singleappmodeprofileinstallation_pkey 1 mdm_client_id engage_singleappmodeprofileinstallation_ios_client_id_key mdm_client_id ios_mdmclient.ios_iosclient_pkey restrict restrict profile_id ios_profiles.ios_profiles_pkey restrict restrict 1045 1 integer nextval('inventory_application_id_seq'::regclass) 1058 1 citext 1058 1 citext 1058 1 citext 1058 1 citext 1058 1 citext 1063 1 citext 1063 bigint 17156 id 1 17493 path version vendor name product_id 1 18612 product_id id inventory_application_pkey 1 path version vendor name product_id inventory_application_path_533491a394b3bef5_uniq 1099 1 bigint nextval('generic_clientapplication_id_seq'::regclass) 1045 1 integer 1045 1 integer 1045 bigint 1045 date 1060 integer 1060 date 1060 date 1060 date 1062 bigint 1062 bigint 18308 id 1 17348 client_id 17354 application_id id inventory_clientapplication_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict application_id generic_application.inventory_application_pkey restrict restrict 1099 1 bigint nextval('generic_clientfileset_id_seq'::regclass) 1045 1 integer 1045 1 integer 1045 timestamp with time zone 1045 1 boolean 18299 id 1 17360 client_id 17366 fileset_id id inventory_clientfileset_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict fileset_id generic_fileset.inventory_fileset_pkey restrict restrict 1099 1 bigint nextval('generic_clientfont_id_seq'::regclass) 1060 1 integer 1060 1 integer 1060 1 citext 1060 boolean 1060 boolean 18287 id 1 17610 client_id 17616 font_id id inventory_clientfont_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict font_id generic_font.inventory_font_pkey restrict restrict 1126 1 bigint nextval('generic_clientupdate_id_seq'::regclass) 1126 1 integer 1126 1 integer 1126 date 1126 1 integer 18566 id 1 18584 client_id 18590 update_id id generic_clientupdate_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict update_id generic_update.generic_update_pkey restrict restrict status status >= 0 1099 1 integer nextval('generic_email_id_seq'::regclass) 1099 1 varchar(254) 1099 1 citext 1099 1 citext 1099 1 timestamp with time zone 1099 1 smallint 1099 timestamp with time zone 1099 text 1099 1 smallint 18284 id 1 id generic_email_pkey 1 status status >= 0 task task >= 0 1045 1 integer nextval('inventory_fileset_id_seq'::regclass) 1045 1 integer 1050 1 citext 1045 bigint 1045 1 integer 1125 citext 1125 1 integer 1125 boolean 17167 id 1 17169 fileset_id version 1 id inventory_fileset_pkey 1 fileset_id version inventory_fileset_fileset_id_4d4044e086e1c651_uniq type type >= 0 type type >= 0 1077 1 integer 1078 1 boolean 17830 admin_id 1 admin_id generic_filewave_admin_pkey 1 1060 1 integer nextval('inventory_font_id_seq'::regclass) 1060 1 citext 1060 1 citext 1060 1 citext 1060 1 citext 1060 1 citext 17556 id 1 17558 name family kind vendor version 1 id inventory_font_pkey 1 name family kind vendor version inventory_font_name_7936ac8c1df8ed93_uniq 1045 1 integer nextval('inventory_client_id_seq'::regclass) 1050 1 citext 1050 citext 1051 timestamp with time zone 1045 bigint 1045 bigint 1045 integer 1050 citext 1047 integer 1050 citext 1050 citext 1052 inet 1060 citext 1060 citext 1060 citext 1060 citext 1063 citext 1075 1 boolean 1080 timestamp with time zone 1122 timestamp with time zone 1124 boolean 17193 id 1 17443 device_id 1 17445 device_id 17442 last_check_in 17330 filewave_id id inventory_client_pkey 1 device_id inventory_client_device_id_key filewave_id generic_operatingsystem.inventory_operatingsystem_pkey restrict restrict 1063 1 integer 1049 integer 1049 bigint 1050 citext 1050 citext 1049 bigint 1050 citext 1049 integer 1050 citext 1049 boolean 1079 citext 17427 genericclient_ptr_id 1 genericclient_ptr_id inventory_desktopclient_pkey 1 genericclient_ptr_id generic_genericclient.inventory_client_pkey restrict restrict 1072 1 integer 17776 genericclient_ptr_id 1 genericclient_ptr_id generic_genericmobileclient_pkey 1 genericclient_ptr_id generic_genericclient.inventory_client_pkey restrict restrict 1079 1 integer 1079 citext 1079 citext 1079 citext 1079 citext 1079 citext 17843 genericclient_ptr_id 1 genericclient_ptr_id generic_genericunmanagedclient_pkey 1 genericclient_ptr_id generic_genericclient.inventory_client_pkey restrict restrict 1030 1 integer nextval('ios_iconfile_id_seq'::regclass) 1030 1 text 1030 text 16779 id 1 id ios_iconfile_pkey 1 1033 1 integer nextval('ios_kioskinfo_id_seq'::regclass) 1033 1 integer 1033 1 double precision 1098 1 citext 1098 citext 1098 citext 1098 integer 16922 id 1 18272 icon_id id ios_kioskinfo_pkey 1 icon_id generic_iconfile.ios_iconfile_pkey restrict restrict 1045 1 integer nextval('inventory_networkaddress_id_seq'::regclass) 1059 1 integer 1045 1 inet 1045 1 smallint 17275 id 1 17495 network_interface_id id inventory_networkaddress_pkey 1 network_interface_id generic_networkinterface.inventory_networkinterface_pkey restrict restrict ip_version ip_version >= 0 1045 1 integer nextval('inventory_networkinterface_id_seq'::regclass) 1059 1 integer 1050 1 citext 1050 1 citext 1050 citext 1045 1 boolean 17263 id 1 17507 client_id id inventory_networkinterface_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict 1045 1 integer nextval('inventory_operatingsystem_id_seq'::regclass) 1058 1 citext 1045 1 varchar(3) 1050 1 citext 1058 1 citext 1058 1 citext 1076 integer 1076 integer 1076 integer 17145 id 1 17483 edition version type name build 1 17479 name 17480 name 17318 type 17319 type 17441 version 17440 version id inventory_operatingsystem_pkey 1 edition version type name build inventory_operatingsystem_edition_d51c2d50e994ccf_uniq 1126 1 integer nextval('generic_update_id_seq'::regclass) 1126 1 citext 1126 1 citext 1126 bigint 1126 boolean 1126 boolean 1126 boolean 1127 1 citext 1127 1 citext 1127 bigint 1127 boolean 18577 id 1 18610 name update_id version 1 18591 update_id id generic_update_pkey 1 name update_id version generic_update_name_3c147d3434e4e206_uniq 1079 1 integer nextval('generic_user_login_id_seq'::regclass) 1079 1 citext 1079 1 integer 1079 timestamp with time zone 1079 timestamp with time zone 1079 1 boolean 1079 1 integer 17854 id 1 17866 device_id id generic_user_login_pkey 1 device_id generic_genericdesktopclient.inventory_desktopclient_pkey restrict restrict 1063 1 integer 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 1060 boolean 17701 client_id 1 client_id inventory_clientcustomboolfields_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict 1063 1 integer 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 1060 timestamp with time zone 17687 client_id 1 client_id inventory_clientcustomdatetimefields_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict 1063 1 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 1060 integer 17694 client_id 1 client_id inventory_clientcustomintegerfields_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict 1063 1 integer 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 1060 citext 17680 client_id 1 client_id inventory_clientcustomstringfields_pkey 1 client_id generic_genericclient.inventory_client_pkey restrict restrict 1053 1 integer nextval('inventory_defaultquery_id_seq'::regclass) 1053 1 text 1053 bigint 17455 id 1 id inventory_defaultquery_pkey 1 1220 1 integer nextval('inventory_imagingmacaddress_id_seq'::regclass) 1220 1 text 1220 1 integer 18628 id 1 18651 imaging_mapping_id id inventory_imagingmacaddress_pkey 1 imaging_mapping_id inventory_imagingmapping.inventory_imagingmapping_pkey restrict restrict 1220 1 integer nextval('inventory_imagingmapping_id_seq'::regclass) 1220 1 integer 1220 text 1220 1 text 1220 timestamp with time zone 1220 1 integer 1220 1 boolean 18640 id 1 18642 serial_number 1 18644 client_id 1 18652 serial_number id inventory_imagingmapping_pkey 1 serial_number inventory_imagingmapping_serial_number_key client_id inventory_imagingmapping_client_id_key client_id client_id >= 0 1045 1 integer nextval('inventory_licensedefinition_id_seq'::regclass) 1057 1 text 1045 integer 1050 citext 1060 text 1217 integer 1222 integer 17286 id 1 18711 #8 1 18618 organization_asset_id id inventory_licensedefinition_pkey 1 #8 inventory_licensedefinition_organization_asset_id_key #8 apple_vpp_organization_asset.apple_vpp_organization_asset_pkey restrict restrict organization_asset_id apple_vpp_organization_license.ios_organizationlicense_pkey restrict restrict 1045 1 integer nextval('inventory_licensepurchaseorder_id_seq'::regclass) 1059 1 integer 1050 citext 1045 1 integer 1045 date 1045 date 1050 citext 1050 citext 1050 citext 17297 id 1 17501 license_id id inventory_licensepurchaseorder_pkey 1 license_id inventory_licensedefinition.inventory_licensedefinition_pkey restrict restrict 1055 1 text 1055 text 17469 #3 1 #3 inventory_preferences_pkey 1 1045 1 integer nextval('inventory_query_id_seq'::regclass) 1050 1 citext 1045 integer 1057 1 text 1045 1 boolean 1045 1 integer 17134 id 1 17315 group_id id inventory_query_pkey 1 group_id inventory_querygroup.inventory_querygroup_pkey restrict restrict 1045 1 integer nextval('inventory_querygroup_id_seq'::regclass) 1050 1 citext 17123 id 1 id inventory_querygroup_pkey 1 1060 1 integer nextval('inventory_reportdefinition_id_seq'::regclass) 1060 1 integer 1060 1 text 1060 1 text 1060 1 text 1060 1 text 1060 1 integer 1060 text 17540 id 1 id inventory_reportdefinition_pkey 1 1033 1 integer 1033 1 text 1033 text 1033 text 1033 integer 16930 id 1 16949 parent_id id ios_category_pkey 1 parent_id ios_category_pkey restrict restrict 1061 1 integer nextval('ios_clientapplinkassociation_id_seq'::regclass) 1061 1 integer 1061 1 integer 1061 1 smallint 1069 1 boolean 1235 1 boolean 1238 1 smallint 17655 id 1 17657 client_id applink_id 1 17664 client_id 17670 applink_id id ios_clientapplinkassociation_pkey 1 client_id applink_id ios_clientapplinkassociation_client_id_548635fa19a66308_uniq client_id generic_genericclient.inventory_client_pkey restrict restrict applink_id apple_applink.ios_applinks_pkey restrict restrict 3824 1 integer nextval('ios_commands_id_seq'::regclass) 3824 text 3824 text 3824 integer 3824 timestamp with time zone 3824 timestamp with time zone 3824 text 3824 text 3824 integer 3824 integer 3824 text 3824 text 3824 text 3824 integer 3824 integer 18996 id 1 18999 id 18998 command_uuid 19000 user_id id ios_commands_pkey 1 user_id ios_mdmuser.ios_devicedata_pkey restrict restrict 1030 1 integer nextval('ios_enrollmentchallenge_id_seq'::regclass) 1030 1 text 1030 text 16766 id 1 16768 challenge_uuid 1 16853 challenge_uuid id ios_enrollmentchallenge_pkey 1 challenge_uuid ios_enrollmentchallenge_challenge_uuid_key 1030 1 integer nextval('ios_iosenterpriseapps_id_seq'::regclass) 1030 text 1030 1 text 1030 1 text 1030 1 text 1030 1 text 1030 text 1030 text 1092 integer 1030 boolean 1030 1 integer 1061 integer 1061 text 1033 bigint 1090 integer 1091 text 1239 text 16790 id 1 17635 kiosk_info_id 1 18096 app_config_id 1 18115 display_image_id id ios_iosenterpriseapps_pkey 1 kiosk_info_id ios_iosenterpriseapps_kiosk_info_id_key app_config_id ios_iosenterpriseapps_app_config_id_key display_image_id generic_iconfile.ios_iconfile_pkey restrict restrict kiosk_info_id generic_kioskinfo.ios_kioskinfo_pkey restrict restrict app_config_id apple_ios_app_config.apple_ios_app_config_pkey restrict restrict 1236 1 integer 1236 1 integer 1236 integer 18773 filewave_fs_id 1 18775 kiosk_info_id 1 18782 update_id filewave_fs_id ios_iosupdatefileset_pkey 1 kiosk_info_id ios_iosupdatefileset_kiosk_info_id_key update_id generic_update.generic_update_pkey restrict restrict kiosk_info_id generic_kioskinfo.ios_kioskinfo_pkey restrict restrict filewave_fs_id filewave_fs_id >= 0 1030 1 integer nextval('ios_managedappstatus_id_seq'::regclass) 1068 1 integer 1030 1 text 1030 1 text 1030 1 integer 1030 text 1090 integer 1090 integer 16801 id 1 17747 device_id 18103 app_link_id 18109 enterprise_app_id id ios_managedappstatus_pkey 1 device_id ios_mdmclient.ios_iosclient_pkey restrict restrict app_link_id apple_applink.ios_applinks_pkey restrict restrict enterprise_app_id ios_iosenterpriseapps.ios_iosenterpriseapps_pkey restrict restrict 1032 1 integer 1032 1 text 16906 id 1 id ios_manifest_pkey 1 1030 text 1097 1 integer 1097 1 citext 1234 boolean 18216 #103 1 18214 #103 1 18248 #104 #103 ios_iosclient_pkey 1 #103 ios_iosclient_appleiosclient_ptr_id_key #103 generic_genericclient.inventory_client_pkey restrict restrict 1031 1 integer nextval('ios_devicedata_id_seq'::regclass) 1097 1 integer 1031 text 1031 text 1097 text 1097 text 1097 text 1097 text 1097 citext 1097 citext 1237 timestamp with time zone 16881 id 1 18249 mdm_client_id id ios_devicedata_pkey 1 mdm_client_id ios_mdmclient.ios_iosclient_pkey restrict restrict 1094 1 integer nextval('ios_pendinginstallcommand_id_seq'::regclass) 1094 1 integer 1100 1 integer 18128 id 1 18324 #4 mdm_user_id 1 18152 mdm_user_id 18326 #4 id ios_pendinginstallcommand_pkey 1 #4 mdm_user_id ios_pendinginstallcommand_mdm_user_id_725637bfd27ce428_uniq #4 ios_mdmuser.ios_devicedata_pkey restrict restrict mdm_user_id apple_applink.ios_applinks_pkey restrict restrict 1038 1 text 1038 text 17029 key 1 17071 key key ios_preferences_pkey 1 1030 1 integer nextval('ios_profiles_id_seq'::regclass) 1030 1 integer 1030 1 text 1030 1 text 1061 integer 1095 1 boolean 1095 text 1095 text 1095 1 boolean 1233 1 boolean 1233 1 boolean 1233 1 boolean 16691 id 1 16693 profile_id 1 17642 kiosk_info_id 1 16823 profile_id 18175 engage_profile id ios_profiles_pkey 1 profile_id ios_profiles_profile_id_key kiosk_info_id ios_profiles_kiosk_info_id_key kiosk_info_id generic_kioskinfo.ios_kioskinfo_pkey restrict restrict type type >= 0 1032 1 integer nextval('ios_recentlyenrolleddevices_id_seq'::regclass) 1068 1 integer 16896 id 1 id ios_recentlyenrolleddevices_pkey 1 device_id ios_mdmclient.ios_iosclient_pkey restrict restrict 1030 1 text 1030 1 text 1030 1 integer 1061 integer 16722 code 1 16828 code 16834 order_id 17629 app_link_id code ios_redemptioncode_pkey 1 order_id ios_vpporder.ios_vpporder_pkey restrict restrict app_link_id apple_applink.ios_applinks_pkey restrict restrict 1030 1 text 1030 1 text 1030 text 1030 integer 1030 integer 1030 1 text 1030 1 integer 1030 text 1030 text 1030 timestamp with time zone 1030 text 1030 1 integer 16714 code 1 16824 code 16825 udid 16826 udid 16827 itunes_id code ios_redemptionevent_pkey 1 reason_type reason_type >= 0 1038 1 integer nextval('ios_statusmessage_id_seq'::regclass) 1038 1 text 1039 1 timestamp with time zone 1040 1 smallint 1040 1 smallint 17008 id 1 id ios_statusmessage_pkey 1 #6 severity >= 0 severity context >= 0 1030 1 integer nextval('ios_vpporder_id_seq'::regclass) 1030 1 text 1030 1 text 1030 1 text 1030 1 integer 1030 1 integer 1030 1 integer 1030 1 timestamp with time zone 1030 1 text 1030 1 integer 16733 id 1 id ios_vpporder_pkey 1 3844 integer 3844 varchar(1024) 3849 text 3844 1 integer nextval('nmapresult_id_seq'::regclass) 3846 varchar(1024) 19054 scanner 1 scanner nmapresult_pkey 1 1003 1 integer nextval('south_migrationhistory_id_seq'::regclass) 1003 1 varchar(255) 1003 1 varchar(255) 1003 1 timestamp with time zone 16622 id 1 id south_migrationhistory_pkey 1 IN citext IN citext RETURN integer IN citext IN citext RETURN boolean IN citext IN citext RETURN boolean IN citext IN citext RETURN boolean IN citext RETURN integer IN citext IN citext RETURN citext IN citext IN citext RETURN boolean IN citext IN citext RETURN boolean IN citext IN citext RETURN boolean IN citext IN citext RETURN citext IN boolean RETURN citext IN char RETURN citext IN cstring RETURN citext IN inet RETURN citext IN citext RETURN cstring IN internal RETURN citext IN citext RETURN bytea IN citext RETURN citext IN citext RETURN citext IN citext IN citext RETURN text[] IN citext IN citext IN text RETURN text[] IN citext IN citext IN text RETURN text IN citext IN citext IN text IN text RETURN text IN citext IN citext RETURN text[] IN citext IN citext IN text RETURN text[] IN citext IN citext RETURN setof text IN citext IN citext IN text RETURN setof text IN citext IN citext IN citext RETURN text IN citext IN citext IN integer RETURN text IN citext IN citext RETURN integer IN citext IN citext RETURN boolean IN citext IN text RETURN boolean IN citext IN citext RETURN boolean IN citext IN text RETURN boolean IN citext IN citext RETURN boolean IN citext IN text RETURN boolean IN citext IN citext RETURN boolean IN citext IN text RETURN boolean IN citext IN citext IN text RETURN text