nowdatabase/documentation/class_diagram.md

```mermaid
classDiagram
    com_mlist --|> now_mus : museum
    com_people --|> com_users : user_id
    com_people --|> now_bau : "bau_coordinator, bau_authorizer"
    com_people --|> now_lau : "lau_coordinator, lau_authorizer"
    com_people --|> now_proj : contact
    com_people --|> now_proj_people : initials
    com_people --|> now_reg_coord_people : initials
    com_people --|> now_sau : "sau_coordinator, sau_authorizer"
    com_people --|> now_sp_coord_people : initials
    com_people --|> now_strat_coord_people : initials
    com_people --|> now_tau : "tau_coordinator, tau_authorizer"
    com_species --|> com_taxa_synonym : species_id
    com_species --|> now_ls : species_id
    com_species --|> now_sau : species_id
    com_species --|> now_sp_coord_taxa : "order_name, family_name"
    now_bau --|> now_br : buid
    now_coll_meth_values --|> now_coll_meth : coll_meth
    now_lau --|> now_lr : luid
    now_loc --|> now_coll_meth : lid
    now_loc --|> now_lau : lid
    now_loc --|> now_ls : lid
    now_loc --|> now_mus : lid
    now_loc --|> now_plr : lid
    now_loc --|> now_ss : lid
    now_loc --|> now_syn_loc : lid
    now_proj --|> now_plr : pid
    now_proj_people --|> now_proj : pid
    now_regional_culture --|> now_loc : "regional_culture_1, regional_culture_2, regional_culture_3"
    now_reg_coord --|> now_reg_coord_country : reg_coord_id
    now_reg_coord --|> now_reg_coord_people : reg_coord_id
    now_sau --|> now_sr : suid
    now_ss_values --|> now_ss : sed_struct
    now_sp_coord --|> now_sp_coord_people : sp_coord_id
    now_sp_coord --|> now_sp_coord_taxa : sp_coord_id
    now_strat_coord --|> now_strat_coord_people : strat_coord_id
    now_tau --|> now_time_update : tuid
    now_tau --|> now_tr : tuid
    now_time_unit --|> now_loc : "bfa_max, bfa_min"
    now_time_unit --|> now_tau : tu_name
    now_time_unit --|> now_time_update : tu_name
    now_tu_bound --|> now_bau : bid
    now_tu_bound --|> now_time_unit : "up_bnd, low_bnd"
    now_tu_bound --|> now_time_update : "upper_buid, lower_buid"
    now_tu_bound --|> now_tur : bid
    now_tu_sequence --|> now_time_unit : sequence
    now_tr --|> now_time_update : tuid

    ref_field_name --|> ref_authors : field_id
    ref_journal --|> ref_ref : journal_id
    ref_keywords --|> ref_keywords_ref : keywords_id
    ref_ref --|> now_br : rid
    ref_ref --|> now_lr : rid
    ref_ref --|> now_sr : rid
    ref_ref --|> now_tr : rid
    ref_ref --|> now_tur : rid
    ref_ref --|> ref_authors : rid
    ref_ref --|> ref_keywords_ref : rid
    ref_ref_type --|> ref_field_name : ref_type_id
    ref_ref_type --|> ref_ref : ref_type_id

    class com_mlist{
      +varchar museum (PK)
      +varchar institution
      +varchar country
    }

    class com_people{
      +varchar initials (PK)
      +int user_id (FK)
    }

    class com_species{
      +int species_id (PK)
      +varchar class_name
      +varchar order_name
      +varchar family_name
      +varchar genus_name
      +varchar species_name
    }

    class com_taxa_synonym{
      +int synonym_id (PK)
      +int species_id (FK)
    }

    class com_users{
      +int user_id (PK)
    }

    class now_bau{
      +int buid (PK)
      +varchar bau_coordinator (FK)
      +varchar bau_authorizer (FK)
      +int bid (FK)
    }

    class now_br{
      +int buid (PK, FK)
      +int rid (PK, FK)
    }

    class now_coll_meth{
      +int lid (PK, FK)
      +varchar coll_meth (PK, FK)
    }

    class now_coll_meth_values{
      +varchar coll_meth (PK)
    }

    class now_lau{
      +int luid (PK)
      +varchar lau_coordinator (FK)
      +varchar lau_authorizer (FK)
      +int lid (FK)
    }

    class now_loc{
      +int lid (PK)
      +varchar bfa_max (FK)
      +varchar bfa_min (FK)
      +varchar regional_culture_1 (FK)
      +varchar regional_culture_2 (FK)
      +varchar regional_culture_3 (FK)
      +varchar country
    }

    class now_lr{
      +int luid (PK, FK)
      +int rid (PK, FK)
    }

    class now_ls{
      +int lid (PK, FK)
      +int species_id (PK, FK)
    }

    class now_mus{
      +int lid (PK, FK)
      +varchar museum (PK, FK)
    }

    class now_plr{
      +int lid (PK, FK)
      +int pid (PK, FK)
    }

    class now_proj{
      +int pid (PK)
      +varchar contact (FK)
      +varchar proj_code
      +varchar proj_name
    }

    class now_proj_people{
      +int pid (PK, FK)
      +varchar initials (PK, FK)
    }

    class now_regional_culture{
      +varchar regional_culture_id (PK)
    }

    class now_reg_coord{
      +int reg_coord_id (PK)
      +varchar region
    }

    class now_reg_coord_country{
      +int reg_coord_id (PK, FK)
      +varchar country (PK)
    }

    class now_reg_coord_people{
      +int reg_coord_id (PK, FK)
      +varchar initials (PK, FK)
    }

    class now_sau{
      +int suid (PK)
      +varchar sau_coordinator (FK)
      +varchar sau_authorizer (FK)
      +int species_id (FK)
    }

    class now_sp_coord{
      +int sp_coord_id (PK)
      +varchar tax_group
    }

    class now_sp_coord_people{
      +int sp_coord_id (PK, FK)
      +varchar initials (PK, FK)
    }

    class now_sp_coord_taxa{
      +int sp_coord_id (PK, FK)
      +varchar order_name (PK, FK)
      +varchar family_name (PK, FK)
    }

    class now_sr{
      +int suid (PK, FK)
      +int rid (PK, FK)
    }

    class now_ss{
      +int lid (PK, FK)
      +varchar sed_struct (PK, FK)
    }

    class now_ss_values{
      +varchar ss_value (PK)
      +varchar category
    }

    class now_strat_coord{
      +int strat_coord_id (PK)
      +varchar title
    }

    class now_strat_coord_people{
      +int strat_coord_id (PK, FK)
      +varchar initials (PK, FK)
    }

    class now_syn_loc{
      +int syn_id (PK)
      +int lid (FK)
    }

    class now_tau{
      +int tuid (PK)
      +varchar tau_coordinator (FK)
      +varchar tau_authorizer (FK)
      +varchar tu_name (FK)
    }

    class now_time_unit{
      +varchar tu_name (PK)
      +varchar tu_display_name
      +int up_bnd (FK)
      +int low_bnd (FK)
      +varchar sequence (FK)
    }

    class now_time_update{
      +int time_update_id (PK)
      +varchar tu_name (FK)
      +int tuid (FK)
      +int lower_buid (FK)
      +int upper_buid (FK)
    }

    class now_tr{
      +int tuid (PK, FK)
      +int rid (PK, FK)
    }

    class now_tur{
      +int bid (PK, FK)
      +int rid (PK, FK)
    }

    class now_tu_bound{
      +int bid (PK)
      +varchar b_name
      +double age
      +varchar b_comment
    }

    class now_tu_sequence{
      +varchar sequence (PK)
      +varchar seq_name
    }

    class ref_authors{
      +int rid (PK, FK)
      +int field_id (PK, FK)
      +int au_num (PK)
    }

    class ref_field_name{
      +int field_ID (PK)
      +int ref_type_id (PK, FK)
    }

    class ref_journal{
      +int journal_id (PK)
    }

    class ref_keywords{
      +int keywords_id (PK)
    }

    class ref_keywords_ref{
      +int keywords_id (PK, FK)
      +int rid (PK, FK)
    }

    class ref_ref{
      +int rid (PK)
      +int ref_type_id (FK)
      +int journal_id (FK)
      +varchar title_primary
      +int date_primary
    }

    class ref_ref_type{
      +int ref_type_id (PK)
    }
```