erDiagram
  shop_shop ||--o{ shop_shop_marine_life : "shop_id"
  marine_life2_marinelifecritter ||--o{ shop_shop_marine_life : "marinelifecritter_id"
  marine_life2_marinelifegroup ||--o{ marine_life2_marinelifecritter : "group_id"
  marine_life2_marinelifekind ||--o{ marine_life2_marinelifegroup : "kind_id"
  shop_shop ||--o{ shop_shop_adventure_dive_sites : "shop_id"
  places_adventuredivesite ||--o{ shop_shop_adventure_dive_sites : "adventuredivesite_id"
  diving_activityproduct ||--o{ diving_activityproduct_sites : "activityproduct_id"
  places_adventuredivesite ||--o{ diving_activityproduct_sites : "adventuredivesite_id"
  places_location |o--o{ places_adventuredivesite : "reference_location_id"
  shop_shop {
    int id PK
  }
  shop_shop_marine_life {
    int shop_id FK
    int marinelifecritter_id FK
  }
  marine_life2_marinelifecritter {
    int id PK "critter_ids"
    text title "10 languages, search"
    int group_id FK
    bool is_active
  }
  marine_life2_marinelifegroup {
    int id PK "marine_group_ids"
    text title "Sharks and Rays"
    int kind_id FK
  }
  marine_life2_marinelifekind {
    int id PK
    text title "Fish, Mammals"
  }
  shop_shop_adventure_dive_sites {
    int shop_id FK
    int adventuredivesite_id FK
  }
  places_adventuredivesite {
    int id PK "dive_site_ids"
    text title "10 languages, search"
    smallint status "approved only"
    bool is_private "exclude"
    float8 latitude
    float8 longitude
    int reference_location_id FK
  }
  diving_activityproduct {
    int id PK
  }
  diving_activityproduct_sites {
    int activityproduct_id FK
    int adventuredivesite_id FK
  }
  places_location {
    int id PK
  }