rckrdmrd/erp-core-database
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
erp-core-database/ddl
History
rckrdmrd 57f41859de [PROJECTS] feat: Add timesheets DDL schema 
Add complete projects schema with timesheets support:
- projects.projects table with status, privacy settings
- projects.tasks table with Kanban support
- projects.timesheets table for Odoo-style time tracking
- projects.milestones table for project milestones
- projects.project_stages table for Kanban columns
- projects.project_members table for team management

Includes all necessary indexes and enums for performance.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-20 04:27:58 -06:00
..
01-auth-profiles.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
02-auth-devices.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
03-core-branches.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
04-mobile.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
05-billing-usage.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
06-auth-extended.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
07-users-rbac.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
08-plans.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
09-notifications.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
10-audit.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
11-feature-flags.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
12-webhooks.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
13-storage.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
14-ai.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
15-whatsapp.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
16-partners.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
17-products.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
18-warehouses.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
20-core-catalogs.sql feat(catalogs): Add core catalogs DDL and seed data (MGN-005) 2026-01-18 08:57:41 -06:00
21-fiscal-catalogs.sql feat(fiscal): Add fiscal catalogs DDL schema (MGN-005) 2026-01-18 09:31:36 -06:00
21-inventory.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
22-sales.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
23-purchases.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
24-invoices.sql refactor: Restructure DDL with numbered schema files 2026-01-16 00:40:32 -06:00
46-purchases-matching.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
50-financial-schema.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
51-financial-accounts.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
52-financial-journals.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
53-financial-entries.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
54-financial-invoices.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
55-financial-payments.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
56-financial-taxes.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
57-financial-bank-reconciliation.sql [TASK-2026-01-20-003] feat: Add financial DDL and matching tables 2026-01-20 03:47:04 -06:00
60-projects-timesheets.sql [PROJECTS] feat: Add timesheets DDL schema 2026-01-20 04:27:58 -06:00