Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| facilityid | int | 4 | √ | null |
|
|
||||
| bedid | int | 4 | √ | null |
|
|
||||
| roomid | int | 4 | √ | null |
|
|
||||
| unitid | int | 4 | √ | null |
|
|
||||
| beddesc | varchar | 30 | √ | null |
|
|
||||
| createddate | datetime | 16,3 | √ | null |
|
|
||||
| revisiondate | datetime | 16,3 | √ | null |
|
|
||||
| deleted | char | 1 | √ | null |
|
|
||||
| floorid | int | 4 | √ | null |
|
|
||||
| floor | varchar | 256 | √ | null |
|
|
||||
| retireddate | datetime | 16,3 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
