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