Claude-skill-registry airtable-model

PM Airtable data model reference. Use when creating tables, querying structure, or understanding relationships between Domain, Subdomain, Capability, Entity, Requirement, and BacklogItem tables.

install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/airtable-model" ~/.claude/skills/majiayu000-claude-skill-registry-airtable-model && rm -rf "$T"
manifest: skills/data/airtable-model/SKILL.md
source content

PM Airtable Data Model

Reference for Airtable tables used by PM plugins.

Entity Relationships

erDiagram
    Domain ||--o{ Subdomain : contains

    Subdomain ||--o{ Capability : contains
    Subdomain ||--o{ Entity : contains
    Subdomain ||--o{ Process : has
    Subdomain ||--o{ Glossary : has

    Entity ||--o{ Attribute : has
    Entity ||--o{ Relationship : from
    Entity ||--o{ Relationship : to

    Capability ||--o{ Requirement : has

    Requirement ||--o{ Rule : has
    Requirement ||--o{ OpenQuestion : has
    Requirement ||--o{ Test : inspires

    Rule ||--o{ Example : has

    TestSuite ||--o{ Test : contains
    TestSuite ||--o{ TestRun : executes

    Fact ||--o{ Insight : supports
    Insight ||--o{ Recommendation : leads-to
    Recommendation ||--o{ BacklogItem : becomes

    BacklogItem }o--o{ Requirement : links

Hierarchy

flowchart TD
    D[Domain] --> SD[Subdomain]
    SD --> C[Capability]
    SD --> E[Entity]
    SD --> P[Process]
    SD --> G[Glossary]

    E --> A[Attribute]
    E --> REL[Relationship]
    REL --> E

    C --> R[Requirement]
    R --> RU[Rule]
    R --> OQ[OpenQuestion]
    R -.-> T[Test]
    RU --> EX[Example]

    TS[TestSuite] --> T
    TS --> TR[TestRun]

    F[Fact] --> I[Insight]
    I --> REC[Recommendation]
    REC -.-> B[BacklogItem]

    B -.-> R

Tables Overview

TableLinks ToPurpose
Domain-Top-level areas
SubdomainDomainSub-areas, has 3-letter prefix
CapabilitySubdomainCategorizes requirements, has 3-letter prefix
EntitySubdomainDomain objects
AttributeEntityEntity properties
RelationshipEntity, EntityEntity-to-entity connections
ProcessSubdomainBusiness workflows
GlossarySubdomainUbiquitous language
RequirementCapabilityBDD requirements (MoSCoW), ReqID: SUB-CAP-NNN
RuleRequirementBusiness rules
ExampleRuleConcrete examples
OpenQuestionRequirementUnresolved questions
TestSuite-Groups related tests
TestTestSuite, RequirementIndividual test cases
TestRunTestSuiteExecution record with results
Fact-Raw research observations
InsightFact[]Patterns from facts
RecommendationInsight[]Actionable suggestions
BacklogItemRequirement[], RecommendationPrioritized work items

For detailed field specifications, see table-specs.md.