quietlight/skraak.app - Change ITCK5KKON6QVQ4CVU7KEZNQTUHPVDHMOTKGWSWFWN4XGWIBDFLFQC

added TODO.md, updated component-flow.mms and schema.dbml

Created by AEj8dahVWy718uSSFPe9VSRJ5qX5G8pC2zvFzJJ8yzBd on May 31, 2025

ITCK5KKON6QVQ4CVU7KEZNQTUHPVDHMOTKGWSWFWN4XGWIBDFLFQC

Dependencies

In channels

main

Change contents

File deletion: B2_SETUP.md

BF:BFD[5.1] → [3.7090:7125]

BF:BFD[3.7125] → [3.4579:4579]

B:BD[3.4579] → [3.4580:7089]

# Backblaze B2 Setup for Skraak
## Environment Variables Required
You need to add the following environment variables to your Cloudflare Workers environment:
### 1. B2_APPLICATION_KEY_ID
- This is your Backblaze B2 Application Key ID
- You can get this from your Backblaze B2 account dashboard
- Go to: Account → Application Keys → Create Application Key
### 2. B2_APPLICATION_KEY  
- This is your Backblaze B2 Application Key (secret)
- Generated when you create an Application Key
- **Important**: This is sensitive - store securely
### 3. B2_BUCKET_NAME
- Set this to: `skraak`
- This should match your existing bucket name
## How to Add Environment Variables
### For Local Development (.dev.vars):
Create a `.dev.vars` file in your project root with:
```
B2_APPLICATION_KEY_ID=your_key_id_here
B2_APPLICATION_KEY=your_application_key_here
B2_BUCKET_NAME=skraak
```
**Note**: `.dev.vars` is the Cloudflare Workers equivalent of `.env` and is automatically used by `wrangler dev` and `npm run dev`. Make sure to add `.dev.vars` to your `.gitignore` file to keep secrets secure.
### For Production (Cloudflare Workers):
**Option 1: Using wrangler CLI (Recommended)**
```bash
# Set sensitive credentials as secrets
wrangler secret put B2_APPLICATION_KEY_ID
wrangler secret put B2_APPLICATION_KEY
# Set non-sensitive config as environment variable
wrangler env put B2_BUCKET_NAME skraak
```
**Option 2: Using wrangler.json for bucket name**
Add to your `wrangler.json`:
```json
{
  "vars": {
    "KINDE_ISSUER_URL": "https://skraak.kinde.com",
    "B2_BUCKET_NAME": "skraak"
  }
}
```
Then only set the sensitive credentials as secrets:
```bash
wrangler secret put B2_APPLICATION_KEY_ID  
wrangler secret put B2_APPLICATION_KEY
```
Or add them in the Cloudflare Dashboard:
1. Go to Workers & Pages
2. Select your worker
3. Go to Settings → Environment Variables
4. Add the three variables above
## B2 Application Key Permissions
When creating your B2 Application Key, ensure it has:
- **Read Files** permission for the `skraak` bucket
- **List Files** permission for the `skraak` bucket
You don't need write permissions for this download-only functionality.
## Testing the Setup
Once configured, you can test the download endpoint:
```bash
# Get a valid file ID from your database where upload=true
curl -H "Authorization: Bearer YOUR_JWT_TOKEN" \
  "https://skraak.app/api/files/YOUR_FILE_ID/download"
```
This should return the FLAC audio file if everything is configured correctly.

File deletion: FILE_COMPONENT_PLAN.md

BF:BFD[5.1] → [4.22406:22452]

BF:BFD[4.22452] → [4.15386:15386]

B:BD[4.15386] → [4.15387:22405]

# File Component Architecture Plan
## 🎯 Overview
Create a `File.tsx` component that handles audio playback and file management based on upload status and user ownership.
## 🔄 User Flows
### Flow A: `upload=true` (File Available Online)
- **Trigger**: User clicks filename in Cluster/Selection component
- **Action**: Load audio from `/api/files/{fileId}/download` endpoint
- **Display**: Wavesurfer.js with spectrogram plugin
- **Features**: Play/pause, seeking, waveform visualization, spectrogram
- **Future**: Annotation tools for creating selections
### Flow B: `upload=false` + User is Owner
- **Trigger**: User clicks filename in Cluster/Selection component  
- **Action**: Show file picker interface
- **Primary**: File System Access API (Chrome 86+, Safari 15.2+)
- **Fallback**: `<input type="file" accept="audio/*">` 
- **Post-selection**: Load local file into wavesurfer.js
- **Future**: Option to upload file to B2
### Flow C: `upload=false` + User is NOT Owner  
- **Trigger**: User clicks filename in Cluster/Selection component
- **Action**: Show informational message
- **Display**: "File not available for playback" + metadata
- **No audio loading capability**
## 🏗️ Component Architecture
### Component Structure
```
File.tsx (Modal/Dialog)
├── FileHeader (filename, close button)
├── FileContent (conditional rendering)
│   ├── AudioPlayer (upload=true)
│   │   ├── WaveSurfer container
│   │   ├── Controls (play/pause/seek)
│   │   └── Spectrogram display
│   ├── FilePicker (upload=false + owner)
│   │   ├── FileSystemAccessPicker
│   │   └── FallbackFilePicker
│   └── FileUnavailable (upload=false + not owner)
└── FileFooter (metadata, actions)
```
### Props Interface
```typescript
interface FileProps {
  file: File;           // File object with all metadata
  isOpen: boolean;      // Modal open state
  onClose: () => void;  // Close modal callback
  currentUserId: string; // From Kinde auth context
}
```
### State Management
```typescript
interface FileState {
  // Audio loading
  audioLoading: boolean;
  audioError: string | null;
  wavesurfer: WaveSurfer | null;
  
  // File picking
  localFile: File | null;
  filePickerSupported: boolean;
  
  // UI states
  isPlaying: boolean;
  currentTime: number;
  duration: number;
}
```
## 🔧 Technical Implementation Plan
### 1. Owner Detection Logic
```typescript
const isOwner = (file: File, currentUserId: string): boolean => {
  return file.created_by === currentUserId || file.modified_by === currentUserId;
  // TODO: Consider admin roles, dataset ownership, etc.
};
```
### 2. Wavesurfer.js Setup
```typescript
// For online files (upload=true)
const initWaveSurfer = async (fileId: string, token: string) => {
  const wavesurfer = WaveSurfer.create({
    container: containerRef.current,
    waveColor: '#4F46E5',
    progressColor: '#7C3AED',
    responsive: true,
    height: 100,
  });
  
  // Add spectrogram plugin
  wavesurfer.registerPlugin(SpectrogramPlugin.create({
    container: spectrogramRef.current,
    height: 256,
  }));
  
  // Load authenticated audio
  await wavesurfer.load(`/api/files/${fileId}/download`, {
    headers: { Authorization: `Bearer ${token}` }
  });
};
// For local files (upload=false + owner)
const loadLocalFile = (file: File) => {
  const url = URL.createObjectURL(file);
  wavesurfer.load(url);
};
```
### 3. File System Access API Implementation
```typescript
const openFilePicker = async (): Promise<File | null> => {
  // Feature detection
  if ('showOpenFilePicker' in window) {
    try {
      const [fileHandle] = await window.showOpenFilePicker({
        types: [{
          description: 'Audio files',
          accept: {
            'audio/*': ['.wav', '.mp3', '.flac', '.ogg', '.m4a']
          }
        }],
        multiple: false
      });
      return await fileHandle.getFile();
    } catch (error) {
      if (error.name === 'AbortError') return null; // User cancelled
      throw error;
    }
  } else {
    // Fallback to input element
    return new Promise((resolve) => {
      const input = document.createElement('input');
      input.type = 'file';
      input.accept = 'audio/*';
      input.onchange = (e) => {
        const file = (e.target as HTMLInputElement).files?.[0];
        resolve(file || null);
      };
      input.click();
    });
  }
};
```
### 4. Authentication Integration
```typescript
const { getAccessToken } = useKindeAuth();
const loadAuthenticatedAudio = async (fileId: string) => {
  const token = await getAccessToken();
  await initWaveSurfer(fileId, token);
};
```
## 🔗 Integration Points
### Cluster.tsx & Selection.tsx Updates
```typescript
// Add click handler to filename
const handleFileNameClick = (file: File) => {
  setSelectedFile(file);
  setIsFileModalOpen(true);
};
// In render:
<TableCell 
  className="font-medium whitespace-normal break-words cursor-pointer hover:text-blue-600"
  onClick={() => handleFileNameClick(file)}
>
  {file.fileName}
</TableCell>
```
### Modal/Dialog System
- Use existing UI components (Dialog from shadcn/ui)
- Full-screen on mobile, large modal on desktop
- Escape key to close, backdrop click to close
- Proper focus management for accessibility
## 📦 Dependencies & Plugins
### New Dependencies Needed
```bash
npm install @wavesurfer/spectrogram  # Spectrogram plugin
```
### Import Structure
```typescript
import WaveSurfer from 'wavesurfer.js';
import SpectrogramPlugin from '@wavesurfer/spectrogram';
```
## 🎨 UI/UX Considerations
### Layout
- **Header**: Filename, file metadata, close button
- **Main**: Waveform + spectrogram (stacked vertically)
- **Controls**: Play/pause, time display, volume
- **Footer**: File info, actions (future: download, annotate)
### Responsive Design
- Mobile: Stack vertically, smaller spectrogram
- Desktop: Larger displays, side-by-side layouts possible
- Touch-friendly controls for mobile devices
### Loading States
- Skeleton loader for waveform area
- Progress indicator for file loading
- Error boundaries for failed loads
### Color Scheme
- Match existing app theme
- High contrast for waveform visibility
- Accessible color combinations for spectrogram
## 🚀 Implementation Order
1. **Basic File component structure** (modal, props, conditional rendering)
2. **Owner detection logic** (compare user IDs)
3. **Wavesurfer.js integration** (online files first)
4. **File System Access API** (local file picking)
5. **Spectrogram plugin setup** (both online and local)
6. **Integration with Cluster/Selection** (click handlers)
7. **Polish & error handling** (loading states, errors)
## 🔮 Future Enhancements
- **Annotation tools**: Create selections on waveform
- **Upload functionality**: Upload local files to B2
- **Keyboard shortcuts**: Spacebar play/pause, arrow keys seek
- **Zoom controls**: Zoom in/out on waveform/spectrogram
- **Export options**: Download selections, export annotations

File deletion: TESTING.md

BF:BFD[5.1] → [6.42735:42769]

BF:BFD[6.42769] → [6.39786:39786]

B:BD[6.39786] → [6.39787:42734]

# Testing Setup Complete ✅
Vitest has been successfully set up for the Skraak project with comprehensive testing capabilities.
## 🎯 What's Included
### **Dependencies Installed**
- `vitest` - Fast test runner
- `@vitest/ui` - Web UI for test results
- `jsdom` & `happy-dom` - DOM environments
- `@testing-library/react` - React component testing
- `@testing-library/jest-dom` - Additional matchers
- `@testing-library/user-event` - User interaction simulation
### **Configuration Files**
- `vitest.config.ts` - Main Vitest configuration
- `src/test/setup.ts` - Global test setup and mocks
- `src/test/README.md` - Detailed testing documentation
### **Test Structure**
```
src/test/
├── setup.ts                    # Global setup and mocks
├── __mocks__/                  # Reusable mocks and test data
│   ├── kinde-auth.ts          # Authentication mocking
│   └── dataset-data.ts        # Sample dataset data
├── __tests__/
│   ├── components/            # React component tests
│   │   └── Datasets.test.tsx  # Comprehensive Datasets component tests
│   └── worker/                # API/Business logic tests
│       └── datasets-api.test.ts # API validation and permission tests
└── README.md                  # Testing guidelines
```
## 🧪 Test Coverage
### **Component Tests (9 tests)**
- ✅ Loading states
- ✅ Data rendering
- ✅ Error handling 
- ✅ User interactions (clicks, form submissions)
- ✅ Conditional rendering based on permissions
- ✅ Button visibility for different user roles
### **API Logic Tests (5 tests)**
- ✅ Permission validation logic
- ✅ Data validation rules
- ✅ Database result transformations
- ✅ Role-based access control logic
## 🚀 Available Commands
```bash
# Development (watch mode)
npm test
# Run once
npm run test:run
# Visual UI
npm run test:ui
# Coverage report
npm run test:coverage
```
## 💡 Key Features
### **Mocking Strategy**
- **External Services**: Kinde Auth, database connections
- **Fetch API**: Global fetch mocking for API calls
- **Realistic Data**: Sample datasets matching production structure
### **Testing Philosophy**
- **Behavior-focused**: Tests what users experience
- **Integration-friendly**: Component tests include realistic interactions
- **Maintainable**: Clear test structure and reusable mocks
### **Claude Code Compatibility**
- **Simple syntax**: Easy for Claude to read and generate tests
- **Clear patterns**: Consistent testing approaches
- **Good documentation**: Self-explanatory test names and structure
## ✨ Next Steps
1. **Add more component tests** as you build new features
2. **Create integration tests** for complex workflows
3. **Add E2E tests** with Playwright for critical user journeys
4. **Set up CI/CD** to run tests automatically
The testing foundation is now solid and ready for continuous development with Claude Code assistance!

Replacement in src/test/setup.ts at line 2 [6.812]
B:BD[6.848] → [6.848:891]
```
import { expect, afterEach } from 'vitest'
```
[6.848]
[6.891]
```
import { expect, afterEach, vi } from 'vitest'
```
Replacement in src/test/setup.ts at line 44 [6.812]
B:BD[6.1857] → [6.1857:1858]
```
}
```
[6.1857]
```
}
```

File deletion: Count.tsx

BF:BFD[7.457] → [8.7713:7746]

BF:BFD[8.7746] → [8.7302:7302]

B:BD[8.7302] → [8.7303:7344]

∅:D[9.694] → [8.7382:7712]

B:BD[8.7382] → [8.7382:7712]

B:BD[8.7344] → [9.660:694]

import React, { useState } from "react";
const Count: React.FC = () => {
  const [count, setCount] = useState(0);
  return (
    <div className="card">
      <Button
        onClick={() => setCount((count) => count + 1)}
        aria-label="increment"
        variant="default"
      >
        count is {count}
      </Button>
    </div>
  );
};
export default Count;
import Button from "./ui/button";

File addition: schema.svg (----------)

[10.1]

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.47.0 (20210316.0004)
 -->
<!-- Title: dbml Pages: 1 -->
<svg width="6328pt" height="4496pt"
 viewBox="0.00 0.00 6328.39 4496.09" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 4492.09)">
<title>dbml</title>
<!-- dataset_type -->
<g id="dataset_type" class="node">
<title>dataset_type</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1081.81" cy="-632.65" rx="235.43" ry="172.57"/>
<polygon fill="#29235c" stroke="transparent" points="917.81,-692.65 917.81,-752.65 1246.81,-752.65 1246.81,-692.65 917.81,-692.65"/>
<polygon fill="none" stroke="#29235c" points="917.81,-692.65 917.81,-752.65 1246.81,-752.65 1246.81,-692.65 917.81,-692.65"/>
<text text-anchor="start" x="928.46" y="-713.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;dataset_type &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="917.81,-632.65 917.81,-692.65 1246.81,-692.65 1246.81,-632.65 917.81,-632.65"/>
<polygon fill="none" stroke="#29235c" points="917.81,-632.65 917.81,-692.65 1246.81,-692.65 1246.81,-632.65 917.81,-632.65"/>
<text text-anchor="start" x="985.39" y="-653.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;organise &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="917.81,-572.65 917.81,-632.65 1246.81,-632.65 1246.81,-572.65 917.81,-572.65"/>
<polygon fill="none" stroke="#29235c" points="917.81,-572.65 917.81,-632.65 1246.81,-632.65 1246.81,-572.65 917.81,-572.65"/>
<text text-anchor="start" x="1020.95" y="-593.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;test &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="917.81,-512.65 917.81,-572.65 1246.81,-572.65 1246.81,-512.65 917.81,-512.65"/>
<polygon fill="none" stroke="#29235c" points="917.81,-512.65 917.81,-572.65 1246.81,-572.65 1246.81,-512.65 917.81,-512.65"/>
<text text-anchor="start" x="1015.63" y="-533.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;train &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="916.31,-511.65 916.31,-753.65 1247.31,-753.65 1247.31,-511.65 916.31,-511.65"/>
</g>
<!-- gain_level -->
<g id="gain_level" class="node">
<title>gain_level</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="4497.59" cy="-2411.65" rx="207.78" ry="257.27"/>
<polygon fill="#29235c" stroke="transparent" points="4352.59,-2531.65 4352.59,-2591.65 4642.59,-2591.65 4642.59,-2531.65 4352.59,-2531.65"/>
<polygon fill="none" stroke="#29235c" points="4352.59,-2531.65 4352.59,-2591.65 4642.59,-2591.65 4642.59,-2531.65 4352.59,-2531.65"/>
<text text-anchor="start" x="4363.33" y="-2552.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;gain_level &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4352.59,-2471.65 4352.59,-2531.65 4642.59,-2531.65 4642.59,-2471.65 4352.59,-2471.65"/>
<polygon fill="none" stroke="#29235c" points="4352.59,-2471.65 4352.59,-2531.65 4642.59,-2531.65 4642.59,-2471.65 4352.59,-2471.65"/>
<text text-anchor="start" x="4438.03" y="-2492.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;low &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4352.59,-2411.65 4352.59,-2471.65 4642.59,-2471.65 4642.59,-2411.65 4352.59,-2411.65"/>
<polygon fill="none" stroke="#29235c" points="4352.59,-2411.65 4352.59,-2471.65 4642.59,-2471.65 4642.59,-2411.65 4352.59,-2411.65"/>
<text text-anchor="start" x="4375.81" y="-2432.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;low&#45;medium &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4352.59,-2351.65 4352.59,-2411.65 4642.59,-2411.65 4642.59,-2351.65 4352.59,-2351.65"/>
<polygon fill="none" stroke="#29235c" points="4352.59,-2351.65 4352.59,-2411.65 4642.59,-2411.65 4642.59,-2351.65 4352.59,-2351.65"/>
<text text-anchor="start" x="4405.14" y="-2372.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;medium &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4352.59,-2291.65 4352.59,-2351.65 4642.59,-2351.65 4642.59,-2291.65 4352.59,-2291.65"/>
<polygon fill="none" stroke="#29235c" points="4352.59,-2291.65 4352.59,-2351.65 4642.59,-2351.65 4642.59,-2291.65 4352.59,-2291.65"/>
<text text-anchor="start" x="4369.58" y="-2312.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;medium&#45;high &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4352.59,-2231.65 4352.59,-2291.65 4642.59,-2291.65 4642.59,-2231.65 4352.59,-2231.65"/>
<polygon fill="none" stroke="#29235c" points="4352.59,-2231.65 4352.59,-2291.65 4642.59,-2291.65 4642.59,-2231.65 4352.59,-2231.65"/>
<text text-anchor="start" x="4431.79" y="-2252.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;high &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="4351.59,-2230.65 4351.59,-2592.65 4643.59,-2592.65 4643.59,-2230.65 4351.59,-2230.65"/>
</g>
<!-- role_name -->
<g id="role_name" class="node">
<title>role_name</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1945.13" cy="-3784.65" rx="212.68" ry="172.57"/>
<polygon fill="#29235c" stroke="transparent" points="1797.13,-3844.65 1797.13,-3904.65 2094.13,-3904.65 2094.13,-3844.65 1797.13,-3844.65"/>
<polygon fill="none" stroke="#29235c" points="1797.13,-3844.65 1797.13,-3904.65 2094.13,-3904.65 2094.13,-3844.65 1797.13,-3844.65"/>
<text text-anchor="start" x="1807.81" y="-3865.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;role_name &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1797.13,-3784.65 1797.13,-3844.65 2094.13,-3844.65 2094.13,-3784.65 1797.13,-3784.65"/>
<polygon fill="none" stroke="#29235c" points="1797.13,-3784.65 1797.13,-3844.65 2094.13,-3844.65 2094.13,-3784.65 1797.13,-3784.65"/>
<text text-anchor="start" x="1858.51" y="-3805.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;ADMIN &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1797.13,-3724.65 1797.13,-3784.65 2094.13,-3784.65 2094.13,-3724.65 1797.13,-3724.65"/>
<polygon fill="none" stroke="#29235c" points="1797.13,-3724.65 1797.13,-3784.65 2094.13,-3784.65 2094.13,-3724.65 1797.13,-3724.65"/>
<text text-anchor="start" x="1865.61" y="-3745.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;USER &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1797.13,-3664.65 1797.13,-3724.65 2094.13,-3724.65 2094.13,-3664.65 1797.13,-3664.65"/>
<polygon fill="none" stroke="#29235c" points="1797.13,-3664.65 1797.13,-3724.65 2094.13,-3724.65 2094.13,-3664.65 1797.13,-3664.65"/>
<text text-anchor="start" x="1830.96" y="-3685.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;CURATOR &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="1795.63,-3663.65 1795.63,-3905.65 2094.63,-3905.65 2094.63,-3663.65 1795.63,-3663.65"/>
</g>
<!-- permission_name -->
<g id="permission_name" class="node">
<title>permission_name</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1945.13" cy="-3136.65" rx="284.01" ry="257.27"/>
<polygon fill="#29235c" stroke="transparent" points="1746.13,-3256.65 1746.13,-3316.65 2144.13,-3316.65 2144.13,-3256.65 1746.13,-3256.65"/>
<polygon fill="none" stroke="#29235c" points="1746.13,-3256.65 1746.13,-3316.65 2144.13,-3316.65 2144.13,-3256.65 1746.13,-3256.65"/>
<text text-anchor="start" x="1756.64" y="-3277.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;permission_name &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1746.13,-3196.65 1746.13,-3256.65 2144.13,-3256.65 2144.13,-3196.65 1746.13,-3196.65"/>
<polygon fill="none" stroke="#29235c" points="1746.13,-3196.65 1746.13,-3256.65 2144.13,-3256.65 2144.13,-3196.65 1746.13,-3196.65"/>
<text text-anchor="start" x="1865.11" y="-3217.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;READ &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1746.13,-3136.65 1746.13,-3196.65 2144.13,-3196.65 2144.13,-3136.65 1746.13,-3136.65"/>
<polygon fill="none" stroke="#29235c" points="1746.13,-3136.65 1746.13,-3196.65 2144.13,-3196.65 2144.13,-3136.65 1746.13,-3136.65"/>
<text text-anchor="start" x="1843.77" y="-3157.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;UPLOAD &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1746.13,-3076.65 1746.13,-3136.65 2144.13,-3136.65 2144.13,-3076.65 1746.13,-3076.65"/>
<polygon fill="none" stroke="#29235c" points="1746.13,-3076.65 1746.13,-3136.65 2144.13,-3136.65 2144.13,-3076.65 1746.13,-3076.65"/>
<text text-anchor="start" x="1815.34" y="-3097.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;DOWNLOAD &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1746.13,-3016.65 1746.13,-3076.65 2144.13,-3076.65 2144.13,-3016.65 1746.13,-3016.65"/>
<polygon fill="none" stroke="#29235c" points="1746.13,-3016.65 1746.13,-3076.65 2144.13,-3076.65 2144.13,-3016.65 1746.13,-3016.65"/>
<text text-anchor="start" x="1873.11" y="-3037.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;EDIT &#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1746.13,-2956.65 1746.13,-3016.65 2144.13,-3016.65 2144.13,-2956.65 1746.13,-2956.65"/>
<polygon fill="none" stroke="#29235c" points="1746.13,-2956.65 1746.13,-3016.65 2144.13,-3016.65 2144.13,-2956.65 1746.13,-2956.65"/>
<text text-anchor="start" x="1847.32" y="-2977.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;DELETE &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="1745.13,-2955.65 1745.13,-3317.65 2145.13,-3317.65 2145.13,-2955.65 1745.13,-2955.65"/>
</g>
<!-- dataset -->
<g id="dataset" class="node">
<title>dataset</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="343.65" cy="-3196.65" rx="343.81" ry="511.89"/>
<polygon fill="#1d71b8" stroke="transparent" points="102.65,-3496.65 102.65,-3556.65 584.65,-3556.65 584.65,-3496.65 102.65,-3496.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3496.65 102.65,-3556.65 584.65,-3556.65 584.65,-3496.65 102.65,-3496.65"/>
<text text-anchor="start" x="228.93" y="-3517.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;dataset &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3436.65 102.65,-3496.65 584.65,-3496.65 584.65,-3436.65 102.65,-3436.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3436.65 102.65,-3496.65 584.65,-3496.65 584.65,-3436.65 102.65,-3436.65"/>
<text text-anchor="start" x="113.65" y="-3457.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="138.54" y="-3457.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="360.35" y="-3457.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3376.65 102.65,-3436.65 584.65,-3436.65 584.65,-3376.65 102.65,-3376.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3376.65 102.65,-3436.65 584.65,-3436.65 584.65,-3376.65 102.65,-3376.65"/>
<text text-anchor="start" x="113.65" y="-3396.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">name &#160;&#160;&#160;</text>
<text text-anchor="start" x="303.47" y="-3397.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<text text-anchor="start" x="534.56" y="-3397.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="543.46" y="-3397.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3316.65 102.65,-3376.65 584.65,-3376.65 584.65,-3316.65 102.65,-3316.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3316.65 102.65,-3376.65 584.65,-3376.65 584.65,-3316.65 102.65,-3316.65"/>
<text text-anchor="start" x="113.65" y="-3336.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">public &#160;&#160;&#160;</text>
<text text-anchor="start" x="418.96" y="-3337.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3256.65 102.65,-3316.65 584.65,-3316.65 584.65,-3256.65 102.65,-3256.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3256.65 102.65,-3316.65 584.65,-3316.65 584.65,-3256.65 102.65,-3256.65"/>
<text text-anchor="start" x="113.65" y="-3276.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="342.56" y="-3277.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3196.65 102.65,-3256.65 584.65,-3256.65 584.65,-3196.65 102.65,-3196.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3196.65 102.65,-3256.65 584.65,-3256.65 584.65,-3196.65 102.65,-3196.65"/>
<text text-anchor="start" x="113.65" y="-3216.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="321.25" y="-3217.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="534.56" y="-3217.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="543.46" y="-3217.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3136.65 102.65,-3196.65 584.65,-3196.65 584.65,-3136.65 102.65,-3136.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3136.65 102.65,-3196.65 584.65,-3196.65 584.65,-3136.65 102.65,-3136.65"/>
<text text-anchor="start" x="113.65" y="-3156.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="386.99" y="-3157.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3076.65 102.65,-3136.65 584.65,-3136.65 584.65,-3076.65 102.65,-3076.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3076.65 102.65,-3136.65 584.65,-3136.65 584.65,-3076.65 102.65,-3076.65"/>
<text text-anchor="start" x="113.65" y="-3096.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="386.99" y="-3097.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-3016.65 102.65,-3076.65 584.65,-3076.65 584.65,-3016.65 102.65,-3016.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-3016.65 102.65,-3076.65 584.65,-3076.65 584.65,-3016.65 102.65,-3016.65"/>
<text text-anchor="start" x="113.63" y="-3036.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="321.45" y="-3037.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="534.76" y="-3037.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="543.66" y="-3037.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-2956.65 102.65,-3016.65 584.65,-3016.65 584.65,-2956.65 102.65,-2956.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-2956.65 102.65,-3016.65 584.65,-3016.65 584.65,-2956.65 102.65,-2956.65"/>
<text text-anchor="start" x="113.65" y="-2976.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">owner &#160;&#160;&#160;</text>
<text text-anchor="start" x="321.25" y="-2977.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="534.56" y="-2977.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="543.46" y="-2977.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-2896.65 102.65,-2956.65 584.65,-2956.65 584.65,-2896.65 102.65,-2896.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-2896.65 102.65,-2956.65 584.65,-2956.65 584.65,-2896.65 102.65,-2896.65"/>
<text text-anchor="start" x="113.65" y="-2916.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="418.96" y="-2917.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="102.65,-2836.65 102.65,-2896.65 584.65,-2896.65 584.65,-2836.65 102.65,-2836.65"/>
<polygon fill="none" stroke="#29235c" points="102.65,-2836.65 102.65,-2896.65 584.65,-2896.65 584.65,-2836.65 102.65,-2836.65"/>
<text text-anchor="start" x="113.65" y="-2856.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">type &#160;&#160;&#160;</text>
<text text-anchor="start" x="351.36" y="-2857.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">dataset_type</text>
<text text-anchor="start" x="534.56" y="-2857.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="543.46" y="-2857.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="101.65,-2835.65 101.65,-3557.65 585.65,-3557.65 585.65,-2835.65 101.65,-2835.65"/>
</g>
<!-- dataset&#45;&gt;dataset_type -->
<g id="edge53" class="edge">
<title>dataset:e&#45;&gt;dataset_type:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-2866.65C813.61,-2866.65 597.12,-1009.5 723.31,-819.65 776.56,-739.53 820.61,-722.65 916.81,-722.65"/>
</g>
<!-- location -->
<g id="location" class="node">
<title>location</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1081.81" cy="-2227.65" rx="343.81" ry="511.89"/>
<polygon fill="#1d71b8" stroke="transparent" points="840.81,-2527.65 840.81,-2587.65 1322.81,-2587.65 1322.81,-2527.65 840.81,-2527.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2527.65 840.81,-2587.65 1322.81,-2587.65 1322.81,-2527.65 840.81,-2527.65"/>
<text text-anchor="start" x="964.44" y="-2548.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;location &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2467.65 840.81,-2527.65 1322.81,-2527.65 1322.81,-2467.65 840.81,-2467.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2467.65 840.81,-2527.65 1322.81,-2527.65 1322.81,-2467.65 840.81,-2467.65"/>
<text text-anchor="start" x="851.81" y="-2488.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="876.7" y="-2488.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="1098.5" y="-2488.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2407.65 840.81,-2467.65 1322.81,-2467.65 1322.81,-2407.65 840.81,-2407.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2407.65 840.81,-2467.65 1322.81,-2467.65 1322.81,-2407.65 840.81,-2407.65"/>
<text text-anchor="start" x="851.81" y="-2427.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">dataset_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="1059.41" y="-2428.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="1272.72" y="-2428.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.61" y="-2428.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2347.65 840.81,-2407.65 1322.81,-2407.65 1322.81,-2347.65 840.81,-2347.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2347.65 840.81,-2407.65 1322.81,-2407.65 1322.81,-2347.65 840.81,-2347.65"/>
<text text-anchor="start" x="851.81" y="-2367.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">name &#160;&#160;&#160;</text>
<text text-anchor="start" x="1041.62" y="-2368.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(140)</text>
<text text-anchor="start" x="1272.72" y="-2368.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.61" y="-2368.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2287.65 840.81,-2347.65 1322.81,-2347.65 1322.81,-2287.65 840.81,-2287.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2287.65 840.81,-2347.65 1322.81,-2347.65 1322.81,-2287.65 840.81,-2287.65"/>
<text text-anchor="start" x="851.81" y="-2307.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">latitude &#160;&#160;&#160;</text>
<text text-anchor="start" x="1086.03" y="-2308.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(10,7)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2227.65 840.81,-2287.65 1322.81,-2287.65 1322.81,-2227.65 840.81,-2227.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2227.65 840.81,-2287.65 1322.81,-2287.65 1322.81,-2227.65 840.81,-2227.65"/>
<text text-anchor="start" x="851.81" y="-2247.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">longitude &#160;&#160;&#160;</text>
<text text-anchor="start" x="1086.03" y="-2248.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(10,7)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2167.65 840.81,-2227.65 1322.81,-2227.65 1322.81,-2167.65 840.81,-2167.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2167.65 840.81,-2227.65 1322.81,-2227.65 1322.81,-2167.65 840.81,-2167.65"/>
<text text-anchor="start" x="851.81" y="-2187.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="1080.71" y="-2188.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2107.65 840.81,-2167.65 1322.81,-2167.65 1322.81,-2107.65 840.81,-2107.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2107.65 840.81,-2167.65 1322.81,-2167.65 1322.81,-2107.65 840.81,-2107.65"/>
<text text-anchor="start" x="851.81" y="-2127.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1059.41" y="-2128.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1272.72" y="-2128.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.61" y="-2128.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-2047.65 840.81,-2107.65 1322.81,-2107.65 1322.81,-2047.65 840.81,-2047.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-2047.65 840.81,-2107.65 1322.81,-2107.65 1322.81,-2047.65 840.81,-2047.65"/>
<text text-anchor="start" x="851.81" y="-2067.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="1125.15" y="-2068.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-1987.65 840.81,-2047.65 1322.81,-2047.65 1322.81,-1987.65 840.81,-1987.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-1987.65 840.81,-2047.65 1322.81,-2047.65 1322.81,-1987.65 840.81,-1987.65"/>
<text text-anchor="start" x="851.81" y="-2007.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="1125.15" y="-2008.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-1927.65 840.81,-1987.65 1322.81,-1987.65 1322.81,-1927.65 840.81,-1927.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-1927.65 840.81,-1987.65 1322.81,-1987.65 1322.81,-1927.65 840.81,-1927.65"/>
<text text-anchor="start" x="851.79" y="-1947.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1059.61" y="-1948.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1272.92" y="-1948.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.81" y="-1948.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-1867.65 840.81,-1927.65 1322.81,-1927.65 1322.81,-1867.65 840.81,-1867.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-1867.65 840.81,-1927.65 1322.81,-1927.65 1322.81,-1867.65 840.81,-1867.65"/>
<text text-anchor="start" x="851.81" y="-1887.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="1157.11" y="-1888.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="839.81,-1866.65 839.81,-2588.65 1323.81,-2588.65 1323.81,-1866.65 839.81,-1866.65"/>
</g>
<!-- dataset&#45;&gt;location -->
<!-- dataset&#45;&gt;location -->
<g id="edge2" class="edge">
<title>dataset:e&#45;&gt;location:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-3466.65C817.74,-3466.65 610.53,-2467.58 829.75,-2438.31"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="830.06,-2441.79 839.81,-2437.65 829.6,-2434.81 830.06,-2441.79"/>
<text text-anchor="middle" x="846.03" y="-2408.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="576.76" y="-3476.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- cluster -->
<g id="cluster" class="node">
<title>cluster</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1945.13" cy="-1813.65" rx="468.62" ry="596.6"/>
<polygon fill="#1d71b8" stroke="transparent" points="1616.13,-2173.65 1616.13,-2233.65 2275.13,-2233.65 2275.13,-2173.65 1616.13,-2173.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-2173.65 1616.13,-2233.65 2275.13,-2233.65 2275.13,-2173.65 1616.13,-2173.65"/>
<text text-anchor="start" x="1836.26" y="-2194.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;cluster &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-2113.65 1616.13,-2173.65 2275.13,-2173.65 2275.13,-2113.65 1616.13,-2113.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-2113.65 1616.13,-2173.65 2275.13,-2173.65 2275.13,-2113.65 1616.13,-2113.65"/>
<text text-anchor="start" x="1627.13" y="-2134.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="1652.02" y="-2134.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="2050.82" y="-2134.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-2053.65 1616.13,-2113.65 2275.13,-2113.65 2275.13,-2053.65 1616.13,-2053.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-2053.65 1616.13,-2113.65 2275.13,-2113.65 2275.13,-2053.65 1616.13,-2053.65"/>
<text text-anchor="start" x="1627.13" y="-2073.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">dataset_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="2011.73" y="-2074.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="2225.03" y="-2074.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="2233.93" y="-2074.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1993.65 1616.13,-2053.65 2275.13,-2053.65 2275.13,-1993.65 1616.13,-1993.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1993.65 1616.13,-2053.65 2275.13,-2053.65 2275.13,-1993.65 1616.13,-1993.65"/>
<text text-anchor="start" x="1627.13" y="-2013.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">location_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="2011.73" y="-2014.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="2225.03" y="-2014.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="2233.93" y="-2014.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1933.65 1616.13,-1993.65 2275.13,-1993.65 2275.13,-1933.65 1616.13,-1933.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1933.65 1616.13,-1993.65 2275.13,-1993.65 2275.13,-1933.65 1616.13,-1933.65"/>
<text text-anchor="start" x="1627.13" y="-1953.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">name &#160;&#160;&#160;</text>
<text text-anchor="start" x="1993.94" y="-1954.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(140)</text>
<text text-anchor="start" x="2225.03" y="-1954.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="2233.93" y="-1954.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1873.65 1616.13,-1933.65 2275.13,-1933.65 2275.13,-1873.65 1616.13,-1873.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1873.65 1616.13,-1933.65 2275.13,-1933.65 2275.13,-1873.65 1616.13,-1873.65"/>
<text text-anchor="start" x="1627.13" y="-1893.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="2033.03" y="-1894.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1813.65 1616.13,-1873.65 2275.13,-1873.65 2275.13,-1813.65 1616.13,-1813.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1813.65 1616.13,-1873.65 2275.13,-1873.65 2275.13,-1813.65 1616.13,-1813.65"/>
<text text-anchor="start" x="1627.13" y="-1833.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="2011.73" y="-1834.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="2225.03" y="-1834.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="2233.93" y="-1834.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1753.65 1616.13,-1813.65 2275.13,-1813.65 2275.13,-1753.65 1616.13,-1753.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1753.65 1616.13,-1813.65 2275.13,-1813.65 2275.13,-1753.65 1616.13,-1753.65"/>
<text text-anchor="start" x="1627.13" y="-1773.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="2077.47" y="-1774.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1693.65 1616.13,-1753.65 2275.13,-1753.65 2275.13,-1693.65 1616.13,-1693.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1693.65 1616.13,-1753.65 2275.13,-1753.65 2275.13,-1693.65 1616.13,-1693.65"/>
<text text-anchor="start" x="1627.13" y="-1713.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="2077.47" y="-1714.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1633.65 1616.13,-1693.65 2275.13,-1693.65 2275.13,-1633.65 1616.13,-1633.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1633.65 1616.13,-1693.65 2275.13,-1693.65 2275.13,-1633.65 1616.13,-1633.65"/>
<text text-anchor="start" x="1627.13" y="-1653.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="2011.73" y="-1654.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="2225.03" y="-1654.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="2233.93" y="-1654.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1573.65 1616.13,-1633.65 2275.13,-1633.65 2275.13,-1573.65 1616.13,-1573.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1573.65 1616.13,-1633.65 2275.13,-1633.65 2275.13,-1573.65 1616.13,-1573.65"/>
<text text-anchor="start" x="1627.13" y="-1593.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="2109.43" y="-1594.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1513.65 1616.13,-1573.65 2275.13,-1573.65 2275.13,-1513.65 1616.13,-1513.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1513.65 1616.13,-1573.65 2275.13,-1573.65 2275.13,-1513.65 1616.13,-1513.65"/>
<text text-anchor="start" x="1627.13" y="-1533.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">timezone_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="2050.82" y="-1534.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(40)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1453.65 1616.13,-1513.65 2275.13,-1513.65 2275.13,-1453.65 1616.13,-1453.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1453.65 1616.13,-1513.65 2275.13,-1513.65 2275.13,-1453.65 1616.13,-1453.65"/>
<text text-anchor="start" x="1626.64" y="-1473.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">cyclic_recording_pattern_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="2050.97" y="-1474.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="1616.13,-1393.65 1616.13,-1453.65 2275.13,-1453.65 2275.13,-1393.65 1616.13,-1393.65"/>
<polygon fill="none" stroke="#29235c" points="1616.13,-1393.65 1616.13,-1453.65 2275.13,-1453.65 2275.13,-1393.65 1616.13,-1393.65"/>
<text text-anchor="start" x="1627.13" y="-1413.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">sample_rate &#160;&#160;&#160;</text>
<text text-anchor="start" x="2082.82" y="-1414.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="2225.03" y="-1414.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="2233.93" y="-1414.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="1614.63,-1392.65 1614.63,-2234.65 2275.63,-2234.65 2275.63,-1392.65 1614.63,-1392.65"/>
</g>
<!-- dataset&#45;&gt;cluster -->
<!-- dataset&#45;&gt;cluster -->
<g id="edge4" class="edge">
<title>dataset:e&#45;&gt;cluster:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-3466.65C786.35,-3466.65 576.09,-1802.05 723.31,-1665.65 752.53,-1638.58 1407.16,-1643.58 1440.31,-1665.65 1604.99,-1775.28 1420.47,-2072.94 1604.87,-2083.37"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="1605.03,-2086.88 1615.13,-2083.65 1605.23,-2079.88 1605.03,-2086.88"/>
<text text-anchor="middle" x="1608.9" y="-2054.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="594.55" y="-3476.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- file_dataset -->
<g id="file_dataset" class="node">
<title>file_dataset</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="3651.25" cy="-3898.65" rx="343.81" ry="342.48"/>
<polygon fill="#1d71b8" stroke="transparent" points="3410.25,-4078.65 3410.25,-4138.65 3892.25,-4138.65 3892.25,-4078.65 3410.25,-4078.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-4078.65 3410.25,-4138.65 3892.25,-4138.65 3892.25,-4078.65 3410.25,-4078.65"/>
<text text-anchor="start" x="3507.19" y="-4099.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;file_dataset &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-4018.65 3410.25,-4078.65 3892.25,-4078.65 3892.25,-4018.65 3410.25,-4018.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-4018.65 3410.25,-4078.65 3892.25,-4078.65 3892.25,-4018.65 3410.25,-4018.65"/>
<text text-anchor="start" x="3421.25" y="-4039.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">file_id</text>
<text text-anchor="start" x="3504.81" y="-4039.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3628.85" y="-4039.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<text text-anchor="start" x="3842.16" y="-4039.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.05" y="-4039.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3958.65 3410.25,-4018.65 3892.25,-4018.65 3892.25,-3958.65 3410.25,-3958.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3958.65 3410.25,-4018.65 3892.25,-4018.65 3892.25,-3958.65 3410.25,-3958.65"/>
<text text-anchor="start" x="3421.25" y="-3979.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">dataset_id</text>
<text text-anchor="start" x="3568.87" y="-3979.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3628.85" y="-3979.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="3842.16" y="-3979.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.05" y="-3979.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3898.65 3410.25,-3958.65 3892.25,-3958.65 3892.25,-3898.65 3410.25,-3898.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3898.65 3410.25,-3958.65 3892.25,-3958.65 3892.25,-3898.65 3410.25,-3898.65"/>
<text text-anchor="start" x="3421.25" y="-3918.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.59" y="-3919.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3838.65 3410.25,-3898.65 3892.25,-3898.65 3892.25,-3838.65 3410.25,-3838.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3838.65 3410.25,-3898.65 3892.25,-3898.65 3892.25,-3838.65 3410.25,-3838.65"/>
<text text-anchor="start" x="3421.25" y="-3858.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="3628.85" y="-3859.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3842.16" y="-3859.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.05" y="-3859.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3778.65 3410.25,-3838.65 3892.25,-3838.65 3892.25,-3778.65 3410.25,-3778.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3778.65 3410.25,-3838.65 3892.25,-3838.65 3892.25,-3778.65 3410.25,-3778.65"/>
<text text-anchor="start" x="3421.25" y="-3798.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.59" y="-3799.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3718.65 3410.25,-3778.65 3892.25,-3778.65 3892.25,-3718.65 3410.25,-3718.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3718.65 3410.25,-3778.65 3892.25,-3778.65 3892.25,-3718.65 3410.25,-3718.65"/>
<text text-anchor="start" x="3421.22" y="-3738.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="3629.05" y="-3739.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3842.36" y="-3739.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.25" y="-3739.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3658.65 3410.25,-3718.65 3892.25,-3718.65 3892.25,-3658.65 3410.25,-3658.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3658.65 3410.25,-3718.65 3892.25,-3718.65 3892.25,-3658.65 3410.25,-3658.65"/>
<text text-anchor="start" x="3491.2" y="-3679.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;file_id, dataset_id &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3409.25,-3657.65 3409.25,-4139.65 3893.25,-4139.65 3893.25,-3657.65 3409.25,-3657.65"/>
</g>
<!-- dataset&#45;&gt;file_dataset -->
<!-- dataset&#45;&gt;file_dataset -->
<g id="edge20" class="edge">
<title>dataset:e&#45;&gt;file_dataset:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-3466.65C868.07,-3466.65 518.27,-1122.87 723.31,-928.65 781.15,-873.86 1376.96,-880.35 1440.31,-928.65 1488.33,-965.26 1431.3,-1019.4 1476.31,-1059.65 1790.81,-1340.86 2136.79,-889.57 2413.94,-1207.65 2482.2,-1285.99 2408.02,-2982.57 2449.94,-3077.65 2685.74,-3612.51 2819.7,-3984.27 3398.96,-3988.61"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="3399.24,-3992.11 3409.25,-3988.65 3399.26,-3985.11 3399.24,-3992.11"/>
<text text-anchor="middle" x="3403.03" y="-3998.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="576.76" y="-3437.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- selection -->
<g id="selection" class="node">
<title>selection</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="4497.59" cy="-3538.65" rx="343.81" ry="851.21"/>
<polygon fill="#1d71b8" stroke="transparent" points="4256.59,-4078.65 4256.59,-4138.65 4738.59,-4138.65 4738.59,-4078.65 4256.59,-4078.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-4078.65 4256.59,-4138.65 4738.59,-4138.65 4738.59,-4078.65 4256.59,-4078.65"/>
<text text-anchor="start" x="4372.22" y="-4099.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;selection &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-4018.65 4256.59,-4078.65 4738.59,-4078.65 4738.59,-4018.65 4256.59,-4018.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-4018.65 4256.59,-4078.65 4738.59,-4078.65 4738.59,-4018.65 4256.59,-4018.65"/>
<text text-anchor="start" x="4267.59" y="-4039.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="4292.48" y="-4039.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="4514.29" y="-4039.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3958.65 4256.59,-4018.65 4738.59,-4018.65 4738.59,-3958.65 4256.59,-3958.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3958.65 4256.59,-4018.65 4738.59,-4018.65 4738.59,-3958.65 4256.59,-3958.65"/>
<text text-anchor="start" x="4267.59" y="-3978.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">file_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.19" y="-3979.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<text text-anchor="start" x="4688.5" y="-3979.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-3979.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3898.65 4256.59,-3958.65 4738.59,-3958.65 4738.59,-3898.65 4256.59,-3898.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3898.65 4256.59,-3958.65 4738.59,-3958.65 4738.59,-3898.65 4256.59,-3898.65"/>
<text text-anchor="start" x="4267.59" y="-3918.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">dataset_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.19" y="-3919.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="4688.5" y="-3919.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-3919.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3838.65 4256.59,-3898.65 4738.59,-3898.65 4738.59,-3838.65 4256.59,-3838.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3838.65 4256.59,-3898.65 4738.59,-3898.65 4738.59,-3838.65 4256.59,-3838.65"/>
<text text-anchor="start" x="4267.59" y="-3858.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">start_time &#160;&#160;&#160;</text>
<text text-anchor="start" x="4480.51" y="-3859.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(7,3)</text>
<text text-anchor="start" x="4688.5" y="-3859.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-3859.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3778.65 4256.59,-3838.65 4738.59,-3838.65 4738.59,-3778.65 4256.59,-3778.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3778.65 4256.59,-3838.65 4738.59,-3838.65 4738.59,-3778.65 4256.59,-3778.65"/>
<text text-anchor="start" x="4267.59" y="-3798.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">end_time &#160;&#160;&#160;</text>
<text text-anchor="start" x="4480.51" y="-3799.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(7,3)</text>
<text text-anchor="start" x="4688.5" y="-3799.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-3799.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3718.65 4256.59,-3778.65 4738.59,-3778.65 4738.59,-3718.65 4256.59,-3718.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3718.65 4256.59,-3778.65 4738.59,-3778.65 4738.59,-3718.65 4256.59,-3718.65"/>
<text text-anchor="start" x="4267.59" y="-3738.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">freq_low &#160;&#160;&#160;</text>
<text text-anchor="start" x="4519.6" y="-3739.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(9,3)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3658.65 4256.59,-3718.65 4738.59,-3718.65 4738.59,-3658.65 4256.59,-3658.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3658.65 4256.59,-3718.65 4738.59,-3718.65 4738.59,-3658.65 4256.59,-3658.65"/>
<text text-anchor="start" x="4267.59" y="-3678.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">freq_high &#160;&#160;&#160;</text>
<text text-anchor="start" x="4519.6" y="-3679.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(9,3)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3598.65 4256.59,-3658.65 4738.59,-3658.65 4738.59,-3598.65 4256.59,-3598.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3598.65 4256.59,-3658.65 4738.59,-3658.65 4738.59,-3598.65 4256.59,-3598.65"/>
<text text-anchor="start" x="4267.59" y="-3618.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="4496.5" y="-3619.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3538.65 4256.59,-3598.65 4738.59,-3598.65 4738.59,-3538.65 4256.59,-3538.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3538.65 4256.59,-3598.65 4738.59,-3598.65 4738.59,-3538.65 4256.59,-3538.65"/>
<text text-anchor="start" x="4267.59" y="-3558.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">upload &#160;&#160;&#160;</text>
<text text-anchor="start" x="4572.9" y="-3559.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3478.65 4256.59,-3538.65 4738.59,-3538.65 4738.59,-3478.65 4256.59,-3478.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3478.65 4256.59,-3538.65 4738.59,-3538.65 4738.59,-3478.65 4256.59,-3478.65"/>
<text text-anchor="start" x="4267.59" y="-3498.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">approved &#160;&#160;&#160;</text>
<text text-anchor="start" x="4572.9" y="-3499.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3418.65 4256.59,-3478.65 4738.59,-3478.65 4738.59,-3418.65 4256.59,-3418.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3418.65 4256.59,-3478.65 4738.59,-3478.65 4738.59,-3418.65 4256.59,-3418.65"/>
<text text-anchor="start" x="4267.59" y="-3438.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">is_solar_night &#160;&#160;&#160;</text>
<text text-anchor="start" x="4572.9" y="-3439.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3358.65 4256.59,-3418.65 4738.59,-3418.65 4738.59,-3358.65 4256.59,-3358.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3358.65 4256.59,-3418.65 4738.59,-3418.65 4738.59,-3358.65 4256.59,-3358.65"/>
<text text-anchor="start" x="4267.59" y="-3378.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">is_civil_night &#160;&#160;&#160;</text>
<text text-anchor="start" x="4572.9" y="-3379.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3298.65 4256.59,-3358.65 4738.59,-3358.65 4738.59,-3298.65 4256.59,-3298.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3298.65 4256.59,-3358.65 4738.59,-3358.65 4738.59,-3298.65 4256.59,-3298.65"/>
<text text-anchor="start" x="4267.59" y="-3318.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">moon_phase &#160;&#160;&#160;</text>
<text text-anchor="start" x="4519.6" y="-3319.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(3,2)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3238.65 4256.59,-3298.65 4738.59,-3298.65 4738.59,-3238.65 4256.59,-3238.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3238.65 4256.59,-3298.65 4738.59,-3298.65 4738.59,-3238.65 4256.59,-3238.65"/>
<text text-anchor="start" x="4267.59" y="-3258.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.19" y="-3259.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4688.5" y="-3259.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-3259.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3178.65 4256.59,-3238.65 4738.59,-3238.65 4738.59,-3178.65 4256.59,-3178.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3178.65 4256.59,-3238.65 4738.59,-3238.65 4738.59,-3178.65 4256.59,-3178.65"/>
<text text-anchor="start" x="4267.59" y="-3198.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="4540.93" y="-3199.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3118.65 4256.59,-3178.65 4738.59,-3178.65 4738.59,-3118.65 4256.59,-3118.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3118.65 4256.59,-3178.65 4738.59,-3178.65 4738.59,-3118.65 4256.59,-3118.65"/>
<text text-anchor="start" x="4267.59" y="-3138.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="4540.93" y="-3139.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-3058.65 4256.59,-3118.65 4738.59,-3118.65 4738.59,-3058.65 4256.59,-3058.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-3058.65 4256.59,-3118.65 4738.59,-3118.65 4738.59,-3058.65 4256.59,-3058.65"/>
<text text-anchor="start" x="4267.57" y="-3078.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.39" y="-3079.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4688.7" y="-3079.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.6" y="-3079.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-2998.65 4256.59,-3058.65 4738.59,-3058.65 4738.59,-2998.65 4256.59,-2998.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-2998.65 4256.59,-3058.65 4738.59,-3058.65 4738.59,-2998.65 4256.59,-2998.65"/>
<text text-anchor="start" x="4267.59" y="-3018.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="4572.9" y="-3019.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-2938.65 4256.59,-2998.65 4738.59,-2998.65 4738.59,-2938.65 4256.59,-2938.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-2938.65 4256.59,-2998.65 4738.59,-2998.65 4738.59,-2938.65 4256.59,-2938.65"/>
<text text-anchor="start" x="4337.54" y="-2959.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;file_id, dataset_id &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="4255.59,-2937.65 4255.59,-4139.65 4739.59,-4139.65 4739.59,-2937.65 4255.59,-2937.65"/>
</g>
<!-- dataset&#45;&gt;selection -->
<!-- dataset&#45;&gt;selection -->
<g id="edge24" class="edge">
<title>dataset:e&#45;&gt;selection:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-3466.65C872.73,-3466.65 514.98,-1084.16 723.31,-886.65 781.12,-831.84 1369.58,-850 1440.31,-886.65 1464.95,-899.42 1452.56,-923.32 1476.31,-937.65 1836.15,-1154.7 2006.76,-955.7 2413.94,-1059.65 2768.35,-1150.13 2889.66,-1136.61 3181.09,-1357.65 3202.33,-1373.77 3193.61,-1393 3217.09,-1405.65 3302.18,-1451.49 4018.15,-1389.24 4085.41,-1458.65 4132.56,-1507.31 4116.8,-2610.06 4121.41,-2677.65 4140.23,-2953.19 3979.99,-3905.02 4245.55,-3928.22"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="4245.45,-3931.72 4255.59,-3928.65 4245.75,-3924.72 4245.45,-3931.72"/>
<text text-anchor="middle" x="4261.82" y="-3938.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="594.55" y="-3437.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- species_dataset -->
<g id="species_dataset" class="node">
<title>species_dataset</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="5253.43" cy="-2887.65" rx="343.81" ry="299.63"/>
<polygon fill="#1d71b8" stroke="transparent" points="5012.43,-3037.65 5012.43,-3097.65 5494.43,-3097.65 5494.43,-3037.65 5012.43,-3037.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-3037.65 5012.43,-3097.65 5494.43,-3097.65 5494.43,-3037.65 5012.43,-3037.65"/>
<text text-anchor="start" x="5075.58" y="-3058.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;species_dataset &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2977.65 5012.43,-3037.65 5494.43,-3037.65 5494.43,-2977.65 5012.43,-2977.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2977.65 5012.43,-3037.65 5494.43,-3037.65 5494.43,-2977.65 5012.43,-2977.65"/>
<text text-anchor="start" x="5023.43" y="-2998.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">species_id</text>
<text text-anchor="start" x="5174.57" y="-2998.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-2998.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="5444.34" y="-2998.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-2998.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2917.65 5012.43,-2977.65 5494.43,-2977.65 5494.43,-2917.65 5012.43,-2917.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2917.65 5012.43,-2977.65 5494.43,-2977.65 5494.43,-2917.65 5012.43,-2917.65"/>
<text text-anchor="start" x="5023.43" y="-2938.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">dataset_id</text>
<text text-anchor="start" x="5171.05" y="-2938.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-2938.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="5444.34" y="-2938.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-2938.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2857.65 5012.43,-2917.65 5494.43,-2917.65 5494.43,-2857.65 5012.43,-2857.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2857.65 5012.43,-2917.65 5494.43,-2917.65 5494.43,-2857.65 5012.43,-2857.65"/>
<text text-anchor="start" x="5023.43" y="-2877.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-2878.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2797.65 5012.43,-2857.65 5494.43,-2857.65 5494.43,-2797.65 5012.43,-2797.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2797.65 5012.43,-2857.65 5494.43,-2857.65 5494.43,-2797.65 5012.43,-2797.65"/>
<text text-anchor="start" x="5023.43" y="-2817.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-2818.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.34" y="-2818.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-2818.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2737.65 5012.43,-2797.65 5494.43,-2797.65 5494.43,-2737.65 5012.43,-2737.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2737.65 5012.43,-2797.65 5494.43,-2797.65 5494.43,-2737.65 5012.43,-2737.65"/>
<text text-anchor="start" x="5023.43" y="-2757.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-2758.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2677.65 5012.43,-2737.65 5494.43,-2737.65 5494.43,-2677.65 5012.43,-2677.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2677.65 5012.43,-2737.65 5494.43,-2737.65 5494.43,-2677.65 5012.43,-2677.65"/>
<text text-anchor="start" x="5023.4" y="-2697.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.23" y="-2698.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.54" y="-2698.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.43" y="-2698.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="5011.43,-2676.65 5011.43,-3098.65 5495.43,-3098.65 5495.43,-2676.65 5011.43,-2676.65"/>
</g>
<!-- dataset&#45;&gt;species_dataset -->
<!-- dataset&#45;&gt;species_dataset -->
<g id="edge50" class="edge">
<title>dataset:e&#45;&gt;species_dataset:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-3466.65C876.94,-3466.65 512,-1049.14 723.31,-848.65 822.75,-754.3 3086.54,-966.4 3181.09,-1065.65 3275.84,-1165.12 3116.2,-1279.41 3217.09,-1372.65 3287.99,-1438.18 4016.69,-1337.83 4085.41,-1405.65 4141,-1460.51 4066.17,-2052.45 4121.41,-2107.65 4180.62,-2166.81 4813.64,-2087.43 4873.77,-2145.65 4908.54,-2179.31 4901.3,-2532.01 4909.77,-2579.65 4938.9,-2743.28 4845.7,-2939.42 5001.32,-2947.4"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5001.34,-2950.9 5011.43,-2947.65 5001.52,-2943.9 5001.34,-2950.9"/>
<text text-anchor="middle" x="5017.65" y="-2918.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="576.76" y="-3476.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- access_grant -->
<g id="access_grant" class="node">
<title>access_grant</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1081.81" cy="-3226.65" rx="358.51" ry="469.54"/>
<polygon fill="#1d71b8" stroke="transparent" points="830.81,-3496.65 830.81,-3556.65 1333.81,-3556.65 1333.81,-3496.65 830.81,-3496.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3496.65 830.81,-3556.65 1333.81,-3556.65 1333.81,-3496.65 830.81,-3496.65"/>
<text text-anchor="start" x="924.92" y="-3517.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;access_grant &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3436.65 830.81,-3496.65 1333.81,-3496.65 1333.81,-3436.65 830.81,-3436.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3436.65 830.81,-3496.65 1333.81,-3496.65 1333.81,-3436.65 830.81,-3436.65"/>
<text text-anchor="start" x="841.81" y="-3457.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="866.7" y="-3457.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="1109.5" y="-3457.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3376.65 830.81,-3436.65 1333.81,-3436.65 1333.81,-3376.65 830.81,-3376.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3376.65 830.81,-3436.65 1333.81,-3436.65 1333.81,-3376.65 830.81,-3376.65"/>
<text text-anchor="start" x="841.81" y="-3396.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">dataset_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="1070.41" y="-3397.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="1283.72" y="-3397.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1292.61" y="-3397.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3316.65 830.81,-3376.65 1333.81,-3376.65 1333.81,-3316.65 830.81,-3316.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3316.65 830.81,-3376.65 1333.81,-3376.65 1333.81,-3316.65 830.81,-3316.65"/>
<text text-anchor="start" x="841.81" y="-3336.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">role &#160;&#160;&#160;</text>
<text text-anchor="start" x="1132.58" y="-3337.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">role_name</text>
<text text-anchor="start" x="1283.72" y="-3337.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1292.61" y="-3337.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3256.65 830.81,-3316.65 1333.81,-3316.65 1333.81,-3256.65 830.81,-3256.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3256.65 830.81,-3316.65 1333.81,-3316.65 1333.81,-3256.65 830.81,-3256.65"/>
<text text-anchor="start" x="841.69" y="-3276.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">permission &#160;&#160;&#160;</text>
<text text-anchor="start" x="1031.53" y="-3277.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">permission_name</text>
<text text-anchor="start" x="1284" y="-3277.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1292.89" y="-3277.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3196.65 830.81,-3256.65 1333.81,-3256.65 1333.81,-3196.65 830.81,-3196.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3196.65 830.81,-3256.65 1333.81,-3256.65 1333.81,-3196.65 830.81,-3196.65"/>
<text text-anchor="start" x="841.81" y="-3216.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">user_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="1109.5" y="-3217.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3136.65 830.81,-3196.65 1333.81,-3196.65 1333.81,-3136.65 830.81,-3136.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3136.65 830.81,-3196.65 1333.81,-3196.65 1333.81,-3136.65 830.81,-3136.65"/>
<text text-anchor="start" x="841.81" y="-3156.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="1136.15" y="-3157.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3076.65 830.81,-3136.65 1333.81,-3136.65 1333.81,-3076.65 830.81,-3076.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3076.65 830.81,-3136.65 1333.81,-3136.65 1333.81,-3076.65 830.81,-3076.65"/>
<text text-anchor="start" x="841.81" y="-3096.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1070.41" y="-3097.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1283.72" y="-3097.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1292.61" y="-3097.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-3016.65 830.81,-3076.65 1333.81,-3076.65 1333.81,-3016.65 830.81,-3016.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-3016.65 830.81,-3076.65 1333.81,-3076.65 1333.81,-3016.65 830.81,-3016.65"/>
<text text-anchor="start" x="841.81" y="-3036.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="1136.15" y="-3037.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-2956.65 830.81,-3016.65 1333.81,-3016.65 1333.81,-2956.65 830.81,-2956.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-2956.65 830.81,-3016.65 1333.81,-3016.65 1333.81,-2956.65 830.81,-2956.65"/>
<text text-anchor="start" x="841.81" y="-2976.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1070.41" y="-2977.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1283.72" y="-2977.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1292.61" y="-2977.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="830.81,-2896.65 830.81,-2956.65 1333.81,-2956.65 1333.81,-2896.65 830.81,-2896.65"/>
<polygon fill="none" stroke="#29235c" points="830.81,-2896.65 830.81,-2956.65 1333.81,-2956.65 1333.81,-2896.65 830.81,-2896.65"/>
<text text-anchor="start" x="841.81" y="-2916.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="1168.11" y="-2917.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="829.31,-2895.65 829.31,-3557.65 1334.31,-3557.65 1334.31,-2895.65 829.31,-2895.65"/>
</g>
<!-- dataset&#45;&gt;access_grant -->
<!-- dataset&#45;&gt;access_grant -->
<g id="edge52" class="edge">
<title>dataset:e&#45;&gt;access_grant:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M585.65,-3466.65C693.9,-3466.65 716.69,-3410.34 819.6,-3406.82"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="819.87,-3410.32 829.81,-3406.65 819.75,-3403.32 819.87,-3410.32"/>
<text text-anchor="middle" x="836.03" y="-3416.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="594.55" y="-3476.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- location&#45;&gt;cluster -->
<!-- location&#45;&gt;cluster -->
<g id="edge6" class="edge">
<title>location:e&#45;&gt;cluster:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M1323.81,-2497.65C1567.58,-2497.65 1373.52,-2036.98 1604.89,-2023.93"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="1605.23,-2027.43 1615.13,-2023.65 1605.03,-2020.43 1605.23,-2027.43"/>
<text text-anchor="middle" x="1608.9" y="-1994.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="1314.92" y="-2468.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- file -->
<g id="file" class="node">
<title>file</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="2815.51" cy="-2217.65" rx="365.65" ry="851.21"/>
<polygon fill="#1d71b8" stroke="transparent" points="2559.51,-2757.65 2559.51,-2817.65 3072.51,-2817.65 3072.51,-2757.65 2559.51,-2757.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2757.65 2559.51,-2817.65 3072.51,-2817.65 3072.51,-2757.65 2559.51,-2757.65"/>
<text text-anchor="start" x="2733.32" y="-2778.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;file &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2697.65 2559.51,-2757.65 3072.51,-2757.65 3072.51,-2697.65 2559.51,-2697.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2697.65 2559.51,-2757.65 3072.51,-2757.65 3072.51,-2697.65 2559.51,-2697.65"/>
<text text-anchor="start" x="2570.51" y="-2718.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="2595.4" y="-2718.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="2848.2" y="-2718.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2637.65 2559.51,-2697.65 3072.51,-2697.65 3072.51,-2637.65 2559.51,-2637.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2637.65 2559.51,-2697.65 3072.51,-2697.65 3072.51,-2637.65 2559.51,-2637.65"/>
<text text-anchor="start" x="2570.51" y="-2657.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">file_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="2791.32" y="-2658.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<text text-anchor="start" x="3022.42" y="-2658.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-2658.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2577.65 2559.51,-2637.65 3072.51,-2637.65 3072.51,-2577.65 2559.51,-2577.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2577.65 2559.51,-2637.65 3072.51,-2637.65 3072.51,-2577.65 2559.51,-2577.65"/>
<text text-anchor="start" x="2570.51" y="-2597.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">path &#160;&#160;&#160;</text>
<text text-anchor="start" x="2830.41" y="-2598.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2517.65 2559.51,-2577.65 3072.51,-2577.65 3072.51,-2517.65 2559.51,-2517.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2517.65 2559.51,-2577.65 3072.51,-2577.65 3072.51,-2517.65 2559.51,-2517.65"/>
<text text-anchor="start" x="2570.51" y="-2537.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">xxh64_hash &#160;&#160;&#160;</text>
<text text-anchor="start" x="2809.11" y="-2538.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(16)</text>
<text text-anchor="start" x="3022.42" y="-2538.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-2538.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2457.65 2559.51,-2517.65 3072.51,-2517.65 3072.51,-2457.65 2559.51,-2457.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2457.65 2559.51,-2517.65 3072.51,-2517.65 3072.51,-2457.65 2559.51,-2457.65"/>
<text text-anchor="start" x="2570.51" y="-2477.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">location_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="2809.11" y="-2478.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="3022.42" y="-2478.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-2478.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2397.65 2559.51,-2457.65 3072.51,-2457.65 3072.51,-2397.65 2559.51,-2397.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2397.65 2559.51,-2457.65 3072.51,-2457.65 3072.51,-2397.65 2559.51,-2397.65"/>
<text text-anchor="start" x="2570.16" y="-2417.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">timestamp_local &#160;&#160;&#160;</text>
<text text-anchor="start" x="2836.14" y="-2418.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<text text-anchor="start" x="3022.8" y="-2418.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.69" y="-2418.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2337.65 2559.51,-2397.65 3072.51,-2397.65 3072.51,-2337.65 2559.51,-2337.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2337.65 2559.51,-2397.65 3072.51,-2397.65 3072.51,-2337.65 2559.51,-2337.65"/>
<text text-anchor="start" x="2570.51" y="-2357.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">cluster_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="2848.2" y="-2358.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2277.65 2559.51,-2337.65 3072.51,-2337.65 3072.51,-2277.65 2559.51,-2277.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2277.65 2559.51,-2337.65 3072.51,-2337.65 3072.51,-2277.65 2559.51,-2277.65"/>
<text text-anchor="start" x="2570.51" y="-2297.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">duration &#160;&#160;&#160;</text>
<text text-anchor="start" x="2814.43" y="-2298.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(7,3)</text>
<text text-anchor="start" x="3022.42" y="-2298.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-2298.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2217.65 2559.51,-2277.65 3072.51,-2277.65 3072.51,-2217.65 2559.51,-2217.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2217.65 2559.51,-2277.65 3072.51,-2277.65 3072.51,-2217.65 2559.51,-2217.65"/>
<text text-anchor="start" x="2570.51" y="-2237.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">sample_rate &#160;&#160;&#160;</text>
<text text-anchor="start" x="2880.2" y="-2238.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="3022.42" y="-2238.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-2238.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2157.65 2559.51,-2217.65 3072.51,-2217.65 3072.51,-2157.65 2559.51,-2157.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2157.65 2559.51,-2217.65 3072.51,-2217.65 3072.51,-2157.65 2559.51,-2157.65"/>
<text text-anchor="start" x="2570.51" y="-2177.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="2830.41" y="-2178.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2097.65 2559.51,-2157.65 3072.51,-2157.65 3072.51,-2097.65 2559.51,-2097.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2097.65 2559.51,-2157.65 3072.51,-2157.65 3072.51,-2097.65 2559.51,-2097.65"/>
<text text-anchor="start" x="2570.51" y="-2117.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">upload &#160;&#160;&#160;</text>
<text text-anchor="start" x="2906.81" y="-2118.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-2037.65 2559.51,-2097.65 3072.51,-2097.65 3072.51,-2037.65 2559.51,-2037.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-2037.65 2559.51,-2097.65 3072.51,-2097.65 3072.51,-2037.65 2559.51,-2037.65"/>
<text text-anchor="start" x="2570.51" y="-2057.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">maybe_solar_night &#160;&#160;&#160;</text>
<text text-anchor="start" x="2906.81" y="-2058.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1977.65 2559.51,-2037.65 3072.51,-2037.65 3072.51,-1977.65 2559.51,-1977.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1977.65 2559.51,-2037.65 3072.51,-2037.65 3072.51,-1977.65 2559.51,-1977.65"/>
<text text-anchor="start" x="2570.51" y="-1997.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">maybe_civil_night &#160;&#160;&#160;</text>
<text text-anchor="start" x="2906.81" y="-1998.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1917.65 2559.51,-1977.65 3072.51,-1977.65 3072.51,-1917.65 2559.51,-1917.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1917.65 2559.51,-1977.65 3072.51,-1977.65 3072.51,-1917.65 2559.51,-1917.65"/>
<text text-anchor="start" x="2570.51" y="-1937.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">moon_phase &#160;&#160;&#160;</text>
<text text-anchor="start" x="2853.52" y="-1938.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(3,2)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1857.65 2559.51,-1917.65 3072.51,-1917.65 3072.51,-1857.65 2559.51,-1857.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1857.65 2559.51,-1917.65 3072.51,-1917.65 3072.51,-1857.65 2559.51,-1857.65"/>
<text text-anchor="start" x="2570.51" y="-1877.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="2809.11" y="-1878.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3022.42" y="-1878.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-1878.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1797.65 2559.51,-1857.65 3072.51,-1857.65 3072.51,-1797.65 2559.51,-1797.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1797.65 2559.51,-1857.65 3072.51,-1857.65 3072.51,-1797.65 2559.51,-1797.65"/>
<text text-anchor="start" x="2570.51" y="-1817.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="2874.85" y="-1818.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1737.65 2559.51,-1797.65 3072.51,-1797.65 3072.51,-1737.65 2559.51,-1737.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1737.65 2559.51,-1797.65 3072.51,-1797.65 3072.51,-1737.65 2559.51,-1737.65"/>
<text text-anchor="start" x="2570.51" y="-1757.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="2874.85" y="-1758.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1677.65 2559.51,-1737.65 3072.51,-1737.65 3072.51,-1677.65 2559.51,-1677.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1677.65 2559.51,-1737.65 3072.51,-1737.65 3072.51,-1677.65 2559.51,-1677.65"/>
<text text-anchor="start" x="2570.51" y="-1697.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="2809.11" y="-1698.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3022.42" y="-1698.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3031.31" y="-1698.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="2559.51,-1617.65 2559.51,-1677.65 3072.51,-1677.65 3072.51,-1617.65 2559.51,-1617.65"/>
<polygon fill="none" stroke="#29235c" points="2559.51,-1617.65 2559.51,-1677.65 3072.51,-1677.65 3072.51,-1617.65 2559.51,-1617.65"/>
<text text-anchor="start" x="2570.51" y="-1637.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="2906.81" y="-1638.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="2558.01,-1616.65 2558.01,-2818.65 3073.01,-2818.65 3073.01,-1616.65 2558.01,-1616.65"/>
</g>
<!-- location&#45;&gt;file -->
<!-- location&#45;&gt;file -->
<g id="edge10" class="edge">
<title>location:e&#45;&gt;file:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M1323.81,-2497.65C1869.24,-2497.65 2008.05,-2487.77 2548.51,-2487.65"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="2548.51,-2491.15 2558.51,-2487.65 2548.51,-2484.15 2548.51,-2491.15"/>
<text text-anchor="middle" x="2564.73" y="-2458.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="1332.71" y="-2468.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- cyclic_recording_pattern -->
<g id="cyclic_recording_pattern" class="node">
<title>cyclic_recording_pattern</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1081.81" cy="-1279.65" rx="351.36" ry="342.48"/>
<polygon fill="#1d71b8" stroke="transparent" points="835.81,-1459.65 835.81,-1519.65 1328.81,-1519.65 1328.81,-1459.65 835.81,-1459.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1459.65 835.81,-1519.65 1328.81,-1519.65 1328.81,-1459.65 835.81,-1459.65"/>
<text text-anchor="start" x="846.7" y="-1480.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;cyclic_recording_pattern &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1399.65 835.81,-1459.65 1328.81,-1459.65 1328.81,-1399.65 835.81,-1399.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1399.65 835.81,-1459.65 1328.81,-1459.65 1328.81,-1399.65 835.81,-1399.65"/>
<text text-anchor="start" x="846.81" y="-1420.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="871.7" y="-1420.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="1104.5" y="-1420.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1339.65 835.81,-1399.65 1328.81,-1399.65 1328.81,-1339.65 835.81,-1339.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1339.65 835.81,-1399.65 1328.81,-1399.65 1328.81,-1339.65 835.81,-1339.65"/>
<text text-anchor="start" x="846.81" y="-1359.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">record_s &#160;&#160;&#160;</text>
<text text-anchor="start" x="1136.5" y="-1360.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="1278.72" y="-1360.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1287.61" y="-1360.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1279.65 835.81,-1339.65 1328.81,-1339.65 1328.81,-1279.65 835.81,-1279.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1279.65 835.81,-1339.65 1328.81,-1339.65 1328.81,-1279.65 835.81,-1279.65"/>
<text text-anchor="start" x="846.81" y="-1299.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">sleep_s &#160;&#160;&#160;</text>
<text text-anchor="start" x="1136.5" y="-1300.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="1278.72" y="-1300.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1287.61" y="-1300.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1219.65 835.81,-1279.65 1328.81,-1279.65 1328.81,-1219.65 835.81,-1219.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1219.65 835.81,-1279.65 1328.81,-1279.65 1328.81,-1219.65 835.81,-1219.65"/>
<text text-anchor="start" x="846.81" y="-1239.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="1131.15" y="-1240.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1159.65 835.81,-1219.65 1328.81,-1219.65 1328.81,-1159.65 835.81,-1159.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1159.65 835.81,-1219.65 1328.81,-1219.65 1328.81,-1159.65 835.81,-1159.65"/>
<text text-anchor="start" x="846.81" y="-1179.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1065.41" y="-1180.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1278.72" y="-1180.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1287.61" y="-1180.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1099.65 835.81,-1159.65 1328.81,-1159.65 1328.81,-1099.65 835.81,-1099.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1099.65 835.81,-1159.65 1328.81,-1159.65 1328.81,-1099.65 835.81,-1099.65"/>
<text text-anchor="start" x="846.81" y="-1119.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="1131.15" y="-1120.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="835.81,-1039.65 835.81,-1099.65 1328.81,-1099.65 1328.81,-1039.65 835.81,-1039.65"/>
<polygon fill="none" stroke="#29235c" points="835.81,-1039.65 835.81,-1099.65 1328.81,-1099.65 1328.81,-1039.65 835.81,-1039.65"/>
<text text-anchor="start" x="846.81" y="-1059.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1065.41" y="-1060.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1278.72" y="-1060.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1287.61" y="-1060.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="834.31,-1038.65 834.31,-1520.65 1329.31,-1520.65 1329.31,-1038.65 834.31,-1038.65"/>
</g>
<!-- cyclic_recording_pattern&#45;&gt;cluster -->
<!-- cyclic_recording_pattern&#45;&gt;cluster -->
<g id="edge8" class="edge">
<title>cyclic_recording_pattern:e&#45;&gt;cluster:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M1329.81,-1429.65C1455.47,-1429.65 1484.56,-1480.84 1605.13,-1483.54"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="1605.09,-1487.04 1615.13,-1483.65 1605.17,-1480.04 1605.09,-1487.04"/>
<text text-anchor="middle" x="1608.9" y="-1454.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="1320.92" y="-1400.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- cluster&#45;&gt;file -->
<!-- cluster&#45;&gt;file -->
<g id="edge12" class="edge">
<title>cluster:e&#45;&gt;file:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M2276.13,-2143.65C2432.88,-2143.65 2399.86,-2358.13 2548.46,-2367.35"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="2548.41,-2370.85 2558.51,-2367.65 2548.62,-2363.85 2548.41,-2370.85"/>
<text text-anchor="middle" x="2564.73" y="-2338.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="2267.23" y="-2114.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- moth_metadata -->
<g id="moth_metadata" class="node">
<title>moth_metadata</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="3651.25" cy="-1965.65" rx="343.81" ry="469.54"/>
<polygon fill="#1d71b8" stroke="transparent" points="3410.25,-2235.65 3410.25,-2295.65 3892.25,-2295.65 3892.25,-2235.65 3410.25,-2235.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-2235.65 3410.25,-2295.65 3892.25,-2295.65 3892.25,-2235.65 3410.25,-2235.65"/>
<text text-anchor="start" x="3477.85" y="-2256.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;moth_metadata &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-2175.65 3410.25,-2235.65 3892.25,-2235.65 3892.25,-2175.65 3410.25,-2175.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-2175.65 3410.25,-2235.65 3892.25,-2235.65 3892.25,-2175.65 3410.25,-2175.65"/>
<text text-anchor="start" x="3421.25" y="-2196.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">file_id</text>
<text text-anchor="start" x="3504.81" y="-2196.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3667.94" y="-2196.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-2115.65 3410.25,-2175.65 3892.25,-2175.65 3892.25,-2115.65 3410.25,-2115.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-2115.65 3410.25,-2175.65 3892.25,-2175.65 3892.25,-2115.65 3410.25,-2115.65"/>
<text text-anchor="start" x="3421.25" y="-2135.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">timestamp &#160;&#160;&#160;</text>
<text text-anchor="start" x="3655.5" y="-2136.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<text text-anchor="start" x="3842.16" y="-2136.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.05" y="-2136.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-2055.65 3410.25,-2115.65 3892.25,-2115.65 3892.25,-2055.65 3410.25,-2055.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-2055.65 3410.25,-2115.65 3892.25,-2115.65 3892.25,-2055.65 3410.25,-2055.65"/>
<text text-anchor="start" x="3421.25" y="-2075.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">recorder_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="3667.94" y="-2076.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(16)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1995.65 3410.25,-2055.65 3892.25,-2055.65 3892.25,-1995.65 3410.25,-1995.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1995.65 3410.25,-2055.65 3892.25,-2055.65 3892.25,-1995.65 3410.25,-1995.65"/>
<text text-anchor="start" x="3421.25" y="-2015.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">gain &#160;&#160;&#160;</text>
<text text-anchor="start" x="3737.21" y="-2016.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">gain_level</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1935.65 3410.25,-1995.65 3892.25,-1995.65 3892.25,-1935.65 3410.25,-1935.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1935.65 3410.25,-1995.65 3892.25,-1995.65 3892.25,-1935.65 3410.25,-1935.65"/>
<text text-anchor="start" x="3421.25" y="-1955.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">battery_v &#160;&#160;&#160;</text>
<text text-anchor="start" x="3673.26" y="-1956.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(2,1)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1875.65 3410.25,-1935.65 3892.25,-1935.65 3892.25,-1875.65 3410.25,-1875.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1875.65 3410.25,-1935.65 3892.25,-1935.65 3892.25,-1875.65 3410.25,-1875.65"/>
<text text-anchor="start" x="3421.25" y="-1895.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">temp_c &#160;&#160;&#160;</text>
<text text-anchor="start" x="3673.26" y="-1896.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(3,1)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1815.65 3410.25,-1875.65 3892.25,-1875.65 3892.25,-1815.65 3410.25,-1815.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1815.65 3410.25,-1875.65 3892.25,-1875.65 3892.25,-1815.65 3410.25,-1815.65"/>
<text text-anchor="start" x="3421.25" y="-1835.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.59" y="-1836.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1755.65 3410.25,-1815.65 3892.25,-1815.65 3892.25,-1755.65 3410.25,-1755.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1755.65 3410.25,-1815.65 3892.25,-1815.65 3892.25,-1755.65 3410.25,-1755.65"/>
<text text-anchor="start" x="3421.25" y="-1775.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="3628.85" y="-1776.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3842.16" y="-1776.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.05" y="-1776.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1695.65 3410.25,-1755.65 3892.25,-1755.65 3892.25,-1695.65 3410.25,-1695.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1695.65 3410.25,-1755.65 3892.25,-1755.65 3892.25,-1695.65 3410.25,-1695.65"/>
<text text-anchor="start" x="3421.25" y="-1715.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.59" y="-1716.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-1635.65 3410.25,-1695.65 3892.25,-1695.65 3892.25,-1635.65 3410.25,-1635.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-1635.65 3410.25,-1695.65 3892.25,-1695.65 3892.25,-1635.65 3410.25,-1635.65"/>
<text text-anchor="start" x="3421.22" y="-1655.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="3629.05" y="-1656.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3842.36" y="-1656.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.25" y="-1656.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3409.25,-1634.65 3409.25,-2296.65 3893.25,-2296.65 3893.25,-1634.65 3409.25,-1634.65"/>
</g>
<!-- file&#45;&gt;moth_metadata -->
<!-- file&#45;&gt;moth_metadata -->
<g id="edge14" class="edge">
<title>file:e&#45;&gt;moth_metadata:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3073.51,-2727.65C3214.95,-2727.65 3140.33,-2562.45 3217.09,-2443.65 3289,-2332.36 3274.13,-2211.93 3399.19,-2205.89"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="3399.33,-2209.39 3409.25,-2205.65 3399.17,-2202.39 3399.33,-2209.39"/>
<text text-anchor="middle" x="3403.03" y="-2176.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3082.41" y="-2698.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- file_metadata -->
<g id="file_metadata" class="node">
<title>file_metadata</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="3651.25" cy="-3200.65" rx="343.81" ry="299.63"/>
<polygon fill="#1d71b8" stroke="transparent" points="3410.25,-3350.65 3410.25,-3410.65 3892.25,-3410.65 3892.25,-3350.65 3410.25,-3350.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3350.65 3410.25,-3410.65 3892.25,-3410.65 3892.25,-3350.65 3410.25,-3350.65"/>
<text text-anchor="start" x="3492.97" y="-3371.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;file_metadata &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3290.65 3410.25,-3350.65 3892.25,-3350.65 3892.25,-3290.65 3410.25,-3290.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3290.65 3410.25,-3350.65 3892.25,-3350.65 3892.25,-3290.65 3410.25,-3290.65"/>
<text text-anchor="start" x="3421.25" y="-3311.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">file_id</text>
<text text-anchor="start" x="3504.81" y="-3311.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3667.94" y="-3311.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3230.65 3410.25,-3290.65 3892.25,-3290.65 3892.25,-3230.65 3410.25,-3230.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3230.65 3410.25,-3290.65 3892.25,-3290.65 3892.25,-3230.65 3410.25,-3230.65"/>
<text text-anchor="start" x="3421.25" y="-3250.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">json &#160;&#160;&#160;</text>
<text text-anchor="start" x="3774.57" y="-3251.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">JSONB</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3170.65 3410.25,-3230.65 3892.25,-3230.65 3892.25,-3170.65 3410.25,-3170.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3170.65 3410.25,-3230.65 3892.25,-3230.65 3892.25,-3170.65 3410.25,-3170.65"/>
<text text-anchor="start" x="3421.25" y="-3190.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.59" y="-3191.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3110.65 3410.25,-3170.65 3892.25,-3170.65 3892.25,-3110.65 3410.25,-3110.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3110.65 3410.25,-3170.65 3892.25,-3170.65 3892.25,-3110.65 3410.25,-3110.65"/>
<text text-anchor="start" x="3421.25" y="-3130.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="3628.85" y="-3131.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3842.16" y="-3131.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.05" y="-3131.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-3050.65 3410.25,-3110.65 3892.25,-3110.65 3892.25,-3050.65 3410.25,-3050.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-3050.65 3410.25,-3110.65 3892.25,-3110.65 3892.25,-3050.65 3410.25,-3050.65"/>
<text text-anchor="start" x="3421.25" y="-3070.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.59" y="-3071.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3410.25,-2990.65 3410.25,-3050.65 3892.25,-3050.65 3892.25,-2990.65 3410.25,-2990.65"/>
<polygon fill="none" stroke="#29235c" points="3410.25,-2990.65 3410.25,-3050.65 3892.25,-3050.65 3892.25,-2990.65 3410.25,-2990.65"/>
<text text-anchor="start" x="3421.22" y="-3010.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="3629.05" y="-3011.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="3842.36" y="-3011.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3851.25" y="-3011.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3409.25,-2989.65 3409.25,-3411.65 3893.25,-3411.65 3893.25,-2989.65 3409.25,-2989.65"/>
</g>
<!-- file&#45;&gt;file_metadata -->
<!-- file&#45;&gt;file_metadata -->
<g id="edge16" class="edge">
<title>file:e&#45;&gt;file_metadata:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3073.51,-2727.65C3221.54,-2727.65 3256.28,-3294.31 3399.22,-3319.77"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="3398.98,-3323.26 3409.25,-3320.65 3399.6,-3316.29 3398.98,-3323.26"/>
<text text-anchor="middle" x="3403.03" y="-3291.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3082.41" y="-2737.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- file&#45;&gt;file_dataset -->
<!-- file&#45;&gt;file_dataset -->
<g id="edge18" class="edge">
<title>file:e&#45;&gt;file_dataset:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3073.51,-2727.65C3238.37,-2727.65 3150.57,-2920.64 3181.09,-3082.65 3219.04,-3284.18 3172.23,-3342.55 3217.09,-3542.65 3268.96,-3774.06 3171.52,-4040.98 3399.23,-4048.49"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="3399.19,-4051.99 3409.25,-4048.65 3399.31,-4044.99 3399.19,-4051.99"/>
<text text-anchor="middle" x="3403.03" y="-4058.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3064.62" y="-2698.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- file&#45;&gt;selection -->
<!-- file&#45;&gt;selection -->
<g id="edge22" class="edge">
<title>file:e&#45;&gt;selection:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3073.51,-2727.65C3351.13,-2727.65 3009.81,-1671.33 3217.09,-1486.65 3253.1,-1454.56 4050.79,-1453.06 4085.41,-1486.65 4132.92,-1532.75 4117.04,-2611.6 4121.41,-2677.65 4130.86,-2820.33 4110.18,-3934.61 4245.57,-3986.76"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="4245.12,-3990.24 4255.59,-3988.65 4246.42,-3983.36 4245.12,-3990.24"/>
<text text-anchor="middle" x="4261.82" y="-3998.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3064.62" y="-2737.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- file_size -->
<g id="file_size" class="node">
<title>file_size</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="3651.25" cy="-2667.65" rx="308.1" ry="214.92"/>
<polygon fill="#1d71b8" stroke="transparent" points="3435.25,-2757.65 3435.25,-2817.65 3867.25,-2817.65 3867.25,-2757.65 3435.25,-2757.65"/>
<polygon fill="none" stroke="#29235c" points="3435.25,-2757.65 3435.25,-2817.65 3867.25,-2817.65 3867.25,-2757.65 3435.25,-2757.65"/>
<text text-anchor="start" x="3531.22" y="-2778.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;file_size &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3435.25,-2697.65 3435.25,-2757.65 3867.25,-2757.65 3867.25,-2697.65 3435.25,-2697.65"/>
<polygon fill="none" stroke="#29235c" points="3435.25,-2697.65 3435.25,-2757.65 3867.25,-2757.65 3867.25,-2697.65 3435.25,-2697.65"/>
<text text-anchor="start" x="3446.25" y="-2718.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">file_id</text>
<text text-anchor="start" x="3529.81" y="-2718.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3642.94" y="-2718.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3435.25,-2637.65 3435.25,-2697.65 3867.25,-2697.65 3867.25,-2637.65 3435.25,-2637.65"/>
<polygon fill="none" stroke="#29235c" points="3435.25,-2637.65 3435.25,-2697.65 3867.25,-2697.65 3867.25,-2637.65 3435.25,-2637.65"/>
<text text-anchor="start" x="3446.25" y="-2657.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">file_size &#160;&#160;&#160;</text>
<text text-anchor="start" x="3710.49" y="-2658.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BIGINT</text>
<text text-anchor="start" x="3817.16" y="-2658.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3826.05" y="-2658.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3435.25,-2577.65 3435.25,-2637.65 3867.25,-2637.65 3867.25,-2577.65 3435.25,-2577.65"/>
<polygon fill="none" stroke="#29235c" points="3435.25,-2577.65 3435.25,-2637.65 3867.25,-2637.65 3867.25,-2577.65 3435.25,-2577.65"/>
<text text-anchor="start" x="3446.25" y="-2597.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="3669.59" y="-2598.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3435.25,-2517.65 3435.25,-2577.65 3867.25,-2577.65 3867.25,-2517.65 3435.25,-2517.65"/>
<polygon fill="none" stroke="#29235c" points="3435.25,-2517.65 3435.25,-2577.65 3867.25,-2577.65 3867.25,-2517.65 3435.25,-2517.65"/>
<text text-anchor="start" x="3446.23" y="-2537.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="3669.92" y="-2538.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3434.25,-2516.65 3434.25,-2818.65 3868.25,-2818.65 3868.25,-2516.65 3434.25,-2516.65"/>
</g>
<!-- file&#45;&gt;file_size -->
<!-- file&#45;&gt;file_size -->
<g id="edge44" class="edge">
<title>file:e&#45;&gt;file_size:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3073.51,-2727.65C3230.4,-2727.65 3272.14,-2727.65 3424.08,-2727.65"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="3424.25,-2731.15 3434.25,-2727.65 3424.25,-2724.15 3424.25,-2731.15"/>
<text text-anchor="middle" x="3428.03" y="-2698.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3082.41" y="-2698.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- moth_metadata&#45;&gt;gain_level -->
<g id="edge54" class="edge">
<title>moth_metadata:e&#45;&gt;gain_level:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3893.25,-2025.65C4206.69,-2025.65 4038.15,-2561.65 4351.59,-2561.65"/>
</g>
<!-- file_dataset&#45;&gt;selection -->
<!-- file_dataset&#45;&gt;selection -->
<g id="edge46" class="edge">
<title>file_dataset:e&#45;&gt;selection:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3893.25,-3688.65C4000.51,-3688.65 4024.44,-3630.89 4085.41,-3542.65 4234.68,-3326.63 3995.95,-2977.99 4245.34,-2968.83"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="4245.66,-2972.33 4255.59,-2968.65 4245.53,-2965.33 4245.66,-2972.33"/>
<text text-anchor="middle" x="4261.82" y="-2939.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3884.36" y="-3698.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- selection_metadata -->
<g id="selection_metadata" class="node">
<title>selection_metadata</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="5253.43" cy="-3928.65" rx="343.81" ry="299.63"/>
<polygon fill="#1d71b8" stroke="transparent" points="5012.43,-4078.65 5012.43,-4138.65 5494.43,-4138.65 5494.43,-4078.65 5012.43,-4078.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-4078.65 5012.43,-4138.65 5494.43,-4138.65 5494.43,-4078.65 5012.43,-4078.65"/>
<text text-anchor="start" x="5052.47" y="-4099.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;selection_metadata &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-4018.65 5012.43,-4078.65 5494.43,-4078.65 5494.43,-4018.65 5012.43,-4018.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-4018.65 5012.43,-4078.65 5494.43,-4078.65 5494.43,-4018.65 5012.43,-4018.65"/>
<text text-anchor="start" x="5023.43" y="-4039.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">selection_id</text>
<text text-anchor="start" x="5192.36" y="-4039.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="5270.12" y="-4039.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-3958.65 5012.43,-4018.65 5494.43,-4018.65 5494.43,-3958.65 5012.43,-3958.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-3958.65 5012.43,-4018.65 5494.43,-4018.65 5494.43,-3958.65 5012.43,-3958.65"/>
<text text-anchor="start" x="5023.43" y="-3978.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">json &#160;&#160;&#160;</text>
<text text-anchor="start" x="5376.75" y="-3979.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">JSONB</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-3898.65 5012.43,-3958.65 5494.43,-3958.65 5494.43,-3898.65 5012.43,-3898.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-3898.65 5012.43,-3958.65 5494.43,-3958.65 5494.43,-3898.65 5012.43,-3898.65"/>
<text text-anchor="start" x="5023.43" y="-3918.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-3919.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-3838.65 5012.43,-3898.65 5494.43,-3898.65 5494.43,-3838.65 5012.43,-3838.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-3838.65 5012.43,-3898.65 5494.43,-3898.65 5494.43,-3838.65 5012.43,-3838.65"/>
<text text-anchor="start" x="5023.43" y="-3858.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-3859.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.34" y="-3859.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-3859.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-3778.65 5012.43,-3838.65 5494.43,-3838.65 5494.43,-3778.65 5012.43,-3778.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-3778.65 5012.43,-3838.65 5494.43,-3838.65 5494.43,-3778.65 5012.43,-3778.65"/>
<text text-anchor="start" x="5023.43" y="-3798.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-3799.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-3718.65 5012.43,-3778.65 5494.43,-3778.65 5494.43,-3718.65 5012.43,-3718.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-3718.65 5012.43,-3778.65 5494.43,-3778.65 5494.43,-3718.65 5012.43,-3718.65"/>
<text text-anchor="start" x="5023.4" y="-3738.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.23" y="-3739.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.54" y="-3739.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.43" y="-3739.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="5011.43,-3717.65 5011.43,-4139.65 5495.43,-4139.65 5495.43,-3717.65 5011.43,-3717.65"/>
</g>
<!-- selection&#45;&gt;selection_metadata -->
<!-- selection&#45;&gt;selection_metadata -->
<g id="edge26" class="edge">
<title>selection:e&#45;&gt;selection_metadata:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4739.59,-4048.65C4856.99,-4048.65 4888.83,-4048.65 5001.38,-4048.65"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5001.43,-4052.15 5011.43,-4048.65 5001.43,-4045.15 5001.43,-4052.15"/>
<text text-anchor="middle" x="5017.65" y="-4058.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4748.49" y="-4058.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- label -->
<g id="label" class="node">
<title>label</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="5253.43" cy="-2100.65" rx="343.81" ry="469.54"/>
<polygon fill="#1d71b8" stroke="transparent" points="5012.43,-2370.65 5012.43,-2430.65 5494.43,-2430.65 5494.43,-2370.65 5012.43,-2370.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2370.65 5012.43,-2430.65 5494.43,-2430.65 5494.43,-2370.65 5012.43,-2370.65"/>
<text text-anchor="start" x="5157.4" y="-2391.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;label &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2310.65 5012.43,-2370.65 5494.43,-2370.65 5494.43,-2310.65 5012.43,-2310.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2310.65 5012.43,-2370.65 5494.43,-2370.65 5494.43,-2310.65 5012.43,-2310.65"/>
<text text-anchor="start" x="5023.43" y="-2331.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="5048.32" y="-2331.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="5270.12" y="-2331.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2250.65 5012.43,-2310.65 5494.43,-2310.65 5494.43,-2250.65 5012.43,-2250.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2250.65 5012.43,-2310.65 5494.43,-2310.65 5494.43,-2250.65 5012.43,-2250.65"/>
<text text-anchor="start" x="5023.43" y="-2270.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">selection_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-2271.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<text text-anchor="start" x="5444.34" y="-2271.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-2271.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2190.65 5012.43,-2250.65 5494.43,-2250.65 5494.43,-2190.65 5012.43,-2190.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2190.65 5012.43,-2250.65 5494.43,-2250.65 5494.43,-2190.65 5012.43,-2190.65"/>
<text text-anchor="start" x="5023.43" y="-2210.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-2211.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="5444.34" y="-2211.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-2211.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2130.65 5012.43,-2190.65 5494.43,-2190.65 5494.43,-2130.65 5012.43,-2130.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2130.65 5012.43,-2190.65 5494.43,-2190.65 5494.43,-2130.65 5012.43,-2130.65"/>
<text text-anchor="start" x="5023.43" y="-2150.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">filter_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5270.12" y="-2151.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2070.65 5012.43,-2130.65 5494.43,-2130.65 5494.43,-2070.65 5012.43,-2070.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2070.65 5012.43,-2130.65 5494.43,-2130.65 5494.43,-2070.65 5012.43,-2070.65"/>
<text text-anchor="start" x="5023.43" y="-2090.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">certainty &#160;&#160;&#160;</text>
<text text-anchor="start" x="5275.44" y="-2091.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(5,2)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-2010.65 5012.43,-2070.65 5494.43,-2070.65 5494.43,-2010.65 5012.43,-2010.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-2010.65 5012.43,-2070.65 5494.43,-2070.65 5494.43,-2010.65 5012.43,-2010.65"/>
<text text-anchor="start" x="5023.43" y="-2030.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-2031.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1950.65 5012.43,-2010.65 5494.43,-2010.65 5494.43,-1950.65 5012.43,-1950.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1950.65 5012.43,-2010.65 5494.43,-2010.65 5494.43,-1950.65 5012.43,-1950.65"/>
<text text-anchor="start" x="5023.43" y="-1970.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-1971.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.34" y="-1971.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-1971.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1890.65 5012.43,-1950.65 5494.43,-1950.65 5494.43,-1890.65 5012.43,-1890.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1890.65 5012.43,-1950.65 5494.43,-1950.65 5494.43,-1890.65 5012.43,-1890.65"/>
<text text-anchor="start" x="5023.43" y="-1910.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-1911.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1830.65 5012.43,-1890.65 5494.43,-1890.65 5494.43,-1830.65 5012.43,-1830.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1830.65 5012.43,-1890.65 5494.43,-1890.65 5494.43,-1830.65 5012.43,-1830.65"/>
<text text-anchor="start" x="5023.4" y="-1850.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.23" y="-1851.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.54" y="-1851.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.43" y="-1851.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1770.65 5012.43,-1830.65 5494.43,-1830.65 5494.43,-1770.65 5012.43,-1770.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1770.65 5012.43,-1830.65 5494.43,-1830.65 5494.43,-1770.65 5012.43,-1770.65"/>
<text text-anchor="start" x="5023.43" y="-1790.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="5289.64" y="-1791.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<text text-anchor="start" x="5444.34" y="-1791.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-1791.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="5011.43,-1769.65 5011.43,-2431.65 5495.43,-2431.65 5495.43,-1769.65 5011.43,-1769.65"/>
</g>
<!-- selection&#45;&gt;label -->
<!-- selection&#45;&gt;label -->
<g id="edge32" class="edge">
<title>selection:e&#45;&gt;label:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4739.59,-4048.65C4904.02,-4048.65 4873.57,-2739.04 4909.77,-2578.65 4939.8,-2445.61 4874.93,-2288.84 5001.17,-2280.96"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5001.54,-2284.45 5011.43,-2280.65 5001.33,-2277.45 5001.54,-2284.45"/>
<text text-anchor="middle" x="5017.65" y="-2251.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4748.49" y="-4019.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- ebird_taxonomy -->
<g id="ebird_taxonomy" class="node">
<title>ebird_taxonomy</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="3651.25" cy="-681.65" rx="434.33" ry="681.8"/>
<polygon fill="#1d71b8" stroke="transparent" points="3346.25,-1101.65 3346.25,-1161.65 3956.25,-1161.65 3956.25,-1101.65 3346.25,-1101.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-1101.65 3346.25,-1161.65 3956.25,-1161.65 3956.25,-1101.65 3346.25,-1101.65"/>
<text text-anchor="start" x="3475.2" y="-1122.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;ebird_taxonomy &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-1041.65 3346.25,-1101.65 3956.25,-1101.65 3956.25,-1041.65 3346.25,-1041.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-1041.65 3346.25,-1101.65 3956.25,-1101.65 3956.25,-1041.65 3346.25,-1041.65"/>
<text text-anchor="start" x="3357.25" y="-1062.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="3382.14" y="-1062.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3731.94" y="-1062.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-981.65 3346.25,-1041.65 3956.25,-1041.65 3956.25,-981.65 3346.25,-981.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-981.65 3346.25,-1041.65 3956.25,-1041.65 3956.25,-981.65 3346.25,-981.65"/>
<text text-anchor="start" x="3357.25" y="-1001.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxonomy_version &#160;&#160;&#160;</text>
<text text-anchor="start" x="3710.64" y="-1002.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(4)</text>
<text text-anchor="start" x="3906.16" y="-1002.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.05" y="-1002.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-921.65 3346.25,-981.65 3956.25,-981.65 3956.25,-921.65 3346.25,-921.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-921.65 3346.25,-981.65 3956.25,-981.65 3956.25,-921.65 3346.25,-921.65"/>
<text text-anchor="start" x="3357.25" y="-941.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxon_order &#160;&#160;&#160;</text>
<text text-anchor="start" x="3763.94" y="-942.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="3906.16" y="-942.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.05" y="-942.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-861.65 3346.25,-921.65 3956.25,-921.65 3956.25,-861.65 3346.25,-861.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-861.65 3346.25,-921.65 3956.25,-921.65 3956.25,-861.65 3346.25,-861.65"/>
<text text-anchor="start" x="3357.25" y="-881.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">category &#160;&#160;&#160;</text>
<text text-anchor="start" x="3692.85" y="-882.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<text text-anchor="start" x="3906.16" y="-882.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.05" y="-882.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-801.65 3346.25,-861.65 3956.25,-861.65 3956.25,-801.65 3346.25,-801.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-801.65 3346.25,-861.65 3956.25,-861.65 3956.25,-801.65 3346.25,-801.65"/>
<text text-anchor="start" x="3357.25" y="-821.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_code &#160;&#160;&#160;</text>
<text text-anchor="start" x="3692.85" y="-822.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<text text-anchor="start" x="3906.16" y="-822.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.05" y="-822.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-741.65 3346.25,-801.65 3956.25,-801.65 3956.25,-741.65 3346.25,-741.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-741.65 3346.25,-801.65 3956.25,-801.65 3956.25,-741.65 3346.25,-741.65"/>
<text text-anchor="start" x="3357.25" y="-761.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxon_concept_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="3731.94" y="-762.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-681.65 3346.25,-741.65 3956.25,-741.65 3956.25,-681.65 3346.25,-681.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-681.65 3346.25,-741.65 3956.25,-741.65 3956.25,-681.65 3346.25,-681.65"/>
<text text-anchor="start" x="3357.13" y="-701.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">primary_com_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="3675.16" y="-702.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="3906.25" y="-702.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.15" y="-702.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-621.65 3346.25,-681.65 3956.25,-681.65 3956.25,-621.65 3346.25,-621.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-621.65 3346.25,-681.65 3956.25,-681.65 3956.25,-621.65 3346.25,-621.65"/>
<text text-anchor="start" x="3357.25" y="-641.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">sci_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="3675.06" y="-642.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="3906.16" y="-642.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.05" y="-642.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-561.65 3346.25,-621.65 3956.25,-621.65 3956.25,-561.65 3346.25,-561.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-561.65 3346.25,-621.65 3956.25,-621.65 3956.25,-561.65 3346.25,-561.65"/>
<text text-anchor="start" x="3357.25" y="-581.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">bird_order &#160;&#160;&#160;</text>
<text text-anchor="start" x="3731.94" y="-582.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(30)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-501.65 3346.25,-561.65 3956.25,-561.65 3956.25,-501.65 3346.25,-501.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-501.65 3346.25,-561.65 3956.25,-561.65 3956.25,-501.65 3346.25,-501.65"/>
<text text-anchor="start" x="3357.25" y="-521.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">family &#160;&#160;&#160;</text>
<text text-anchor="start" x="3714.15" y="-522.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-441.65 3346.25,-501.65 3956.25,-501.65 3956.25,-441.65 3346.25,-441.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-441.65 3346.25,-501.65 3956.25,-501.65 3956.25,-441.65 3346.25,-441.65"/>
<text text-anchor="start" x="3357.25" y="-461.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_group &#160;&#160;&#160;</text>
<text text-anchor="start" x="3714.15" y="-462.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-381.65 3346.25,-441.65 3956.25,-441.65 3956.25,-381.65 3346.25,-381.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-381.65 3346.25,-441.65 3956.25,-441.65 3956.25,-381.65 3346.25,-381.65"/>
<text text-anchor="start" x="3357.25" y="-401.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">report_as &#160;&#160;&#160;</text>
<text text-anchor="start" x="3731.94" y="-402.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-321.65 3346.25,-381.65 3956.25,-381.65 3956.25,-321.65 3346.25,-321.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-321.65 3346.25,-381.65 3956.25,-381.65 3956.25,-321.65 3346.25,-321.65"/>
<text text-anchor="start" x="3357.25" y="-341.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">valid_from &#160;&#160;&#160;</text>
<text text-anchor="start" x="3820.83" y="-342.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DATE</text>
<text text-anchor="start" x="3906.16" y="-342.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3915.05" y="-342.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-261.65 3346.25,-321.65 3956.25,-321.65 3956.25,-261.65 3346.25,-261.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-261.65 3346.25,-321.65 3956.25,-321.65 3956.25,-261.65 3346.25,-261.65"/>
<text text-anchor="start" x="3357.25" y="-281.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">valid_to &#160;&#160;&#160;</text>
<text text-anchor="start" x="3859.92" y="-282.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DATE</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3346.25,-201.65 3346.25,-261.65 3956.25,-261.65 3956.25,-201.65 3346.25,-201.65"/>
<polygon fill="none" stroke="#29235c" points="3346.25,-201.65 3346.25,-261.65 3956.25,-261.65 3956.25,-201.65 3346.25,-201.65"/>
<text text-anchor="start" x="3379.17" y="-222.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;taxonomy_version, species_code &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3345.25,-200.65 3345.25,-1162.65 3957.25,-1162.65 3957.25,-200.65 3345.25,-200.65"/>
</g>
<!-- species -->
<g id="species" class="node">
<title>species</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="4497.59" cy="-1544.65" rx="376.36" ry="554.24"/>
<polygon fill="#1d71b8" stroke="transparent" points="4233.59,-1874.65 4233.59,-1934.65 4761.59,-1934.65 4761.59,-1874.65 4233.59,-1874.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1874.65 4233.59,-1934.65 4761.59,-1934.65 4761.59,-1874.65 4233.59,-1874.65"/>
<text text-anchor="start" x="4381.11" y="-1895.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;species &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1814.65 4233.59,-1874.65 4761.59,-1874.65 4761.59,-1814.65 4233.59,-1814.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1814.65 4233.59,-1874.65 4761.59,-1874.65 4761.59,-1814.65 4233.59,-1814.65"/>
<text text-anchor="start" x="4244.59" y="-1835.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="4269.48" y="-1835.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="4537.29" y="-1835.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1754.65 4233.59,-1814.65 4761.59,-1814.65 4761.59,-1754.65 4233.59,-1754.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1754.65 4233.59,-1814.65 4761.59,-1814.65 4761.59,-1754.65 4233.59,-1754.65"/>
<text text-anchor="start" x="4244.59" y="-1774.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">label &#160;&#160;&#160;</text>
<text text-anchor="start" x="4480.41" y="-1775.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="4711.5" y="-1775.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4720.4" y="-1775.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1694.65 4233.59,-1754.65 4761.59,-1754.65 4761.59,-1694.65 4233.59,-1694.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1694.65 4233.59,-1754.65 4761.59,-1754.65 4761.59,-1694.65 4233.59,-1694.65"/>
<text text-anchor="start" x="4244.59" y="-1714.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">ebird_code &#160;&#160;&#160;</text>
<text text-anchor="start" x="4537.29" y="-1715.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1634.65 4233.59,-1694.65 4761.59,-1694.65 4761.59,-1634.65 4233.59,-1634.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1634.65 4233.59,-1694.65 4761.59,-1694.65 4761.59,-1634.65 4233.59,-1634.65"/>
<text text-anchor="start" x="4244.59" y="-1654.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxonomy_version &#160;&#160;&#160;</text>
<text text-anchor="start" x="4555.07" y="-1655.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(4)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1574.65 4233.59,-1634.65 4761.59,-1634.65 4761.59,-1574.65 4233.59,-1574.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1574.65 4233.59,-1634.65 4761.59,-1634.65 4761.59,-1574.65 4233.59,-1574.65"/>
<text text-anchor="start" x="4244.59" y="-1594.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="4519.5" y="-1595.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1514.65 4233.59,-1574.65 4761.59,-1574.65 4761.59,-1514.65 4233.59,-1514.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1514.65 4233.59,-1574.65 4761.59,-1574.65 4761.59,-1514.65 4233.59,-1514.65"/>
<text text-anchor="start" x="4244.59" y="-1534.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="4498.19" y="-1535.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4711.5" y="-1535.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4720.4" y="-1535.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1454.65 4233.59,-1514.65 4761.59,-1514.65 4761.59,-1454.65 4233.59,-1454.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1454.65 4233.59,-1514.65 4761.59,-1514.65 4761.59,-1454.65 4233.59,-1454.65"/>
<text text-anchor="start" x="4244.59" y="-1474.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="4563.93" y="-1475.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1394.65 4233.59,-1454.65 4761.59,-1454.65 4761.59,-1394.65 4233.59,-1394.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1394.65 4233.59,-1454.65 4761.59,-1454.65 4761.59,-1394.65 4233.59,-1394.65"/>
<text text-anchor="start" x="4244.59" y="-1414.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="4563.93" y="-1415.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1334.65 4233.59,-1394.65 4761.59,-1394.65 4761.59,-1334.65 4233.59,-1334.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1334.65 4233.59,-1394.65 4761.59,-1394.65 4761.59,-1334.65 4233.59,-1334.65"/>
<text text-anchor="start" x="4244.59" y="-1354.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="4498.19" y="-1355.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4711.5" y="-1355.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4720.4" y="-1355.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1274.65 4233.59,-1334.65 4761.59,-1334.65 4761.59,-1274.65 4233.59,-1274.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1274.65 4233.59,-1334.65 4761.59,-1334.65 4761.59,-1274.65 4233.59,-1274.65"/>
<text text-anchor="start" x="4244.59" y="-1294.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="4595.9" y="-1295.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1214.65 4233.59,-1274.65 4761.59,-1274.65 4761.59,-1214.65 4233.59,-1214.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1214.65 4233.59,-1274.65 4761.59,-1274.65 4761.59,-1214.65 4233.59,-1214.65"/>
<text text-anchor="start" x="4244.59" y="-1234.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">owner &#160;&#160;&#160;</text>
<text text-anchor="start" x="4498.19" y="-1235.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4711.5" y="-1235.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4720.4" y="-1235.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4233.59,-1154.65 4233.59,-1214.65 4761.59,-1214.65 4761.59,-1154.65 4233.59,-1154.65"/>
<polygon fill="none" stroke="#29235c" points="4233.59,-1154.65 4233.59,-1214.65 4761.59,-1214.65 4761.59,-1154.65 4233.59,-1154.65"/>
<text text-anchor="start" x="4244.19" y="-1175.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;ebird_code, taxonomy_version &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="4232.59,-1153.65 4232.59,-1935.65 4762.59,-1935.65 4762.59,-1153.65 4232.59,-1153.65"/>
</g>
<!-- ebird_taxonomy&#45;&gt;species -->
<!-- ebird_taxonomy&#45;&gt;species -->
<g id="edge28" class="edge">
<title>ebird_taxonomy:e&#45;&gt;species:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M3957.25,-231.65C4174.25,-231.65 4017.23,-1155.1 4222.54,-1183.96"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="4222.38,-1187.46 4232.59,-1184.65 4222.86,-1180.47 4222.38,-1187.46"/>
<text text-anchor="middle" x="4238.82" y="-1155.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="3948.36" y="-202.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- call_type -->
<g id="call_type" class="node">
<title>call_type</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="5253.43" cy="-1228.65" rx="343.81" ry="384.83"/>
<polygon fill="#1d71b8" stroke="transparent" points="5012.43,-1438.65 5012.43,-1498.65 5494.43,-1498.65 5494.43,-1438.65 5012.43,-1438.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1438.65 5012.43,-1498.65 5494.43,-1498.65 5494.43,-1438.65 5012.43,-1438.65"/>
<text text-anchor="start" x="5128.05" y="-1459.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;call_type &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1378.65 5012.43,-1438.65 5494.43,-1438.65 5494.43,-1378.65 5012.43,-1378.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1378.65 5012.43,-1438.65 5494.43,-1438.65 5494.43,-1378.65 5012.43,-1378.65"/>
<text text-anchor="start" x="5023.43" y="-1399.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="5048.32" y="-1399.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="5270.12" y="-1399.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1318.65 5012.43,-1378.65 5494.43,-1378.65 5494.43,-1318.65 5012.43,-1318.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1318.65 5012.43,-1378.65 5494.43,-1378.65 5494.43,-1318.65 5012.43,-1318.65"/>
<text text-anchor="start" x="5023.43" y="-1338.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-1339.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="5444.34" y="-1339.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-1339.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1258.65 5012.43,-1318.65 5494.43,-1318.65 5494.43,-1258.65 5012.43,-1258.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1258.65 5012.43,-1318.65 5494.43,-1318.65 5494.43,-1258.65 5012.43,-1258.65"/>
<text text-anchor="start" x="5023.43" y="-1278.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">label &#160;&#160;&#160;</text>
<text text-anchor="start" x="5213.24" y="-1279.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="5444.34" y="-1279.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-1279.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1198.65 5012.43,-1258.65 5494.43,-1258.65 5494.43,-1198.65 5012.43,-1198.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1198.65 5012.43,-1258.65 5494.43,-1258.65 5494.43,-1198.65 5012.43,-1198.65"/>
<text text-anchor="start" x="5023.43" y="-1218.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.03" y="-1219.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.34" y="-1219.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.23" y="-1219.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1138.65 5012.43,-1198.65 5494.43,-1198.65 5494.43,-1138.65 5012.43,-1138.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1138.65 5012.43,-1198.65 5494.43,-1198.65 5494.43,-1138.65 5012.43,-1138.65"/>
<text text-anchor="start" x="5023.43" y="-1158.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-1159.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1078.65 5012.43,-1138.65 5494.43,-1138.65 5494.43,-1078.65 5012.43,-1078.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1078.65 5012.43,-1138.65 5494.43,-1138.65 5494.43,-1078.65 5012.43,-1078.65"/>
<text text-anchor="start" x="5023.43" y="-1098.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="5296.77" y="-1099.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-1018.65 5012.43,-1078.65 5494.43,-1078.65 5494.43,-1018.65 5012.43,-1018.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-1018.65 5012.43,-1078.65 5494.43,-1078.65 5494.43,-1018.65 5012.43,-1018.65"/>
<text text-anchor="start" x="5023.4" y="-1038.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5231.23" y="-1039.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="5444.54" y="-1039.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="5453.43" y="-1039.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5012.43,-958.65 5012.43,-1018.65 5494.43,-1018.65 5494.43,-958.65 5012.43,-958.65"/>
<polygon fill="none" stroke="#29235c" points="5012.43,-958.65 5012.43,-1018.65 5494.43,-1018.65 5494.43,-958.65 5012.43,-958.65"/>
<text text-anchor="start" x="5023.43" y="-978.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="5328.73" y="-979.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="5011.43,-957.65 5011.43,-1499.65 5495.43,-1499.65 5495.43,-957.65 5011.43,-957.65"/>
</g>
<!-- species&#45;&gt;call_type -->
<!-- species&#45;&gt;call_type -->
<g id="edge30" class="edge">
<title>species:e&#45;&gt;call_type:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4762.59,-1844.65C5005.73,-1844.65 4771.62,-1362.6 5001.24,-1348.95"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5001.53,-1352.44 5011.43,-1348.65 5001.33,-1345.44 5001.53,-1352.44"/>
<text text-anchor="middle" x="5017.65" y="-1319.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4771.49" y="-1815.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- species&#45;&gt;label -->
<!-- species&#45;&gt;label -->
<g id="edge34" class="edge">
<title>species:e&#45;&gt;label:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4762.59,-1844.65C4959.46,-1844.65 4816.27,-2207.55 5001.18,-2220.31"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5001.32,-2223.81 5011.43,-2220.65 5001.55,-2216.82 5001.32,-2223.81"/>
<text text-anchor="middle" x="5017.65" y="-2191.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4771.49" y="-1854.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- species&#45;&gt;species_dataset -->
<!-- species&#45;&gt;species_dataset -->
<g id="edge48" class="edge">
<title>species:e&#45;&gt;species_dataset:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4762.59,-1844.65C5023.4,-1844.65 4754.42,-2977.19 5001.26,-3007.05"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5001.24,-3010.55 5011.43,-3007.65 5001.65,-3003.57 5001.24,-3010.55"/>
<text text-anchor="middle" x="5017.65" y="-2978.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4753.7" y="-1815.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- label_subtype -->
<g id="label_subtype" class="node">
<title>label_subtype</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="5976.74" cy="-1168.65" rx="343.81" ry="469.54"/>
<polygon fill="#1d71b8" stroke="transparent" points="5735.74,-1438.65 5735.74,-1498.65 6217.74,-1498.65 6217.74,-1438.65 5735.74,-1438.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1438.65 5735.74,-1498.65 6217.74,-1498.65 6217.74,-1438.65 5735.74,-1438.65"/>
<text text-anchor="start" x="5815.78" y="-1459.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;label_subtype &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1378.65 5735.74,-1438.65 6217.74,-1438.65 6217.74,-1378.65 5735.74,-1378.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1378.65 5735.74,-1438.65 6217.74,-1438.65 6217.74,-1378.65 5735.74,-1378.65"/>
<text text-anchor="start" x="5746.74" y="-1399.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="5771.63" y="-1399.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="5993.43" y="-1399.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1318.65 5735.74,-1378.65 6217.74,-1378.65 6217.74,-1318.65 5735.74,-1318.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1318.65 5735.74,-1378.65 6217.74,-1378.65 6217.74,-1318.65 5735.74,-1318.65"/>
<text text-anchor="start" x="5746.74" y="-1338.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">label_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5954.34" y="-1339.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(21)</text>
<text text-anchor="start" x="6167.65" y="-1339.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="6176.54" y="-1339.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1258.65 5735.74,-1318.65 6217.74,-1318.65 6217.74,-1258.65 5735.74,-1258.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1258.65 5735.74,-1318.65 6217.74,-1318.65 6217.74,-1258.65 5735.74,-1258.65"/>
<text text-anchor="start" x="5746.74" y="-1278.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">calltype_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5954.34" y="-1279.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<text text-anchor="start" x="6167.65" y="-1279.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="6176.54" y="-1279.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1198.65 5735.74,-1258.65 6217.74,-1258.65 6217.74,-1198.65 5735.74,-1198.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1198.65 5735.74,-1258.65 6217.74,-1258.65 6217.74,-1198.65 5735.74,-1198.65"/>
<text text-anchor="start" x="5746.74" y="-1218.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">filter_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="5993.43" y="-1219.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1138.65 5735.74,-1198.65 6217.74,-1198.65 6217.74,-1138.65 5735.74,-1138.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1138.65 5735.74,-1198.65 6217.74,-1198.65 6217.74,-1138.65 5735.74,-1138.65"/>
<text text-anchor="start" x="5746.74" y="-1158.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">certainty &#160;&#160;&#160;</text>
<text text-anchor="start" x="5998.74" y="-1159.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DECIMAL(5,2)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1078.65 5735.74,-1138.65 6217.74,-1138.65 6217.74,-1078.65 5735.74,-1078.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1078.65 5735.74,-1138.65 6217.74,-1138.65 6217.74,-1078.65 5735.74,-1078.65"/>
<text text-anchor="start" x="5746.74" y="-1098.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="6020.08" y="-1099.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-1018.65 5735.74,-1078.65 6217.74,-1078.65 6217.74,-1018.65 5735.74,-1018.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-1018.65 5735.74,-1078.65 6217.74,-1078.65 6217.74,-1018.65 5735.74,-1018.65"/>
<text text-anchor="start" x="5746.74" y="-1038.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5954.34" y="-1039.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="6167.65" y="-1039.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="6176.54" y="-1039.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-958.65 5735.74,-1018.65 6217.74,-1018.65 6217.74,-958.65 5735.74,-958.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-958.65 5735.74,-1018.65 6217.74,-1018.65 6217.74,-958.65 5735.74,-958.65"/>
<text text-anchor="start" x="5746.74" y="-978.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="6020.08" y="-979.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-898.65 5735.74,-958.65 6217.74,-958.65 6217.74,-898.65 5735.74,-898.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-898.65 5735.74,-958.65 6217.74,-958.65 6217.74,-898.65 5735.74,-898.65"/>
<text text-anchor="start" x="5746.71" y="-918.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="5954.54" y="-919.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="6167.85" y="-919.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="6176.74" y="-919.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="5735.74,-838.65 5735.74,-898.65 6217.74,-898.65 6217.74,-838.65 5735.74,-838.65"/>
<polygon fill="none" stroke="#29235c" points="5735.74,-838.65 5735.74,-898.65 6217.74,-898.65 6217.74,-838.65 5735.74,-838.65"/>
<text text-anchor="start" x="5746.74" y="-858.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="6012.95" y="-859.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<text text-anchor="start" x="6167.65" y="-859.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="6176.54" y="-859.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="5734.74,-837.65 5734.74,-1499.65 6218.74,-1499.65 6218.74,-837.65 5734.74,-837.65"/>
</g>
<!-- call_type&#45;&gt;label_subtype -->
<!-- call_type&#45;&gt;label_subtype -->
<g id="edge40" class="edge">
<title>call_type:e&#45;&gt;label_subtype:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M5495.43,-1408.65C5610.92,-1408.65 5615.57,-1295.58 5724.58,-1288.95"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5724.85,-1292.45 5734.74,-1288.65 5724.64,-1285.45 5724.85,-1292.45"/>
<text text-anchor="middle" x="5740.96" y="-1259.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="5504.32" y="-1379.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- filter -->
<g id="filter" class="node">
<title>filter</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="4497.59" cy="-545.65" rx="343.81" ry="427.19"/>
<polygon fill="#1d71b8" stroke="transparent" points="4256.59,-785.65 4256.59,-845.65 4738.59,-845.65 4738.59,-785.65 4256.59,-785.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-785.65 4256.59,-845.65 4738.59,-845.65 4738.59,-785.65 4256.59,-785.65"/>
<text text-anchor="start" x="4405.13" y="-806.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;filter &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-725.65 4256.59,-785.65 4738.59,-785.65 4738.59,-725.65 4256.59,-725.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-725.65 4256.59,-785.65 4738.59,-785.65 4738.59,-725.65 4256.59,-725.65"/>
<text text-anchor="start" x="4267.59" y="-746.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="4292.48" y="-746.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="4514.29" y="-746.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-665.65 4256.59,-725.65 4738.59,-725.65 4738.59,-665.65 4256.59,-665.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-665.65 4256.59,-725.65 4738.59,-725.65 4738.59,-665.65 4256.59,-665.65"/>
<text text-anchor="start" x="4267.59" y="-685.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">name &#160;&#160;&#160;</text>
<text text-anchor="start" x="4457.41" y="-686.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(140)</text>
<text text-anchor="start" x="4688.5" y="-686.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-686.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-605.65 4256.59,-665.65 4738.59,-665.65 4738.59,-605.65 4256.59,-605.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-605.65 4256.59,-665.65 4738.59,-665.65 4738.59,-605.65 4256.59,-605.65"/>
<text text-anchor="start" x="4267.59" y="-625.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">description &#160;&#160;&#160;</text>
<text text-anchor="start" x="4496.5" y="-626.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(255)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-545.65 4256.59,-605.65 4738.59,-605.65 4738.59,-545.65 4256.59,-545.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-545.65 4256.59,-605.65 4738.59,-605.65 4738.59,-545.65 4256.59,-545.65"/>
<text text-anchor="start" x="4267.59" y="-565.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="4540.93" y="-566.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-485.65 4256.59,-545.65 4738.59,-545.65 4738.59,-485.65 4256.59,-485.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-485.65 4256.59,-545.65 4738.59,-545.65 4738.59,-485.65 4256.59,-485.65"/>
<text text-anchor="start" x="4267.59" y="-505.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.19" y="-506.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4688.5" y="-506.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-506.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-425.65 4256.59,-485.65 4738.59,-485.65 4738.59,-425.65 4256.59,-425.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-425.65 4256.59,-485.65 4738.59,-485.65 4738.59,-425.65 4256.59,-425.65"/>
<text text-anchor="start" x="4267.59" y="-445.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="4540.93" y="-446.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-365.65 4256.59,-425.65 4738.59,-425.65 4738.59,-365.65 4256.59,-365.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-365.65 4256.59,-425.65 4738.59,-425.65 4738.59,-365.65 4256.59,-365.65"/>
<text text-anchor="start" x="4267.57" y="-385.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.39" y="-386.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4688.7" y="-386.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.6" y="-386.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-305.65 4256.59,-365.65 4738.59,-365.65 4738.59,-305.65 4256.59,-305.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-305.65 4256.59,-365.65 4738.59,-365.65 4738.59,-305.65 4256.59,-305.65"/>
<text text-anchor="start" x="4267.59" y="-325.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">owner &#160;&#160;&#160;</text>
<text text-anchor="start" x="4475.19" y="-326.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="4688.5" y="-326.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-326.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="4256.59,-245.65 4256.59,-305.65 4738.59,-305.65 4738.59,-245.65 4256.59,-245.65"/>
<polygon fill="none" stroke="#29235c" points="4256.59,-245.65 4256.59,-305.65 4738.59,-305.65 4738.59,-245.65 4256.59,-245.65"/>
<text text-anchor="start" x="4267.59" y="-265.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="4533.81" y="-266.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<text text-anchor="start" x="4688.5" y="-266.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="4697.4" y="-266.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="4255.59,-244.65 4255.59,-846.65 4739.59,-846.65 4739.59,-244.65 4255.59,-244.65"/>
</g>
<!-- filter&#45;&gt;label -->
<!-- filter&#45;&gt;label -->
<g id="edge36" class="edge">
<title>filter:e&#45;&gt;label:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4739.59,-755.65C4856.41,-755.65 4839.71,-869.92 4873.77,-981.65 4911.23,-1104.48 4881.21,-2105.77 5001.33,-2158.49"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5000.92,-2161.98 5011.43,-2160.65 5002.38,-2155.14 5000.92,-2161.98"/>
<text text-anchor="middle" x="5017.65" y="-2131.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4748.49" y="-726.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- filter&#45;&gt;label_subtype -->
<!-- filter&#45;&gt;label_subtype -->
<g id="edge42" class="edge">
<title>filter:e&#45;&gt;label_subtype:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M4739.59,-755.65C5121.18,-755.65 5294.59,-566.04 5597.08,-798.65 5753.36,-918.82 5541.76,-1217.89 5724.54,-1228.37"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5724.64,-1231.87 5734.74,-1228.65 5724.84,-1224.88 5724.64,-1231.87"/>
<text text-anchor="middle" x="5740.96" y="-1199.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="4748.49" y="-765.25" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- label&#45;&gt;label_subtype -->
<!-- label&#45;&gt;label_subtype -->
<g id="edge38" class="edge">
<title>label:e&#45;&gt;label_subtype:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M5495.43,-2340.65C5718.76,-2340.65 5514.35,-1378.45 5724.74,-1349.33"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="5725,-1352.82 5734.74,-1348.65 5724.52,-1345.83 5725,-1352.82"/>
<text text-anchor="middle" x="5740.96" y="-1319.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">*</text>
<text text-anchor="middle" x="5504.32" y="-2311.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>
</g>
<!-- access_grant&#45;&gt;role_name -->
<g id="edge55" class="edge">
<title>access_grant:e&#45;&gt;role_name:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M1334.81,-3346.65C1646.43,-3346.65 1484.51,-3874.65 1796.13,-3874.65"/>
</g>
<!-- access_grant&#45;&gt;permission_name -->
<g id="edge56" class="edge">
<title>access_grant:e&#45;&gt;permission_name:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M1334.81,-3286.65C1517.17,-3286.65 1562.76,-3286.65 1745.13,-3286.65"/>
</g>
<!-- user_role -->
<g id="user_role" class="node">
<title>user_role</title>
<ellipse fill="none" stroke="black" stroke-width="0" cx="1081.81" cy="-4013.65" rx="343.81" ry="299.63"/>
<polygon fill="#1d71b8" stroke="transparent" points="840.81,-4163.65 840.81,-4223.65 1322.81,-4223.65 1322.81,-4163.65 840.81,-4163.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-4163.65 840.81,-4223.65 1322.81,-4223.65 1322.81,-4163.65 840.81,-4163.65"/>
<text text-anchor="start" x="952.89" y="-4184.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;user_role &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-4103.65 840.81,-4163.65 1322.81,-4163.65 1322.81,-4103.65 840.81,-4103.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-4103.65 840.81,-4163.65 1322.81,-4163.65 1322.81,-4103.65 840.81,-4103.65"/>
<text text-anchor="start" x="851.81" y="-4124.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">user_id</text>
<text text-anchor="start" x="956.72" y="-4124.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="1098.5" y="-4124.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-4043.65 840.81,-4103.65 1322.81,-4103.65 1322.81,-4043.65 840.81,-4043.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-4043.65 840.81,-4103.65 1322.81,-4103.65 1322.81,-4043.65 840.81,-4043.65"/>
<text text-anchor="start" x="851.81" y="-4063.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">role &#160;&#160;&#160;</text>
<text text-anchor="start" x="1121.58" y="-4064.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">role_name</text>
<text text-anchor="start" x="1272.72" y="-4064.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.61" y="-4064.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-3983.65 840.81,-4043.65 1322.81,-4043.65 1322.81,-3983.65 840.81,-3983.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-3983.65 840.81,-4043.65 1322.81,-4043.65 1322.81,-3983.65 840.81,-3983.65"/>
<text text-anchor="start" x="851.81" y="-4003.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_at &#160;&#160;&#160;</text>
<text text-anchor="start" x="1125.15" y="-4004.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-3923.65 840.81,-3983.65 1322.81,-3983.65 1322.81,-3923.65 840.81,-3923.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-3923.65 840.81,-3983.65 1322.81,-3983.65 1322.81,-3923.65 840.81,-3923.65"/>
<text text-anchor="start" x="851.81" y="-3943.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">created_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1059.41" y="-3944.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1272.72" y="-3944.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.61" y="-3944.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-3863.65 840.81,-3923.65 1322.81,-3923.65 1322.81,-3863.65 840.81,-3863.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-3863.65 840.81,-3923.65 1322.81,-3923.65 1322.81,-3863.65 840.81,-3863.65"/>
<text text-anchor="start" x="851.81" y="-3883.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">last_modified &#160;&#160;&#160;</text>
<text text-anchor="start" x="1125.15" y="-3884.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">TIMESTAMP</text>
<polygon fill="#e7e2dd" stroke="transparent" points="840.81,-3803.65 840.81,-3863.65 1322.81,-3863.65 1322.81,-3803.65 840.81,-3803.65"/>
<polygon fill="none" stroke="#29235c" points="840.81,-3803.65 840.81,-3863.65 1322.81,-3863.65 1322.81,-3803.65 840.81,-3803.65"/>
<text text-anchor="start" x="851.79" y="-3823.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">modified_by &#160;&#160;&#160;</text>
<text text-anchor="start" x="1059.61" y="-3824.85" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(64)</text>
<text text-anchor="start" x="1272.92" y="-3824.85" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="1281.81" y="-3824.85" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="839.81,-3802.65 839.81,-4224.65 1323.81,-4224.65 1323.81,-3802.65 839.81,-3802.65"/>
</g>
<!-- user_role&#45;&gt;role_name -->
<g id="edge57" class="edge">
<title>user_role:e&#45;&gt;role_name:w</title>
<path fill="none" stroke="#29235c" stroke-width="3" d="M1323.81,-4073.65C1551.6,-4073.65 1568.34,-3874.65 1796.13,-3874.65"/>
</g>
</g>
</svg>

Replacement in db/schema.sql at line 3 [10.70506]

B:BD[10.70617] → [10.70617:70954]


-- no need to keep a storage url for files, pattern is $prefix/$file_id.opus,
--     this way can change provider anytime.
-- store files and selections on aws, to train models
-- 1 bucket for files, 1 bucket for selections, random 12 digit prefix to filename
-- save files as opus
-- save selections as wav to prevent over compression

[10.70617]

[10.70954]

-- dbml-renderer -i schema.dbml -o schema.svg

File addition: schema.dbml (----------)

[10.1]

Enum "dataset_type" {
  "organise"
  "test"
  "train"
}
Enum "gain_level" {
  "low"
  "low-medium"
  "medium"
  "medium-high"
  "high"
}
Enum "role_name" {
  "ADMIN"
  "USER"
  "CURATOR"
}
Enum "permission_name" {
  "READ"
  "UPLOAD"
  "DOWNLOAD"
  "EDIT"
  "DELETE"
}
Table "dataset" {
  "id" VARCHAR(12) [pk]
  "name" VARCHAR(255) [not null]
  "public" BOOLEAN [default: FALSE]
  "description" VARCHAR(255)
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "owner" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  "type" dataset_type [not null, default: 'organise']
  Indexes {
    name [name: "idx_dataset_name"]
    owner [name: "idx_dataset_owner"]
    active [name: "idx_dataset_active"]
    public [name: "idx_dataset_public"]
  }
}
Table "location" {
  "id" VARCHAR(12) [pk]
  "dataset_id" VARCHAR(12) [not null]
  "name" VARCHAR(140) [not null]
  "latitude" DECIMAL(10,7)
  "longitude" DECIMAL(10,7)
  "description" VARCHAR(255)
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  Indexes {
    name [name: "idx_location_name"]
    dataset_id [name: "idx_location_dataset"]
    active [name: "idx_location_active"]
    (dataset_id, active) [name: "idx_location_dataset_active"]
  }
}
Table "cyclic_recording_pattern" {
  "id" VARCHAR(12) [pk]
  "record_s" INTEGER [not null]
  "sleep_s" INTEGER [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
}
Table "cluster" {
  "id" VARCHAR(12) [pk]
  "dataset_id" VARCHAR(12) [not null]
  "location_id" VARCHAR(12) [not null]
  "name" VARCHAR(140) [not null]
  "description" VARCHAR(255)
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  "timezone_id" VARCHAR(40)
  "cyclic_recording_pattern_id" VARCHAR(12)
  "sample_rate" INTEGER [not null]
  Indexes {
    dataset_id [name: "idx_cluster_dataset"]
    active [name: "idx_cluster_active"]
    (dataset_id, active) [name: "idx_cluster_dataset_active"]
    cyclic_recording_pattern_id [name: "idx_cluster_recording_pattern"]
    location_id [name: "idx_cluster_location_id"]
  }
}
Table "file" {
  "id" VARCHAR(21) [pk]
  "file_name" VARCHAR(255) [not null]
  "path" VARCHAR(255)
  "xxh64_hash" VARCHAR(16) [not null]
  "location_id" VARCHAR(12) [not null]
  "timestamp_local" TIMESTAMP [not null]
  "cluster_id" VARCHAR(12)
  "duration" DECIMAL(7,3) [not null]
  "sample_rate" INTEGER [not null]
  "description" VARCHAR(255)
  "upload" BOOLEAN [default: FALSE]
  "maybe_solar_night" BOOLEAN
  "maybe_civil_night" BOOLEAN
  "moon_phase" DECIMAL(3,2)
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  Indexes {
    location_id [name: "idx_file_location"]
    active [name: "idx_file_active"]
    timestamp_local [name: "idx_file_timestamp_local"]
    cluster_id [name: "idx_file_cluster"]
    maybe_solar_night [name: "idx_file_maybe_solar_night"]
    maybe_civil_night [name: "idx_file_maybe_civil_night"]
  }
}
Table "moth_metadata" {
  "file_id" VARCHAR(21) [pk]
  "timestamp" TIMESTAMP [not null]
  "recorder_id" VARCHAR(16)
  "gain" gain_level
  "battery_v" DECIMAL(2,1)
  "temp_c" DECIMAL(3,1)
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
}
Table "file_metadata" {
  "file_id" VARCHAR(21) [pk]
  "json" JSONB
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  Indexes {
    json [type: gin, name: "idx_file_metadata_json"]
  }
}
Table "file_dataset" {
  "file_id" VARCHAR(21) [not null]
  "dataset_id" VARCHAR(12) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  Indexes {
    (file_id, dataset_id) [pk]
    file_id [name: "idx_file_dataset_file"]
    dataset_id [name: "idx_file_dataset_dataset"]
  }
}
Table "selection" {
  "id" VARCHAR(21) [pk]
  "file_id" VARCHAR(21) [not null]
  "dataset_id" VARCHAR(12) [not null]
  "start_time" DECIMAL(7,3) [not null]
  "end_time" DECIMAL(7,3) [not null]
  "freq_low" DECIMAL(9,3)
  "freq_high" DECIMAL(9,3)
  "description" VARCHAR(255)
  "upload" BOOLEAN [default: FALSE]
  "approved" BOOLEAN [default: FALSE]
  "is_solar_night" BOOLEAN
  "is_civil_night" BOOLEAN
  "moon_phase" DECIMAL(3,2)
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  Indexes {
    file_id [name: "idx_selection_file"]
    dataset_id [name: "idx_selection_dataset"]
    active [name: "idx_selection_active"]
    approved [name: "idx_selection_approved"]
    is_solar_night [name: "idx_selection_is_solar_night"]
    is_civil_night [name: "idx_selection_is_civil_night"]
    moon_phase [name: "idx_selection_moon_phase"]
  }
}
Table "selection_metadata" {
  "selection_id" VARCHAR(21) [pk]
  "json" JSONB
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  Indexes {
    json [type: gin, name: "idx_selection_metadata_json"]
  }
}
Table "ebird_taxonomy" {
  "id" VARCHAR(12) [pk]
  "taxonomy_version" VARCHAR(4) [not null]
  "taxon_order" INTEGER [not null]
  "category" VARCHAR(15) [not null]
  "species_code" VARCHAR(15) [not null]
  "taxon_concept_id" VARCHAR(15)
  "primary_com_name" VARCHAR(100) [not null]
  "sci_name" VARCHAR(100) [not null]
  "bird_order" VARCHAR(30)
  "family" VARCHAR(100)
  "species_group" VARCHAR(100)
  "report_as" VARCHAR(15)
  "valid_from" DATE [not null]
  "valid_to" DATE
  Indexes {
    (species_code, taxonomy_version) [unique]
  }
}
Table "species" {
  "id" VARCHAR(12) [pk]
  "label" VARCHAR(100) [not null]
  "ebird_code" VARCHAR(12)
  "taxonomy_version" VARCHAR(4)
  "description" VARCHAR(255)
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  "owner" VARCHAR(64) [not null]
  Indexes {
    label [name: "idx_species_label"]
    ebird_code [name: "idx_species_ebird"]
  }
}
Table "call_type" {
  "id" VARCHAR(12) [pk]
  "species_id" VARCHAR(12) [not null]
  "label" VARCHAR(100) [not null]
  "created_by" VARCHAR(64) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  Indexes {
    species_id [name: "idx_call_type_species"]
    label [name: "idx_call_type_label"]
  }
}
Table "filter" {
  "id" VARCHAR(12) [pk]
  "name" VARCHAR(140) [not null]
  "description" VARCHAR(255)
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "owner" VARCHAR(64) [not null]
  "active" BOOLEAN [not null, default: true]
}
Table "label" {
  "id" VARCHAR(21) [pk]
  "selection_id" VARCHAR(21) [not null]
  "species_id" VARCHAR(12) [not null]
  "filter_id" VARCHAR(12)
  "certainty" DECIMAL(5,2)
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [not null, default: true]
  Indexes {
    selection_id [name: "idx_label_selection_id"]
    species_id [name: "idx_label_species_id"]
  }
}
Table "label_subtype" {
  "id" VARCHAR(21) [pk]
  "label_id" VARCHAR(21) [not null]
  "calltype_id" VARCHAR(12) [not null]
  "filter_id" VARCHAR(12)
  "certainty" DECIMAL(5,2)
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [not null, default: true]
}
Table "file_size" {
  "file_id" VARCHAR(21) [pk]
  "file_size" BIGINT [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  Indexes {
    file_id [name: "idx_file_size_file"]
  }
}
Table "species_dataset" {
  "species_id" VARCHAR(12) [not null]
  "dataset_id" VARCHAR(12) [not null]
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  Indexes {
    (species_id, dataset_id) [pk]
    species_id [name: "idx_species_dataset_species"]
    dataset_id [name: "idx_species_dataset_dataset"]
  }
}
Table "access_grant" {
  "id" VARCHAR(12) [pk]
  "dataset_id" VARCHAR(12) [not null]
  "role" role_name [not null]
  "permission" permission_name [not null]
  "user_id" VARCHAR(64)
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  "active" BOOLEAN [default: TRUE]
  Indexes {
    (dataset_id, role, permission, user_id) [unique, name: "unique_access_grant"]
    (dataset_id, role, permission) [unique, name: "idx_unique_role_permission"]
    dataset_id [name: "idx_access_grant_dataset"]
    role [name: "idx_access_grant_role"]
    permission [name: "idx_access_grant_permission"]
    user_id [name: "idx_access_grant_user"]
    active [name: "idx_access_grant_active"]
  }
}
Table "user_role" {
  "user_id" VARCHAR(64) [pk]
  "role" role_name [not null, default: 'USER']
  "created_at" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "created_by" VARCHAR(64) [not null]
  "last_modified" TIMESTAMP [default: `CURRENT_TIMESTAMP`]
  "modified_by" VARCHAR(64) [not null]
  Indexes {
    user_id [name: "idx_user_role"]
  }
}
Ref:"dataset"."id" < "location"."dataset_id"
Ref:"dataset"."id" < "cluster"."dataset_id"
Ref:"location"."id" < "cluster"."location_id"
Ref:"cyclic_recording_pattern"."id" < "cluster"."cyclic_recording_pattern_id"
Ref:"location"."id" < "file"."location_id"
Ref:"cluster"."id" < "file"."cluster_id"
Ref:"file"."id" < "moth_metadata"."file_id"
Ref:"file"."id" < "file_metadata"."file_id"
Ref:"file"."id" < "file_dataset"."file_id"
Ref:"dataset"."id" < "file_dataset"."dataset_id"
Ref:"file"."id" < "selection"."file_id"
Ref:"dataset"."id" < "selection"."dataset_id"
Ref:"selection"."id" < "selection_metadata"."selection_id"
Ref:"ebird_taxonomy".("species_code", "taxonomy_version") < "species".("ebird_code", "taxonomy_version")
Ref:"species"."id" < "call_type"."species_id"
Ref:"selection"."id" < "label"."selection_id"
Ref:"species"."id" < "label"."species_id"
Ref:"filter"."id" < "label"."filter_id"
Ref:"label"."id" < "label_subtype"."label_id"
Ref:"call_type"."id" < "label_subtype"."calltype_id"
Ref:"filter"."id" < "label_subtype"."filter_id"
Ref:"file"."id" < "file_size"."file_id"
Ref "fk_selection_file_dataset":"file_dataset".("file_id", "dataset_id") < "selection".("file_id", "dataset_id")
Ref:"species"."id" < "species_dataset"."species_id"
Ref:"dataset"."id" < "species_dataset"."dataset_id"
Ref:"dataset"."id" < "access_grant"."dataset_id"

Replacement in component-flow.mmd at line 1 [11.1]

B:BD[11.1] → [2.65:124]

∅:D[2.124] → [11.59:273]

B:BD[11.59] → [11.59:273]

// Skraak Component Flow Diagram at Saturday 25th May 2025
// To render this diagram, copy the contents and paste into the Mermaid playground:
// https://www.mermaidchart.com/play
//
// This diagram visualizes the component hierarchy and API flow in the React application.

[11.1]

[11.273]

%% Skraak Component Flow Diagram - Updated 1 June 2025
%% To render this diagram:
%% mmdc -i component-flow.mmd -o component-flow.svg
%% 
%% This diagram visualizes the component hierarchy and API flow in the React application.

Replacement in component-flow.mmd at line 8 [11.1]

B:BD[11.283] → [11.283:348]

    App["App"] --> KindeProvider["KindeProvider (Auth Context)"]

[11.283]

[11.348]

    App["App.tsx"] --> KindeProvider["KindeProvider (Auth Context)"]

Replacement in component-flow.mmd at line 10 [11.1]

B:BD[11.401] → [11.401:462]

    KindeProvider --> AuthorisedContent["AuthorisedContent"]

[11.401]

[11.462]

    KindeProvider --> AuthorisedContent["AuthorisedContent
    (Navigation Hub)"]

Replacement in component-flow.mmd at line 15 [11.1]

B:BD[11.546] → [11.546:656]

    PC_Auth -- "No" --> Authenticate["Authenticate"]
    PC_Auth -- "Yes" --> NoPublicContent["(No Content)"]

[11.546]

[11.656]

    PC_Auth -- "No" --> Authenticate["Authenticate
    (Login/Register)"]
    PC_Auth -- "Yes" --> NoPublicContent["(Hidden)"]

Replacement in component-flow.mmd at line 21 [11.1]

B:BD[11.748] → [11.748:808]

    AC_Auth -- "No" --> NoAuthorisedContent["(No Content)"]

[11.748]

[11.808]

    AC_Auth -- "No" --> NoAuthorisedContent["(Hidden)"]

Replacement in component-flow.mmd at line 24 [11.1]

B:BD[11.871] → [11.871:959]

    AC_Content --> UserProfile["UserProfile"]
    AC_Content --> AC_View{"activeView?"}

[11.871]

[11.959]

    AC_Content --> UserProfile["UserProfile
    (User info + logout)"]
    AC_Content --> AC_View{"activeView state?"}

Replacement in component-flow.mmd at line 30 [11.1]

B:BD[11.1034] → [11.1034:1080]

    API: /api/datasets
    (fetch datasets)"]

[11.1034]

[11.1080]

    API: GET /api/datasets
    API: POST /api/datasets (create)
    API: PUT /api/datasets/{id} (update)"]

Replacement in component-flow.mmd at line 34 [11.1]
B:BD[11.1085] → [11.1085:1105]
```
    %% Dataset view
```
[11.1085]
[11.1105]
```
    %% Dataset view with tabs
```

Replacement in component-flow.mmd at line 36 [11.1]

B:BD[11.1151] → [11.1151:1410]

    (Tabs component)"]
    Dataset --> DatasetTabs["Tabs"]
    DatasetTabs --> Locations["Locations
    API: /api/locations?datasetId={id}
    (fetch locations)"]
    DatasetTabs --> Species["Species
    API: /api/species?datasetId={id}
    (fetch species)"]

[11.1151]

[11.1410]

    (Tab container)"]
    Dataset --> DatasetTabs["Tabs Navigation"]
    DatasetTabs --> Locations["Locations Tab
    API: GET /api/locations?datasetId={id}&page={n}
    API: POST /api/locations (create)
    API: PUT /api/locations/{id} (update)"]
    DatasetTabs --> Species["Species Tab
    API: GET /api/species?datasetId={id}
    API: POST /api/species (create)
    API: PUT /api/species/{id} (update)"]

Insertion in component-flow.mmd at line 47 [11.1]

[11.1415]

    %% Species management
    Species --> EbirdSearch["EbirdSearch
    (eBird integration - placeholder)"]

Replacement in component-flow.mmd at line 53 [11.1]

B:BD[11.1485] → [11.1485:1547]

    API: /api/clusters?locationId={id}
    (fetch clusters)"]

[11.1485]

[11.1547]

    API: GET /api/clusters?locationId={id}
    API: POST /api/clusters (create)
    API: PUT /api/clusters/{id} (update)
    API: DELETE /api/clusters/{id}"]

Replacement in component-flow.mmd at line 58 [11.1]
B:BD[11.1552] → [11.1552:1572]
```
    %% Cluster view
```
[11.1552]
[11.1572]
```
    %% Cluster view (file listing)
```

Replacement in component-flow.mmd at line 60 [11.1]

B:BD[11.1627] → [11.1627:1750]

    API: /api/files?clusterId={id}
    (fetch files)
    API: /api/species?datasetId={id}
    (fetch species for filter)"]

[11.1627]

[11.1750]

    (File browser with filters)
    API: GET /api/files?clusterId={id}&filters...
    API: GET /api/species?datasetId={id}
    API: GET /api/datasets/{id}"]

Replacement in component-flow.mmd at line 65 [11.1]
B:BD[11.1755] → [2.125:147]
```
    %% Selection view
```
[11.1755]
[2.147]
```
    %% Selection view (species-filtered files)
```

Replacement in component-flow.mmd at line 67 [11.1]

B:BD[2.200] → [2.200:254]

∅:D[2.254] → [11.1888:1958]

B:BD[11.1888] → [11.1888:1958]

    API: /api/selection?datasetId={id}&speciesId={id}
    API: /api/species?datasetId={id}
    (fetch species for filter)"]

[2.200]

[11.1958]

    (Species-filtered files)
    API: GET /api/selection?datasetId={id}&speciesId={id}&filters...
    API: GET /api/species?datasetId={id}"]
    
    %% File modal (shared by Cluster and Selection)
    ClusterComponent --> FileModal["File Modal
    API: GET /api/files/{id}/download
    API: GET /api/files/{id}/selections
    API: GET /api/files/{id}/context"]
    Selection --> FileModal

Replacement in component-flow.mmd at line 78 [11.1]

B:BD[11.1963] → [11.1963:2047]

    %% User interactions
    Datasets -- "onDatasetSelect(id, name)" --> AC_Content

[11.1963]

[11.2047]

    %% Navigation callbacks
    Datasets -- "onDatasetSelect(id, name, permissions)" --> AC_Content

Replacement in component-flow.mmd at line 84 [11.1]

B:BD[11.2230] → [11.2230:2257]

    %% Authentication flow

[11.2230]

[11.2257]

    %% Breadcrumb navigation
    AC_Content --> Breadcrumbs["Breadcrumb Navigation
    (Dataset > Location > Cluster)"]
    
    %% Authentication context usage

Insertion in component-flow.mmd at line 98 [11.1]

[2.307]

    FileModal -. "useKindeAuth()" .-> KindeProvider
    
    %% API Routes Available (Worker Backend)
    subgraph "API Routes (Hono Worker)"
        API_Health["/api - Health check"]
        API_Datasets["/api/datasets - CRUD + permissions"]
        API_Locations["/api/locations - CRUD + pagination"]
        API_Clusters["/api/clusters - CRUD + recording patterns"]
        API_Files["/api/files - File listing + download + selections + context"]
        API_Species["/api/species - CRUD + call types"]
        API_CallTypes["/api/call-types - Management (placeholder)"]
        API_Ebird["/api/ebird - eBird integration (placeholder)"]
        API_Selection["/api/selection - Species-filtered files"]
    end
    
    %% Key Features
    subgraph "Key Features"
        Features_Auth["Role-based permissions (USER/CURATOR/ADMIN)"]
        Features_Pagination["Pagination support"]
        Features_Filters["Time/Species filtering"]
        Features_Audio["Audio player with waveform/spectrogram"]
        Features_B2["Backblaze B2 file storage"]
        Features_Metadata["File metadata + Moth recorder data"]
    end