clubID | name | location |
---|---|---|
1 | Sunshine Gardeners | New York |
2 | Green Thumbs Society | Los Angeles |
3 | Floral Friends | Chicago |
4 | Blossom Bunch | Miami |
5 | Nature Lovers | Dallas |
plantID | type | careInstructions |
---|---|---|
1 | Rose Bushes | Water regularly, prune dead leaves. |
2 | Tomatoes | Keep well-watered but not overly saturated, provide ample sunlight. |
3 | Pansies | Easy to grow, requires full sun and moist soil. |
4 | Tulips | Prefer cool weather, plant bulbs in fall for spring blooms. |
5 | Lavender | Needs well-draining soil, avoid overwatering. |
gardeningClubID | plantID |
---|---|
(→ Gardening_Clubs.clubID) | (→ Plants.plantID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
memberID | firstName | lastName |
---|---|---|
1 | John | Smith |
2 | Jane | Doe |
3 | Alice | Brown |
4 | Bob | White |
5 | Emma | Black |
eventID | title | description | date |
---|---|---|---|
1 | Spring Planting Party | Celebrate the beginning of Spring! | 2021-03-20 |
2 | Summer Bloom Festival | Show off your garden's best blooms. | 2021-07-10 |
3 | Autumn Leaf Raking | Get ready for winter by raking leaves. | 2021-10-01 |
4 | Winter Pruning Workshop | Learn how to properly prune plants for next year. | 2021-12-12 |
5 | Annual Seed Swap | Exchange seeds and gardening tips with fellow members. | 2022-02-20 |