resource

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
resource_view.resource_id resource_view_resource_id_fkeyC
url text 2147483647 null
format text 2147483647 √ null
description text 2147483647 √ null
position int4 10 √ null
hash text 2147483647 √ null
state text 2147483647 √ null
extras text 2147483647 √ null
name text 2147483647 √ null
resource_type text 2147483647 √ null
mimetype text 2147483647 √ null
mimetype_inner text 2147483647 √ null
size int8 19 √ null
last_modified timestamp 29,6 √ null
cache_url text 2147483647 √ null
cache_last_updated timestamp 29,6 √ null
webstore_url text 2147483647 √ null
webstore_last_updated timestamp 29,6 √ null
created timestamp 29,6 √ null
url_type text 2147483647 √ null
package_id text 2147483647 ''::text
metadata_modified timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
resource_pkey Primary key Asc id
idx_package_resource_id Performance Asc id
idx_package_resource_package_id Performance Asc package_id
idx_package_resource_url Performance Asc url

Relationships

Close relationships within degrees of separation