| 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 |