recos - Laravel Schema Designer

types

id increments
timestamps timestamps
softDeletes softDeletes
name string

sub_types

id increments
timestamps timestamps
softDeletes softDeletes
type_id ^FK bigInteger
name string

incoming_mail

id increments
timestamps timestamps
softDeletes softDeletes
no string
full_number string
description string
sign_date string
sign_place string
unit_id bigInteger
sign_user string
classification_id bigInteger
priority_id bigInteger
status string
publish_date string
user_id_created string
type_id bigIncrements

units

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
level string
parent_id string

classifications

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
description string

priorities

id increments
timestamps timestamps
softDeletes softDeletes
name string

tracking_incoming_mails

id increments
timestamps timestamps
softDeletes softDeletes
incoming_mail_id bigIncrements
to string
unit_id bigIncrements
status string
note string
read_at string
forward_date string
user_id string

outgoing_mails

id increments
timestamps timestamps
softDeletes softDeletes
no string
full_number string
subject string
content string
code string
mail_date string
user_id string
type_id bigIncrements

tracking_outgoing_mails

id increments
timestamps timestamps
softDeletes softDeletes
outgoing_mail_id bigIncrements
to string
unit_id bigIncrements
status string
note string
read_at string
forward_date string
user_id string

dispositions

id increments
timestamps timestamps
softDeletes softDeletes
forward string
content string
priority_id bigIncrements
expired_date string
note string
read_at string
incoming_mail_id bigIncrements
user_id bigIncrements

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