id | method_name | description |
---|---|---|
1 | Landfill | Disposing of waste by burying it in a designated area. |
2 | Incineration | Burning waste to reduce its volume and kill pathogens. |
3 | Recycling | Processing waste materials to create new products. |
4 | Composting | Breaking down organic matter into nutrient-rich humus. |
5 | Biodegradable Waste | Organic waste that can be broken down by microorganisms. |
id | program_name | description |
---|---|---|
1 | Community Recycling Program | A local initiative to encourage recycling among residents. |
2 | Corporate Recycling Program | An initiative by companies to recycle their waste. |
3 | Electronic Waste Recycling | A specialized program to recycle electronic devices. |
4 | Hazardous Waste Recycling | A program to handle and recycle hazardous waste. |
5 | Construction Materials Recycling | A program focused on recycling construction materials. |
id | material_type | quantity |
---|---|---|
1 | Concrete | 100.0 |
2 | Steel | 200.0 |
3 | Bricks | 300.0 |
4 | Glass | 400.0 |
5 | Aluminum | 500.0 |
site_id | site_name | location | waste_disposal_method_id | recycling_program_id |
---|---|---|---|---|
(→ Waste_Disposal_Method.id) | (→ Recycling_Program.id) | |||
1 | Site A | New York City | 1 | 1 |
2 | Site B | Los Angeles | 2 | 2 |
3 | Site C | Chicago | 3 | 3 |
4 | Site D | Miami | 4 | 4 |
5 | Site E | Dallas | 5 | 5 |
site_material_id | construction_site_id | construction_material_id | amount |
---|---|---|---|
(→ Construction_Site.site_id) | (→ Construction_Material.id) | ||
1 | 1 | 1 | 50.0 |
2 | 1 | 2 | 75.0 |
3 | 2 | 3 | 60.0 |
4 | 2 | 4 | 80.0 |
5 | 3 | 5 | 90.0 |
disposed_waste_id | site_material_id | waste_disposal_method_id | disposal_date |
---|---|---|---|
(→ Site_Material.site_material_id) | (→ Waste_Disposal_Method.id) | ||
1 | 1 | 1 | 2022-01-01 |
2 | 1 | 1 | 2022-01-02 |
3 | 2 | 2 | 2022-01-03 |
4 | 2 | 2 | 2022-01-04 |
5 | 3 | 3 | 2022-01-05 |