TAB_AIPORTRAIT_SOURCE Class

Sources analysed for the AI portrait: idempotence (content hash), processing status, and the source → parent index used to purge only what a deleted action produced.

Show:

ID_AIPORTRAIT_SOURCE

Int(11)

Row ID

ID_AIREQUEST

Int(11)

TAB_AIREQUEST row of the extraction call (tokens, provider, quota): the cost of this analysis

PARENT_ID

Int(11)

Parent model id

PARENT_TYPE

Varchar(20)

Parent model type

SOURCE_CREATEDAT

Datetime

Creation date

SOURCE_ERROR

Varchar(64)

Technical error code when failed (a code, truncated to the column width, never a message)

SOURCE_HASH

Char(64)

sha256 of the analysed text. Same hash and status done → the source is not analysed again.

SOURCE_ID

Int(11)

Source id (e.g. TAB_ACTION.ID_ACTION). Unique with SOURCE_TYPE: a source has a single parent.

SOURCE_NBITEMS

Smallint(5) unsigned

Number of items kept from this analysis (0 = not relevant or nothing valid)


Default: 0

SOURCE_STATUS

Tinyint(1)

Processing status: 0 pending · 1 done · 2 skipped (not relevant) · 3 failed. Indexed with SOURCE_ERROR and SOURCE_UPDATEDAT: the companion cron picks by age the pending sources and the failed ones whose error is recoverable, while definitive failures pile up and must not be read.


Default: 0

SOURCE_TYPE

Varchar(20)

Source type, closed vocabulary of the PortraitSourceType enum: action today; candidate, cv, app planned

SOURCE_UPDATEDAT

Datetime

Last update date

SOURCE_VERSION

Varchar(128)

Extraction recipe: provider + prompt version + fingerprint (sha256) of the enrichable fields referential. Set with the fingerprint at registration, completed with the provider recipe when the source is done or skipped