Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ObjectLoansSeq | int | 4 | null |
|
|
|||
| ObjectBookingsSeq | int | 4 | null |
|
|
|||
| ObjectNumber | int | 4 | null |
|
|
|||
| Description | varchar | 100 | √ | null |
|
|
||
| ObjectTypesSeq | varchar | 15 | √ | null |
|
|
||
| Barcode | varchar | 20 | null |
|
|
|||
| MasterBarcode | varchar | 20 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
||
| LoanedToName | varchar | 120 | √ | null |
|
|
||
| StudentLoanFlag | bit | 1 | √ | null |
|
|
||
| LoanedDate | datetime | 16,3 | √ | null |
|
|
||
| ReturnedDate | datetime | 16,3 | √ | null |
|
|
||
| Comment | varchar | 255 | null |
|
|
|||
| IssuedByID | int | 4 | √ | null |
|
|
||
| IssuedByName | varchar | 100 | √ | null |
|
|
||
| ReturnedToID | int | 4 | √ | null |
|
|
||
| ReturnedToName | varchar | 100 | √ | 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 |
|
|
||
| BookingComment | varchar | 255 | √ | null |
|
|
||
| BookingFileSemestersSeqFrom | int | 4 | √ | null |
|
|
||
| BookingFileSemestersSeqTo | int | 4 | √ | null |
|
|
||
| LoanedToNameInternal | varchar | 100 | √ | null |
|
|
||
| LoanedToNameExternal | varchar | 100 | √ | null |
|
|
||
| LoanedToLegalFullName | varchar | 150 | √ | null |
|
|
||
| LoanedToSurname | varchar | 30 | √ | null |
|
|
||
| LoanedToPreferred | varchar | 20 | √ | null |
|
|
||
| LoanedToPreferredFormal | varchar | 20 | √ | null |
|
|
||
| LoanedToGiven1 | varchar | 20 | √ | null |
|
|
||
| OverdueFlag | bit | 1 | √ | null |
|
|
||
| PhoneExtension | varchar | 15 | null |
|
|
|||
| ProcessOverdueChargeFlag | bit | 1 | null |
|
|
|||
| ProcessOverdueReversalFlag | bit | 1 | null |
|
|
Table contained 0 rows