Skip to content

Instantly share code, notes, and snippets.

@jdecode

jdecode/geartable-db-design.md

Last active September 26, 2020 22:53
Show Gist options
  • Save jdecode/e17653e47a56c537afac612765287f91 to your computer and use it in GitHub Desktop.
Save jdecode/e17653e47a56c537afac612765287f91 to your computer and use it in GitHub Desktop.
Download ZIP
Geartable DB design
Raw
geartable-db-design.md

This gist is to jump to the DB designing (without explaining the "Why/How DynamoDB" part).

  1. ERD - Entity Relation Diagram
  2. Define the Access Patterns
  3. Design PK/SK
@jdecode
Copy link
Author

jdecode commented Sep 26, 2020 •
edited
Loading

NoSQL Workbench screenshot of the table

Screenshot from 2020-09-27 04-05-14

Other columns except PK/SK are set for Users only, for now.

Meta info of Sheets and APIs would be saved during run-time

@jdecode
Copy link
Author

jdecode commented Sep 26, 2020

I believe this is where I must stop from DB POV.

Moving on the the UI aspect in another gist (Tailwind + CakePHP).

For UX, Vue will be brought in, soon.

@jdecode
Copy link
Author

jdecode commented Sep 26, 2020 •
edited
Loading

Exported data model (as JSON) from NoSQL Workbench for DynamoDB

https://gist.githubusercontent.com/jdecode/d8249ec9516b9c7f7080c333ebcd3a21/raw/3b8e2d1c667971547de1fe48db07c32808157985/geartable-db-model-nosql-workbench.json

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment