
TRUNCATE TABLE appointment CASCADE;
TRUNCATE TABLE inquiry CASCADE;
TRUNCATE TABLE timeslot CASCADE;
TRUNCATE TABLE client CASCADE;
TRUNCATE TABLE unit CASCADE;
TRUNCATE TABLE floor CASCADE;
TRUNCATE TABLE designs CASCADE;
TRUNCATE TABLE building CASCADE;
TRUNCATE TABLE architect CASCADE;

INSERT INTO architect (full_name) VALUES
('Stefan'),
('Aleksandar');

INSERT INTO designs (architect_id, building_id) VALUES
((SELECT architect_id FROM architect WHERE full_name = 'Stefan'), (SELECT building_id FROM building WHERE name = 'Golden Tower')),
((SELECT architect_id FROM architect WHERE full_name = 'Aleksandar'), (SELECT building_id FROM building WHERE name = 'Azure Block')),
((SELECT architect_id FROM architect WHERE full_name = 'Stefan'), (SELECT building_id FROM building WHERE name = 'City Wall'));

INSERT INTO client (name, email, phone) VALUES
('Marko', 'marko@gmail.com', '+389 73 123 456'),
('Ana', 'ana@yahoo.com', '+389 73 234 567'),
('Ivan', 'ivan@hotmail.com', '+389 73 345 678'),
('Elena', 'elena@gmail.com', '+389 73 456 789'),
('Darko', 'darko@gmail.com', '+389 73 567 890');
