AccountBase

2624 rows


Description

Companies table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AccountId uuid 2147483647 √ null
Name varchar 160 √ null
Description text 2147483647 √ null
EMailAddress1 varchar 100 √ null
Telephone1 varchar 50 √ null
Fax varchar 50 √ null
CreatedOn timestamp 26,3 √ null
CreatedBy uuid 2147483647 √ null
StateCode int4 10 0
StatusCode int4 10 √ null
new_contact uuid 2147483647 √ null
new_Balance numeric 19,4 √ null
new_companytype bool 1 √ null
new_Passportid varchar 100 √ null
new_companyaddress text 2147483647 √ null
new_companyid varchar 100 √ null
new_Payeeinformation text 2147483647 √ null
new_Customer bool 1 √ null
new_IsSupplier bool 1 √ null
new_Accounttype int4 10 √ null
CompanyType.id AccountBase_new_Accounttype_fkeyR
new_Manager varchar 100 √ null
new_Country uuid 2147483647 √ null
id serial 10 √ nextval('v1."AccountBase_id_seq"'::regclass)
InvoiceBase.company_id InvoiceBase_company_id_fkeyR
new_brandBase.company_id new_brandBase_company_id_fkeyR
new_POBase.company_id new_POBase_company_id_fkeyR
new_receiptBase.company_id new_receiptBase_company_id_fkeyR
SalesOrderBase.company_id SalesOrderBase_company_id_fkeyR
owner_id int4 10 √ null
SystemUserBase.id AccountBase_owner_id_fkeyR
createdby_id int4 10 √ null
SystemUserBase.id AccountBase_createdby_id_fkeyR
country_id int4 10 √ null
new_countryBase.id AccountBase_country_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
cndx_PrimaryKey_Account Primary key Asc id
AccountBase_id_key Must be unique Asc id
comp_name_index Performance Asc Name
comp_statecode_index Performance Asc StateCode

Relationships

Close relationships within degrees of separation