App entity.

Show:

ENTITY_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

ENTITY_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

ENTITY_CREATEDAT

Datetime

Creation date.

ENTITY_DEVISE

Int(11)

Currency.

cf. key id for JSON response data.setting.currency of API /application/dictionary


Default: 0

ENTITY_DEVISEAGENCE

Int(11)

Agency's currency.

cf. key id for JSON response data.setting.currency of API /application/dictionary


Default: 0

ENTITY_GUEST_TYPE_VALIDATOR

Varchar(100)

Guest validator type :

  • 'resource'


Default: 'resource'

ENTITY_GUESTS_STATE

Tinyint(1)

Entity guests validation :

  • 0 : Not validated
  • 1 : Validated


Default: 0

ENTITY_GUESTS_VALIDATION_DATE

Datetime

Guest validator date.

ENTITY_MANAGERS_STATE

Tinyint(1)

Entity managers validation :

  • 0 : Not validated
  • 1 : Validated


Default: 0

ENTITY_MANAGERS_VALIDATION_DATE

Datetime

Main manager validator date.

ENTITY_STATE

Int(11)

State.


Default: 1

ENTITY_TYPE

Int(11)

Type.


Default: 0

ENTITY_UPDATEDAT

Datetime

Update date.

ENTITY_VALIDATION

Tinyint(1)

Entity global validation :

  • 0 : Not validated
  • 1 : Validated


Default: 0

ENTITY_VISIBILITY

Tinyint(1)

Entity visibility :

  • 0 : Not visible by guest
  • 1 : Visible by guest


Default: 0

ID_AGENCY

Int(11)


Default: 0

ID_CREATOR

Int(11)


Default: 0

ID_ENTITY_APP

Int(11)

Unique Identifier.

ID_GUEST_VALIDATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Guest validator.


Default: 0

ID_MAINAPI

Int(11)


Default: 0

ID_MAINMANAGER_VALIDATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager validator.


Default: 0

ID_PARENT

Int(11)

Unique identifier of dependsOn.

DependsOn.


Default: 0

ID_POLE

Int(11)


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

MAINAPI_VIEW

Tinyint(1)

App's type :

  • 0 : iFrame
  • 1 : Native Module
  • 2 : Customized module
  • 3 : Customized section


Default: 0

PARENT_TYPE

Varchar(100)

DependsOn type :

  • 'resource'
  • 'candidate'
  • 'product'
  • 'company'
  • 'contact'
  • 'opportunity'
  • 'project'
  • 'purchase'
  • 'order'
  • 'invoice'