Open jomariabejo opened 1 year ago
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 );
L_ID
BORROWER
BOOK
ISSUER
ISS_DATE
RECEIVER
RET_DATE
FINE_PAID
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 );