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)