bcs - Laravel Schema Designer

services

id increments
timestamps timestamps
name string
description text
price_type tinyInteger
have_domain tinyInteger
renew_type tinyInteger
service_group_id integer
type tinyInteger

safes

id increments
timestamps timestamps
current_balance float (10,2)
currency tinyInteger
name string

service_groups

id increments
timestamps timestamps
name string

clients

id increments
timestamps timestamps
support_code string
name string
organization string
country_id integer
address text
telephone string
activity tinyInteger
know_us_from string

subscriptions

id increments
timestamps timestamps
client_id integer
software_serial string
date date
domain string
price float (10,2)
agent_id integer
agent_percentage float (10,2)
net_price float (10,2)
payment_method integer
payment_status integer
payment_date date
renew string

client_payments

id increments
timestamps timestamps
client_id integer
date date
safe_id integer
amount float (10,2)
service_id integer

transactions

id increments
timestamps timestamps
date string
transaction_item_id integer
safe_id integer
notes text
type tinyInteger

tickets

id increments
timestamps timestamps
title string
body string
client_id integer
product string
status tinyInteger

advertisements

id increments
timestamps timestamps
title string
body text
image string

agents

id increments
timestamps timestamps
name string
responsible string
country_id integer
telephone string
details string

transaction_items

id increments
timestamps timestamps
name string
type tinyInteger

change_devices

id increments
timestamps timestamps
client_id integer
old_pc_serial string
reason text

countries

id increments
timestamps timestamps
name string

country_service

id increments
timestamps timestamps
service_id integer
country_id integer
price float (10,2)
min_price float

ticket_replies

id increments
timestamps timestamps
client_id integer
user_id integer
ticket_id integer
text text

users

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

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