I created a db table named LOAN and I encountered error after executing this query.
CREATE TABLE LOAN
(
L_ID INTEGER not null PRIMARY KEY,
BORROWER INTEGER not null,
BOOK INTEGER not null,
ISSUER INTEGER not null,
ISS_DATE TIMESTAMP not null,
RECEIVER INTEGER ,
RET_DATE TIMESTAMP ,
FINE_PAID BOOLEAN
);
I created a db table named LOAN and I encountered error after executing this query.
CREATE TABLE LOAN
(
L_IDINTEGER not null PRIMARY KEY,BORROWERINTEGER not null,BOOKINTEGER not null,ISSUERINTEGER not null,ISS_DATETIMESTAMP not null,RECEIVERINTEGER ,RET_DATETIMESTAMP ,FINE_PAIDBOOLEAN);