Minet

Tables (18)

Album (Untitled5)

  • Key (album_url) — Primary key — NOT NULL
  • Key (artist_id) — Foreign key → Artist.Key — NOT NULL
  • Field (album_name)
  • Field (release_date)
  • Field (genre)
  • Field (album_photo)

Album_Like (Untitled10)

  • Key (album_like_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Key (album_url) — Foreign key → Album.Key — NOT NULL

Artist (Untitled2)

  • Key (artist_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Field (artist_name)
  • Field2 (genre)
  • Field3 (birth)
  • Field (profile_url)

Artist_Page (Untitled7)

  • Key (artist_page_id) — Primary key — NOT NULL
  • Field (biography)
  • Key (artist_id) — Foreign key → Artist.Key — NOT NULL

Artist_Page_Content (Untitled8)

  • Key (content_id) — Primary key — NOT NULL
  • Field (photo)
  • Field (description)
  • Field (create_date)
  • Field (update_date)
  • Key (artist_page_id) — Foreign key → Artist_Page.Key — NOT NULL

Chart (Untitled11)

  • Key (chart_id) — Primary key — NOT NULL
  • Field (chart_type)
  • Field (chart_date)
  • Field (genre)

Chart_Song (Untitled12)

  • Key (chart_song_id) — Primary key — NOT NULL
  • Key (chart_id) — Foreign key → Chart.Key — NOT NULL
  • Key (song_id) — Foreign key → Song.Key — NOT NULL
  • Field (rank)
  • Field (genre)

Commnet (Untitled14)

  • Key (commnet_id) — Primary key — NOT NULL
  • Field (content)
  • Field (create_date)
  • Key (content_id) — Foreign key → Artist_Page_Content.Key — NOT NULL

Content_Photo (Untitled17)

  • Key (photo_id) — Primary key — NOT NULL
  • Key (content_id) — Foreign key → Artist_Page_Content.Key — NOT NULL
  • Field (url)

Follow (Untitled3)

  • Key (follow_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Key (artist_id) — Foreign key → Artist.Key — NOT NULL

Funding (Untitled4)

  • Key (funding_id) — Primary key — NOT NULL
  • Field (amount)
  • Field (created_date)
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Key (artist_id) — Foreign key → Artist.Key — NOT NULL

Member (Untitled)

  • Key (member_id) — Primary key — NOT NULL
  • Field (name)
  • Field (id)
  • Field2 (password)
  • Field3 (phone)
  • Field4 (create_time)
  • Field (enabled)
  • Field (is_artist)

Reply (Untitled15)

  • Key2 (reply_id) — Primary key — NOT NULL
  • Field (content)
  • Field (create_date)
  • Key (commnet_id) — Foreign key → Commnet.Key — NOT NULL

Song (Untitled6)

  • Key (song_id) — Primary key — NOT NULL
  • Key (album_url) — Foreign key → Album.Key — NOT NULL
  • Field (genre)
  • Field2 (song_name)
  • Field (fileUrl)

Song_Like (Untitled9)

  • Key (create_date) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Field

Song_Playlist (Untitled18)

  • Key (create_date) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Key (song_id) — Foreign key → Song.Key — NOT NULL

Visited (Untitled13)

  • Key (create_date) — Primary key — NOT NULL
  • Key (song_url) — Foreign key → Song.Key — NOT NULL
  • Field (count)

week_visited (Untitled16)

  • Key (week_visited_id) — Primary key — NOT NULL
  • Key (chart_song_id) — Foreign key → Chart_Song.Key — NOT NULL
  • Field (create_date)
  • Field (count)