Awasul - Laravel Schema Designer

user

id increments
timestamps timestamps
softDeletes softDeletes

member

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name string
phone string
email string
department_id integer
position string
work_site_id integer
office_phone string
city_id integer
birth_date datetime
gender enum
about longText
password string
work_number string

department

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
phone string
parent_id integer
description_en text
description_ar text

member_department

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
department_id integer

supervisor

id increments
timestamps timestamps
softDeletes softDeletes
supervisor_id integer
department_id integer

hobby

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
member_id integer

child_name

id increments
timestamps timestamps
softDeletes softDeletes
name string
member_id integer

experience

id increments
timestamps timestamps
softDeletes softDeletes
title string
description text
member_id integer

certification

id increments
softDeletes softDeletes
university string
timestamps timestamps
level string
univer string
collage string
degree string
year integer
description text
member_id integer

group

id increments
timestamps timestamps
softDeletes softDeletes
created_by integer
name string
about text
send_invitations enum
who_approve enum
rate integer
folder_id integer
type enum
visible enum
approved_invitations boolean
total_member integer

group_tag

id increments
timestamps timestamps
softDeletes softDeletes
tag_id string
group_id integer

group_admin

id increments
softDeletes softDeletes
group_admin_id integer
group_id integer
timestamps timestamps

group_member

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
group_id integer

post

id increments
timestamps timestamps
softDeletes softDeletes
post_type enum
created_by integer
title string
description text
expire_at datetime
confirm_report boolean
letter_number string
alert_type_id integer
all_member boolean

group_post

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
group_id integer

group_rate

id increments
timestamps timestamps
softDeletes softDeletes
group_id integer
member_id integer
rate integer
review text

drive

id increments
timestamps timestamps
softDeletes softDeletes
name string

group_invitation

id increments
timestamps timestamps
softDeletes softDeletes
group_id integer
member_id integer
sender_id integer
status enum
approve boolean

project

id increments
timestamps timestamps
softDeletes softDeletes
name string
description text
suggestion_date datetime
start_at datetime
end_at datetime
created_by integer
supervisor_id integer
comment text
progress integer
status string
percent integer
group_id string
folder_id integer
total_days integer
total_members integer

project_member

timestamps timestamps
id increments
softDeletes softDeletes
member_id integer
project_id integer
rate integer
comment text
confirm boolean

task

id increments
timestamps timestamps
softDeletes softDeletes
project_id integer
created_by integer
name string
description text
start_at datetime
end_at datetime
status string
priority string
predicted_time string
rate integer
progress integer
comment text

check_item

id increments
timestamps timestamps
softDeletes softDeletes
check_list_id integer
description text
completed boolean
created_by integer

task_assign

id increments
timestamps timestamps
softDeletes softDeletes
task_id integer
member_id integer

task_follower

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
task_id integer

task_history

id increments
timestamps timestamps
softDeletes softDeletes
task_id integer
created_by integer
description text

task_comment

id increments
timestamps timestamps
softDeletes softDeletes
message text
reply_on integer
created_by integer
task_id integer

reaction

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

check_list

id increments
timestamps timestamps
softDeletes softDeletes
name string
task_id string
created_by string

task_comment_like

id increments
timestamps timestamps
softDeletes softDeletes
name string
created_by integer
comment_id integer

alert_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

post_member

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
member_id integer

post_mention

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
member_id integer

post_schedule

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
date datetime
publish boolean

post_reaction

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
reaction_id integer
created_by integer

post_comment

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
message text
reply_on integer
main_thread integer
created_by integer

comment_mention

id increments
timestamps timestamps
softDeletes softDeletes
comment_id integer
created_by integer
member_id integer

post_follower

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
post_id integer

post_view

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
post_id integer

post_report

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
member_id integer
reason text

post_confirm

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
member_id integer

note

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
title string
description text
date datetime
from_hour string
to_hour string

invitation

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
status enum

company

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
about_en text
about_ar text
words_en text
words_ar text
policy_en text
policy_ar text
vision_en text
vision_ar text
mission_en text
mission_ar text
total_hours integer
folder_id integer

calendar_word

id increments
timestamps timestamps
softDeletes softDeletes
description text
from_date datetime
to_date datetime
hide boolean
member_id integer

contract

id increments
timestamps timestamps
softDeletes softDeletes
created_by integer
title string
description text

contract_member

id increments
timestamps timestamps
softDeletes softDeletes
contract_id integer
member_id integer
agree boolean

notification

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
message text
read boolean

comment_reaction

id increments
timestamps timestamps
softDeletes softDeletes
comment_id integer
reaction_id integer
created_by integer

project_report

timestamps timestamps
softDeletes softDeletes
id increments
project_id integer
created_by integer
to_member_id integer
status string
title string
report text
respond string
note text

task_report

id increments
timestamps timestamps
softDeletes softDeletes
task_id integer
member_id integer
status string
title string
report text
respond string
note text

project_history

id increments
timestamps timestamps
softDeletes softDeletes
project_id integer
created_by integer
description text

city

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

post_city

id increments
timestamps timestamps
softDeletes softDeletes
city_id integer
post_id integer

file_history

id increments
timestamps timestamps
softDeletes softDeletes
created_by integer
description text
drive_id integer

tag

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

attendance

id increments
timestamps timestamps
softDeletes softDeletes
member_id string
date datetime
from_hour string
to_hour string
total_hours integer
sign_in string
sign_out string
last_seen string
month string

followers

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
follower_id integer

chat

id increments
timestamps timestamps
softDeletes softDeletes
last_message text
group_id integer
project_id integer

chat_message

id increments
timestamps timestamps
softDeletes softDeletes
sender_id integer
message mediumText
chat_id integer

chat_member

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
chat_id integer

chat_read

id increments
timestamps timestamps
softDeletes softDeletes
member_id integer
chat_message_id integer