# Coheris schema ERD

Table and field reference for the Fivetran Coheris connector.

## 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 |  |

## Relationships

- table_a(parent_id) → table_a(code)
- table_me(parent_id) → table_me(code)
- table_16(parent_id) → table_16(code)
- table_grp(parent_id) → table_grp(code)
- table_11(parent_id) → table_11(code)
- table_10(parent_id) → table_10(code)
- table_5(co_code) → country(code)
- table_5(la_code) → langues(code)
- table_6(parent_id) → table_6(code)
- table_7(parent_id) → table_7(code)
- table_4(co_code) → country(code)
- table_4(parent_id) → table_4(code)
- table_4(la_code) → langues(code)
- table_40(parent_id) → table_40(code)
- historique(groups_code) → link_groups_table_u(code)
- historique(af_code) → affaires(code)
- historique(t_ca_code) → table_ca(code)
- historique(reference) → client(reference)
- historique(t_a_code) → table_a(code)
- af_link(af_code) → affaires(code)
- meeting(af_code) → affaires(code)
- meeting(hi_code) → historique(code)
- wishlist(reference) → client(reference)
- client(t_19_code) → table_19(code)
- client(t_15_code) → table_15(code)
- client(t_16_code) → table_16(code)
- client(t_18_code) → table_18(code)
- client(t_2_code) → table_2(code)
- client(t_1_code) → table_1(code)
- client(co_code) → country(code)
- client(la_code) → langues(code)
- client(t_17_code) → table_17(code)
- wishlist_line(wi_code) → wishlist(code)
- cl_channel(reference) → client(reference)
- affaires(t_5_code) → table_5(code)
- affaires(t_40_code) → table_40(code)
- affaires(t_10_code) → table_10(code)
- affaires(t_23_code) → table_23(code)
- affaires(t_4_code) → table_4(code)
- affaires(t_8_code) → table_8(code)
- affaires(t_11_code) → table_11(code)
- affaires(t_22_code) → table_22(code)
- affaires(t_7_code) → table_7(code)
- affaires(t_21_code) → table_21(code)
- affaires(co_code) → country(code)
- affaires(t_me_code) → table_me(code)
- affaires(t_6_code) → table_6(code)
- affaires(la_code) → langues(code)
- affaires(t_9_code) → table_9(code)