Table "public.hosts"
          Column          |            Type             |                     Modifiers                      
--------------------------+-----------------------------+----------------------------------------------------
 id                       | integer                     | not null default nextval('hosts_id_seq'::regclass)
 name                     | character varying(255)      | not null
 last_compile             | timestamp without time zone | 
 last_report              | timestamp without time zone | 
 updated_at               | timestamp without time zone | 
 created_at               | timestamp without time zone | 
 root_pass                | character varying(255)      | 
 architecture_id          | integer                     | 
 operatingsystem_id       | integer                     | 
 environment_id           | integer                     | 
 ptable_id                | integer                     | 
 medium_id                | integer                     | 
 build                    | boolean                     | default false
 comment                  | text                        | 
 disk                     | text                        | 
 installed_at             | timestamp without time zone | 
 model_id                 | integer                     | 
 hostgroup_id             | integer                     | 
 owner_id                 | integer                     | 
 owner_type               | character varying(255)      | 
 enabled                  | boolean                     | default true
 puppet_ca_proxy_id       | integer                     | 
 managed                  | boolean                     | not null default false
 use_image                | boolean                     | 
 image_file               | character varying(128)      | 
 uuid                     | character varying(255)      | 
 compute_resource_id      | integer                     | 
 puppet_proxy_id          | integer                     | 
 certname                 | character varying(255)      | 
 image_id                 | integer                     | 
 organization_id          | integer                     | 
 location_id              | integer                     | 
 type                     | character varying(255)      | 
 otp                      | character varying(255)      | 
 realm_id                 | integer                     | 
 compute_profile_id       | integer                     | 
 provision_method         | character varying(255)      | 
 grub_pass                | character varying(255)      | default ''::character varying
 content_view_id          | integer                     | 
 lifecycle_environment_id | integer                     | 
 global_status            | integer                     | not null default 0
 lookup_value_matcher     | character varying(255)      | 
 pxe_loader               | character varying(255)      | 
Indexes:
    "hosts_pkey" PRIMARY KEY, btree (id)
    "host_arch_id_ix" btree (architecture_id)
    "host_env_id_ix" btree (environment_id)
    "host_group_id_ix" btree (hostgroup_id)
    "host_medium_id_ix" btree (medium_id)
    "host_os_id_ix" btree (operatingsystem_id)
    "index_hosts_on_certname" btree (certname)
    "index_hosts_on_compute_profile_id" btree (compute_profile_id)
    "index_hosts_on_installed_at" btree (installed_at)
    "index_hosts_on_last_report" btree (last_report)
    "index_hosts_on_name" btree (name)
    "index_hosts_on_type" btree (type)
Foreign-key constraints:
    "hosts_architecture_id_fk" FOREIGN KEY (architecture_id) REFERENCES architectures(id)
    "hosts_compute_profile_id_fk" FOREIGN KEY (compute_profile_id) REFERENCES compute_profiles(id)
    "hosts_compute_resource_id_fk" FOREIGN KEY (compute_resource_id) REFERENCES compute_resources(id)
    "hosts_environment_id_fk" FOREIGN KEY (environment_id) REFERENCES environments(id)
    "hosts_hostgroup_id_fk" FOREIGN KEY (hostgroup_id) REFERENCES hostgroups(id)
    "hosts_image_id_fk" FOREIGN KEY (image_id) REFERENCES images(id)
    "hosts_location_id_fk" FOREIGN KEY (location_id) REFERENCES taxonomies(id)
    "hosts_medium_id_fk" FOREIGN KEY (medium_id) REFERENCES media(id)
    "hosts_model_id_fk" FOREIGN KEY (model_id) REFERENCES models(id)
    "hosts_operatingsystem_id_fk" FOREIGN KEY (operatingsystem_id) REFERENCES operatingsystems(id)
    "hosts_organization_id_fk" FOREIGN KEY (organization_id) REFERENCES taxonomies(id)
    "hosts_ptable_id_fk" FOREIGN KEY (ptable_id) REFERENCES templates(id)
    "hosts_puppet_ca_proxy_id_fk" FOREIGN KEY (puppet_ca_proxy_id) REFERENCES smart_proxies(id)
    "hosts_puppet_proxy_id_fk" FOREIGN KEY (puppet_proxy_id) REFERENCES smart_proxies(id)
    "hosts_realms_id_fk" FOREIGN KEY (realm_id) REFERENCES realms(id)
Referenced by:
    TABLE "fact_values" CONSTRAINT "fact_values_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "host_classes" CONSTRAINT "host_classes_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "host_status" CONSTRAINT "host_status_hosts_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "katello_content_facets" CONSTRAINT "katello_content_facets_host_id" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "katello_host_collection_hosts" CONSTRAINT "katello_host_collection_hosts_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "katello_host_installed_packages" CONSTRAINT "katello_host_installed_packages_host_id" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "katello_host_tracers" CONSTRAINT "katello_host_trace_host_id" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "katello_subscription_facets" CONSTRAINT "katello_subscription_facets_host_id" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "nics" CONSTRAINT "nics_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "reports" CONSTRAINT "reports_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)
    TABLE "tokens" CONSTRAINT "tokens_host_id_fk" FOREIGN KEY (host_id) REFERENCES hosts(id)