BrianMehrman · October 12, 2021 18:05
diff --git a/Data Modeling Exercise b/Data Modeling Exercise
 **Patreon**(http://www.patreon.com/) is a service that connects **patrons** with **creators**. A creator promises to produce creations; these could be videos, songs, podcast episodes, comics, or anything else that can be delivered digitally.

 Each patron is automatically a creator if they create a **creator's** **page**. A creator charges patrons **per creation** or **per month** (of creations). A creator creates **posts** for their page (think "blog").  A post has content (displayed in a feed of posts); some posts have a creation that needs to be billed.

 The creator also establishes **reward** **tiers** for their page (e.g., $1 per whatever, $5 per whatever, $25 per whatever). A patron chooses a tier *and* an amount for their pledge; they must pledge as much or *more* than their reward tier.  A post is either public or linked to a reward tier. The content of public posts can be seen by everyone, even visitors not logged in; the content of posts tied to a reward tier can be seen by a patron at that tier or higher.

 *The reward tier is a separate feature from the creations*. Every patron is charged for each creation, so a creator is encouraged to post a creation on the lowest tier.

 Patrons are billed on the 1st of each month for the previous month's creations. A history of collected pledges must be maintained.
	Patreon(http://www.patreon.com/) is a service that connects patrons with creators. A creator promises to produce creations; these could be videos, songs, podcast episodes, comics, or anything else that can be delivered digitally.

	Each patron is automatically a creator if they create a creator's page. A creator charges patrons per creation or per month (of creations). A creator creates posts for their page (think "blog"). A post has content (displayed in a feed of posts); some posts have a creation that needs to be billed.

	The creator also establishes reward tiers for their page (e.g., $1 per whatever, $5 per whatever, $25 per whatever). A patron chooses a tier and an amount for their pledge; they must pledge as much or more than their reward tier. A post is either public or linked to a reward tier. The content of public posts can be seen by everyone, even visitors not logged in; the content of posts tied to a reward tier can be seen by a patron at that tier or higher.

	The reward tier is a separate feature from the creations. Every patron is charged for each creation, so a creator is encouraged to post a creation on the lowest tier.

	Patrons are billed on the 1st of each month for the previous month's creations. A history of collected pledges must be maintained.