tax - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
ar_name string (255)
en_name string (255)
email string (255)
email_verified_at timestamp
password string (255)
remember_token string (500)
last_token string (500)
role_id ^FK integer

entity_actions

id increments
timestamps timestamps
softDeletes softDeletes
action string
notes string (500)
user_id ^FK integer
entity_id ^FK integer

entity_additions

id increments
timestamps timestamps
softDeletes softDeletes
addition_id ^FK integer
entity_package_id ^FK integer
purchased_quota bigInteger
available_quota bigInteger
price float

entity_package

id increments
timestamps timestamps
softDeletes softDeletes
package_id ^FK integer
entity_id ^FK integer
name string (255)
duration bigInteger
purchased_quota bigInteger
available_quota bigInteger
price float
end_date timestamp
start_date timestamp
status integer

package

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
duration integer
quota bigInteger
price float
status integer
user_id ^FK integer

package_logs

id increments
timestamps timestamps
softDeletes softDeletes
package_id ^FK integer
name string (255)
duration integer
quota bigInteger
price float
status integer

user_passwords

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
password string (255)

attachment

id increments
timestamps timestamps
softDeletes softDeletes
attachment_type integer
attachment_id ^FK integer
url string (255)
file_name string (255)
type integer

entities

id increments
timestamps timestamps
softDeletes softDeletes
ar_name string (255)
en_name string (255)
ar_address string (500)
en_address string (255)
tax_registration_number string (255)
commercial_registration_number string (255)
joining_purpose string (255)
phone_number string (255)
ar_representative_name string (255)
en_representative_name string (255)
representative_mobile_number string (20)
representative_national_id integer
ar_representative_administrative_position string (255)
en_representative_administrative_position string (255)
ar_representative_department string (255)
en_representative_department string (255)
ar_representative_division string (255)
en_representative_division string (255)
notes string (500)
request_status integer
request_code integer
end_date timestamp

entity_activations

id increments
timestamps timestamps
softDeletes softDeletes
payment_transaction_id ^FK integer
entity_id ^FK integer
purchased_activation_count bigInteger
purchased_month_count bigInteger
activation_price float
activation_id ^FK integer
availabe_activation bigInteger
end_date timestamp
start_date timestamp
status integer

annual_activation_price

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
price float
role_id ^FK integer

additions

id increments
timestamps timestamps
softDeletes softDeletes
quota bigInteger
price float
status integer
user_id ^FK integer

additions_logs

id increments
timestamps timestamps
softDeletes softDeletes
addition_id ^FK integer
quota bigInteger
price float

integration_logs

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
request_body json
request_response json
url string (255)
method string (10)
status_code string (4)

roles

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)

payment_transactions

id increments
timestamps timestamps
softDeletes softDeletes
entity_id ^FK integer
transaction_id integer
transaction_status integer
role_id ^FK integer
package_id ^FK integer
addition_id ^FK integer
total_amount float
status integer

verified_mails

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
email string (255)
status integer
type_code integer
token string (255)

annual_activation_price_logs

id increments
timestamps timestamps
softDeletes softDeletes
activation_id ^FK integer
name string (500)
price float
user_id ^FK integer

entity_users

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
branch_id ^FK integer
start_date timestamp
end_date datetime
phone_number string (12)
en_team string (255)
ar_team string (255)
ar_department string (255)
en_department string (255)
national_id string (30)
status integer

checker_reviewer

id increments
timestamps timestamps
softDeletes softDeletes
checker_id ^FK integer
reviewer_id ^FK integer

checker_requests

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
status integer
request_code string (4)
employee_national_id string (24)

entity_annual_logs

id increments
timestamps timestamps
softDeletes softDeletes
entity_id ^FK integer
price float

payment_logs

id increments
timestamps timestamps
softDeletes softDeletes
entity_id ^FK integer
payment_transaction_id ^FK integer
status integer
total_amount float

blocked_domain

id increments
timestamps timestamps
softDeletes softDeletes
domain string (255)
user_id ^FK integer

checker_quota

id increments
timestamps timestamps
softDeletes softDeletes
entity_user_id ^FK integer
branch_id ^FK integer
purchased_quota bigInteger
available_quota bigInteger

entity_users_activations_logs

id increments
timestamps timestamps
softDeletes softDeletes
entity_user_id ^FK integer
branch_id ^FK integer
start_date datetime
end_date datetime
status integer

branch

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
entity_id ^FK integer
en_name string (255)
ar_name string (255)

branch_activations

id increments
timestamps timestamps
softDeletes softDeletes
branch_id ^FK integer
purchased_activation_count bigInteger
purchased_month_count bigInteger
availabe_activation bigInteger
end_date datetime
start_date datetime

branch_quota

id increments
timestamps timestamps
softDeletes softDeletes
branch_id ^FK integer
purchased_quota bigInteger
available_quota bigInteger