Table testsql_comments.auth_header Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
authid bigint unsigned 20  √ 
authtypecode varchar 10
auth_types.authtypecode Implied Constraint R
datecreated date 10  √  null
modification_time timestamp 19 CURRENT_TIMESTAMP
origincode varchar 20  √  null
authtrees mediumtext 16777215  √  null
marc blob 65535  √  null
linkid bigint 19  √  null
marcxml longtext 2147483647

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort Constraint Name
authid Primary key Asc PRIMARY
origincode Performance Asc origincode

Close relationships: