Skip to content

Instantly share code, notes, and snippets.

@jdecode
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.
Geartable DB design

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

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

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