astro-schema - Laravel Schema Designer

user_roles

id increments
user_id ^FK integer
approved_at datetime
role string
timestamps timestamps

astrologer_details

id increments
astrologer_id ^FK integer
experience string (255)
description longText
city string
state string
bank_name string
bank_acc_no string
bank_ifsc string
timestamps timestamps

schedules

id increments
astrologer_id ^FK integer
start_at datetime
end_at datetime
chat_availability boolean
call_availability boolean
video_availability boolean
timestamps timestamps

bookings

id increments
schedule_id ^FK integer
notes longText
user_id ^FK integer
astrologer_id ^FK integer
service string
scheduled_at datetime
start_at datetime
end_at datetime
status string
charge decimal
timestamps timestamps

users

id increments
name string (255)
email string (255)
mobile_no string (15)
password string (255)
profile_photo string
dob date
status string
timestamps timestamps

charges

astrologer_id ^FK integer
chat_charge decimal
call_charge decimal
video_charge decimal
timestamps timestamps

languages

id increments
language string
timestamps timestamps

user_languages

id increments
user_id ^FK integer
language_id ^FK integer
timestamps timestamps

skills

id increments
skill string
timestamps timestamps

astrologer_skills

id increments
astrologer_id ^FK integer
skill_id ^FK integer
timestamps timestamps

category

id increments
category string
timestamps timestamps

astrologer_category

id increments
astrologer_id ^FK integer
category_id ^FK integer
timestamps timestamps

charts

id increments
name string
gender string
birth_date date
birth_time time
birth_location string
timestamps timestamps

reviews

id increments
user_id ^FK integer
astrologer_id ^FK integer
rating integer
comment longText
status string
timestamps timestamps

reports

id increments
timestamps timestamps
user_id ^FK integer
astrologer_id ^FK integer
reported_by string
report longText

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