educourses - Laravel Schema Designer

admins

id increments
name string
email string
image string
password string
status enum
timestamps timestamps

users

id increments
username string
email string
mobile string
country_id ^FK integer
category_id ^FK integer
image string
password string
status enum
timestamps timestamps
verification_code string

categories

id increments
name json
timestamps timestamps

countries

id increments
name json
code string
image string
timestamps timestamps

tokens

id increments
user_id ^FK integer
token string
device_type enum
device_lang enum
status enum
timestamps timestamps

contacts

id increments
name string
email string
mobile string
message text
timestamps timestamps

settings

id increments
snapchat string
twitter string
instagram string
whatsapp string
about_us json
timestamps timestamps
zbony_link string
sala_link string

courses

id increments
title json
category_id ^FK integer
description json
piad enum
price string
start_date date
end_date date
course_code string
zoom_link text
timestamps timestamps

course_dayes

id increments
course_id ^FK integer
day_name string
day_code string
from_hour string
to_hour string
timestamps timestamps

banks

id increments
bank_name string
bank_image string
account_number string
iban_number string
timestamps timestamps

course_requests

id increments
user_id ^FK integer
course_id ^FK integer
payment_type enum
paid enum
admin_accept enum
price string
timestamps timestamps

payment_transfers

id increments
course_id ^FK integer
user_id ^FK integer
image string
course_request_id ^FK integer
bank_id ^FK integer
type enum
user_bank_name string
user_account_number integer
timestamps timestamps

user_courses

id increments
user_id ^FK integer
course_id ^FK integer
course_request_id ^FK integer
timestamps timestamps

rates

id increments
user_id ^FK integer
course_id ^FK integer
course_rate string
teacher_rate string
description text
timestamps timestamps

new_topics

id increments
timestamps timestamps
title json
description json
image string

common_questions

id increments
name string
email string
question text
answer text
show enum
timestamps timestamps

course_documents

id increments
course_id ^FK integer
document string
timestamps timestamps

student_opinions

id increments
title json
image string
timestamps timestamps

reference_summaries

id increments
image string
title json
category_id ^FK integer
description json
inside_advise json
timestamps timestamps

revision_requests

id increments
user_id ^FK integer
code string
name string
email string
body text
document string
revision_price_id ^FK integer
status enum
payment_type enum
bank_id ^FK integer
transfer_image string
timestamps timestamps

revision_prices

id increments
day_from date
day_to date
price string
timestamps timestamps

exams

id increments
title json
file string
timestamps timestamps

notifications

id increments
timestamps timestamps
user_id ^FK integer
body json
type enum
side_col string

topic_liberaries

id increments
image string
title json
paid enum
link string
timestamps timestamp

download_requests

id increments
user_id ^FK integer
topic_liberary_id ^FK integer
payment_type enum
paid enum
price string
bank_id ^FK integer
transfer_image string
status enum
timestamps timestamps

user_topics

id increments
user_id ^FK integer
topic_liberary_id ^FK integer
timestamps timestamps