dmis_db - Laravel Schema Designer

westoyvs

id increments
name string
short_name char (1)
timestamps timestamps

commissions

id increments
westoyv_id ^FK bigInteger
parent_id bigInteger
seq integer
name string
sub_name string
timestamps timestamps

users

id increments
name string
email string
email_verified_at timestamp
password string
rememberToken string
timestamps timestamps

positions

id increments
name string
timestamps timestamps

assignments

id increments
assignment_id bigInteger
assignment_type string
personnel_id ^FK bigInteger
position_id ^FK bigInteger
location_id bigInteger
timestamps timestamps

personnels

id increments
name string
personnel_type_id ^FK bigInteger
timestamps timestamps

locations

id increments
name string
timestamps timestamps

parishes

id increments
location_id ^FK bigInteger
vicarate_id bigInteger
name string
latin string
titular string
address string
telno string
faxno string
timestamps timestamps

religious_groupings

id increments
name string
timestamps timestamps

other_designation

id increments
name string
timestamps timestamps

institutes

id increments
location_id ^FK bigInteger
religious_grouping_id bigInteger
name string
address string
tel_no string
fax_no string
email string
website string
timestamps timestamps

educational_centers

id increments
location_id bigInteger
name string
address string
tel_no string
fax_no string
email string
website string
timestamps timestamps

miscellaneous_listings

id increments
location_id ^FK bigInteger
name string
address string
tel_no string
fax_no string
email string
timestamps timestamps

personnel_types

id increments
name string
timestamps timestamps

councils

id increments
parent_id bigInteger
name string
timestamps timestamps

seminaries

id increments
location_id ^FK bigInteger
name string
Address string
tel_no string
fax_no string
website string
timestamps timestamps

vicarates

id increments
timestamps timestamps
location_id ^FK bigInteger
name string
subname string

affiliation_types

id increments
timestamps timestamps
name string

Affiliations

id increments
timestamps timestamps
name string
abbreviation string
shortname string
affiliation_type_id ^FK bigInteger
religious_grouping_id ^FK bigInteger

clergies

id increments
timestamps timestamps
personnel_id ^FK bigInteger
affiliation_id ^FK bigInteger
license string
expiry date

activities

id increments
name string
timestamps timestamps

days

id increments
name string
timestamps timestamps

months

id increments
timestamps timestamps
name string

years

id increments
timestamps timestamps
name string

times

id increments
timestamps timestamps
name string

schedules

id increments
timestamps timestamps
year_id ^FK bigInteger
month_id bigInteger
day string
start_time_id bigInteger
end_time_id bigInteger
activity_id bigInteger
description string
assignable_type string
assignable_id string
is_request tinyInteger
is_approved tinyInteger

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