Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ObjectLoansSeq | int | 4 | null |
|
|
|||
| ObjectBookingsSeq | int | 4 | null |
|
|
|||
| ObjectNumber | int | 4 | null |
|
|
|||
| ObjectDescription | varchar | 50 | √ | null |
|
|
||
| ObjectDescriptionFull | varchar | 100 | √ | null |
|
|
||
| ObjectTypesSeq | varchar | 15 | √ | null |
|
|
||
| ObjectTypeDescription | varchar | 50 | √ | null |
|
|
||
| ObjectTypeCategoryCode | varchar | 15 | √ | null |
|
|
||
| ObjectModel | varchar | 50 | √ | null |
|
|
||
| ObjectSerial | varchar | 50 | √ | null |
|
|
||
| ObjectAcquiredDate | datetime | 16,3 | √ | null |
|
|
||
| ObjectBarCode | varchar | 20 | √ | null |
|
|
||
| ObjectQuantity | int | 4 | √ | null |
|
|
||
| ObjectRoom | varchar | 15 | √ | null |
|
|
||
| ObjectAssetNumber | int | 4 | √ | null |
|
|
||
| ObjectAssetSynDatabaseCode | varchar | 5 | √ | null |
|
|
||
| ObjectOwnershipType | varchar | 15 | √ | null |
|
|
||
| ObjectStatus | varchar | 15 | √ | null |
|
|
||
| ObjectResponsibleID | int | 4 | √ | null |
|
|
||
| ObjectInsurancePoliciesSeq | int | 4 | √ | null |
|
|
||
| ObjectInsuranceValue | money | 21,4 | √ | null |
|
|
||
| ObjectInsuranceValuedDate | datetime | 16,3 | √ | null |
|
|
||
| ObjectMasterObjectFlag | bit | 1 | √ | null |
|
|
||
| LoanedToID | int | 4 | √ | null |
|
|
||
| LoanedToStudentName | varchar | 221 | √ | null |
|
|
||
| LoanedToName | varchar | 221 | √ | null |
|
|
||
| LoanedToMailNamePrimary | varchar | 100 | √ | null |
|
|
||
| LonedToNameInternal | varchar | 100 | √ | null |
|
|
||
| LoanedToNameExternal | varchar | 100 | √ | null |
|
|
||
| LoanedToSurname | varchar | 30 | √ | null |
|
|
||
| LoanedToPreferred | varchar | 20 | √ | null |
|
|
||
| LoanedDate | datetime | 16,3 | √ | null |
|
|
||
| ReturnedDate | datetime | 16,3 | √ | null |
|
|
||
| Comment | varchar | 255 | null |
|
|
|||
| IssuedByID | int | 4 | √ | null |
|
|
||
| ReturnedToID | int | 4 | √ | null |
|
|
||
| BookingCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| BookingCreatedBy | varchar | 50 | √ | null |
|
|
||
| BookingObjectNumber | int | 4 | √ | null |
|
|
||
| BookingBookedByID | int | 4 | √ | null |
|
|
||
| BookingBorrowerID | int | 4 | √ | null |
|
|
||
| BookingQuantity | int | 4 | √ | null |
|
|
||
| BookingDateFrom | datetime | 16,3 | √ | null |
|
|
||
| BookingDateTo | datetime | 16,3 | √ | null |
|
|
||
| BookingDateToEffective | datetime | 16,3 | √ | null |
|
|
||
| BookingComment | varchar | 255 | √ | null |
|
|
||
| BookingFileSemestersSeqFrom | int | 4 | √ | null |
|
|
||
| BookingFileSemestersSeqTo | int | 4 | √ | null |
|
|
||
| PhoneExtension | varchar | 15 | √ | null |
|
|
Table contained 0 rows