森高千里データベース

erDiagram
  Devices {
    Files p0 "Thumbnail"
    Select p1 "Device type"
    Checkbox p2 "finished?"
    Rollup p3 "Concerts"
    Url p4 "Official link"
    Formula p5 "SingleFinished?"
    RichText p6 "Comments"
    RichText p7 "Sort order"
    Rollup p8 "Video recorded at"
    Formula p9 "AlbumFinished?"
    Date p10 "Release date"
    Rollup p11 "Video recorded in"
    Formula p12 "VIdeoFinished?"
    MultiSelect p13 "Kinds"
    Title p14 "Name"
    RichText p15 "Whole time"
  }

  Devices |o--o{ Apple_Music_Videos : r0
  Devices |o--o{ Years : r1
  Devices |o--o{ Set_lists : r2
  Devices |o--o{ People : r3
  Devices |o--o{ Media : r4
  Devices |o--o{ Performances : r5

  Apple_Music_Videos {
    Files p0 "Thumbnails"
    Url p1 "Video URI"
    Title p2 "Name"
  }

  Apple_Music_Videos |o--o{ Songs : r0
  Apple_Music_Videos |o--o{ Devices : r1

  Years {
    Formula p0 "%AlbumFinished"
    Formula p1 "#Albums"
    Rollup p2 "#AlbumFinished"
    Formula p3 "#Singles"
    Rollup p4 "%DevicesFinished"
    Rollup p5 "#SingleFinished"
    Formula p6 "%SingleFinished"
    Rollup p7 "DeviceTypes"
    Rollup p8 "%ConcertsFinished"
    Formula p9 "#Videos"
    Rollup p10 "#Concerts"
    Title p11 "Name"
  }

  Years |o--o{ Devices : r0
  Years |o--o{ Concerts : r1

  Set_lists {
    Formula p0 "DeviceReleaseDateCopy"
    Rollup p1 "# of performances"
    Rollup p2 "# of contents"
    Rollup p3 "Songs"
    Rollup p4 "DeviceReleaseDate"
    Rollup p5 "ConcertPerformanceDate"
    Rollup p6 "DeviceKinds"
    Formula p7 "DeviceKindsCopy"
    Formula p8 "ConcertPerformanceDateCopy"
    Title p9 "Name"
  }

  Set_lists |o--o{ Devices : r0
  Set_lists |o--o{ Concerts : r1
  Set_lists |o--o{ Contents : r2
  Set_lists |o--o{ Performances : r3

  People {
    Rollup p0 "Arranges"
    RichText p1 "Yomi"
    Select p2 "Head"
    Title p3 "Name"
  }

  People |o--o{ Songs : r0
  People |o--o{ Contents : r1
  People |o--o{ Songs : r2
  People |o--o{ Devices : r3

  Media {
    Select p0 "Maker"
    Url p1 "URL"
    Number p2 "Price"
    MultiSelect p3 "Tags"
    Title p4 "Name"
  }

  Media |o--o{ Devices : r0

  Performances {
    RichText p0 "Hall info"
    Select p1 "Product"
    Url p2 "Live reports"
    Date p3 "Date"
    Rollup p4 "Prefecture"
    RichText p5 "Comments"
    Title p6 "Name"
  }

  Performances |o--o{ Devices : r0
  Performances |o--o{ Concerts : r1
  Performances |o--o{ Set_lists : r2
  Performances |o--o{ ConcertHalls : r3

  Songs {
    Checkbox p0 "finished?"
    Date p1 "First appearance"
    Select p2 "Head"
    RichText p3 "Yomi"
    Title p4 "Name"
  }

  Songs |o--o{ People : r0
  Songs |o--o{ People : r1
  Songs |o--o{ YouTubes : r2
  Songs |o--o{ Apple_Music_Videos : r3
  Songs |o--o{ Activities : r4
  Songs |o--o{ Activities : r5
  Songs |o--o{ Contents : r6

  Concerts {
    RichText p0 "Comments"
    Rollup p1 "# of performances"
    Select p2 "Tags"
    Checkbox p3 "finished"
    Date p4 "Performance date"
    Rollup p5 "The number of halls"
    Title p6 "Name"
  }

  Concerts |o--o{ Bands : r0
  Concerts |o--o{ Set_lists : r1
  Concerts |o--o{ Years : r2
  Concerts |o--o{ Performances : r3

  Concerts {
    RichText p0 "Comments"
    Rollup p1 "# of performances"
    Select p2 "Tags"
    Checkbox p3 "finished"
    Date p4 "Performance date"
    Rollup p5 "The number of halls"
    Title p6 "Name"
  }

  Concerts |o--o{ Bands : r0
  Concerts |o--o{ Set_lists : r1
  Concerts |o--o{ Years : r2
  Concerts |o--o{ Performances : r3

  Contents {
    Rollup p0 "Performance"
    Rollup p1 "Concert"
    Select p2 "Version"
    Rollup p3 "Device Release Date"
    Rollup p4 "Musics"
    MultiSelect p5 "Comments"
    Rollup p6 "Lyrics"
    Rollup p7 "Device"
    Rollup p8 "Concert Performance Date"
    Rollup p9 "Device kind"
    Title p10 "Name"
  }

  Contents |o--o{ Songs : r0
  Contents |o--o{ Activities : r1
  Contents |o--o{ Set_lists : r2
  Contents |o--o{ People : r3

  Performances {
    RichText p0 "Hall info"
    Select p1 "Product"
    Url p2 "Live reports"
    Date p3 "Date"
    Rollup p4 "Prefecture"
    RichText p5 "Comments"
    Title p6 "Name"
  }

  Performances |o--o{ Devices : r0
  Performances |o--o{ Concerts : r1
  Performances |o--o{ Set_lists : r2
  Performances |o--o{ ConcertHalls : r3

  Songs {
    Checkbox p0 "finished?"
    Date p1 "First appearance"
    Select p2 "Head"
    RichText p3 "Yomi"
    Title p4 "Name"
  }

  Songs |o--o{ People : r0
  Songs |o--o{ People : r1
  Songs |o--o{ YouTubes : r2
  Songs |o--o{ Apple_Music_Videos : r3
  Songs |o--o{ Activities : r4
  Songs |o--o{ Activities : r5
  Songs |o--o{ Contents : r6

  Contents {
    Rollup p0 "Performance"
    Rollup p1 "Concert"
    Select p2 "Version"
    Rollup p3 "Device Release Date"
    Rollup p4 "Musics"
    MultiSelect p5 "Comments"
    Rollup p6 "Lyrics"
    Rollup p7 "Device"
    Rollup p8 "Concert Performance Date"
    Rollup p9 "Device kind"
    Title p10 "Name"
  }

  Contents |o--o{ Songs : r0
  Contents |o--o{ Activities : r1
  Contents |o--o{ Set_lists : r2
  Contents |o--o{ People : r3

  Songs {
    Checkbox p0 "finished?"
    Date p1 "First appearance"
    Select p2 "Head"
    RichText p3 "Yomi"
    Title p4 "Name"
  }

  Songs |o--o{ People : r0
  Songs |o--o{ People : r1
  Songs |o--o{ YouTubes : r2
  Songs |o--o{ Apple_Music_Videos : r3
  Songs |o--o{ Activities : r4
  Songs |o--o{ Activities : r5
  Songs |o--o{ Contents : r6

  Concerts {
    RichText p0 "Comments"
    Rollup p1 "# of performances"
    Select p2 "Tags"
    Checkbox p3 "finished"
    Date p4 "Performance date"
    Rollup p5 "The number of halls"
    Title p6 "Name"
  }

  Concerts |o--o{ Bands : r0
  Concerts |o--o{ Set_lists : r1
  Concerts |o--o{ Years : r2
  Concerts |o--o{ Performances : r3

  ConcertHalls {
    Rollup p0 "# of performances"
    Rollup p1 "Region"
    Formula p2 "RegionCopy"
    Title p3 "Name"
  }

  ConcertHalls |o--o{ Prefectures : r0
  ConcertHalls |o--o{ Performances : r1

  YouTubes {
    Date p0 "Date"
    Select p1 "Type"
    Url p2 "link"
    Files p3 "thumbnail"
    Formula p4 "Year"
    RichText p5 "comment"
    Title p6 "Name"
  }

  YouTubes |o--o{ Songs : r0

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  Contents {
    Rollup p0 "Performance"
    Rollup p1 "Concert"
    Select p2 "Version"
    Rollup p3 "Device Release Date"
    Rollup p4 "Musics"
    MultiSelect p5 "Comments"
    Rollup p6 "Lyrics"
    Rollup p7 "Device"
    Rollup p8 "Concert Performance Date"
    Rollup p9 "Device kind"
    Title p10 "Name"
  }

  Contents |o--o{ Songs : r0
  Contents |o--o{ Activities : r1
  Contents |o--o{ Set_lists : r2
  Contents |o--o{ People : r3

  Bands {
    MultiSelect p0 "Tags"
    Title p1 "Name"
  }

  Bands |o--o{ Concerts : r0

  Bands {
    MultiSelect p0 "Tags"
    Title p1 "Name"
  }

  Bands |o--o{ Concerts : r0

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  ConcertHalls {
    Rollup p0 "# of performances"
    Rollup p1 "Region"
    Formula p2 "RegionCopy"
    Title p3 "Name"
  }

  ConcertHalls |o--o{ Prefectures : r0
  ConcertHalls |o--o{ Performances : r1

  YouTubes {
    Date p0 "Date"
    Select p1 "Type"
    Url p2 "link"
    Files p3 "thumbnail"
    Formula p4 "Year"
    RichText p5 "comment"
    Title p6 "Name"
  }

  YouTubes |o--o{ Songs : r0

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  YouTubes {
    Date p0 "Date"
    Select p1 "Type"
    Url p2 "link"
    Files p3 "thumbnail"
    Formula p4 "Year"
    RichText p5 "comment"
    Title p6 "Name"
  }

  YouTubes |o--o{ Songs : r0

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  Activities {
    Select p0 "TV station"
    Select p1 "Photographer"
    Select p2 "Publisher"
    Date p3 "Date"
    RichText p4 "Comment"
    Select p5 "Author"
    Select p6 "Company"
    Select p7 "Distribution"
    Select p8 "Tag"
    Url p9 "Official link"
    Select p10 "Type"
    Title p11 "Name"
  }

  Activities |o--o{ Contents : r0
  Activities |o--o{ Songs : r1
  Activities |o--o{ Songs : r2

  Bands {
    MultiSelect p0 "Tags"
    Title p1 "Name"
  }

  Bands |o--o{ Concerts : r0

  Prefectures {
    Rollup p0 "Property"
    Number p1 "Sort order"
    Select p2 "Region"
    Title p3 "Name"
  }

  Prefectures |o--o{ ConcertHalls : r0

  Prefectures {
    Rollup p0 "Property"
    Number p1 "Sort order"
    Select p2 "Region"
    Title p3 "Name"
  }

  Prefectures |o--o{ ConcertHalls : r0