asset_template


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
asset_schedule.template_id FK7A002706658AD94A R
asset_template_type.template_id FKF3F210D0658AD94A R
program_asset_templates.asset_template_id FK_sjrdqbl86kl4yw46d6xftptu2 R
version INT 10 √ 0
active BIT 1 null
name VARCHAR 50 null
sequence INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation