site_channel


Columns

Column Type Size Nulls Auto Default Children Parents Comments
channel_code VARCHAR 5 null
milestone_template_channel.channel_code FK_milestone_template_channel R
process_library_record_site_channel.site_channel_id FKF11409E525DF84A6 R
program_site_channel.site_channel_id FK_95wtbjxawo3uulf6a1bok11wi R
site.channel_code FK35DF47353BF280 R
channel VARCHAR 50 √ null
template_id INT 10 √ null
milestone_templates.template_id FK6F7CCC0BE98DF3E0 R
channel_group VARCHAR 20 √ null
channel_operator VARCHAR 100 √ null
contact_group INT 10 √ null
lookup_table VARCHAR 50 √ null
active BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc channel_code
channel Must be unique Asc channel
FK6F7CCC0BE98DF3E0 Performance Asc template_id
idx_channel_grp Performance Asc channel_group

Relationships

Close relationships within degrees of separation