auth_header

1606 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
authid BIGINT UNSIGNED 20 √ null
import_oai_authorities.authid FK_import_oai_authorities_1 C
authtypecode VARCHAR 10 ''
auth_types.authtypecode Implied Constraint R
datecreated DATE 10 √ NULL
modification_time TIMESTAMP 19 current_timestamp()
heading LONGTEXT 2147483647 √ NULL
origincode VARCHAR 20 √ NULL
authtrees LONGTEXT 2147483647 √ NULL
linkid BIGINT 19 √ NULL
marcxml LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
auth_header_s_pk Primary key Asc authid
origincode Performance Asc origincode
PRIMARY Must be unique Asc authid

Relationships

Close relationships within degrees of separation