cross-datasource-mapping
Cross-Datasource Mapping
This skill documents how the same entities map across the three datasources: Notion API, NotionArchive (MSSQL), and StonePro (Firebird).
Entity: Job / Production Order
| Field | Notion (Production DB) | NotionArchive MSSQL | StonePro Firebird |
|---|---|---|---|
| Primary key | Page UUID | notion_jobs.id (int) |
DOC_HEADER.DOC_ID |
| Notion ID | Page UUID | notion_page_id |
— |
| Job number | Job (title) |
job_number |
DOC_NUMBER |
| Job name | Job Name (rich_text) |
job_name |
(derived from CUSTOMER_NAME + SITE_ADDRESS) |
| Status | Status (status) |
status |
DOC_STATUS (int code) |
| Install date | Install Date (formula → Install relation) |
install_date (ISO string) |
DUE_DATE |
| Customer | Relation → Customers DB | customer_name (denorm) |
CUSTOMER_ID FK |
| Stone colour | Relation → Stone Colours DB | stone_colour (denorm) |
COLOUR |
| Suburb | Rich text property | suburb |
SUBURB |
| Folder path | Folder in O: Drive (rich_text) |
folder_path |
— |
More from ds-codi/project-memory-mcp
pyside6-mvc
Use this skill when building Python desktop applications using PySide6 with strict MVC architecture where all UI is defined by .ui files. Covers architecture patterns, controller/model/view separation, signal handling, and .ui file workflows.
95pyside6-qml-views
Use this skill when creating QML view files, designing QML component hierarchies, building layouts, styling QML controls, creating reusable QML components, implementing QML navigation / page switching, or working with QML resources. Covers QML file structure, component patterns, Material/Controls styling, resource management, and common QML idioms for desktop applications.
49pyside6-qml-architecture
Use this skill when creating a new PySide6 + QML desktop application with MVC architecture, setting up project structure, implementing the application bootstrap / DI container, or understanding how the MVC layers connect. Covers project scaffolding, entry points, singleton application class, service locator, signal registry, and lifecycle management.
47mvc-architecture
Use this skill when implementing Model-View-Controller architecture. Covers core MVC principles, layer separation, dependency injection, event-driven communication, and patterns for controllers, models, and views.
40pyside6-qml-models-services
Use this skill when creating domain models with Qt signal support, implementing the repository pattern for data persistence, building service classes for external interactions, designing the central signal registry, or working with application state management. Covers BaseModel, model serialization, database repositories, service patterns, signal definitions, and the ApplicationState singleton.
34pyside6-qml-bridge
Use this skill when exposing Python objects to QML, creating bridge classes, defining Qt properties with NOTIFY signals, implementing invokable methods / slots, or connecting QML user actions to Python controllers. Covers the QObject bridge pattern, property decorators, type conversions, context properties, and QML type registration.
32