cross-datasource-mapping
Installation
SKILL.md
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 |
— |