park accountant 2 - Laravel Schema Designer

acc_supplier

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
email string
credit_limit double
currency_id integer
address text
division_id integer
division_place_id integer
place_id integer
control_account_id integer
available_credit double
status enum
account_payable double
money_status enum
user_id integer
accounts_payable double

acc_currency

id increments
timestamps timestamps
softDeletes softDeletes

acc_division

id increments
timestamps timestamps
softDeletes softDeletes

acc_place

id increments
timestamps timestamps
softDeletes softDeletes

acc_division_place

id increments
timestamps timestamps
softDeletes softDeletes

acc_control_accont

id increments
timestamps timestamps
softDeletes softDeletes

user

id increments
timestamps timestamps
softDeletes softDeletes

acc_purchase_quote

timestamps timestamps
softDeletes softDeletes
footer_id integer
supplier_id integer
date datetime
reference string
description text
title string
status enum
id increments
amount double
request_for_quotation boolean
withholding_tax_type enum
withholding_tax double
cancelled boolean
show_item_image boolean
sub_total double
total double
user_id integer
show_withholding_tax boolean

acc_footer

id increments
timestamps timestamps
softDeletes softDeletes

acc_purchase_order

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
footer_id integer
supplier_id integer
cancelled boolean
purchase_quote_id integer
date datetime
reference string
description text
quantity_receive integer
amount double
title string
status enum
sub_total double
total double
withholding_tax_type enum
withholding_tax double
show_item_image boolean
delivery_status enum
invoice_amount double
invoice_status enum
show_withholding_tax boolean

acc_item

id increments
timestamps timestamps
softDeletes softDeletes

acc_purchase_invoice

id increments
timestamps timestamps
softDeletes softDeletes
status enum
user_id integer
footer_id integer
supplier_id integer
date datetime
due_type enum
due_date datetime
day integer
reference string
description text
amount double
title string
sub_total double
total double
withholding_tax_type enum
withholding_tax double
closed_invoice boolean
show_item_image boolean
show_withholding_tax boolean
balance_due double
days_to_due_date integer
days_overdue integer
sales_quote_id integer
sales_order_id integer

acc_debit_note

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
supplier_id integer
purchase_invoice_id integer
description text
amount double
title string
tax_inclusive boolean
total double
footer_id integer
sub_total double

acc_goods_receipt

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
purchase_order_id integer
purchase_invoice_id integer
supplier_id integer
inventory_id integer
description text
quantity integer
title string
footer_id integer

acc_inventory

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
user_id integer
status enum

acc_inventory_item

id increments
timestamps timestamps
softDeletes softDeletes
code string
name_en string
name_ar string
unit_name_en string
unit_name_ar string
division_id integer
place_id integer
divison_place_id string
control_account_id integer
production_stage integer
quantity_desired integer
receive boolean
deliver boolean
income_account_id integer
expense_account_id integer
description_en text
description_ar string
purchase_price double
unit_price double
sales_division_id integer
sales_place_id integer
sales_division_place_id integer
tax_code_id integer
hide_name boolean
average_cost double
total_quantity integer
quantity_on_hand integer
quantity_to_deliver integer
quantity_available integer
quantity_to_receive integer
quantity_be_available integer
quantity_to_order integer
obsolete_quantity_to_receive integer
obsolete_quantity_to_deliver integer
obsolete_quantity_on_hand integer
quantity_owned integer
total_cost double
user_id integer
status enum
sales_price double

acc_tax_code

id increments
timestamps timestamps
softDeletes softDeletes
name string
code double
user_id integer
label string
tax_rate enum
invoice_title string
credit_note_title string
balance_sheet_account_id integer
custome_type enum
rate decimal
reverse_charged string
net_reporting_category_id integer
net_reporting_category_reversed_id integer
amount_reporting_category_reversed_id integer
amount_reporting_category_id integer
status enum

acc_item_store

id increments
timestamps timestamps
softDeletes softDeletes
inventory_item_id integer
quantity integer
inventory_id integer
inventory_transfer_id integer
inventory_write_off_id integer
production_order_id integer
user_id integer
average_cost integer
description text
inventory_kit_id integer

acc_balance_sheet_account

id increments
timestamps timestamps
softDeletes softDeletes

acc_profit_loss_account

id increments
timestamps timestamps
softDeletes softDeletes

acc_inventory_transfer

id increments
timestamps timestamps
softDeletes softDeletes
date integer
reference string
from_inventory_id integer
to_inventory_id integer
description text
total integer
quantity integer
user_id integer

acc_inventory_write_off

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
reference string
description text
inventory_id integer
balance_sheet_account_id integer
profit_loss_account_id integer
division_id integer
place_id integer
division_place_id integer
project_id integer
total integer
user_id integer
tax_code_id integer

acc_project

id increments
timestamps timestamps
softDeletes softDeletes
name string
income double
direct_cost double
profit double
status enum
user_id integer
code string

acc_production_order

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
reference string
description text
inventory_id integer
finished_item_id integer
quantity integer
status enum
production_cost boolean
total double
user_id integer

acc_production_cost

id increments
timestamps timestamps
softDeletes softDeletes
balance_sheet_account_id integer
profit_loss_accoun_id integer
amount double
production_order_id integer
division_id integer
place_id integer
division_place_id integer
user_id integer

acc_employee

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
employee_id integer
currency_id integer
division_id integer
division_place_id integer
place_id integer
control_account_id integer
address text
starting_balance_type enum
starting_balance double
status enum

employee

id increments
timestamps timestamps
softDeletes softDeletes

acc_payslip

id increments
timestamps timestamps
softDeletes softDeletes
user_id string
employee_id integer
acc_employee_id integer
footer_id integer
date datetime
description text
refrence string
show_total boolean
title string
from_date datetime
gross_pay double
deduction double
net_pay double
contribution double

acc_payslip_contribution

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
payslip_id integer
payslip_item_id integer
division_place_id integer
division_id integer
place_id integer
description string
amount double
recurring_transaction_id integer

acc_payslip_deduction

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
payslip_id integer
payslip_item_id integer
division_id integer
place_id integer
division_place_id integer
description string
amount double
recurring_transaction_id integer

acc_payslip_earning

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
payslip_id integer
payslip_item_id integer
place_id integer
division_id integer
division_place_id integer
project_id integer
description string
unit_number integer
unit_price double
amount double
recurring_transaction_id integer

acc_investment

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
currency_id integer
control_account_id integer
code string
name_en string
name_ar string
market_price double
quantity integer
total_cost double
status enum
average_cost double
market_value double
unrealized_gain double

acc_investment_revaluation

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
description text
fixed_asset_id integer
realized_gain double
division_id integer
place_id integer
division_place_id integer

acc_investment_revaluation_item

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
investment_id integer
realized_gain double
investment_revaluation_id integer

acc_fixed_asset

id increments
timestamps timestamps
softDeletes softDeletes
code string
name_en string
name_ar string
depreciation_rate decimal
description text
user_id integer
division_id integer
place_id integer
division_place_id integer
control_account_cost_id integer
control_account_depreciation_id integer
acquisition_cost double
acccumulated_depreciation double
profit_loss_account_id integer
date_disposal datetime
disposal_account_id integer
status enum
book_value double
depreciation double

acc_asset_entry

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
description text
amount double

acc_asset_entry_item

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
fixed_asset_id integer
intangible_asset_id integer
division_id integer
place_id integer
division_place_id integer
amount double
depreciation_entry_id integer
amortization_entry_id integer

acc_intangible_asset

id increments
timestamps timestamps
softDeletes softDeletes
code string
name_en string
name_ar string
amortization_rate decimal
description text
user_id integer
division_id integer
place_id integer
division_place_id integer
control_account_cost_id integer
control_account_amortization_id integer
acquisition_cost double
acccumulated_amortization double
profit_loss_account_id integer
date_disposal datetime
disposal_account_id integer
status enum
book_value double
amortization double

acc_currency_revaluation

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
total_item double
total_gain double
unrealized_gain double
description text
user_id integer

acc_journal_entry

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
reference string
currency_id integer
description text
cash_transaction boolean
user_id integer
footer_id integer
status enum
accounts string
debit double
credit double

acc_currency_revaluation_item

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
currency_revaluation_id integer
profit_loss_account_id integer
balance_sheet_account_id integer
gain_loss_value double
control_account_id integer
description text
special_account_id integer
supplier_id integer
customer_id integer
employee_id string
bank_account_id integer
capital_account_id integer

Acc_currency_currency

id increments
timestamps timestamps
softDeletes softDeletes
currency_id integer
currency_revaluation_id integer
realized_gain double
user_id integer

acc_special_account

id increments
timestamps timestamps
softDeletes softDeletes

acc_capital_account

id increments
timestamps timestamps
softDeletes softDeletes

acc_bank_account

id increments
timestamps timestamps
softDeletes softDeletes

acc_customer

id increments
timestamps timestamps
softDeletes softDeletes

acc_tax_code_custom

id increments
timestamps timestamps
softDeletes softDeletes
name string
rate decimal
balance_sheet_account_id integer
user_id integer
tax_code_id integer
amount_reporting_category_id integer

acc_currency_exchange

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
currency_id integer
rate integer
transaction double
user_id integer

acc_currency_exchange_transaction

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
base_amount double
exchange_amount double
currency_exchange_id integer
user_id integer

acc_forecast

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
repeat enum
growth double
description string
amount double
status enum

acc_recurring_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
user_id integer

acc_recurring_transaction

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
interval_duration integer
interval_type enum
description integer
total double
show_total boolean
title string
until_type enum
until_date datetime
amount double
user_id integer
footer_id integer
category_id integer
employee_id integer
paid_from_bank_account_id integer
received_in_bank_account_id integer
currency_id integer
customer_id integer
supplier_id integer
paid_by_type enum
other_name string
due_date datetime
billing_address string
from_date integer

acc_inventory_kit

id increments
timestamps timestamps
softDeletes softDeletes
code string
name_en string
name_ar string
unit_name_en string
unit_name_ar string
division_id integer
place_id integer
division_place_id integer
description string
sales_price double
sales_division_id integer
sales_division_place_id integer
sales_place_id integer
tax_code_id integer
income_account_id integer
user_id integer
status enum
unit_price double

acc_non_inventory_item

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name_ar string
name_en string
unit_name_en string
unit_name_ar string
sold_balance_sheet_account_id integer
purchased_balance_sheet_account_id integer
sold_profit_loss_account_id integer
purchased_profit_loss_account_id integer
description string
sales_price double
purchase_price double
tax_code_id integer
division_place_id integer
place_id integer
division_id integer
status enum
unit_price double

acc_lock_date

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
lock_accounting_period boolean
date datetime

acc_bank_rule

id increments
timestamps timestamps
softDeletes softDeletes
user_id string
type enum
bank_account_id integer
amount double
amount_type enum
description string
paid_by_type enum
other_name string
customer_id integer
supplier_id integer

acc_inventory_item_amount

id increments
timestamps timestamps
softDeletes softDeletes
inventory_item_id integer
quantity integer
inventory_id integer
description text
user_id integer

acc_payslip_item

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
status enum
user_id integer
category_id integer
balance_sheet_acount_id integer
profit_loss_account_id integer
reporting_category_id integer

acc_payslip_item_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
user_id integer

acc_reporting_category_type

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name_en string
name_ar string
parent_id integer

acc_reporting_category

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
category_id integer
name_en string
name_ar string