Linking Tables

Tasks
UNIT ID
	
DESCRIPTION
	
PRIORITY
	
START_DATE
	
END_DATE
	
STATUS

	
Unit 10
	
Basement cleaning
	
LOW
	
09/15/2023
	
09/17/2023
	
NOT STARTED

	
Unit 9
	
Check water heater
	
MEDIUM
	
09/12/2023
	
09/13/2023
	
COMPLETED

	
Unit 8
	
Fix gate latch
	
LOW
	
09/11/2023
	
---
	
SCHEDULED

	
Unit 8
	
Pest control
	
MEDIUM
	
09/15/2023
	
09/17/2023
	
NOT STARTED

	
Unit 8
	
Clean vents
	
LOW
	
09/12/2023
	
09/13/2023
	
COMPLETED

	
Unit 7
	
Check electrical outlets
	
LOW
	
09/14/2023
	
---
	
SCHEDULED

	
Unit 7
	
Replace kitchen faucet
	
MEDIUM
	
09/10/2023
	
09/12/2023
	
COMPLETED

	
Unit 5
	
Exterior painting
	
HIGH
	
09/15/2023
	
09/20/2023
	
SCHEDULED

	
Unit 5
	
Inspect plumbing
	
MEDIUM
	
09/13/2023
	
09/14/2023
	
IN PROGRESS

	
Unit 5
	
Replace smoke detector batteries
	
LOW
	
09/11/2023
	
---
	
SCHEDULED


12
20 items
Refresh automatically

Tasks 2 · Property Management

Columns parent
Units
Units
UNIT NUMBER
	
PROPERTY_ID
	
BEDROOMS
	
BATHROOMS
	
FURNISHED
	
ACCESS TO POOL

	
Unit 10
	
Redwood Cottages
	
2
	
1
	
	

	
Unit 9
	
Spruce Mansion
	
3
	
2
	
	

	
Unit 9
	
Spruce Mansion
	
2
	
2
	
	

	
Unit 9
	
Spruce Mansion
	
3
	
1
	
	

	
Unit 8
	
Maple Suites
	
1
	
1
	
	

	
Unit 8
	
Maple Suites
	
4
	
4
	
	

	
Unit 7
	
Fir Estates
	
2
	
1
	
	

	
Unit 6
	
Cedar Lofts
	
3
	
2
	
	

	
Unit 5
	
Birch Residences
	
4
	
2
	
	

	
Unit 5
	
Birch Residences
	
2
	
2
	
	


12
20 items
Refresh automatically