gabogg/orinokia-mall-control
Watch
1
0
Fork
You've already forked orinokia-mall-control
 0
Code Issues 3 Pull requests 3 Projects Releases Packages Wiki Activity Actions

US-01: Database Schema and RLS Policies in Supabase (PostgreSQL) #1

New issue
Closed
opened 2026-09-23 17:42:50 +00:00 by gabogg · 2 comments
gabogg commented 2026-09-23 17:42:50 +00:00
Owner
Copy link

User Story

As a system developer and administrator, I need to create the and tables with unique indexes and Row Level Security (RLS) policies in PostgreSQL (Supabase) to ensure data persistence and integrity for daily shifts.

Acceptance Criteria

  • Table with columns: uid=1000(gabogg) gid=1001(gabogg) groups=1001(gabogg),10(wheel),18(dialout),100(users),968(docker),1000(autologin),1005(nintendo_switch) (UUID PK), (DATE), (TEXT CHECK ('DIURNO', 'NOCTURNO')), (JSONB), (JSONB), (JSONB), (JSONB), (JSONB), , and .
  • Unique index on to enable atomic upserts.
  • Index on for fast calendar queries.
  • Full RLS policies enabled for and roles (SELECT, INSERT, UPDATE, DELETE).
  • Table for master personnel catalog with status, experience, and weekly shift rotation.
  • SQL migration file tracked under .
## User Story As a system developer and administrator, I need to create the and tables with unique indexes and Row Level Security (RLS) policies in PostgreSQL (Supabase) to ensure data persistence and integrity for daily shifts. ## Acceptance Criteria - [ ] Table with columns: uid=1000(gabogg) gid=1001(gabogg) groups=1001(gabogg),10(wheel),18(dialout),100(users),968(docker),1000(autologin),1005(nintendo_switch) (UUID PK), (DATE), (TEXT CHECK ('DIURNO', 'NOCTURNO')), (JSONB), (JSONB), (JSONB), (JSONB), (JSONB), , and . - [ ] Unique index on to enable atomic upserts. - [ ] Index on for fast calendar queries. - [ ] Full RLS policies enabled for and roles (SELECT, INSERT, UPDATE, DELETE). - [ ] Table for master personnel catalog with status, experience, and weekly shift rotation. - [ ] SQL migration file tracked under .
gabogg changed title from US-01: Esquema de Base de Datos y Políticas RLS en Supabase (PostgreSQL) to US-01: Database Schema and RLS Policies in Supabase (PostgreSQL) 2026-09-23 17:46:04 +00:00
gabogg commented 2026-09-23 18:25:38 +00:00
Author
Owner
Copy link

Addressed in Pull Request #12: #12

Addressed in Pull Request #12: https://git.gaboggamer.online/gabogg/orinokia-mall-control/pulls/12
gabogg commented 2026-09-24 10:40:46 +00:00
Author
Owner
Copy link

Closed via merged PR #12.

Closed via merged PR #12.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
docs/system-workflow-and-views-guide
feat/us-10-us-11-scheduled-alerts-and-auto-roster
feat/us-09-official-report-generation-and-export
feat/us-07-us-08-autosave-and-audit-calendar
feat/us-03-us-04-domain-constants-and-sidebar
feat/us-01-us-02-supabase-persistence
feat/us-05-us-06-map-and-summary-cards
No results found.
Labels
Clear labels   
automation
Auto-save, audio alert, or automated scheduling

  
database
Database schema, migrations, and RLS

  
frontend
React components and UI interaction

  
mvp
Core feature required for MVP

  
needs-info
Waiting on reporter for more information

  
needs-triage
Maintainer needs to evaluate this issue

  
ready-for-agent
Fully specified, ready for an agent

  
ready-for-human
Requires human implementation

  
reporting
Attendance report generation, PDF, and sharing

  
wontfix
Will not be actioned

No labels
automation
database
frontend
mvp
needs-info
needs-triage
ready-for-agent
ready-for-human
reporting
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
gabogg/orinokia-mall-control#1
No description provided.