Rubrique précédente: Objet cnoteRubrique suivante: Objet cnt_role


Objet cnt

Les détails de l'objet sont les suivants :

Table associée : ca_contact, usp_contact

Sous-objets : default, agt, cst, grp

REL_ATTR : id

Nom commun : combo_name

Groupe de fonctions : contact

Table ca_contact

Opérations REST : CREATE READ UPDATE

Attribut

Champ BdD

Type de données

Références SREL

Indicateurs

access_type

access_type

SREL

acctyp.id

 

admin_org

admin_organization_uuid

UUID

uuid ca_organization

 

alias

alias

STRING

 

 

alt_phone

alt_phone_ number

STRING

 

 

cnthandling_list

 

BREL

contact_handling

 

contact_num

alternate_ identifier

STRING

 

 

notes

Commentaire

STRING

 

 

Company (société)

company_uuid

UUID

ca_company company_uuid

 

type

contact_type

integer

id ca_contact_type

 

id

contact_uuid

UUID

 

UNIQUE REQUIRED KEY

billing_code

cost_center

NOMBRE ENTIER

id ca_resource_cost_center

 

creation_date

creation_date

LOCAL_TIME

 

 

creation_user

creation_user

STRING

 

 

delete_time

delete_time

LOCAL_TIME

 

 

dept

Service

NOMBRE ENTIER

id ca_resource_department

 

email_address

email_address

STRING

 

 

exclude_ registration

exclude_ registration

integer

 

 

fax_phone

fax_number

STRING

 

 

first_name

first_name

STRING

 

 

floor_location

floor_location

STRING

 

 

delete_flag

inactive

integer

actbool enum

 

job_function

job_function

integer

 

 

position

job_title

integer

id ca_job_title

 

last_name

last_name

STRING

 

 

last_mod

last_update_date

LOCAL_TIME

 

 

last_mod_by

last_update_user

STRING

 

 

emplacement

location_uuid

UUID

ca_location location_uuid

 

mail_stop

mail_stop

STRING

 

 

middle_name

middle_name

STRING

 

 

mobile_phone

mobile_phone_ number

STRING

 

 

Organisation

organization_ uuid

UUID

uuid ca_organization

 

pemail_address

pager_email_ address

STRING

 

 

beeper_phone

pager_number

STRING

 

 

phone_number

pri_phone_ number

STRING

 

 

rôles

rôles

LIST

 

 

room_location

room_location

STRING

 

 

supervisor_ contact_uuid

supervisor_ contact_uuid

UUID

ca_contact uuid

 

userid

userid

STRING

 

 

version_number

version_number

integer