Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ParticipantIdentifier | varchar | 250 | √ | null |
|
|
|||||
| PatientID | uniqueidentifier | 16 | √ | null |
|
|
|||||
| Date | date | 6 | √ | null |
|
|
|||||
| Bedtime | datetime2 | 16,7 | √ | null |
|
|
|||||
| Waketime | datetime2 | 16,7 | √ | null |
|
|
|||||
| Sleep | int | 4 | √ | null |
|
|
|||||
| Efficiency | varchar | 100 | √ | null |
|
|
|||||
| MinAfterWakeup | varchar | 100 | √ | null |
|
|
|||||
| MinToFallAsleep | varchar | 100 | √ | null |
|
|
|||||
| Asleep | varchar | 100 | √ | null |
|
|
|||||
| Awake | varchar | 100 | √ | null |
|
|
|||||
| InBed | varchar | 100 | √ | null |
|
|
|||||
| Type | varchar | 100 | √ | null |
|
|
|||||
| Deep | varchar | 100 | √ | null |
|
|
|||||
| Light | varchar | 100 | √ | null |
|
|
|||||
| REM | varchar | 100 | √ | null |
|
|
|||||
| Wake | varchar | 100 | √ | null |
|
|
|||||
| ClassicAwake | varchar | 100 | √ | null |
|
|
|||||
| ClassicAsleep | varchar | 100 | √ | null |
|
|
|||||
| ClassicRestless | varchar | 100 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
