dipsea-web - Laravel Schema Designer

users

id bigIncrements
user_role_id ^FK bigInteger
name string
email string
password string
email_verified_at timestamp
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

user_roles

id bigIncrements
name string
timestamps timestamps
softDeletes softDeletes

islands

id bigIncrements
state_id ^FK bigInteger
name string
descriptions string
emergency_contact string
longitude string
latitude string
timestamps timestamps
softDeletes softDeletes

states

id bigIncrements
name string
name_long string
timestamps timestamps
softDeletes softDeletes

villages

id bigIncrements
island_id ^FK bigInteger
name string
timestamps timestamps
softDeletes softDeletes

service_types

id bigIncrements
name string
timestamps timestamps
softDeletes softDeletes

vendors

id bigIncrements
village_id ^FK bigInteger
first_name string
last_name string
phone_no string
company_name string
ssm_no string
ssm_url string
timestamps timestamps
softDeletes softDeletes

customers

id bigIncrements
first_name string
last_name string
email string
phone_no string
timestamps timestamps
softDeletes softDeletes

services

id bigIncrements
service_type_id ^FK bigInteger
vendor_id ^FK bigInteger
village_id ^FK bigInteger
name string
address string
price decimal (10,2)
longitude string
latitude string
timestamps timestamps
softDeletes softDeletes

payments

id bigIncrements
customer_id ^FK bigInteger
bill_id string
paid tinyInteger
paid_at datetime
amount integer
paid_amount integer
timestamps timestamps
softDeletes softDeletes

bookings

id bigIncrements
payment_id ^FK bigInteger
customer_id ^FK bigInteger
service_id ^FK bigInteger
island_id ^FK bigInteger
village_id ^FK bigInteger
name string
status string
timestamps timestamps
softDeletes softDeletes

rooms

id bigIncrements
name string
descriptions string
max_guests integer
price decimal (10,2)
quantity integer
timestamps timestamps
softDeletes softDeletes

accommodation_bookings

id bigIncrements
customer_id ^FK bigInteger
service_id ^FK bigInteger
room_id ^FK bigInteger
check_in datetime
check_out datetime
total_price decimal (10,2)
total_days integer
timestamps timestamps
softDeletes softDeletes

activities

id bigIncrements
service_id ^FK bigInteger
duration string
min_participants integer
max_participants integer
price decimal (10,2)
timestamps timestamps
softDeletes softDeletes

activity_bookings

id bigIncrements
customer_id ^FK bigInteger
service_id ^FK bigInteger
activity_id ^FK bigInteger
num_participants integer
total_price decimal (10,2)
timestamps timestamps
softDeletes softDeletes

statuses

id bigIncrements
statusable_id bigInteger
statusable_type string
name string
descriptions string
timestamps timestamps
softDeletes softDeletes

images

id bigIncrements
image_type_id ^FK bigInteger
imageable_id bigInteger
imageable_type string
original_name string
path string
size integer
timestamps timestamps
softDeletes softDeletes

image_types

id bigIncrements
name string
timestamps timestamps
softDeletes softDeletes

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