This content has been marked as final.
Show 1 reply
-
1. Re: What is the table structure for booking table in JBOSS b
jeya.louis Jan 13, 2007 4:54 AM (in response to jeya.louis)Problem solved, The table structure is
CREATE TABLE BOOKING
(
ID INTEGER NOT NULL,
USER_USERNAME VARCHAR2(255 BYTE),
HOTEL_ID INTEGER NOT NULL,
CHECKINDATE DATE,
CHECKOUTDATE DATE,
CREDITCARD VARCHAR2(255 BYTE) NOT NULL,
CREDITCARDNAME VARCHAR2(255 BYTE) NOT NULL,
CREDITCARDEXPIRYMONTH NUMBER,
CREDITCARDEXPIRYYEAR NUMBER,
SMOKING CHAR(1 BYTE),
BEDS INTEGER
)