## Gardening_Clubs

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

## Plants

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.

## Gardening_Clubs_Plants

gardeningClubID | plantID
--- | ---
(→ Gardening_Clubs.clubID) | (→ Plants.plantID)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1

## Members

memberID | firstName | lastName
--- | --- | ---
1 | John | Smith
2 | Jane | Doe
3 | Alice | Brown
4 | Bob | White
5 | Emma | Black

## Events

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