Referencing tables: attachment_link | loan_sample | loan_specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| loan_number | varchar | ||
| date_start | date | ||
| date_end | date | ||
| type | int | list_loan_type | |
| project | varchar | ||
| borrower | int | agent | |
| borrower_institution | int | agent | |
| loaner | int | agent | |
| date_signed | date | ||
| delivery_method | int | list_loan_delivery_method | |
| deliverer | int | agent | |
| delivery_remarks | varchar | ||
| returned | tinyint | ||
| date_returned | date | ||
| special | varchar | ||
| remarks | text | ||
| database | int | database | |
| id | int(auto increment) | ||
| timestamp | datetime |