Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ParticipantIdentifier | varchar | 250 | √ | null |
|
|
||
| StartDate | datetime2 | 16,7 | √ | null |
|
|
||
| EndDate | datetime2 | 16,7 | √ | null |
|
|
||
| Duration | varchar | 100 | √ | null |
|
|
||
| Efficiency | varchar | 100 | √ | null |
|
|
||
| InfoCode | varchar | 100 | √ | null |
|
|
||
| MinutesAfterWakeup | varchar | 100 | √ | null |
|
|
||
| MinutesAsleep | varchar | 100 | √ | null |
|
|
||
| MinutesAwake | varchar | 100 | √ | null |
|
|
||
| MinutesToFallAsleep | varchar | 100 | √ | null |
|
|
||
| TimeInBed | varchar | 100 | √ | null |
|
|
||
| Type | varchar | 100 | √ | null |
|
|
||
| SleepLevelDeep | varchar | 100 | √ | null |
|
|
||
| SleepLevelLight | varchar | 100 | √ | null |
|
|
||
| SleepLevelRem | varchar | 100 | √ | null |
|
|
||
| SleepLevelWake | varchar | 100 | √ | null |
|
|
||
| SleepLogDetails | nvarchar | 2147483647 | √ | null |
|
|
||
| FileName | varchar | 250 | √ | null |
|
|
||
| FileCreationDate | datetime2 | 16,7 | √ | null |
|
|
||
| ProcessedDate | datetime2 | 16,7 | √ | null |
|
|
||
| ClassicAwake | varchar | 100 | √ | null |
|
|
||
| ClassicAsleep | varchar | 100 | √ | null |
|
|
||
| ClassicRestless | varchar | 100 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
