Model Company

namespace HubletoApp\Customers\Models\Company

List of companies existing in the system.

Constants

This model does not define constants.

Properties

Property	Value
eloquentClass	Eloquent\Company::class
table	companies
lookupSqlValue	[TABLE].name

Data Scructure

Column	Title	ADIOS Type	Length	Required
id	ID	int		TRUE
name	Company Name	varchar		TRUE
street_line_1	Street line 1	varchar		FALSE
street_line_2	Street line 2	varchar		FALSE
region	Region	varchar		FALSE
city	City	varchar		FALSE
postal_code	Postal code	varchar		FALSE
vat_id	Vat ID	varchar		FALSE
tax_id	Tax ID	varchar		TRUE
company_id	Company ID	varchar		FALSE
note	Note	text		FALSE
is_active	Active	boolean		FALSE
date_created	Date Created	date		TRUE
id_country	Country	lookup		FALSE
id_user	Assigned User	lookup		TRUE

Foreign Keys

Column	Model	Relation	OnUpdate	OnDelete
id_country	Modules\Core\Settings\Models\Country	1:1	Cascade	Restrict
id_user	Modules\Core\Settings\Models\User	1:1	Cascade	Restrict

Indexes

Name	Type	Column + Order
id	PRIMARY	id ASC
var_id	UNIQUE	company_id ASC
company_id	UNIQUE	company_id ASC
tax_id	UNIQUE	company_id ASC

Relations

Relation	Type	Other parameters
PERSONS	HAS_MANY	Person::class, 'id_company'
COUNTRY	HAS_ONE	Country::class, 'id', 'id_country'
USER	BELONGS_TO	User::class, 'id_user', 'id'
FIRST_CONTACT	HAS_ONE	Person::class, 'id_company',
BILLING_ACCOUNTS	HAS_MANY	BillingAccount::class, 'id_company',
ACTIVITIES	HAS_MANY	CompanyActivity::class, 'id_company', id
TAGS	HAS_MANY	CompanyTag::class, 'id_company', 'id'
LEADS	HAS_MANY	Lead::class, 'id_company', 'id'
DEALS	HAS_MANY	Deal::class, 'id_company', 'id'
DOCUMENTS	HAS_MANY	CompanyDocument::class, 'id_company', 'id'

www.hubleto.com | Found a bug or missing something? Report an issue via GitHub.