riff_curia - Laravel Schema Designer

artists

id increments
name string (1000)
bio longText
profile_img_path string (1000)
cover_pic mediumText
total_ratings float (8,2)
avg_ratings float (8,2)
added_by_user_id bigIncrements
added_by string
updated_by_user_id bigIncrements
updated_by string
is_active boolean
timestamps timestamps

albums

id increments
name string (1000)
description mediumText
release_date date
format string
duration string
cover_pic string
added_by string
updated_by_user_id bigIncrements
updated_by string
is_active boolean
timestamps timestamps

users

id increments
name string (1000)
username string (1000)
email string
mobile string
email_verified_at datetime
password string
gender string
bio mediumText
profile_pic string
reviews_count decimal
ratings_count decimal
favorites_count decimal
likes_count decimal
followers_count string
following_count decimal
status boolean
sent_email_time datetime
remember_token longText
timestamps timestamps

admins

id increments
timestamps timestamps
name string (1000)
username string (1000)
email string
mobile string
password string (1000)
is_block boolean
remember_token string (1000)

genres

id increments
name string (1000)
added_by_user_id bigIncrements
added_by string
updated_by_user_id bigIncrements
updated_by string
is_active boolean
timestamps timestamps

tracks

id increments
timestamps timestamps
name string
album_id bigIncrements
duration string
format string
release_date date
track_img string
description mediumText
total_rating integer
avg_rating decimal
review_count integer
added_by_user_id bigIncrements
added_by string
updated_by_user_id bigIncrements
updated_by string

album_artist_mappings

id increments
album_id bigIncrements
artist_id bigIncrements
timestamps timestamps

languages

id increments
name string (1000)
code string
added_by_user_id bigIncrements
added_by string
updated_by_user_id bigIncrements
updated_by string
timestamps timestamps

track_artist_mappings

id increments
timestamps timestamps
track_id bigIncrements
artist_id bigIncrements

track_genre_mappings

id increments
timestamps timestamps
track_id bigIncrements
genre_id bigIncrements

reviews

id increments
user_id bigIncrements
track_id bigIncrements
review_text longText
comment_count mediumInteger
likes_count integer
timestamps timestamps

jobs

id increments
queue string
payload longText
attempts integer
reserved_at integer
available_at mediumInteger
timestamps timestamps

rate_artists

id increments
user_id bigIncrements
artist_id bigIncrements
rate tinyInteger
timestamps timestamps

track_language_mappings

id increments
track_id bigIncrements
language_id bigIncrements
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01