diff options
| author | mo khan <mo@mokhan.ca> | 2017-01-26 09:56:50 -0700 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2017-01-26 09:56:50 -0700 |
| commit | 9fa05b16245358581ed85ac1c308c6ce2cee6e0a (patch) | |
| tree | fe6235af51b76d69e18e218067281d9449a9babf /README.md | |
| parent | 8ec14688124a4e3f65d916301f6994a26cfc324a (diff) | |
parallize seed data insertion.
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/README.md b/README.md new file mode 100644 index 0000000..9a3d879 --- /dev/null +++ b/README.md @@ -0,0 +1,17 @@ +# Schema + +| BUSINESSES | | COMPUTERS | | EVENTS | | +| id | int | id | int | id | int | +| name | varchar(255) | active | tinyint | computer_id | int | +| business_relationship_id | int | business_id | int | occurred_at | datetime | +| | | | | type | varchar(255) | +| | | | | data | text | + +# Lessons + +1. Which businesses have more than N computers? +2. Which computer had the most events in a single day? +3. What are the top 10 most active computers (day, week, month)? .i.e emits the most events. +4. Which businesses have at least one computer? +5. Which businesses have zero computers? +6. Do we have any computers that belong to a business that doesn't exist? |