森高千里 DB

erDiagram
  T1["People"] {
    title p1 "Name"
    text p2 "Yomi"
    select p3 "Head"
    relation p4 "Bands"
    relation p5 "Devices"
    relation p6 "ArrangeContents"
    relation p7 "LyricSongs"
    relation p8 "MusicStrs"
  }

  T2["Songs"] {
    title p1 "Name"
    text p2 "Yomi"
    select p3 "Head"
    date p4 "First appearance"
    relation p5 "Lyrics"
    relation p6 "Musics"
    relation p7 "Contents"
    relation p8 "ActivitiesByPerformances"
    relation p9 "ActivitiesByTieupSong"
    relation p10 "YouTubes"
  }

  T3["Years"] {
    title p1 "名前"
    relation p2 "Map"
    relation p3 "Performances"
    relation p4 "Concerts"
    relation p5 "YouTubes"
    relation p6 "Devices"
  }

  T4["Map"] {
    title p1 "名前"
    relation p2 "Years"
  }

  T5["Devices"] {
    title p1 "Name"
    select p2 "Device type"
    multi_select p3 "Kinds"
    date p4 "Release date"
    url p5 "Official link"
    text p6 "Whole time"
    file p7 "Thumbnail"
    text p8 "Comments"
    text p9 "Sort order"
    relation p10 "Artists"
    relation p11 "Year"
    relation p12 "Media"
    relation p13 "Contents"
    relation p14 "SetLists"
    relation p15 "Map"
  }

  T6["Bands"] {
    title p1 "Name"
    relation p2 "BandMembers"
    relation p3 "Concerts"
  }

  T7["Concerts"] {
    title p1 "Name"
    select p2 "Type"
    date p3 "Performance date"
    text p4 "Comments"
    relation p5 "Year"
    relation p6 "ConcertHalls"
    relation p7 "Bands"
    relation p8 "Performances"
    relation p9 "SetLists"
    relation p10 "Map"
  }

  T8["Prefectures"] {
    title p1 "Name"
    select p2 "Region"
    number p3 "Sort order"
    relation p4 "ConcertHalls"
  }

  T9["ConcertHalls"] {
    title p1 "Name"
    place p2 "Place"
    relation p3 "Prefecture"
    relation p4 "Performances"
    relation p5 "Concerts"
  }

  T10["Performances"] {
    title p1 "Name"
    number p2 "Order"
    date p3 "Date"
    text p4 "Hall info"
    select p5 "Product"
    url p6 "Live reports"
    text p7 "Comments"
    relation p8 "Concert"
    relation p9 "ConcertHall"
    relation p10 "Year"
    relation p11 "SetList"
    relation p12 "Map"
  }

  T11["SetLists"] {
    title p1 "Name"
    text p2 "Type"
    relation p3 "Concert"
    relation p4 "Performances"
    relation p5 "Devices"
    relation p6 "Contents"
  }

  T12["Media"] {
    title p1 "Name"
    select p2 "Type"
    select p3 "Maker"
    number p4 "Price"
    url p5 "URL"
    relation p6 "Device"
  }

  T13["Activities"] {
    title p1 "Name"
    select p2 "Type"
    select p3 "Sub type"
    date p4 "Start date"
    select p5 "Publishers"
    select p6 "Author"
    select p7 "Photographer"
    text p8 "Comment"
    url p9 "Official link"
    relation p10 "Performances"
    relation p11 "Tieup song"
  }

  T14["Contents"] {
    title p1 "Name"
    text p2 "Number"
    select p3 "Version"
    number p4 "SongNameOrder"
    text p5 "Comments"
    relation p6 "Song"
    relation p7 "SetList"
    relation p8 "ContainedDevice"
    relation p9 "Arranges"
  }

  T15["YouTubes"] {
    title p1 "Name"
    select p2 "Type"
    date p3 "Date"
    text p4 "comment"
    url p5 "link"
    file p6 "Thumbnail"
    relation p7 "Year"
    relation p8 "Songs"
    relation p9 "Map"
  }

  %% 双方向（両側にプロパティが存在）
  T2 }o--o{ T1 : "Lyrics/Musics / LyricSongs/MusicStrs"
  T6 }o--o{ T1 : "BandMembers / Bands"
  T7 }o--o{ T6 : "Bands / Concerts"
  T7 }o--o{ T9 : "ConcertHalls / Concerts"
  T9 }o--o{ T10 : "Performances / ConcertHall"
  T7 }o--o{ T10 : "Performances / Concert"
  T11 }o--o{ T10 : "Performances / SetList"
  T11 }o--o{ T14 : "Contents / SetList"
  T5 }o--o{ T11 : "Devices / SetLists"
  T5 }o--o{ T14 : "Contents / ContainedDevice"
  T12 ||--o{ T5 : "Device / Media"
  T8 ||--o{ T9 : "Prefecture / ConcertHalls"
  T3 ||--o{ T7 : "Year / Concerts"
  T3 ||--o{ T10 : "Year / Performances"
  T3 ||--o{ T5 : "Year / Devices"
  T3 ||--o{ T15 : "Year / YouTubes"
  T4 ||--o{ T3 : "Map / Years"

  %% 片方向（片側のみプロパティが存在）
  T7 ||--o{ T4 : "Map"
  T10 ||--o{ T4 : "Map"
  T5 ||--o{ T4 : "Map"
  T15 ||--o{ T4 : "Map"

  %% その他の片方向・多対多
  T2 ||--o{ T13 : "Tieup song"
  T2 }o--o{ T13 : "ActivitiesByPerformances / Performances"