erp - Laravel Schema Designer

tmp_customers

id increments
name string (100)
national_id integer
phone string (20)
role_type string (100)
status boolean
timestamps timestamps
softDeletes softDeletes
expected_sales_price double
expected_activity_price double

tmb_jack_customers

id increments
customer_id integer
comercial_number string (100)
tax_number string (100)
dues double
last_settlement_date date
marketer_id integer
daily_expected_amount double
registration_type enum
manger_name string (100)
discount double
timestamps timestamps
softDeletes softDeletes
clasification_n enum
manager_id ^FK bigInteger

tmp_maak_customer

id increments
customer_id integer
Monthly_income double
Monthly_dues double
Calculator_id integer
Contract_number string (100)
timestamps timestamps
softDeletes softDeletes
fund_amount double
marketing_id integer

tmp_pay_customers

id increments
customer_id integer
timestamps timestamps
softDeletes softDeletes
marketer_id integer
pay_vendor_id integer

tmp_pay_customer_cards

id increments
pay_customer_id integer
amount double
type enum
status boolean
timestamps timestamps
softDeletes softDeletes

tmp_pay_vendor

id increments
customer_id integer
is_jack boolean
status boolean
timestamps timestamps
softDeletes softDeletes
reconciliation double

tmp_customer_bank_account

id increments
customer_id integer
bank_name string (100)
IBan string (100)
Acc_number string (100)
status boolean
timestamps timestamps
softDeletes softDeletes

tmp_maak_transactions

id increments
timestamps timestamps
softDeletes softDeletes
Tracation_number integer
value double
maak_customer_id integer
jack_customer_id integer
status boolean
is_reconciliation boolean

tmp_maak_transaction_attachments

id increments
timestamps timestamps
softDeletes softDeletes
transaction_id integer
file string (100)

tmp_installments

id increments
timestamps timestamps
softDeletes softDeletes
transaction_id integer
Instelemnt_id string (100)
value double
jack_customer_id integer
maak_customer_id integer
due_date time
Payment_status enum
Payment_date date
Delay_fee double

customer_notes

id increments
timestamps timestamps
softDeletes softDeletes
customer_id integer
Employee_id integer
Notes longText

Collection_orders

id increments
maak_customer_id integer
timestamps timestamps
softDeletes softDeletes
order_number string (100)
Title string (100)
Descaption longText
Type enum
status boolean

collection_order_attacachemnt

id increments
timestamps timestamps
softDeletes softDeletes
collection_order_id integer
file string (100)

order_life_cycles

id increments
timestamps timestamps
softDeletes softDeletes
collection_order_id integer
Management_id integer
Management_name string (100)
Notes longText
Status boolean

tmp_pay_transactions

id increments
timestamps timestamps
softDeletes softDeletes
pay_customer_id integer
reciver_id integer
pay_card_id integer
amount double
type enum
is_reconciliation boolean

incomes

id increments
timestamps timestamps
softDeletes softDeletes
bond_no string (100)
treasury_id integer
income_type_id ^FK integer
dealing enum
Employee_id integer
customer_id ^FK integer
vendor_id ^FK integer
iban string (100)
Bank_id ^FK integer
check_number string (100)
check_date date
Management_id integer
income_number string (100)
Instelemnt_id ^FK integer
amount double
attachments json

treasuries

id increments
timestamps timestamps
softDeletes softDeletes

outcomes

id increments
timestamps timestamps
softDeletes softDeletes
bond_no string (100)
amount double
employee_id integer
vendor_id ^FK integer
dealing enum
source_treasury_id ^FK integer
destination_treasury_id ^FK integer
management_id integer
pay_type enum
customer_id ^FK integer
system_account_id ^FK integer
attachments json

treasury_transfers

id increments
timestamps timestamps
softDeletes softDeletes
transfer_number string (100)
amount double
employee_id integer
transfer_type enum
source_treasury_id ^FK integer
destination_treasury_id ^FK integer
Notes text
bank_id ^FK integer
check_number string (100)
check_date date
attachments json

system_accounts

id increments
timestamps timestamps
softDeletes softDeletes
reference_number string (100)
name string (100)
status boolean
account_type enum
symbole string (100)
parent_id ^FK integer
payment_check integer
collect_check boolean
note text

notifications

id increments
timestamps timestamps
softDeletes softDeletes
notification_number string
amount double
employee_id integer
complain_number string
notification_type enum
dealing enum
notification_name_id ^FK integer
management_id integer
attachments json
source_customer_id ^FK integer
destination_customer_id ^FK integer
source_bank_id ^FK integer
destination_bank_id ^FK integer
source_iban string (100)
destination_iban string

notification_names

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
notes text
status boolean

accounting_restrictions

id increments
timestamps timestamps
softDeletes softDeletes
restriction_number string (100)
employee_id integer
customer_id ^FK integer
restriction_type ^FK integer
document_number string (100)
description longText

restriction_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note text
status boolean

restriction_items

id increments
timestamps timestamps
softDeletes softDeletes
system_account_id ^FK integer
type enum
managment_id integer
amount double
note text
accounting_restriction_id ^FK integer

fi_custodies

id increments
timestamps timestamps
softDeletes softDeletes
invoice_number string (100)
tax_number string (100)
supplier_name string (100)
total_amount double
invoice_tax_value double
net_amount double
date date
managment_id integer
expense_type_id ^FK integer
attatchments json
cost_center_id integer
supply_employee_name string (150)
note text

fi_expense_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note text
status boolean

fi_assets

id increments
timestamps timestamps
softDeletes softDeletes
refrence_number string (100)
name string (100)
asset_category_id ^FK integer
purchase_date date
operation_date date
measure_value enum
tax enum
barcode string (100)
asset_account_id ^FK integer
value double
scrap_value double
expiration_date date
is_depreciable boolean
depreciation_expense_account ^FK integer
depreciation_collection_account ^FK integer
is_warranty boolean
warranty_date date
description text

fi_asset_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note text
status boolean
refrence_number string (100)
system_account_id ^FK integer
is_depreciable boolean
depreciable_rate double

asset_attachments

id increments
timestamps timestamps
softDeletes softDeletes
file string (100)
asset_id ^FK integer

income_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note text
status boolean

legal_consultings

id increments
timestamps timestamps
softDeletes softDeletes
employee_id integer
consulting_number string (100)
name string (100)
type enum

legal_consulting_attachments

id increments
timestamps timestamps
softDeletes softDeletes
file string (100)
consulting_id ^FK integer

legal_consulting_texts

id increments
timestamps timestamps
softDeletes softDeletes
consulting_id ^FK integer
note longText
status enum

legal_opinions

id increments
timestamps timestamps
softDeletes softDeletes
consulting_text_id ^FK integer
note longText

legal_company_lawsuits

id increments
timestamps timestamps
softDeletes softDeletes
isfailed_id integer
status enum
implementation_status enum
judicial_department_id ^FK integer
judicial_request string (100)
judicial_upload_date date
lawsuit_number string (100)
judicial_amount double
judicial_fee double
execution_id ^FK integer
customer_id ^FK integer
employee_id integer

legal_failed_status

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
status boolean

legal_judicial_departments

id increments
timestamps timestamps
softDeletes softDeletes
region_id ^FK bigInteger
court_id ^FK bigInteger
name string (100)
note longText

legal_company_lawsuit_executions

id increments
timestamps timestamps
softDeletes softDeletes
implementation_number string (100)
implementation_department_number string (100)
payment enum
payment_order_number string (100)

legal_decisions

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)

legal_execution_decisions

id increments
timestamps timestamps
softDeletes softDeletes
execution_id ^FK integer
decision_id ^FK integer

legal_payment_orders

id increments
timestamps timestamps
softDeletes softDeletes
payed_amount double
remaining_amount double
payed_date date
execution_id ^FK integer

legal_company_lawsuit_sessions

id increments
timestamps timestamps
softDeletes softDeletes
company_lawsuit_id ^FK integer
session_date date
note longText

legal_company_lawsuit_attatchments

id increments
timestamps timestamps
softDeletes softDeletes
file string (100)
company_lawsuit_id ^FK integer

legal_against_company_lawsuits

id increments
timestamps timestamps
softDeletes softDeletes
lawsuit_number string (100)
court_id ^FK bigInteger
judicial_department_id ^FK integer
lawsuit_upload_date date
status enum
reason text
judicial_fee double
claimant_name string (100)
claimant_identity string (100)
customer_id ^FK integer
employee_id integer

legal_against_company_lawsuit_sessions

id increments
timestamps timestamps
softDeletes softDeletes
against_company_lawsuit_id ^FK integer
session_date date
note longText

legal_against_company_lawsuit_attatchments

id increments
timestamps timestamps
softDeletes softDeletes
file string (100)
against_company_lawsuit_id ^FK integer

legal_power_attorney_texts

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note longText
status boolean

legal_power_attorney_items

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note longText
status boolean
parent bigInteger

legal_power_attorney_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
note longText
status boolean

legal_power_attorney

id increments
timestamps timestamps
softDeletes softDeletes
attorney_number string (100)
attorney_type_id ^FK bigInteger
attorney_status enum
duration smallInteger
category enum
previous_attorney_number string (100)
country_id ^FK bigInteger
client_employee bigInteger
agent_employee bigInteger
power_attorney_text_id ^FK bigInteger
power_attorney_item_id ^FK bigInteger

legal_countries

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
status boolean

legal_power_attorney_attachments

id increments
timestamps timestamps
softDeletes softDeletes
file string (100)
power_attorney_id ^FK bigInteger

legal_regions

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
status boolean
country_id ^FK bigInteger

legal_courts

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
status boolean
region_id ^FK bigInteger

legal_investigations

id increments
timestamps timestamps
softDeletes softDeletes
investigation_number string (100)
investigation_date date
employee_judge bigInteger
employee_accused bigInteger
subject string (100)
reason longText
result_status enum
result_note longText

legal_investigation_attachments

id increments
timestamps timestamps
softDeletes softDeletes
file string (100)
investigation_id ^FK bigInteger

legal_investigation_questions

id increments
timestamps timestamps
question string (150)
answer longText
investigation_id ^FK bigInteger

tmp_customer_attachments

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK bigInteger
file string (150)

tmp_jack_transactions

id increments
timestamps timestamps
softDeletes softDeletes
transaction_number integer
value double
is_reconciliation boolean
jack_customer_id integer
paymet_method enum

tpm_jack_transaction_attachments

id increments
timestamps timestamps
softDeletes softDeletes
jack_transaction_id bigInteger
file string (100)

risk_alert_settings

id increments
timestamps timestamps
softDeletes softDeletes
title string (150)
description longText

risk_alert_setting_items

id increments
timestamps timestamps
softDeletes softDeletes
field enum
coefficient enum
value string (150)
parent ^FK bigInteger
conection_type enum
status boolean
alert_setting_id bigInteger

risk_alerts

id increments
timestamps timestamps
softDeletes softDeletes
risk_setting_id ^FK bigInteger
jack_customer_id ^FK bigInteger
action enum
reasons longText

risk_alert_attachments

id increments
timestamps timestamps
softDeletes softDeletes
file string (150)
risk_alert_id ^FK bigInteger