rcoleo: rcoleo

# tips for working with this table
# use datapasta::fiddle() to fix formatting after an update

# Table des tables requises par type de campagne
#
#
# @return a tbl_df showing which tables are required for which injection efforts.
coleo_get_required_tables <- function(){

tibble::tribble(
                           ~table, ~'phénologie_indicateur', ~'phénologie', ~'v\u00e9g\u00e9tation', ~'v\u00e9g\u00e9tation_transect', ~sol, ~'acoustique_chiropt\u00e8res', ~'acoustique_orthopt\u00e8res', ~acoustique_oiseaux, ~acoustique_anoures, ~'acoustique_mammif\u00e8res', ~'ph\u00e9nologie', ~'mammif\u00e8res', ~'papilionid\u00e9s', ~odonates, ~insectes_sol, ~ADNe, ~ADNe_corrigé, ~ADNe_brut, ~ADNe_blanc, ~zooplancton, ~'temp\u00e9rature_eau', ~'temp\u00e9rature_sol', ~'marais_profondeur_temp\u00e9rature', ~'d\u00e9composition_sol', ~thermographe,~benthos, ~physicochimie_terrain, ~physicochimie_labo, ~NDSI, ~FPAR,
                          "cells",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                          "sites",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                      "campaigns",                        0,             1,                       1,                                1,    1,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    1,         1,             1,     1,             1,          1,           1,            1,                       0,                       0,                                     0,                         1,             1,       1,                      1,                   1,     0,     0,
                        "efforts",                        0,             0,                       1,                                1,    0,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    0,         1,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       1,                      0,                   0,     0,     0,
                   "environments",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    1,         1,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       1,                      1,                   1,     0,     0,
                        "devices",                        0,             1,                       0,                                0,    0,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                          "lures",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  1,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                          "traps",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             1,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                      "landmarks",                        0,             1,                       1,                                1,    1,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    0,         0,             1,     1,             0,          1,           1,            1,                       0,                       0,                                     0,                         1,             1,       0,                      1,                   1,     0,     0,
                        "samples",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             1,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                   "thermographs",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             1,       0,                      0,                   0,     0,     0,
                   "observations",                        0,             1,                       1,                                1,    1,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    1,         1,             1,     1,             1,          1,           1,            1,                       0,                       0,                                     0,                         1,             0,       1,                      1,                   1,     0,     0,
    "observations_efforts_lookup",                        0,             0,                       1,                                1,    0,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    0,         1,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       1,                      0,                   0,     0,     0,
  "observations_landmarks_lookup",                        0,             1,                       1,                                1,    1,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    0,         0,             1,     1,             0,          1,           1,            1,                       0,                       0,                                     0,                         1,             1,       0,                      1,                   1,     0,     0,
                    "obs_species",                        0,             0,                       1,                                1,    0,                              1,                              1,                   1,                   1,                             1,                  0,                  1,                    1,         1,             1,     0,             0,          0,           0,            1,                       0,                       0,                                     0,                         0,             0,       1,                      0,                   0,     0,     0,
                     "attributes",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
         "obs_soil_decomposition",                        0,             0,                       0,                                0,    1,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         1,             0,       0,                      0,                   0,     0,     0,
                       "obs_lake",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      1,                   1,     0,     0,
                       "obs_edna",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     1,             1,          1,           1,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                       "obs_soil",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
          "obs_temperature_depth",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                "obs_thermograph",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             1,       0,                      0,                   0,     0,     0,
                      "obs_pheno",                        0,             1,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
                          "media",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  1,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0,
          "remote_sensing_events",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     1,     1,
             "remote_sensing_obs",                        0,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     1,     1,
           "vegetation_phenology",                        1,             0,                       0,                                0,    0,                              0,                              0,                   0,                   0,                             0,                  0,                  0,                    0,         0,             0,     0,             0,          0,           0,            0,                       0,                       0,                                     0,                         0,             0,       0,                      0,                   0,     0,     0
)
}