--OWNER TABLE				--3
create table owner
(owner_num SMALLINT PRIMARY KEY NOT NULL,
first_name VARCHAR(20),
last_name VARCHAR(20),
street VARCHAR(30),
city_town VARCHAR(20),
postcode VARCHAR(4),
phone_num VARCHAR(20));


--PROPERTY TABLE			--4
create table property_
(property_num SMALLINT PRIMARY KEY NOT NULL,
staff_no INT,
street_no VARCHAR(15),
street VARCHAR(30),
postcode VARCHAR(4),
property_type VARCHAR(30),
no_of_bedrooms TINYINT,
no_of_bathrooms TINYINT,
property_state VARCHAR(20),
tenant_limit Int,
owner_num SMALLINT,
CONSTRAINT staff FOREIGN KEY (staff_no) REFERENCES real_estate_agent(staff_num),
CONSTRAINT ownern FOREIGN KEY (owner_num) REFERENCES owner(owner_num));