BONSAMURAIS / BONSAMURAIS/schema

Add correspondence table(s)

Open
#17 2 comments 0 reactions 0 assignees View on GitHub
design help wanted
Dominant language
PLpgSQL
Stars
0
Forks
1
PR merge metrics
No merged PRs in 30d

Description

Bonsai policy is to store data on its "native" scale, which means we need correspondence from one set to another. Traditionally, we would have 1 to 1 and 1 to N, but maybe it also makes sense to have approximate 1 to 1 matches, and to distinguish 1 to 1 that is official versus matches made by Bonsai team members.

@mfastudillo You know this as well as anyone, want to suggest something? We would need a table name and the names and data types of the columns, plus values to be added whenever we want to limit choices to a select few ([enumerated types](https://www.postgresql.org/docs/12/datatype-enum.html)).

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reading the issue discussion and the linked PostgreSQL enumerated-types documentation. Clarify whether correspondence includes 1-to-1, 1-to-N, approximate, and official mappings, then propose table names, column data types, and any constrained values. Done means the schema design and allowed values are agreed.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.