Document both views. State the grain in one sentence, identify the keys, and list the measures (the columns you can aggregate). Replace every TODO.
- Grain: TODO (one sentence, e.g. "One row per ...")
- Primary key: TODO
- Foreign keys: TODO
- Measures: TODO (columns you would SUM or AVG)
- Grain: TODO
- Primary key: TODO
- Foreign keys: TODO (or "none")
- Measures: TODO (or "none, descriptive attributes only")