|
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)
|
|
|
