Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AgreementType | varchar | 100 | null |
|
|
Type classification - Category or classification type for LegalContent records |
|||||
| ContentId | Unknown | 0 | null |
|
|
Primary key - LegalContent unique identifier for each legal document |
|||||
| ContentText | Unknown | 0 | null |
|
|
Content text - Full text of the legal document |
|||||
| ContentTitle | Unknown | 0 | null |
|
|
Content title - Title of the legal document |
|||||
| ContentType | Unknown | 0 | null |
|
|
Content type - Type of legal content (Terms, Privacy Policy, etc.) |
|||||
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this legal content becomes effective |
|||||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when this content expires |
|||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this content is currently in effect |
|||||
| pkLegalContentID | int identity | 4 | √ | null |
|
|
Primary key - LegalContent unique identifier for each record |
||||
| Status | bit | 1 | ((1)) |
|
|
Status indicator - Current operational status or state of LegalContent records |
|||||
| InsertDate | smalldatetime | 16 | (getdate()) |
|
|
Date/time field - Date and time when insert occurred or was recorded |
|||||
| LegalContent | ntext | 1073741823 | √ | null |
|
|
Text field - LegalContent text information for LegalContent records |
||||
| Version | Unknown | 0 | null |
|
|
Version - Version number of the legal document |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_LegalContent | Primary key | Asc | pkLegalContentID |