Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ObjectBookingsSeq | int | 4 | null |
|
|
|||
| ID | int | 4 | √ | null |
|
|
||
| ClassBookingFlag | bit | 1 | √ | null |
|
|
||
| Description | varchar | 100 | √ | null |
|
|
||
| ObjectNumber | int | 4 | null |
|
|
|||
| AccommodationLinkedID | int | 4 | √ | null |
|
|
||
| AccommodationTypeCode | varchar | 15 | null |
|
|
|||
| AccommodationRoomTypeCode | varchar | 15 | null |
|
|
|||
| AccommodationMealsAvailableFlag | bit | 1 | null |
|
|
|||
| AccommodationCapacity | int | 4 | √ | null |
|
|
||
| AccommodationAvailableDateFrom | datetime | 16,3 | √ | null |
|
|
||
| AccommodationAvailableDateTo | datetime | 16,3 | √ | null |
|
|
||
| AccommodationFacilities | varchar | 1000 | null |
|
|
|||
| AccommodationApprovedDate | datetime | 16,3 | √ | null |
|
|
||
| AccommodationApprovedUnder18Flag | bit | 1 | null |
|
|
|||
| AccommodationApprovedFemaleFlag | bit | 1 | null |
|
|
|||
| AccommodationDistanceFromSchool | smallint | 2 | √ | null |
|
|
||
| AccommodationPermissionToCheckFlag | bit | 1 | null |
|
|
|||
| AccommodationWelfareApprovedFlag | bit | 1 | null |
|
|
|||
| AccommodationReligionCode | varchar | 15 | null |
|
|
|||
| AccommodationComment | varchar | 2147483647 | null |
|
|
|||
| AccommodationAgentID | int | 4 | √ | null |
|
|
||
| AccommodationStatusCode | varchar | 15 | null |
|
|
|||
| AccommodationRating | varchar | 15 | null |
|
|
|||
| DateFrom | datetime | 16,3 | √ | null |
|
|
||
| DateTo | datetime | 16,3 | √ | null |
|
|
||
| DateToEffective | datetime | 16,3 | √ | null |
|
|
||
| Quantity | int | 4 | null |
|
|
|||
| RoomNumber | varchar | 15 | null |
|
|
|||
| ObjectLoansSeq | int | 4 | √ | null |
|
|
||
| ClassCode | varchar | 20 | √ | null |
|
|
||
| ClassDescription | varchar | 100 | null |
|
|
|||
| IssuedFlag | bit | 1 | √ | null |
|
|
||
| LoanedDate | datetime | 16,3 | √ | null |
|
|
||
| ReturnedFlag | bit | 1 | √ | null |
|
|
||
| ReturnedDate | datetime | 16,3 | √ | null |
|
|
||
| MasterObjectFlag | bit | 1 | null |
|
|
|||
| ObjectTypesSeq | int | 4 | null |
|
|
|||
| ObjectTypesDescription | varchar | 50 | null |
|
|
|||
| ObjectTypesMeaning | varchar | 20 | null |
|
|
|||
| PastBookingFlag | bit | 1 | √ | null |
|
|
||
| CancelledFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows