<aside> 💡 This command assumes that the enviroment variable NOTION_API_KEY contains your integration key. Please set this environment variable before execution.

# bash, zsh
export NOTION_API_KEY=secret_..........

# fish
set -gx NOTION_API_KEY secret_.......

</aside>

notionErDiagram.rb creates ER diagrams to a codeblock from your Notion database. After inviting your integration to your databases, please type the following command.

# Pattern1: use id
notionErDiagram.rb database_id code_block_id
Example:
  notionErDiagram.rb 06915e565005487baea5a8a7550991cd 7daea26b52d04d1bb79cf452da7f35c9

# Pattern2: use url (requre quote)
notionErDiagram.rb "database_url" "code_block_url"

Example:
  notionErDiagram.rb "<https://www.notion.so/hkob/06915e565005487baea5a8a7550991cd?v=d9485754c9424d60aa54a2ce141f2e15>" "<https://www.notion.so/hkob/Irish-tunes-in-youtube-bf69c69a0bd547d1820b1585360b980d#7daea26b52d04d1bb79cf452da7f35c9>"

erDiagram
  Irish_YouTubes {
    Url p0 "URL"
    RichText p1 "Description"
    Date p2 "Uploaded"
    Formula p3 "Thumbnail URL (copy to Thumbnail)"
    MultiSelect p4 "Insturumentals"
    Formula p5 "TypeStr"
    LastEditedTime p6 "最終更新日"
    Files p7 "Thumbnail"
    Rollup p8 "Rhythm"
    Title p9 "Name"
  }

  Irish_YouTubes ||--o{ Irish_Musicians : r0
  Irish_YouTubes ||--o{ Irish_Tunes : r1
  
  Irish_Musicians {
    Rollup p0 "Number of Recordings"
    MultiSelect p1 "Instrumentals"
    Rollup p2 "Number of YouTubes"
    Rollup p3 "Number of Albums"
    Title p4 "名前"
  }

  Irish_Musicians ||--o{ Irish_YouTubes : r0
  Irish_Musicians ||--o{ Irish_Recordings : r1
  Irish_Musicians ||--o{ Irish_Albums : r2
  
  Irish_Tunes {
    MultiSelect p0 "Rhythm"
    Rollup p1 "Musicians (YouTubes)"
    Rollup p2 "Musicians (Recordings)"
    Url p3 "The session link"
    Rollup p4 "Albums"
    Title p5 "Name"
  }

  Irish_Tunes ||--o{ Irish_YouTubes : r0
  Irish_Tunes ||--o{ Irish_Recordings : r1
  
  Irish_Recordings {
    Url p0 "Apple Music"
    Rollup p1 "RecordingsOnSameAlbum"
    Number p2 "Number"
    Title p3 "Name"
  }

  Irish_Recordings ||--o{ Irish_Tunes : r0
  Irish_Recordings ||--o{ Irish_Albums : r1
  Irish_Recordings ||--o{ Irish_Musicians : r2
  
  Irish_Albums {
    Url p0 "Apple Music"
    MultiSelect p1 "Source"
    Url p2 "The session link"
    Title p3 "Name"
  }

  Irish_Albums ||--o{ Irish_Musicians : r0
  Irish_Albums ||--o{ Irish_Recordings : r1
  
  Irish_Recordings {
    Url p0 "Apple Music"
    Rollup p1 "RecordingsOnSameAlbum"
    Number p2 "Number"
    Title p3 "Name"
  }

  Irish_Recordings ||--o{ Irish_Tunes : r0
  Irish_Recordings ||--o{ Irish_Albums : r1
  Irish_Recordings ||--o{ Irish_Musicians : r2
  
  Irish_Albums {
    Url p0 "Apple Music"
    MultiSelect p1 "Source"
    Url p2 "The session link"
    Title p3 "Name"
  }

  Irish_Albums ||--o{ Irish_Musicians : r0
  Irish_Albums ||--o{ Irish_Recordings : r1
  

erDiagram
  Irish_YouTubes {
    Url p0 "URL"
    RichText p1 "Description"
    Rollup p2 "TuneName"
    Date p3 "Uploaded"
    Formula p4 "Thumbnail URL (copy to Thumbnail)"
    MultiSelect p5 "Insturumentals"
    Formula p6 "TypeStr"
    Formula p7 "shortYouTubeURL"
    LastEditedTime p8 "最終更新日"
    Files p9 "Thumbnail"
    Rollup p10 "Rhythm"
    Title p11 "Name"
  }

  Irish_YouTubes }o--o{ Irish_Musicians : "Musicians / YouTubes" 
  Irish_YouTubes }o--o{ Irish_Tunes : "Tunes / YouTubes" 

  Irish_Musicians {
    Rollup p0 "Number of Recordings"
    MultiSelect p1 "Instrumentals"
    Rollup p2 "Number of YouTubes"
    Rollup p3 "Number of Albums"
    Title p4 "名前"
  }

  Irish_Musicians }o--o{ Irish_Recordings : "Recordings / Musicians" 
  Irish_Musicians }o--o{ Irish_Albums : "Albums / Musicians" 

  Irish_Tunes {
    MultiSelect p0 "Rhythm"
    Rollup p1 "Musicians (YouTubes)"
    Rollup p2 "Musicians (Recordings)"
    Url p3 "The session link"
    Rollup p4 "Albums"
    Rollup p5 "Property"
    Rollup p6 "Apple Music"
    Title p7 "Name"
  }

  Irish_Tunes }o--o{ Irish_Recordings : "Recordings / Tunes" 

  Irish_Recordings {
    Url p0 "Apple Music"
    Rollup p1 "RecordingsOnSameAlbum"
    Number p2 "Number"
    Title p3 "Name"
  }

  Irish_Recordings }o--o{ Irish_Albums : "Irish Album / Recordings" 

  Irish_Albums {
    Url p0 "Apple Music"
    MultiSelect p1 "Source"
    Url p2 "The session link"
    Title p3 "Name"
  }

  Irish_Recordings {
    Url p0 "Apple Music"
    Rollup p1 "RecordingsOnSameAlbum"
    Number p2 "Number"
    Title p3 "Name"
  }

  Irish_Albums {
    Url p0 "Apple Music"
    MultiSelect p1 "Source"
    Url p2 "The session link"
    Title p3 "Name"
  }

erDiagram
  ABC {
    Title p0 "名前"
  }

  ABC |o--o{ DEF : "無題のデータベース"

  DEF {
    Title p0 "Name"
  }

Untitled