Tracking Email

FILEPATH: /d:/Projects/1bytesoftware/sql/table-scripts/JFW.TrackingEmail.Table.sql

This script creates a table named `[JFW]`.[TrackingEmail] in the `[JFW_live]` database.

Table Structure:
- `[ID]`: bigint, `auto-incrementing primary key`
- `[Brand_ID]`: bigint, `nullable`
- `[User_ID]`: bigint, `nullable`
- `[Support_Code]`: varchar(150), `nullable`
- `[Pattern_Code]`: varchar(150), `nullable`
- `[Email_From]`: varchar(1000), `nullable`
- `[Email_To]`: varchar(max), `nullable`
- `[Email_CC]`: varchar(max), `nullable`
- `[Email_BCC]`: varchar(max), `nullable`
- `[Email_Subject]`: nvarchar(1024), `nullable`
- `[Email_Body]`: nvarchar(max), `nullable`
- `[Sent_Time]`: datetime, `nullable`
- `[Tracking_Email_Type]`: smallint, `nullable`
- `[Status]`: smallint, `not null`
- `[Modified_By]`: bigint, `nullable`
- `[Modified_Date]`: datetime, `not null`
- `[Created_By]`: bigint, `nullable`
- `[Created_Date]`: datetime, `not null`

Constraints:
- Primary Key: `[ID]`
- Default Constraint: `[Modified_Date]` (getutcdate())
- Default Constraint: `[Created_Date]` (getutcdate())

Note: This script assumes that the `[JFW_live]` database already exists.