co_space - Laravel Schema Designer

companies

id bigIncrements
plan_id ^FK bigInteger
timestamps timestamps
name string
address string
email string
web string
logo string
password string
phone string
email_verified tinyInteger
email_verified_at datetime
email_verification_token string
status tinyInteger
type string

users

id increments
timestamps timestamps
company_id ^FK integer
full_name string
email string
password string
phone string
address string
photo string
email_verified tinyInteger
email_verified_at datetime
email_verification_token string
designation string
status tinyInteger

resources_categories

id increments
timestamps timestamps
name string
description string
status tinyInteger

resources

id increments
timestamps timestamps
resources_category_id ^FK bigInteger
name string
price decimal
description string
status tinyInteger

bookings

id increments
timestamps timestamps
company_id ^FK bigInteger
user_id ^FK bigInteger
resources_id ^FK bigInteger
start_date date
end_date date
start_time time
end_time time
price decimal
status tinyInteger

basic_setups

id bigIncrements
name string
address string
email string
phone string
web string
logo string
timestamps timestamps

plans

id bigIncrements
timestamps timestamps
title string
price string
photo string
description string
status string

invoice_setups

id increments
timestamps timestamps
logo string
address string
email string
phone string

payment_methods

id increments
timestamps timestamps
Name string
notes string

service_charges

id increments
timestamps timestamps
title string
price decimal
status tinyInteger

messages

id increments
timestamps timestamps
to ^FK bigInteger
from ^FK bigInteger
text text
file string

invoices

id increments
timestamps timestamps
user_id ^FK bigInteger
track_no string
status tinyInteger
company_id ^FK bigInteger

invites

id increments
timestamps timestamps
user_id ^FK bigInteger
full_name string
email string
phone bigInteger
address string
organization string
type string
time time
date date
notes string

visitors

id increments
timestamps timestamps
user_id ^FK bigInteger
company_id ^FK bigInteger
full_name string
email string
phone string
address string
organization string
type string
photo string
time time
date date
notes string

group_visitors

id increments
timestamps timestamps
user_id ^FK bigInteger
company_id ^FK bigInteger
type string
name string
organization string
address string
date date
time time
notes string

group_members

id increments
timestamps timestamps
group_id ^FK bigInteger
name string
phone bigInteger

payments

id increments
timestamps timestamps
invoice_id ^FK bigInteger
payment_method_id ^FK bigInteger
amount decimal (12,2)
remarks string

invoice_details

id increments
timestamps timestamps
invoice_id ^FK bigInteger
plan_id ^FK bigInteger
booking_id ^FK bigInteger
time_pass_id ^FK bigInteger
service_charge_id ^FK bigInteger

time_pass

id increments
timestamps timestamps
user_id ^FK bigInteger
start_time time
price string
date date
card_no bigInteger

activity_log

id increments
timestamps timestamps
user_id ^FK bigInteger
text text
company_id ^FK bigInteger

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