Table testsql_comments.creator_templates 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
template_id int 10  √ 
marc_modification_templates.template_id Implied Constraint R
profile_id int 10  √  null
printers_profile.profile_id Implied Constraint R
template_code char 100 DEFAULT TEMPLATE
template_desc char 100 Default description
page_width float 12 0
page_height float 12 0
label_width float 12 0
label_height float 12 0
top_text_margin float 12 0
left_text_margin float 12 0
top_margin float 12 0
left_margin float 12 0
cols int 10 0
rows int 10 0
col_gap float 12 0
row_gap float 12 0
units char 20 POINT
creator char 15 Labels

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
template_id Primary key Asc PRIMARY
profile_id Performance Asc template_profile_fk_constraint

Close relationships: