loan

Table 5. loan

ColumnTypeNot NULLKeyPrimary keyDefaultFrom
idINTX X Loan
id0_personINTX   Loan
id1_bookINTX   Loan
startdateDATEX  '2001-01-01'Loan
enddateDATE    Loan
durationCHAR(1)X   Loan