OWNER-ACCOUNTANT-CRM - Laravel Schema Designer

covenants

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id integer

covenant_translations

id increments
timestamps timestamps
name string
locale string
covenant_id ^FK integer

covenant_stocks

id increments
timestamps timestamps
added_by_id integer
branch_id integer
covenant_id ^FK integer
type string
price double
parts_count integer
remain integer

covenant_stock_translations

id increments
timestamps timestamps
notes longText
locale string
covenant_stock_id ^FK integer

covenant_stock_option

id increments
timestamps timestamps
covenant_stock_id ^FK integer
option_id ^FK integer

options

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id integer

option_translations

id increments
timestamps timestamps
name string
locale string
option_id ^FK integer

subscription_settings

id increments
timestamps timestamps
softDeletes softDeletes

subscription_translations

id increments
name string
locale string
subscription_setting_id ^FK integer

subscription_types

id increments
timestamps timestamps
softDeletes softDeletes
added_by_id integer

subscription_type_translations

id increments
name string
locale string
subscription_type_id ^FK integer

clients

id increments
timestamps timestamps
softDeletes softDeletes
project_type string
name string
email string
mobile string
status string
responsible_employee string
notes longText

subscription

id increments
timestamps timestamps
softDeletes softDeletes
subscription_id ^FK integer
subscription_type string
received_date date
ended_date date
project_id integer
cost float

projects

id increments
timestamps timestamps
softDeletes softDeletes
type string
name string
code string
project_type_id string
price float
currency_id ^FK integer
have_copy_project string
copy_project_id ^FK integer
project_start_date date
project_end_date date
project_class_id integer
logo string
description longText
status string
start_technical_support date
end_technical_support date
technical_support_duration float
technical_support_duration_type string
client_id ^FK integer

project_types

id increments
timestamps timestamps
softDeletes softDeletes
name string

project_classes

id increments
timestamps timestamps
softDeletes softDeletes
name string

project_categories

id increments
timestamps timestamps
project_id ^FK integer
category_id integer

project_branches

id increments
timestamps timestamps
project_id ^FK integer
branch_id integer

banks

id increments
timestamps timestamps
softDeletes softDeletes
name string

invoices

id increments
timestamps timestamps
softDeletes softDeletes
invoice_number string
company_name string
email string
mobile_code string
mobile string
company_address string
visa_number string
country_id string
bank_id string
swift_code string
international_bank_account_number string
bank_account string

invoices_due

id increments
timestamps timestamps
invoice_id ^FK integer
date date
tax float
discount float
pricr float
item_name string

project_files

id increments
timestamps timestamps
project_id ^FK integer
file_type string
file_name string
step_name string
value string

project_attached_data

id increments
timestamps timestamps
project_id ^FK integer
platform_name string
platform_url string
user_name string
password string

project_platforms

id increments
timestamps timestamps
project_id ^FK integer
logo string
name string

project_links

id increments
timestamps timestamps
project_id ^FK integer
project_platform_id ^FK integer
app_name string
url string

project_third_party_integrations

id increments
timestamps timestamps
integration_name string
company_name string
contacted boolean
categories json

project_plans

id increments
timestamps timestamps
project_id ^FK integer
step_id ^FK integer
start_date date
days_count integer
end_date date
color_id integer
file string

steps

id increments
timestamps timestamps
softDeletes softDeletes
name string

project_steps

id increments
timestamps timestamps
project_id ^FK integer
step_id ^FK integer
category_id integer
start_date date
end_date date
have_qc string

project_step_groups

id increments
timestamps timestamps
project_id ^FK integer
project_step_id ^FK integer
app_name string
group_name string
start_date date
end_date date

project_members

id increments
timestamps timestamps
project_id ^FK integer
employee_id integer

projects_reports

id increments
timestamps timestamps
project_id ^FK integer
report_type string
title string
date date
start_time string
end_time string
description string
links string

project_testers

id increments
timestamps timestamps
project_id ^FK integer
employee_id integer

currencies

id increments
timestamps timestamps
softDeletes softDeletes
name string