url

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('url_verify.url_id_seq'::regclass)
url.redirect_from url_redirect_from_fkey R
url_verification.redirect_to url_verification_redirect_to_fkey R
url_verification.url url_verification_url_fkey R
redirect_from int4 10 √ null
url.id url_redirect_from_fkey R
item int4 10 √ null
biblio_record_entry_bucket_item.id url_item_fkey R
session int4 10 √ null
session.id url_session_fkey R
url_selector int4 10 √ null
url_selector.id url_url_selector_fkey R
tag text 2147483647 √ null
subfield text 2147483647 √ null
ord int4 10 √ null
full_url text 2147483647 null
scheme text 2147483647 √ null
username text 2147483647 √ null
password text 2147483647 √ null
host text 2147483647 √ null
domain text 2147483647 √ null
tld text 2147483647 √ null
port text 2147483647 √ null
path text 2147483647 √ null
page text 2147483647 √ null
query text 2147483647 √ null
fragment text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
url_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
redirect_or_from_item (((redirect_from IS NOT NULL) OR ((item IS NOT NULL) AND (url_selector IS NOT NULL) AND (tag IS NOT NULL) AND (subfield IS NOT NULL) AND (ord IS NOT NULL))))

Relationships

Close relationships within degrees of separation