SchemaSpy - Table webco_4.3.1.public.resource

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
obj_oid	int8	19
container_foreignid	varchar	2147483647	√	null
rtid	varchar	2147483647	√	null
metaclass	varchar	2147483647	√	null
file_id	varchar	2147483647	√	null
csv_line_number	int4	10	√	null
origin	varchar	2147483647	√	null
accessories	varchar	2147483647	√	null
asset_tag	varchar	2147483647	√	null
barcode	varchar	2147483647	√	null
capacity	varchar	2147483647	√	null
circulating	varchar	2147483647	√	null
condition_note	varchar	2147483647	√	null
description	varchar	2147483647	√	null
destination	varchar	2147483647	√	null
label_id	varchar	2147483647	√	null
inventory_date	varchar	2147483647	√	null
location	varchar	2147483647	√	null
manufacturer	varchar	2147483647	√	null
model	varchar	2147483647	√	null
purchase_date	varchar	2147483647	√	null
purchase_order	varchar	2147483647	√	null
replacement_date	varchar	2147483647	√	null
room_number	varchar	2147483647	√	null
serial_number	varchar	2147483647	√	null
unserialized	varchar	2147483647	√	null
url	varchar	2147483647	√	null
value	varchar	2147483647	√	null
vendor	varchar	2147483647	√	null
warranty_labor	varchar	2147483647	√	null
warranty_parts	varchar	2147483647	√	null
biblio_id	varchar	2147483647	√	null
call_number	varchar	2147483647	√	null
restrictions	varchar	2147483647	√	null
home_location_string	varchar	2147483647	√	null
distributor	varchar	2147483647	√	null
shelf_location	varchar	2147483647	√	null
mac_address	varchar	2147483647	√	null
hostname	varchar	2147483647	√	null
hardware_version	varchar	2147483647	√	null
software_version	varchar	2147483647	√	null
ip_address	varchar	2147483647	√	null
budget_number	varchar	2147483647	√	null

Table contained 0 rows at Tue Jun 21 07:45 CDT 2016

Indexes:

Column(s)	Type	Sort	Constraint Name
obj_oid	Primary key	Asc	resource_ext_pkey