asdasd

Tables (29)

ACTIVITIES

  • activity_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • music_PK — int — NOT NULL
  • activity_event — varchar
  • activity_content — text
  • activity_state — varchar
  • activity_registerday — date

ACTIVITYLIKES

  • activity_like_PK — int — Primary key — NOT NULL
  • activity_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • activity_like_registerday — date

ACTIVITYPHOTOS

  • activity_photo_PK — int — Primary key — NOT NULL
  • activity_PK — int — NOT NULL
  • activity_photo_path — varchar

ACTIVITYREVIEWREPLIES

  • activity_review_reply_PK — int — Primary key — NOT NULL
  • activity_review_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • activity_review_reply_content — text
  • activity_review_reply_registerday — date
  • activity_review_reply_state — varchar

ACTIVITYREVIEWS

  • activity_review_PK — int — Primary key — NOT NULL
  • activity_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • activity_review_content — text
  • activity_review_registerday — date
  • activity_review_state — varchar

ALBUMREVIEWLIKES

  • album_review_like_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • album_review_PK — int — NOT NULL
  • album_review_like_state — varchar
  • album_review_like_registerday — date

ALBUMREVIEWREPLIES

  • album_review_reply_PK — int — Primary key — NOT NULL
  • album_review_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • album_review_reply_content — text
  • album_review_reply_registerday — date
  • album_review_reply_state — varchar

ALBUMREVIEWS

  • album_review_PK — int — Primary key — NOT NULL
  • album_PK — int — NOT NULL
  • album_review_content — text
  • album_review_registerday — date
  • album_review_state — varchar

ALBUMS

  • album_PK — int — Primary key — NOT NULL
  • album_photo_path — varchar
  • album_name — varchar
  • album_artist_name — varchar
  • album_sub_artist_name — varchar
  • album_genre — varchar
  • album_resisterday — date
  • album_introduction — text
  • album_state — varchar

ALBUMSCORES

  • album_score_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • album_PK — int — NOT NULL
  • album_score_registerday — date
  • album_score_score — int

CHARGES

  • charge_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • charge_amount — int
  • charge_registerday — date

CURRENTMUSICS

  • current_music_PK — int — Primary key — NOT NULL
  • music_PK2 — int — NOT NULL

DONATIONS

  • donation_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • artist_PK — int — NOT NULL
  • donation_amount — int
  • donation_registerday — date

FANCLUBS

  • fanclub_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • artist_PK — int — NOT NULL
  • fanclub_total_donation_amount — int

FOLLOWS

  • follow_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • artist_PK — int — NOT NULL
  • follow_registerday — date

LIKES

  • like_PK — int — Primary key — NOT NULL
  • like_registerday — date
  • user_PK — int — NOT NULL
  • music_PK — int — NOT NULL

MUSICREVIEWLIKES

  • music_like_PK — int — Primary key — NOT NULL
  • music_review_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • music_review_like_state — varchar
  • music_review_like_registerday — date

MUSICREVIEWREPLIES

  • music_review_reply_PK — int — Primary key — NOT NULL
  • music_review_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • music_review_reply_content — text
  • music_review_reply_registerday — date

MUSICREVIEWS

  • music_review_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • music_PK — int — NOT NULL
  • music_review_content — text
  • music_review_registerday — date
  • music_review_state — varchar

MUSICS

  • music_PK — int — Primary key — NOT NULL
  • music_name — varchar
  • music_artist_name — varchar
  • music_sub_artist_name — varchar
  • music_writer — varchar
  • music_composer — varchar
  • music_arranger — varchar
  • music_genre — varchar
  • music_mood — varchar
  • music_photo_path — varchar
  • music_liric — varchar
  • music_registerday — date
  • music_introduction — text
  • music_stateb — varchar
  • music_streaming_path — varchar
  • album_PK — int — NOT NULL

MUSICSCORES

  • music_score_PK — int — Primary key — NOT NULL
  • music_PK — int — NOT NULL
  • user_PK — int — NOT NULL
  • music_score_score — int
  • music_score_registerday — date

PLAYLISTMUSICS

  • playlist_music_PK — int — Primary key — NOT NULL
  • playlist_PK — int — NOT NULL
  • music_PK2 — int — NOT NULL

PLAYLISTS

  • playlist_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • playlist_name — varchar
  • playlist_registerday — date

PUSHES

  • push_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL
  • artist_PK — int — NOT NULL
  • push_event — varchar
  • push_registerday — date
  • push_state — varchar

RADIOPLAYLISTMUSICS

  • radio_playlist_music_PK — int — Primary key — NOT NULL
  • radio_playlist_PK — int — NOT NULL
  • music_PK2 — int — NOT NULL

RADIOPLAYLISTS

  • radio_playlist_PK — int — Primary key — NOT NULL
  • user_PK — int — NOT NULL

STATISTICS

    STREAMINGS

    • streaming_PK — int — Primary key — NOT NULL
    • user_PK — int — NOT NULL
    • music_PK — int — NOT NULL
    • streaming_count — varchar
    • streaming_gender — varchar
    • streaming_age — varchar
    • streaming_firstday — date
    • streaming_genre — varchar
    • streaming_mood — varchar
    • streaming_lastday — date

    USERS

    • user_PK — int — Primary key — NOT NULL
    • user_nickname — varchar
    • user_email — varchar
    • user_password — varchar
    • user_phone_number — varchar
    • user_gender — varchar
    • user_birthday — date
    • user_registerday — date
    • user_state — varchar
    • user_photo_path — varchar
    • user_introduction — text