DATA_MODEL.md

Data Model for Gridwalk

This is the data model used for the Gridwalk application. Currently, only DynamoDB is supported, with plans to add support for other databases in the future.

DynamoDB (Single Table)

PK	SK	Attributes	GSIs
USER#<user_id>	USER#<user_id>	user_name created_at primary_email
EMAIL#<email_address>	EMAIL#<email_address>	user_id
WSP#<workspace_id>	WSP#<workspace_id>	workspace_name workspace_owner created_at	GSI_WORKSPACE_BY_NAME workspace_name: <workspace_name>
WSP#<workspace_id>	USER#<user_id>	user_role joined_at user_id	GSI_USER_ID user_id: <user_id>
WSP#<workspace_id>	CON#<connection_id>	name connector_type created_by pg_host pg_port pg_db pg_username pg_password
WSP#<workspace_id>	LAYER#<layer_name>	name connection_id uploaded_by created_at
WSP#<workspace_id>	PROJ#<project_id>	name owner created_at
SESSION#<session_id>	SESSION#<session_id>	user_id created_at	GSI_USER user_id: <user_id>