Primary key
document_id
uuiddefault:"Random UUID"publicrequired
The unique identifier for the Maihue lead record.
Specific attributes
collection_channel
varcharpublic
The channel through which the lead was collected.
Rules: Max length: 250 characters
commercial_activity
varcharpublic
The commercial activity associated with the lead.
Rules: Max length: 250 characters
contact
varcharpublicrequired
The contact information for the lead.
Rules: Max length: 250 characters
The DNI (Document of National Identity) of the lead.
Rules: Max length: 50 characters
email
varcharpublicrequired
The email address of the lead.
Rules: Max length: 250 characters
evaluation_debt
decimalpublic
The evaluated debt of the lead.
Rules: Precision: 12, Scale: 2
evaluation_score
decimalpublic
The evaluation score of the lead.
Rules: Precision: 6, Scale: 2
Additional notes or comments about the lead.
Rules: Max length: 150 characters
The IP address associated with the lead.
Rules: Max length: 50 characters
name
varcharpublicrequired
The name of the lead.
Rules: Max length: 250 characters
name_fantasy
varcharpublic
The fantasy or trade name associated with the lead.
Rules: Max length: 250 characters
payment_method
varcharpublic
The preferred payment method of the lead.
Rules: Possible values: PAC, PAT, TRANSFER; Max length: 50 characters
phone
varcharpublicrequired
The phone number of the lead.
Rules: Max length: 50 characters
s_utm_compaign
varcharpublic
The UTM campaign parameter for the session.
Rules: Max length: 250 characters
s_utm_content
varcharpublic
The UTM content parameter for the session.
Rules: Max length: 250 characters
s_utm_medium
varcharpublic
The UTM medium parameter for the session.
Rules: Max length: 250 characters
s_utm_source
varcharpublic
The UTM source parameter for the session.
Rules: Max length: 250 characters
The UTM term parameter for the session.
Rules: Max length: 250 characters
type
varcharpublicrequired
The type of lead.
Rules: Possible values: COMPANY, HOME, HORECA; Max length: 50 characters
utm_compaign
varcharpublic
The UTM campaign parameter.
Rules: Max length: 250 characters
The UTM content parameter.
Rules: Max length: 250 characters
The UTM medium parameter.
Rules: Max length: 250 characters
The UTM source parameter.
Rules: Max length: 250 characters
The UTM term parameter.
Rules: Max length: 250 characters
Foreign keys
address
uuidpublicrequired
country
uuidpublicrequired
type_dni
uuidpublicrequired
Tracking attributes
created_at
timestamppublic
The timestamp when the Maihue lead record was created.
Rules: Precision: 6, with timezone
deleted_at
timestamppublic
The timestamp when the Maihue lead record was deleted, if applicable.
Rules: Precision: 6, with timezone
is_actived
booleandefault:"true"public
Indicates whether the Maihue lead record is active.
is_deleted
booleandefault:"false"public
Indicates whether the Maihue lead record has been deleted.
updated_at
timestamppublic
The timestamp when the Maihue lead record was last updated.
Rules: Precision: 6, with timezone