bullbrokers - Laravel Schema Designer

companies

id increments
name string (255)
email string (255)
phone string
website string
kid_code string (10)
type string
number_of_employees integer
connectivity string
contact_person enum
timestamps timestamps
softDeletes softDeletes

main_addresses

id increments
company_id ^FK integer
type enum
address string
additional_address string
city string
timestamps timestamps
softDeletes softDeletes

invoice_details

id increments
company_id ^FK integer
bulstat string
vat_number string
mol string
address string
timestamps timestamps
softDeletes softDeletes

company_services

id increments
company_id ^FK integer
service_id ^FK integer
is_active tinyInteger
activated_at timestamp
timestamps timestamps
softDeletes softDeletes

manual_parameters

id increments
company_id ^FK integer
user_id ^FK integer
text text
timestamps timestamps
softDeletes softDeletes

users

id increments
company_id ^FK integer
timestamps timestamps
softDeletes softDeletes

submitted_data

id increments
company_id ^FK integer
user_id ^FK integer
softDeletes softDeletes
status enum
timestamps timestamps
completed_at timestamp

programs

id increments
year string (4)
name string (255)
max_perc_co_financing float (3,2)
date_of_announcement timestamp
submission_deadline timestamp
is_state_aid tinyInteger
is_min_aid tinyInteger
max_bfp_sum float
timestamps timestamps
softDeletes softDeletes

program_service

id increments
program_id ^FK integer
service_id ^FK integer
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

company_program

id increments
company_id ^FK integer
program_id ^FK integer
timestamps timestamps
softDeletes softDeletes

services

id increments
is_financial_param tinyInteger
name string (255)
recommendations text
timestamps timestamps
softDeletes softDeletes

templates

id increments
name string (255)
is_active integer
timestamps timestamps
softDeletes softDeletes

service_template

id increments
timestamps timestamps
softDeletes softDeletes
service_id ^FK integer
template_id ^FK integer

ranges

id increments
template_id ^FK integer
from float
to float
points integer
timestamps timestamps
softDeletes softDeletes

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