Unanet Data Model

EMAIL_TEMPLATE

Column Name Data Type Nulls References
Table
Foreign Key
Name
name varchar (50)      
description varchar (250) YES    
subject varchar (250) YES    
message text YES    
enabled varchar (1)      

Check Constraints for EMAIL_TEMPLATE

Check Constraint Name Definition
cc_enabled (enabled = 'N' or (enabled = 'Y'))

Indexes on EMAIL_TEMPLATE

Index Name Column(s)
pk_email_template name


No References made to EMAIL_TEMPLATE

No Views Reference EMAIL_TEMPLATE


Copyright 1998, 1999 Computer Strategies, Inc., All Rights Reserved.
Last revised: May 25, 2000 11:27:35 AM EDT