Meem - Laravel Schema Designer

users

id increments
name string
email string
password string
communication_code string
address text
birthdate string
phone string
gender enum
image string
timestamps timestamps
is_active boolean

managers

id increments
timestamps timestamps
name string
email string
password string
birthdate string
phone string
gender enum
image string
cv_pdf string
cv_description mediumText

fields

id increments
category_id ^FK bigInteger
name string
image string
is_active boolean
timestamps timestamps

categories

id increments
name string
image string
is_active boolean
timestamps timestamps

courses

id increments
category_id ^FK bigInteger
name string
price float
description mediumText
image string
start_date timestamp
end_date timestamp
duration float
whatsapp_link string
telegram_link string
telegram_channel_link string
is_active boolean
show_teachers_names boolean
certificate_price float
timestamps timestamps

books

id increments
course_id ^FK bigInteger
book_pdf string
is_bw boolean
bw_price float
is_colored boolean
colored_price float
timestamps timestamps

standards

id increments
course_id ^FK bigInteger
name string
timestamps timestamps

lectures

id increments
standard_id ^FK bigInteger
type enum
name string
video_link string
start_at timestamp
end_at timestamp
is_published boolean
publish_at timestamp
is_active boolean

lectures_pins

id increments
lecture_id ^FK bigInteger
name string
description text
time string
timestamps timestamps

indicators

id increments
name string
lecture_id ^FK bigInteger
standard_id ^FK bigInteger
timestamps timestamps

exams

id increments
type enum
lecture_id ^FK bigInteger
standard_id ^FK bigInteger
course_id ^FK bigInteger
duration integer
attempts integer
solution_video_link string
is_active boolean
timestamps timestamps

questions

id increments
exam_id ^FK bigInteger
indicator_id ^FK bigInteger
standard_id ^FK bigInteger
content string
image string
degree float
is_active boolean
timestamps timestamps

answers

id increments
question_id ^FK bigInteger
content string
is_correct boolean
timestamps timestamps

exam_user

id increments
user_id ^FK bigInteger
exam_id ^FK bigInteger
is_ended boolean
ends_at timestamp
timestamps timestamps

course_teacher

id increments
teacher_id ^FK bigInteger
course_id ^FK bigInteger
timestamps timestamps

student_course

id increments
student_id ^FK bigInteger
course_id ^FK bigInteger
amount float
payment_id ^FK bigInteger
is_active boolean
timestamps timestamps

answer_user

id increments
user_id ^FK bigInteger
answer_id ^FK bigInteger
exam_user_id ^FK bigInteger
is_correct boolean
timestamps timestamps

courses_attachments

id increments
course_id ^FK bigInteger
name string
file string
is_active boolean
timestamps timestamps

courses_inquiries

id increments
type enum
user_id ^FK bigInteger
course_id ^FK bigInteger
content string
is_public boolean
timestamps timestamps

courses_inquires_replies

id increments
course_inquire_id ^FK bigInteger
user_id ^FK bigInteger
content string
is_public boolean
timestamps timestamps

print_requests

id increments
user_id ^FK bigInteger
type enum
course_id ^FK bigInteger
book_id ^FK bigInteger
status enum
payment_id ^FK bigInteger
amount float
coupon_id ^FK bigInteger
timestamps timestamps

carts

id increments
user_id ^FK bigInteger
timestamps timestamps

carts_contents

id increments
cartable_id bigInteger
cartable_type string
amount float
coupon_id ^FK bigInteger
timestamps timestamps

coupons

id increments
coupon string
discount float
couponable_id bigInteger
couponable_type string
timestamps timestamps

payments

id increments
payment_type enum
user_id ^FK bigInteger
amount float
type enum
is_confirmed boolean
timestamps timestamps

courses_progresses

id increments
user_id ^FK bigInteger
lecture_id ^FK bigInteger
timestamps timestamps

users_addresses

id increments
user_id ^FK bigInteger
timestamps timestamps
content text