Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | INTEGER | 2000000000 | √ | null |
|
|
|||||
| Category | TEXT | 2000000000 | √ | null |
|
|
|||||
| CreatedAtUtc | TEXT | 2000000000 | null |
|
|
||||||
| Description | TEXT | 2000000000 | √ | null |
|
|
|||||
| Name | TEXT | 2000000000 | null |
|
|
||||||
| Notes | TEXT | 2000000000 | √ | null |
|
|
|||||
| RoomId | INTEGER | 2000000000 | null |
|
|
||||||
| UpdatedAtUtc | TEXT | 2000000000 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| Item_s_pk | Primary key | Asc | Id |
| IX_Item_RoomId | Performance | Asc | RoomId |
Relationships
Close relationships within degrees of separation
