Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ObjectNumber | int | 4 | null |
|
|
|||
| ParentObjectNumber | int | 4 | √ | null |
|
|
||
| Description | varchar | 100 | √ | null |
|
|
||
| ObjectTypeCategoryCode | varchar | 15 | null |
|
|
|||
| Model | varchar | 50 | null |
|
|
|||
| Serial | varchar | 50 | null |
|
|
|||
| AcquiredDate | datetime | 16,3 | √ | null |
|
|
||
| BarCode | varchar | 20 | null |
|
|
|||
| Room | varchar | 15 | null |
|
|
|||
| AssetNumber | int | 4 | √ | null |
|
|
||
| AssetSynDatabaseCode | varchar | 5 | null |
|
|
|||
| OwnershipType | varchar | 15 | null |
|
|
|||
| Status | varchar | 15 | null |
|
|
|||
| ResponsibleID | int | 4 | √ | null |
|
|
||
| LoanedToID | int | 4 | √ | null |
|
|
||
| InsurancePolicyCode | varchar | 15 | null |
|
|
|||
| InsuranceValue | money | 21,4 | null |
|
|
|||
| InsuranceValuedDate | datetime | 16,3 | √ | null |
|
|
||
| MasterObjectFlag | bit | 1 | null |
|
|
|||
| ObjectTypesSeq | int | 4 | null |
|
|
|||
| DefaultChildObjectTypesSeq | int | 4 | √ | null |
|
|
||
| InsurancePoliciesSeq | int | 4 | √ | null |
|
|
||
| ActiveFlag | bit | 1 | null |
|
|
|||
| ObjectAccommodationLinkedID | int | 4 | √ | null |
|
|
||
| ObjectAccommodationAccommodationTypeCode | varchar | 15 | √ | null |
|
|
||
| ObjectAccommodationRoomTypeCode | varchar | 15 | √ | null |
|
|
||
| ObjectAccommodationMealsAvailableFlag | bit | 1 | √ | null |
|
|
||
| ObjectAccommodationCapacity | int | 4 | √ | null |
|
|
||
| ObjectAccommodationAvailableDateFrom | datetime | 16,3 | √ | null |
|
|
||
| ObjectAccommodationAvailableDateTo | datetime | 16,3 | √ | null |
|
|
||
| ObjectAccommodationFacilities | varchar | 1000 | √ | null |
|
|
||
| ObjectAccommodationApprovedDate | datetime | 16,3 | √ | null |
|
|
||
| ObjectAccommodationApprovedUnder18Flag | bit | 1 | √ | null |
|
|
||
| ObjectAccommodationApprovedFemaleFlag | bit | 1 | √ | null |
|
|
||
| ObjectAccommodationDistanceFromSchool | smallint | 2 | √ | null |
|
|
||
| ObjectAccommodationPermissionToCheckFlag | bit | 1 | √ | null |
|
|
||
| ObjectAccommodationWelfareApprovedFlag | bit | 1 | √ | null |
|
|
||
| ObjectAccommodationAgentID | int | 4 | √ | null |
|
|
||
| ObjectAccommodationStatusCode | varchar | 15 | √ | null |
|
|
||
| ObjectAccommodationReligionCode | varchar | 15 | √ | null |
|
|
||
| ObjectAccommodationComment | varchar | 2147483647 | √ | null |
|
|
||
| ObjectAccommodationRating | varchar | 15 | √ | null |
|
|
||
| ObjectTypeDescription | varchar | 50 | √ | null |
|
|
||
| ObjectLocation | varchar | 255 | √ | null |
|
|
||
| PhoneExtension | varchar | 15 | null |
|
|
Table contained 0 rows