Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConversionDate | Unknown | 0 | null |
|
|
Conversion date - Date when pre-signup converted to full signup |
||
| PreID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| FirstName | nvarchar | 200 | √ | null |
|
|
First name - First name of the pre-signup user |
|
| LastName | nvarchar | 200 | √ | null |
|
|
Last name - Last name of the pre-signup user |
|
| nvarchar | 200 | √ | null |
|
|
Email address - Email address of the pre-signup user |
||
| Phone | nvarchar | 40 | √ | null |
|
|
Phone number - Contact phone number for TheraWowPreSignup communications |
|
| CompanyName | nvarchar | 400 | √ | null |
|
|
Company name - Name of the company or organization |
|
| iPad | bit | 1 | √ | ((0)) |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
|
| BetaTester | bit | 1 | √ | ((0)) |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
|
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Date/time field - Date and time when created occurred or was recorded |
|
| PhoneNumber | Unknown | 0 | null |
|
|
Phone number - Contact phone number |
||
| PreSignupId | Unknown | 0 | null |
|
|
Primary key - TheraWowPreSignup unique identifier for each pre-signup record |
||
| SignupDate | Unknown | 0 | null |
|
|
Signup date - Date when pre-signup was completed |
||
| Status | Unknown | 0 | null |
|
|
Signup status - Current status of the pre-signup |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_TheraWowPreSignup | Primary key | Asc | PreID |