airtable-model

PM Airtable 数据模型参考。在创建表、查询结构或理解领域、子领域、能力、实体、需求和待办事项表之间的关系时使用。

📖 中文导读:PM Airtable 数据模型参考。在创建表、查询结构或理解领域、子领域、能力、实体、需求和待办事项表之间的关系时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

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

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

Table Links To Purpose
Domain - Top-level areas
Subdomain Domain Sub-areas, has 3-letter prefix
Capability Subdomain Categorizes requirements, has 3-letter prefix
Entity Subdomain Domain objects
Attribute Entity Entity properties
Relationship Entity, Entity Entity-to-entity connections
Process Subdomain Business workflows
Glossary Subdomain Ubiquitous language
Requirement Capability BDD requirements (MoSCoW), ReqID: SUB-CAP-NNN
Rule Requirement Business rules
Example Rule Concrete examples
OpenQuestion Requirement Unresolved questions
TestSuite - Groups related tests
Test TestSuite, Requirement Individual test cases
TestRun TestSuite Execution record with results
Fact - Raw research observations
Insight Fact[] Patterns from facts
Recommendation Insight[] Actionable suggestions
BacklogItem Requirement[], Recommendation Prioritized work items

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