Coheris

Explore the interactive ERD

Table & Field Reference

table_a_status

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`flag_closed`	Unknown
`indic_fils`	Unknown
`lect_seul`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown
`text_3`	Unknown
`text_4`	Unknown

table_a

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`auto_create`	Unknown
`auto_exec`	Unknown
`auto_open`	Unknown
`auto_save`	Unknown
`cal_visibility`	Unknown
`channel`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`cout`	Unknown
`cpg_executable`	Unknown
`css_class`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`dragndrop_opts`	Unknown
`duration`	Unknown
`flux`	Unknown
`indic_fils`	Unknown
`indic_program`	Unknown
`indic_typlet`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`report_screen`	Unknown
`stock_alerte`	Unknown
`stock_encour`	Unknown
`t_p_code`	Unknown
`text`	Unknown
`typ_planing`	Unknown
`type_01`	Unknown
`type_02`	Unknown
`type_03`	Unknown

table_me

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lect_seul`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown
`text_3`	Unknown
`text_4`	Unknown

table_17

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_16

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_grp

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown

table_15

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

country

Column	Type	Keys
`code`	Unknown	PK
`code_iso_2`	Unknown
`disc_web`	Unknown
`langues`	Unknown
`libelle`	Unknown
`num_iso`	Unknown
`ord`	Unknown

table_9

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_11

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_10`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`comp_6`	Unknown
`comp_7`	Unknown
`comp_8`	Unknown
`comp_9`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`paragraphe`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_10

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_10`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`comp_6`	Unknown
`comp_7`	Unknown
`comp_8`	Unknown
`comp_9`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`paragraphe`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_5

Column	Type	Keys
`code`	Unknown	PK
`co_code`	Unknown	FK
`la_code`	Unknown	FK
`adresse`	Unknown
`ap_code`	Unknown
`appart`	Unknown
`area`	Unknown
`comp_1`	Unknown
`comp_10`	Unknown
`comp_11`	Unknown
`comp_12`	Unknown
`comp_13`	Unknown
`comp_14`	Unknown
`comp_15`	Unknown
`comp_16`	Unknown
`comp_17`	Unknown
`comp_18`	Unknown
`comp_19`	Unknown
`comp_2`	Unknown
`comp_20`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`comp_6`	Unknown
`comp_7`	Unknown
`comp_8`	Unknown
`comp_9`	Unknown
`cp`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`email`	Unknown
`eta`	Unknown
`fax`	Unknown
`geo_x`	Unknown
`geo_y`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`nom`	Unknown
`ord`	Unknown
`parent`	Unknown
`prenom`	Unknown
`tel`	Unknown
`text`	Unknown
`text_2`	Unknown
`ville`	Unknown

table_6

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`code_gravite`	Unknown
`comp_1`	Unknown
`comp_10`	Unknown
`comp_11`	Unknown
`comp_12`	Unknown
`comp_13`	Unknown
`comp_14`	Unknown
`comp_15`	Unknown
`comp_16`	Unknown
`comp_17`	Unknown
`comp_18`	Unknown
`comp_19`	Unknown
`comp_2`	Unknown
`comp_20`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`comp_6`	Unknown
`comp_7`	Unknown
`comp_8`	Unknown
`comp_9`	Unknown
`delai`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`ht_1_row_code`	Unknown
`ht_1_table_abr`	Unknown
`ht_2_row_code`	Unknown
`ht_2_table_abr`	Unknown
`id_table_7`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`p_delay_day`	Unknown
`paragraphe`	Unknown
`parent`	Unknown
`pdelay_t`	Unknown
`periode`	Unknown
`text`	Unknown
`text_2`	Unknown
`tw_bid`	Unknown
`txt_01`	Unknown
`txt_02`	Unknown
`txt_03`	Unknown
`txt_04`	Unknown
`txt_05`	Unknown

table_7

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`cumul`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`formula_01`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`next_proc_01_code`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_8

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`ident`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`nom`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown
`text_3`	Unknown

table_1

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lect_seul`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown
`text_3`	Unknown
`text_4`	Unknown

table_2

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_19

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_4

Column	Type	Keys
`code`	Unknown	PK
`co_code`	Unknown	FK
`la_code`	Unknown	FK
`parent_id`	Unknown	FK
`ap_code`	Unknown
`ap_code_1`	Unknown
`appart`	Unknown
`code_enr`	Unknown
`code_table`	Unknown
`comp_1`	Unknown
`comp_10`	Unknown
`comp_11`	Unknown
`comp_12`	Unknown
`comp_13`	Unknown
`comp_14`	Unknown
`comp_15`	Unknown
`comp_16`	Unknown
`comp_17`	Unknown
`comp_18`	Unknown
`comp_19`	Unknown
`comp_2`	Unknown
`comp_20`	Unknown
`comp_21`	Unknown
`comp_22`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`comp_6`	Unknown
`comp_7`	Unknown
`comp_8`	Unknown
`comp_9`	Unknown
`desc_1`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`funct`	Unknown
`funct_1`	Unknown
`implant`	Unknown
`indic_fils`	Unknown
`interl_adresse`	Unknown
`interl_area`	Unknown
`interl_cp`	Unknown
`interl_email`	Unknown
`interl_eta`	Unknown
`interl_fax`	Unknown
`interl_geo_x`	Unknown
`interl_geo_y`	Unknown
`interl_nom`	Unknown
`interl_nom_1`	Unknown
`interl_prenom`	Unknown
`interl_prenom_1`	Unknown
`interl_tel`	Unknown
`interl_ville`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text_2`	Unknown

table_18

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

langues

Column	Type	Keys
`code`	Unknown	PK
`code_iso_3`	Unknown
`disc_web`	Unknown
`libelle`	Unknown
`ord`	Unknown

table_40

Column	Type	Keys
`code`	Unknown	PK
`parent_id`	Unknown	FK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`paragraphe`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_23

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`paragraphe`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_22

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

table_21

Column	Type	Keys
`code`	Unknown	PK
`appart`	Unknown
`comp_1`	Unknown
`comp_10`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`comp_6`	Unknown
`comp_7`	Unknown
`comp_8`	Unknown
`comp_9`	Unknown
`disc`	Unknown
`disc_web`	Unknown
`indic_fils`	Unknown
`lib`	Unknown
`lib_long`	Unknown
`marker`	Unknown
`niv_0`	Unknown
`niv_1`	Unknown
`niv_2`	Unknown
`niv_3`	Unknown
`niv_4`	Unknown
`niv_5`	Unknown
`niv_6`	Unknown
`niv_7`	Unknown
`niv_8`	Unknown
`niv_9`	Unknown
`niv_hier`	Unknown
`ord`	Unknown
`parent`	Unknown
`text`	Unknown
`text_2`	Unknown

link_groups_table_u

Column	Type	Keys
`code`	Unknown	PK
`end_date`	Unknown
`groups_code`	Unknown
`info_date_01`	Unknown
`info_date_02`	Unknown
`start_date`	Unknown
`t_ro_code`	Unknown
`t_u_code`	Unknown

table_ca

Column	Type	Keys
`code`	Unknown	PK
`budget_num_01`	Unknown
`budget_num_02`	Unknown
`budget_num_03`	Unknown
`budget_num_04`	Unknown
`budget_num_05`	Unknown
`budget_str_01`	Unknown
`budget_str_02`	Unknown
`budget_str_03`	Unknown
`budget_str_04`	Unknown
`budget_str_05`	Unknown
`budget_txt_01`	Unknown
`budget_txt_02`	Unknown
`cad_date_01`	Unknown
`cad_date_02`	Unknown
`cad_date_03`	Unknown
`cad_date_04`	Unknown
`cad_date_05`	Unknown
`channel_select_mod`	Unknown
`codeu`	Unknown
`comp_1`	Unknown
`comp_2`	Unknown
`comp_3`	Unknown
`comp_4`	Unknown
`comp_5`	Unknown
`cond_stop`	Unknown
`consent_applies`	Unknown
`date_beg`	Unknown
`date_crea`	Unknown
`date_end`	Unknown
`date_mod`	Unknown
`date_prep_beg`	Unknown
`date_prep_end`	Unknown
`event`	Unknown
`external_mkt_action_archived`	Unknown
`external_mkt_action_connector_id`	Unknown
`external_mkt_action_id`	Unknown
`external_mkt_action_type`	Unknown
`info_chk_01`	Unknown
`info_chk_02`	Unknown
`info_chk_03`	Unknown
`info_date_01`	Unknown
`info_date_02`	Unknown
`info_str_01`	Unknown
`info_str_02`	Unknown
`info_str_03`	Unknown
`info_str_04`	Unknown
`info_str_05`	Unknown
`info_txt_01`	Unknown
`info_txt_02`	Unknown
`info_txt_03`	Unknown
`is_execution`	Unknown
`lib`	Unknown
`marker`	Unknown
`media`	Unknown
`model`	Unknown
`object_if_num_01`	Unknown
`object_if_num_02`	Unknown
`object_if_num_03`	Unknown
`object_if_str_01`	Unknown
`object_if_str_02`	Unknown
`object_if_str_03`	Unknown
`object_if_txt_01`	Unknown
`object_if_txt_02`	Unknown
`occurrence`	Unknown
`occurrence_set`	Unknown
`parent`	Unknown
`period`	Unknown
`planning_beg`	Unknown
`planning_end`	Unknown
`planning_type`	Unknown
`priority`	Unknown
`rec_days_time`	Unknown
`rec_friday`	Unknown
`rec_monday`	Unknown
`rec_period_number`	Unknown
`rec_period_time`	Unknown
`rec_period_unit`	Unknown
`rec_saturday`	Unknown
`rec_sunday`	Unknown
`rec_thursday`	Unknown
`rec_tuesday`	Unknown
`rec_wednesday`	Unknown
`recurrence_type`	Unknown
`rmq`	Unknown
`state`	Unknown
`status_info`	Unknown
`t_ca_desc`	Unknown
`t_r_code`	Unknown
`t_u_code`	Unknown
`tmp_code`	Unknown
`type`	Unknown
`type_1`	Unknown
`type_2`	Unknown
`type_3`	Unknown
`type_4`	Unknown
`type_5`	Unknown

historique

Column	Type	Keys
`code`	Unknown	PK
`af_code`	Unknown	FK
`groups_code`	Unknown	FK
`reference`	Unknown	FK
`t_a_code`	Unknown	FK
`t_ca_code`	Unknown	FK
`ac_code`	Unknown
`ag_code`	Unknown
`ca_state`	Unknown
`ca_state_date`	Unknown
`cal_visibility`	Unknown
`date_01`	Unknown
`date_02`	Unknown
`date_03`	Unknown
`date_04`	Unknown
`date_05`	Unknown
`date_annule`	Unknown
`date_crea`	Unknown
`date_doc`	Unknown
`date_eche`	Unknown
`date_exec`	Unknown
`date_ret_at`	Unknown
`date_start`	Unknown
`duration`	Unknown
`email_module_id`	Unknown
`fiche_suivi`	Unknown
`float_01`	Unknown
`float_02`	Unknown
`float_03`	Unknown
`float_04`	Unknown
`float_05`	Unknown
`indic_atte`	Unknown
`indic_mes_lu`	Unknown
`int_01`	Unknown
`int_02`	Unknown
`interact_provider`	Unknown
`interact_score_01`	Unknown
`interact_score_02`	Unknown
`interact_score_03`	Unknown
`interact_score_upd`	Unknown
`interact_uid`	Unknown
`last_update`	Unknown
`lib_action`	Unknown
`lib_desti`	Unknown
`lib_emet`	Unknown
`lib_exec`	Unknown
`lib_lettre`	Unknown
`lpa_code`	Unknown
`mkt_reactivity`	Unknown
`mkt_reactivity_date`	Unknown
`mkt_reactivity_stamp_id`	Unknown
`mkt_reactivity_t_ca_code`	Unknown
`mont_cheq`	Unknown
`mont_cheq_2`	Unknown
`montant_cad`	Unknown
`montant_cad_2`	Unknown
`nb_gen`	Unknown
`net_publication_id`	Unknown
`nom_doc`	Unknown
`nom_src_scan`	Unknown
`num_01`	Unknown
`num_02`	Unknown
`num_03`	Unknown
`num_04`	Unknown
`num_05`	Unknown
`num_cheq`	Unknown
`ph_code`	Unknown
`quo_code`	Unknown
`resume`	Unknown
`str_1`	Unknown
`str_10`	Unknown
`str_11`	Unknown
`str_12`	Unknown
`str_13`	Unknown
`str_14`	Unknown
`str_2`	Unknown
`str_3`	Unknown
`str_4`	Unknown
`str_5`	Unknown
`str_6`	Unknown
`str_7`	Unknown
`str_8`	Unknown
`str_9`	Unknown
`t_u_code_desti`	Unknown
`t_u_code_emet`	Unknown
`t_u_code_exec`	Unknown
`tcalg_code`	Unknown
`tl_code`	Unknown
`tw_bid`	Unknown
`txt_1`	Unknown
`txt_2`	Unknown
`type_01`	Unknown
`type_02`	Unknown
`type_03`	Unknown
`user_rule_code`	Unknown
`wf_id`	Unknown

af_link

Column	Type	Keys
`code`	Unknown	PK
`af_code`	Unknown	FK
`check_1`	Unknown
`check_2`	Unknown
`check_3`	Unknown
`check_4`	Unknown
`check_5`	Unknown
`date_1`	Unknown
`date_2`	Unknown
`date_3`	Unknown
`int_1`	Unknown
`int_2`	Unknown
`int_3`	Unknown
`int_4`	Unknown
`int_5`	Unknown
`int_6`	Unknown
`int_7`	Unknown
`last_modified`	Unknown
`num_1`	Unknown
`num_10`	Unknown
`num_2`	Unknown
`num_3`	Unknown
`num_4`	Unknown
`num_5`	Unknown
`num_6`	Unknown
`num_7`	Unknown
`num_8`	Unknown
`num_9`	Unknown
`str_1`	Unknown
`str_10`	Unknown
`str_11`	Unknown
`str_12`	Unknown
`str_13`	Unknown
`str_14`	Unknown
`str_15`	Unknown
`str_16`	Unknown
`str_17`	Unknown
`str_18`	Unknown
`str_19`	Unknown
`str_2`	Unknown
`str_20`	Unknown
`str_21`	Unknown
`str_22`	Unknown
`str_23`	Unknown
`str_24`	Unknown
`str_25`	Unknown
`str_26`	Unknown
`str_27`	Unknown
`str_28`	Unknown
`str_29`	Unknown
`str_3`	Unknown
`str_30`	Unknown
`str_4`	Unknown
`str_5`	Unknown
`str_6`	Unknown
`str_7`	Unknown
`str_8`	Unknown
`str_9`	Unknown
`t_31_code`	Unknown
`t_32_code`	Unknown
`t_33_code`	Unknown
`t_34_code`	Unknown
`t_35_code`	Unknown

meeting

Column	Type	Keys
`code`	Unknown	PK
`af_code`	Unknown	FK
`hi_code`	Unknown	FK
`cal_visibility`	Unknown
`canceled_date`	Unknown
`css_class`	Unknown
`description`	Unknown
`end_date`	Unknown
`entry_type`	Unknown
`importance`	Unknown
`info_date_01`	Unknown
`info_str_01`	Unknown
`info_str_02`	Unknown
`info_str_03`	Unknown
`info_str_04`	Unknown
`info_str_05`	Unknown
`is_online_meeting`	Unknown
`last_update`	Unknown
`location`	Unknown
`meeting_from`	Unknown
`model_entry_type`	Unknown
`octipas_id`	Unknown
`online_meeting_join_url`	Unknown
`owner`	Unknown
`participant`	Unknown
`priority`	Unknown
`reference`	Unknown
`reply_to`	Unknown
`report`	Unknown
`return_rcpt`	Unknown
`sender`	Unknown
`sent_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`subject`	Unknown
`tl_code`	Unknown
`type`	Unknown

wishlist

Column	Type	Keys
`code`	Unknown	PK
`reference`	Unknown	FK
`created_date`	Unknown
`description`	Unknown
`expiration_date`	Unknown
`external_uid`	Unknown
`last_modified`	Unknown
`name`	Unknown

client

Column	Type	Keys
`reference`	Unknown	PK
`co_code`	Unknown	FK
`la_code`	Unknown	FK
`t_15_code`	Unknown	FK
`t_16_code`	Unknown	FK
`t_17_code`	Unknown	FK
`t_18_code`	Unknown	FK
`t_19_code`	Unknown	FK
`t_1_code`	Unknown	FK
`t_2_code`	Unknown	FK
`activity_end_date`	Unknown
`activity_start_date`	Unknown
`address_quality`	Unknown
`address_quality_date`	Unknown
`adresse`	Unknown
`adresse_c_1`	Unknown
`adresse_c_2`	Unknown
`adresse_c_3`	Unknown
`adresse_c_4`	Unknown
`adresse_c_5`	Unknown
`adresse_num`	Unknown
`adresse_street`	Unknown
`ap_code`	Unknown
`ape_code`	Unknown
`birthdate`	Unknown
`birthplace`	Unknown
`client`	Unknown
`code_postal`	Unknown
`csp_code`	Unknown
`cty_code`	Unknown
`date_dern`	Unknown
`date_prem`	Unknown
`departement`	Unknown
`email`	Unknown
`fax`	Unknown
`gdpr_status`	Unknown
`gdpr_status_update`	Unknown
`id_ext_1`	Unknown
`id_ext_2`	Unknown
`info_comp_1`	Unknown
`info_comp_10`	Unknown
`info_comp_11`	Unknown
`info_comp_12`	Unknown
`info_comp_13`	Unknown
`info_comp_14`	Unknown
`info_comp_15`	Unknown
`info_comp_16`	Unknown
`info_comp_17`	Unknown
`info_comp_18`	Unknown
`info_comp_19`	Unknown
`info_comp_2`	Unknown
`info_comp_20`	Unknown
`info_comp_21`	Unknown
`info_comp_22`	Unknown
`info_comp_23`	Unknown
`info_comp_24`	Unknown
`info_comp_25`	Unknown
`info_comp_26`	Unknown
`info_comp_27`	Unknown
`info_comp_28`	Unknown
`info_comp_29`	Unknown
`info_comp_3`	Unknown
`info_comp_30`	Unknown
`info_comp_31`	Unknown
`info_comp_32`	Unknown
`info_comp_33`	Unknown
`info_comp_34`	Unknown
`info_comp_35`	Unknown
`info_comp_36`	Unknown
`info_comp_37`	Unknown
`info_comp_38`	Unknown
`info_comp_39`	Unknown
`info_comp_4`	Unknown
`info_comp_40`	Unknown
`info_comp_41`	Unknown
`info_comp_42`	Unknown
`info_comp_43`	Unknown
`info_comp_44`	Unknown
`info_comp_45`	Unknown
`info_comp_46`	Unknown
`info_comp_47`	Unknown
`info_comp_48`	Unknown
`info_comp_49`	Unknown
`info_comp_5`	Unknown
`info_comp_50`	Unknown
`info_comp_51`	Unknown
`info_comp_52`	Unknown
`info_comp_53`	Unknown
`info_comp_54`	Unknown
`info_comp_55`	Unknown
`info_comp_56`	Unknown
`info_comp_57`	Unknown
`info_comp_58`	Unknown
`info_comp_59`	Unknown
`info_comp_6`	Unknown
`info_comp_60`	Unknown
`info_comp_61`	Unknown
`info_comp_62`	Unknown
`info_comp_63`	Unknown
`info_comp_64`	Unknown
`info_comp_65`	Unknown
`info_comp_66`	Unknown
`info_comp_67`	Unknown
`info_comp_68`	Unknown
`info_comp_69`	Unknown
`info_comp_7`	Unknown
`info_comp_70`	Unknown
`info_comp_71`	Unknown
`info_comp_8`	Unknown
`info_comp_9`	Unknown
`latitude`	Unknown
`lf_code`	Unknown
`longitude`	Unknown
`net_count_fans_fbk`	Unknown
`net_count_fans_twt`	Unknown
`net_count_msg_fbk`	Unknown
`net_count_msg_twt`	Unknown
`net_profile_id_fbk`	Unknown
`net_profile_id_twt`	Unknown
`net_profile_name_fbk`	Unknown
`net_profile_name_twt`	Unknown
`nic`	Unknown
`nom`	Unknown
`npai`	Unknown
`prenom`	Unknown
`region`	Unknown
`remarque`	Unknown
`revenue`	Unknown
`revenues_tcy_code`	Unknown
`revenues_year`	Unknown
`rub_1`	Unknown
`rub_2`	Unknown
`rub_3`	Unknown
`satisfaction`	Unknown
`siren`	Unknown
`status_code`	Unknown
`t_12_code`	Unknown
`t_u_code`	Unknown
`t_u_code_1`	Unknown
`t_u_code_2`	Unknown
`t_u_code_last_upd`	Unknown
`t_u_code_resp`	Unknown
`tel`	Unknown
`tel_2`	Unknown
`tva_intra`	Unknown
`un_code`	Unknown
`ville`	Unknown
`website`	Unknown
`workforce`	Unknown

wishlist_line

Column	Type	Keys
`code`	Unknown	PK
`wi_code`	Unknown	FK
`external_product_id`	Unknown
`last_modified`	Unknown
`t_3_code`	Unknown

cl_channel

Column	Type	Keys
`code`	Unknown	PK
`reference`	Unknown	FK
`channel`	Unknown
`channel_value`	Unknown
`last_update`	Unknown
`npai`	Unknown
`opt`	Unknown
`priority`	Unknown

affaires

Column	Type	Keys
`code`	Unknown	PK
`co_code`	Unknown	FK
`la_code`	Unknown	FK
`t_10_code`	Unknown	FK
`t_11_code`	Unknown	FK
`t_21_code`	Unknown	FK
`t_22_code`	Unknown	FK
`t_23_code`	Unknown	FK
`t_40_code`	Unknown	FK
`t_4_code`	Unknown	FK
`t_5_code`	Unknown	FK
`t_6_code`	Unknown	FK
`t_7_code`	Unknown	FK
`t_8_code`	Unknown	FK
`t_9_code`	Unknown	FK
`t_me_code`	Unknown	FK
`age_tab_3`	Unknown
`answer`	Unknown
`ap_code`	Unknown
`assigned_date`	Unknown
`budget`	Unknown
`cloture`	Unknown
`code_gravite`	Unknown
`contact_count`	Unknown
`contract_id`	Unknown
`converted_date`	Unknown
`cout_supl`	Unknown
`cout_supl_2`	Unknown
`cout_total`	Unknown
`cout_total_2`	Unknown
`date_answer`	Unknown
`date_closed`	Unknown
`date_cont`	Unknown
`date_crea`	Unknown
`date_util`	Unknown
`delai_clos`	Unknown
`dluo`	Unknown
`email_module_id`	Unknown
`estimated_date`	Unknown
`faq_code`	Unknown
`ident_prop`	Unknown
`info_comp_1`	Unknown
`info_comp_10`	Unknown
`info_comp_11`	Unknown
`info_comp_12`	Unknown
`info_comp_13`	Unknown
`info_comp_14`	Unknown
`info_comp_15`	Unknown
`info_comp_16`	Unknown
`info_comp_17`	Unknown
`info_comp_18`	Unknown
`info_comp_19`	Unknown
`info_comp_2`	Unknown
`info_comp_20`	Unknown
`info_comp_21`	Unknown
`info_comp_22`	Unknown
`info_comp_23`	Unknown
`info_comp_24`	Unknown
`info_comp_25`	Unknown
`info_comp_26`	Unknown
`info_comp_27`	Unknown
`info_comp_28`	Unknown
`info_comp_29`	Unknown
`info_comp_3`	Unknown
`info_comp_30`	Unknown
`info_comp_31`	Unknown
`info_comp_32`	Unknown
`info_comp_33`	Unknown
`info_comp_34`	Unknown
`info_comp_35`	Unknown
`info_comp_36`	Unknown
`info_comp_37`	Unknown
`info_comp_38`	Unknown
`info_comp_39`	Unknown
`info_comp_4`	Unknown
`info_comp_40`	Unknown
`info_comp_41`	Unknown
`info_comp_42`	Unknown
`info_comp_43`	Unknown
`info_comp_44`	Unknown
`info_comp_45`	Unknown
`info_comp_46`	Unknown
`info_comp_47`	Unknown
`info_comp_48`	Unknown
`info_comp_49`	Unknown
`info_comp_5`	Unknown
`info_comp_50`	Unknown
`info_comp_6`	Unknown
`info_comp_7`	Unknown
`info_comp_8`	Unknown
`info_comp_9`	Unknown
`interact_uid`	Unknown
`last_modified`	Unknown
`last_reopen_date`	Unknown
`net_publication_id`	Unknown
`num_fab`	Unknown
`priority`	Unknown
`project_weight`	Unknown
`proposal_date`	Unknown
`reference`	Unknown
`rem_2`	Unknown
`rem_3`	Unknown
`rem_supp`	Unknown
`rem_supp_2`	Unknown
`rem_supp_3`	Unknown
`rem_supp_4`	Unknown
`remarque`	Unknown
`reopen_count`	Unknown
`request`	Unknown
`satisfaction`	Unknown
`score`	Unknown
`status_code`	Unknown
`t_13_code`	Unknown
`t_14_code`	Unknown
`t_20_code`	Unknown
`t_24_code`	Unknown
`t_25_code`	Unknown
`t_26_code`	Unknown
`t_27_code`	Unknown
`t_28_code`	Unknown
`t_29_code`	Unknown
`t_30_code`	Unknown
`t_36_code`	Unknown
`t_37_code`	Unknown
`t_38_code`	Unknown
`t_39_code`	Unknown
`t_3_code`	Unknown
`t_u_code`	Unknown
`t_u_code_1`	Unknown
`t_u_code_2`	Unknown
`t_u_code_closed`	Unknown
`tcalg_code`	Unknown
`tcompet_code`	Unknown
`tconcl_code`	Unknown
`temps_passe`	Unknown
`temps_passe_mn`	Unknown
`tfaqctx_code`	Unknown
`tiers_adres`	Unknown
`tiers_cp`	Unknown
`tiers_date`	Unknown
`tiers_email`	Unknown
`tiers_eta`	Unknown
`tiers_fax`	Unknown
`tiers_nom`	Unknown
`tiers_prenom`	Unknown
`tiers_prix`	Unknown
`tiers_prix_2`	Unknown
`tiers_tel`	Unknown
`tiers_ville`	Unknown
`title`	Unknown
`tlossreason_code`	Unknown
`torigin_code`	Unknown
`tw_bid`	Unknown
`un_code`	Unknown
`val_amount`	Unknown
`val_quotation_id`	Unknown
`val_success_rate`	Unknown
`val_weighted_amount`	Unknown
`val_weighted_amount_ht`	Unknown
`workflow_step`	Unknown