28:null 29:["$","title",null,{"children":"Data Dictionary Template | dduyg | Observable"}] 2e:T593,

${Inputs.button("📥 Export CSV", { reduce: () => { let csv = 'Source System,Schema Name,Table Name,Field Name,Data Type,Length,Nullable,Primary Key,Foreign Key,Default Value,Description,Business Rule,Sample Values,Transformation Logic\n'; tables.forEach(table => { table.fields.forEach(field => { csv += `"${table.sourceSystem}","${table.schemaName}","${table.tableName}","${field.fieldName}","${field.dataType}","${field.length}","${field.nullable}","${field.primaryKey}","${field.foreignKey}","${field.defaultValue}","${field.description}","${field.businessRule}","${field.sampleValues}","${field.transformationLogic}"\n`; }); }); const blob = new Blob([csv], { type: 'text/csv' }); const url = URL.createObjectURL(blob); const a = document.createElement('a'); a.href = url; a.download = 'data_dictionary.csv'; a.click(); } })} ${Inputs.button("📥 Export JSON", { reduce: () => { const dataStr = JSON.stringify(tables, null, 2); const blob = new Blob([dataStr], { type: 'application/json' }); const url = URL.createObjectURL(blob); const a = document.createElement('a'); a.href = url; a.download = 'data_dictionary.json'; a.click(); } })}

2f:T2df5,{ const container = html`

`; function render() { container.innerHTML = ""; filteredTables.forEach((table, tIndex) => { const tableDiv = html`

              Source System
              
              Schema Name
              
              Table Name
              
                Fields (${
                  table.fields.length
                })
              
            ${
              table.fields.length === 0
                ? `
                   No fields defined. Click "Add Field" to get started.
                 
`
                : `
                  
                        ${[
                          "Field Name",
                          "Data Type",
                          "Length",
                          "Nullable",
                          "PK",
                          "FK",
                          "Default",
                          "Description",
                          "Business Rule",
                          "Sample Values",
                          "Transformation",
                          "Actions"
                        ]
                          .map(
                            (h) =>
                              ``
                          )
                          .join("")}
                      
                      ${table.fields
                        .map(
                          (field, fIndex) => `
                        
                      `
                        )
                        .join("")}
                    
                    ${h}

`
            }

`; container.appendChild(tableDiv); }); // --- EVENTS --- // Update inputs container.querySelectorAll("[data-field]").forEach((el) => { const tIdx = +el.dataset.table; const key = el.dataset.field; el.addEventListener("input", (e) => { const newTables = [...tables]; newTables[tIdx][key] = e.target.value; mutable tables = newTables; }); }); // Add field container.querySelectorAll('[data-action="addField"]').forEach((btn) => { const tIdx = +btn.dataset.table; btn.addEventListener("click", () => { const newTables = [...tables]; newTables[tIdx].fields.push({ id: Date.now(), fieldName: "", dataType: "", length: "", nullable: "YES", primaryKey: "NO", foreignKey: "", defaultValue: "", description: "", businessRule: "", sampleValues: "", transformationLogic: "" }); mutable tables = newTables; }); }); // Delete field container.querySelectorAll('[data-action="deleteField"]').forEach((btn) => { const tIdx = +btn.dataset.table; const fIdx = +btn.dataset.fieldIndex; btn.addEventListener("click", () => { const newTables = [...tables]; newTables[tIdx].fields.splice(fIdx, 1); mutable tables = newTables; }); }); // ✅ Delete table (the real fix) container.querySelectorAll('[data-action="deleteTable"]').forEach((btn) => { const tIdx = +btn.dataset.table; btn.addEventListener("click", () => { if (confirm("Delete this table?")) { mutable tables = tables.filter((_, i) => i !== tIdx); } }); }); } render(); return container; }30:Ta39, --- Data dictionary template used for curating a data model or data mart. Add all source system schema records for final review and handoff. This is meant for completeness, must be derivative from the source data system and used for any downstream data lineage management. ## Metadata

Attribute	Description
Source System	The origin system of the data (e.g., CRM_PROD).
Schema Name	Logical schema in the source system.
Table Name	Name of the table.
Fields	List of fields in the table.
Field Name	Name of the field/column.
Data Type	Data type (e.g., INTEGER, VARCHAR, DATE).
Length	Maximum length (if applicable).
Nullable	YES/NO – indicates if NULL values are allowed.
Primary Key	YES/NO – indicates if this field is a primary key.
Foreign Key	Reference to another table.field if applicable.
Default Value	Default value for the field.
Description	Short explanation of the field purpose.
Business Rule	Rules or logic associated with the field.
Sample Values	Example values for reference.
Transformation Logic	Any transformations applied from source data.

31:[] 2c:{"id":"825d8aab9d36f91a","slug":"data-dictionary","title":"Data Dictionary Template","thumbnail":"25cb39f0324479e78703d080c5585b737e5f1273851ad3733628f7c9337d419a","access_level":"public","create_time":"$D2025-10-28T19:30:22.735Z","update_time":"$D2025-11-18T22:11:07.236Z","view_time":null,"first_public_time":"$D2025-10-28T19:30:22.735Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1fa0c77b14fd90d0","login":"dduyg","name":"","avatar_url":"https://avatars-next.observableusercontent.com/8922701a2d973be0158565df96ce0b2fe9ffd55df053350d59973a811bac06af","tier":"starter_2024"},"version":136,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"248f116c85e550e3","login":"dduyg","name":"Duygu Dağdelen","avatar_url":"https://avatars-next.observableusercontent.com/ca098eb30fb37c129368c39d70e98a9a8444cfaa7496c72781905ac410af8cad","tier":null}],"members":[{"type":"individual","id":"248f116c85e550e3","login":"dduyg","name":"Duygu Dağdelen","avatar_url":"https://avatars-next.observableusercontent.com/ca098eb30fb37c129368c39d70e98a9a8444cfaa7496c72781905ac410af8cad","tier":null,"role":"editor"},{"type":"team","id":"1fa0c77b14fd90d0","login":"dduyg","name":"","avatar_url":"https://avatars-next.observableusercontent.com/8922701a2d973be0158565df96ce0b2fe9ffd55df053350d59973a811bac06af","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Data Dictionary Template","cells":[{"id":0,"value":"# Data Dictionary Template \n \nSource system schema documentation for data lineage and governance\n\n\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"### 🎛️ Controls","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"viewof searchTerm = Inputs.text({\n placeholder: \"Search tables or fields...\",\n label: \"Search\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"viewof filterSystem = Inputs.select(\n [\n \"All Source Systems\",\n ...new Set(tables.map((t) => t.sourceSystem).filter(Boolean))\n ],\n {\n label: \"Filter by Source System\",\n value: \"All Source Systems\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"viewof addTableTrigger = Inputs.button(\"➕ Add Table\", {\n reduce: () => {\n const newTable = {\n id: Date.now(),\n tableName: \"\",\n schemaName: \"\",\n sourceSystem: \"\",\n fields: []\n };\n mutable tables = [...tables, newTable];\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"$2e","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":24,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"### 📊 Data Tables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"mutable tables = [\n {\n id: 1,\n tableName: \"customer\",\n schemaName: \"sales\",\n sourceSystem: \"CRM_PROD\",\n fields: [\n {\n id: 1,\n fieldName: \"customer_id\",\n dataType: \"INTEGER\",\n length: \"\",\n nullable: \"NO\",\n primaryKey: \"YES\",\n foreignKey: \"\",\n defaultValue: \"\",\n description: \"Unique identifier for customer\",\n businessRule: \"Auto-generated sequence\",\n sampleValues: \"1001, 1002, 1003\",\n transformationLogic: \"Direct mapping from source\"\n }\n ]\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"filteredTables = tables.filter((table) => {\n const matchesSearch =\n searchTerm === \"\" ||\n table.tableName.toLowerCase().includes(searchTerm.toLowerCase()) ||\n table.schemaName.toLowerCase().includes(searchTerm.toLowerCase()) ||\n table.fields.some((f) =>\n f.fieldName.toLowerCase().includes(searchTerm.toLowerCase())\n );\n\n const matchesFilter =\n filterSystem === \"All Source Systems\" ||\n table.sourceSystem === filterSystem;\n\n return matchesSearch && matchesFilter;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"{\n if (filteredTables.length === 0) {\n return html`

No tables found. Add a table to get started.

`;\n }\n return html`

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"$30","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2d:"$2c:body"

Fields (${ table.fields.length })