SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE reAddress (reAddressID number(8) PRIMARY KEY, country varchar2(20) NOT NULL, city varchar2(20) NOT NULL, area varchar2(300) NOT NULL); CREATE TABLE hAddress (hAddressID number(8) PRIMARY KEY, country varchar2(20) NOT NULL, city varchar2(20) NOT NULL, area varchar2(300) NOT NULL); CREATE TABLE client (clientID number(8) PRIMARY KEY, fname varchar2(300) NOT NULL, lname varchar2(300) NOT NULL, postcode number(5) NOT NULL, join_date date NOT NULL, username varchar2(250) NOT NULL, dateofbirth date NOT NULL, city varchar2(100) NOT NULL, mail varchar2(30) NOT NULL, phone varchar2(12) NOT NULL ); CREATE TABLE rEstate (rEstateID number(8) PRIMARY KEY, phone varchar2(12) NOT NULL, rEstate_name varchar2(20) NOT NULL, reAddressID varchar2(300) NOT NULL REFERENCES reAddress(reAddressID)); CREATE TABLE agent (agentID number(8) PRIMARY KEY, fname varchar(600) NOT NULL, lname varchar(300) NOT NULL, rEstateID number(8) NOT NULL REFERENCES rEstate(rEstateID), phone varchar2(12) NOT NULL); CREATE TABLE houses (houseID number(6) PRIMARY KEY, rEstateID number(8) NOT NULL REFERENCES rEstate(rEstateID), date_posted date NOT NULL, price number(8) NOT NULL, description varchar2(25) NOT NULL, size varchar2(5) NOT NULL, type varchar2(30) NOT NULL, hAddressID number(8) NOT NULL REFERENCES hAddress(hAddressID), msquare number(5) NOT NULL); CREATE TABLE booking (bookingID number(8) PRIMARY KEY, houseID number(6) NOT NULL REFERENCES Houses(houseID), rEstateID number(8) NOT NULL REFERENCES rEstate(reAddressID), clientID number(8) NOT NULL REFERENCES Client(clientID), booking_date date NOT NULL);