Imagine - Laravel Schema Designer

roles

id increments
name string
slug string
description text
timestamps timestamps

users

id bigIncrements
username string (100)
name string (100)
last_name string (100)
email string (100)
password string (500)
picture string (500)
register_ip string (15)
rememberToken rememberToken
forget_token string (100)
activation_key string (100)
softDeletes softDeletes
timestamps timestamps

permissions

id increments
slug string
name string
description text
config text
enabled boolean
timestamps timestamps

permission_role

id increments
permission_id ^FK integer
role_id ^FK integer
timestamps timestamps

role_user

id increments
role_id ^FK integer
user_id ^FK bigInteger
timestamps timestamps

login_attempts

id increments
user_id ^FK bigInteger
login_ip string (15)
login_time timestamp
browser_agent string (100)
success boolean

permission_user

id increments
permission_id ^FK integer
user_id ^FK bigInteger
timestamps timestamps

Log

id increments
timestamps timestamps

agencies

id increments
name string (100)
registered_name string (100)
rnc string (50)
email string (100)
phone string (20)
address text
description text
enable boolean
timestamps timestamps
softDeletes softDeletes

agents

id increments
name string (100)
phone string (20)
timestamps timestamps
softDeletes softDeletes

hotels

id increments
name string (100)
address text
description text
enable boolean
timestamps timestamps
softDeletes softDeletes

hotel_location

id increments
name string (150)
address text
collection_location text
collection_time time
hotel_id ^FK integer
timestamps timestamps
enable boolean
softDeletes softDeletes

packages

id increments
name string (100)
drinks integer
price decimal (10,4)
active boolean
upgrade_from ^FK integer
timestamps timestamps

reservations

id increments
hotel_id ^FK integer
agency_id ^FK integer
route_id ^FK integer
voucher_code string (20)
agent_name string (100)
agent_phone string (20)
date date
status string (50)
timestamps timestamps
softDeletes softDeletes

reservation_packages

id increments
inherit_id ^FK integer
reservation_id integer
reseptionist_id ^FK bigInteger
name string (100)
drinks integer
price decimal (10,4)
pax integer
total decimal (10,4)
pax_name string (100)
room string (100)
country_id ^FK integer
was_upgrated boolean
upgrade_id ^FK integer
timestamps timestamps

countries

id increments
iso string (5)
name string (100)

vouchers

id increments
reservation_id ^FK integer
voucher_code string (20)
agent_name string (100)
agent_phone string (20)
hotel_name string (100)
hotel_address text
agency_name string (100)
agency_rnc string (50)
agency_phone string (20)
agency_address text
route_name string (100)
route_address text
route_collection_location text
route_collection_time time
grand_total decimal (10,4)
status string (50)
timestamps timestamps
softDeletes softDeletes

package_actions

id increments
reseptionist_id ^FK bigInteger
reservation_package_id ^FK integer
action_id ^FK integer
pax integer
date date
timestamps timestamps

actions

id increments
name string (100)
description text
enabled boolean

sold_packages

id increments
inherit_id ^FK integer
direct_sells_id ^FK integer
package_name string (100)
price decimal (10,4)
pax integer
total decimal (10,4)
timestamps timestamps

direct_sells

id increments
seller_id ^FK bigInteger
grand_total decimal (10,4)
is_credit_card boolean
timestamps timestamps
cc_confirmation_code string (25)

sells

id increments
seller_id ^FK bigInteger
sellable_type string (50)
sellable_id integer
grand_total decimal (10,4)
timestamps timestamps
softDeletes softDeletes

vip_sells

id increments
seller_id ^FK bigInteger
pax integer
total_price decimal (10,4)
table_code string (20)
timestamps timestamps
softDeletes softDeletes

currencies

id increments
name string (50)
code string (20)
conversion_rate decimal (10,4)

currency_configs

id increments
currency_id ^FK integer
key string (50)
value decimal (10,4)
enabled boolean
timestamps timestamps

cash_count

id increments
supevisor_id ^FK bigInteger
cashier_id ^FK bigInteger
closing_time datetime
total decimal (10,4)
timestamps timestamps

cash_count_money

id increments
cash_count_id ^FK integer
currency_config_id ^FK integer
quantity integer
amount decimal (10,4)
timestamps timestamps
cash_count_total_id ^FK integer

cash_count_totals

id increments
cash_count_id ^FK integer
currency_id ^FK integer
total decimal (10,4)
conversion_rate decimal (10,4)
timestamps timestamps

special_event

id increments
nombre string (100)
date date
event_price decimal (10,4)
description text
timestamps timestamps
softDeletes softDeletes

notes

id increments
body text
commentable_type string (30)
commentable_id integer
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger

route

id increments
name string (150)
enable boolean
timestamps timestamps

hotel_route

id increments
hotel_id ^FK integer
route_id ^FK integer
softDeletes softDeletes

route_details

id increments
reservation_id ^FK integer
hotel_name string (150)
collection_location string (150)
collection_time string (150)
timestamps timestamps

dayprice

id increments
day string (25)
package_id ^FK integer
price decimal (10,4)
timestamps timestamps
softDeletes softDeletes