smart_tax - Laravel Schema Designer

issuing_services

id increments
code string (2)
name string
status smallInteger
is_system smallInteger
timestamps timestamps

items

id increments
type_id ^FK integer
base_unit_id ^FK integer
code string (50)
name string
description text
barcode string
assortment_id ^FK integer
brand_id ^FK integer
brand_model_id ^FK integer
legal_basis string
regulation_chapter string (5)
regulation_section string (5)
regulation_article string (5)
regulation_number string (5)
regulation_item string (5)
image string
remarks text
status smallInteger
is_system smallInteger
timestamps timestamps

item_types

id increments
code char (1)
name string
status smallInteger
is_system smallInteger
timestamps timestamps

regions

id increments
code string (5)
name string
country_id ^FK integer
culture_id ^FK integer
time_zone_id ^FK integer
status smallInteger
timestamps timestamps

tax_classes

id increments
code string (5)
name string
edifact5153 string (5)
status smallInteger
is_system smallInteger
timestamps timestamps

withholding_tax_types

id increments
name string
description string
country_id ^FK integer
beneficiary_entity_id integer
fiscal_witholding_tax_type_id ^FK integer
base_includes_discount smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

units

id increments
code string (5)
name string
symbol string (3)
precision_digits smallInteger
unecerec20 string (5)
is_dimension_base_unit smallInteger
unit_dimension_id ^FK integer
conversion_factor decimal
formula string
status smallInteger
timestamps timestamps

unit_dimensions

id increments
name string
base_unit_id ^FK integer
status smallInteger
timestamps timestamps

cultures

id increments
code string (5)
name string
status smallInteger
timestamps timestamps

countries

id increments
code char
name string
culture_id ^FK integer
calling_code smallInteger
number_format string (20)
date_format string (20)
eu_member smallInteger
status smallInteger
timestamps timestamps

series

id increments
name string
description string
start_number integer
end_number integer
start_at date
end_at date
status smallInteger
is_system smallInteger
timestamps timestamps

issuing_stations

id increments
issuing_service_id ^FK integer
user_id integer
code string (2)
name string
status smallInteger
is_system smallInteger
timestamps timestamps

currencies

id increments
code string (3)
iso_code string (3)
name string
symbol string
fraction_digits smallInteger
prices_fraction_digits smallInteger
start_at datetime
end_at datetime
timestamps timestamps

item_files

id increments
item_id ^FK integer
filename string
timestamps timestamps

tax_regional_areas

id increments
name string
description string
country_id ^FK integer
region_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

time_zones

id increments
name string
status smallInteger
timestamps timestamps

tax_sub_classes

id increments
code string (5)
name string
tax_class_id ^FK integer
edifact5305 string (5)
status smallInteger
is_system smallInteger
timestamps timestamps

exemption_reason_codes

id increments
name string
description string
tax_class_id ^FK integer
remarks text
start_at datetime
end_at datetime
status smallInteger
is_system smallInteger
timestamps timestamps

fiscal_document_types

id increments
name string
description string
fiscal_use_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

tax_type_codes

id increments
name string
description string
print_code string
base_value_id ^FK integer
tax_class_id ^FK integer
tax_sub_class_id ^FK integer
tax_regional_area_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

tax_type_base_values

id increments
name string
status smallInteger
is_system smallInteger
timestamps timestamps

party_tax_schemas

id increments
name string
description string
allowed_in integer
status smallInteger
is_system smallInteger
timestamps timestamps

party_tax_schema_items

id increments
party_tax_schema_id ^FK integer
tax_type_code_id ^FK integer
exemption_reason_code_id ^FK integer
is_exempt smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

tax_code_rates

id increments
tax_type_code_id ^FK integer
value decimal
name string
deductible decimal
start_at datetime
end_at datetime
status smallInteger
is_system smallInteger
timestamps timestamps

item_tax_schemas

id increments
name string
description string
is_default_exempt smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

item_tax_schema_tax_type_codes

id increments
item_tax_schema_id ^FK integer
tax_type_code_id ^FK integer
timestamps timestamps

brands

id increments
name string
description string
image string
remarks text
status smallInteger
is_system smallInteger
timestamps timestamps

brand_models

id increments
brand_id ^FK integer
name string
description string
remarks text
status smallInteger
timestamps timestamps

assortments

id increments
name string
description string
remarks text
status smallInteger
is_system smallInteger
timestamps timestamps

economic_activity_classifications

id increments
name string
description string
status smallInteger
is_system smallInteger
timestamps timestamps

item_subtypes

id increments
name string
fiscal_classification_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

fiscal_classifications

id increments
code char (1)
name string
status smallInteger
is_system smallInteger
timestamps timestamps

item_sales

id increments
unit_id ^FK integer
revenue_classification_id ^FK integer
item_tax_schema_id ^FK integer
item_withholding_tax_schema_id integer
income_account_id integer
locked smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

item_materials

id increments
item_subtype_id ^FK integer
max_stock decimal
max_stock_decimal_places smallInteger
min_stock decimal
min_stock_decimal_places smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

fiscal_witholding_tax_types

id increments
name string
description string
status smallInteger
is_system smallInteger
timestamps timestamps

withholding_tax_codes

id increments
name string
description string
withholding_tax_type_id ^FK integer
amount_base_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

withholding_tax_rates

id increments
withholding_tax_code_id ^FK integer
value decimal
description string
start_at datetime
end_at datetime
status smallInteger
is_system smallInteger
timestamps timestamps

withholding_tax_base_values

id increments
status smallInteger
is_system smallInteger
timestamps timestamps
name string

party_withholding_tax_schemas

id increments
name string
description string
status smallInteger
is_system smallInteger
timestamps timestamps

party_withholding_tax_schema_items

id increments
party_withholding_tax_schema_id ^FK integer
withholding_tax_code_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

item_withholding_tax_schemas

id increments
name string
description string
status smallInteger
is_system smallInteger
timestamps timestamps

item_withholding_tax_schema_withholding_tax_code

id increments
item_withholding_tax_schema_id ^FK integer
withholding_tax_code_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

fiscal_uses

id increments
name string
status smallInteger
is_system smallInteger
timestamps timestamps

revenues_classifications

id increments
code string
name string
remarks text
status smallInteger
is_system smallInteger
timestamps timestamps

expenses_classifications

id increments
timestamps timestamps

account_types

id increments
account_type_id ^FK integer
is_groupable smallInteger
code integer
name string
direct_posting smallInteger
hide_in_p_and_l smallInteger
hide_when_has_no_entries smallInteger
locked smallInteger
income_statement_type_id integer
status smallInteger
is_system smallInteger
timestamps timestamps

accounts

id increments
code integer
name string
account_type_id ^FK integer
cost_account_id integer
default_item_tax_schema_id ^FK integer
remarks text
locked smallInteger
is_sales_profit_account smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

Income_statement_types

id increments
timestamps timestamps

chart_accounts

id increments
timestamps timestamps
code string

exchange_rates

id increments
timestamps timestamps

invoice_types

id increments
name string
description string
fiscal_document_type_id ^FK integer
cash_invoice smallInteger
notification_id integer
contact_type_id ^FK integer
default_financial_account_id integer
default_cash_flow_item_id integer
default_credit_memo_type_id ^FK integer
default_debit_memo_type_id ^FK integer
default_memo_reason_id integer
document_note string
document_note_title string
status smallInteger
is_system smallInteger
timestamps timestamps

order_types

id increments
name string
description string
fiscal_document_type_id ^FK integer
order_nature_id ^FK integer
delivery_on_invoice smallInteger
notification_id integer
contact_type_id ^FK integer
default_delivery_type_id integer
default_invoice_type_id ^FK integer
default_goods_receipt_note_type_id integer
default_memo_type_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

quotation_types

id increments
name string
description string
fiscal_document_type_id ^FK integer
notification_id integer
contact_type_id ^FK integer
status smallInteger
is_system smallInteger
timestamps timestamps

memo_types

id increments
name string
description string
fiscal_document_type_id ^FK integer
accounting_nature_id ^FK integer
automatically_settled smallInteger
notification_id integer
contact_type_id ^FK integer
default_financial_account_id smallInteger
default_cash_flow_item_id smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

accounting_natures

id increments
name string
status smallInteger
is_system smallInteger
timestamps timestamps

contact_types

id increments
name string
description string
is_main_contact_type smallInteger
status smallInteger
is_system smallInteger
timestamps timestamps

document_type_series

id increments
seriable_id integer
seriable_type string
serie_id ^FK integer
is_default smallInteger
number_copies smallInteger
tax_included smallInteger
economic_activity_classification_id ^FK integer
communication_type_id integer
status smallInteger
is_system smallInteger
timestamps timestamps

communication_types

id increments
name string
status smallInteger
is_system smallInteger
timestamps timestamps

order_natures

id increments
name string
status smallInteger
is_system smallInteger
timestamps timestamps

document_type_issuing_services

id increments
serviceable_id integer
serviceable_name string
status smallInteger
is_system smallInteger
timestamps timestamps

itemables

id increments
item_id ^FK bigInteger
itemable morphs
timestamps timestamps
softDeletes softDeletes