DataPotal
Tables (7)
ANALYSIS (analysis)
- ID (analysis_id) — INT — Primary key — NOT NULL
- START (start_date) — DATETIME
- END (end_date) — DATETIME
- LOCATION (location) — TEXT
- ID (data_id) — INT — Foreign key → DATA.ID — NOT NULL
CATEGORY (category)
- ID (category_id) — INT — Primary key — NOT NULL
- NAME (name) — VARCHAR(255) — NOT NULL — UNIQUE
- DESCRIPTION (description) — TEXT
DATA (data)
- ID (data_id) — INT — Primary key — NOT NULL
- TITLE (title) — TEXT — NOT NULL
- DESCRIPTION (description) — TEXT
- LOCATION (location) — TEXT
- START (start_date) — DATETIME
- END (end_date) — DATETIME
- CREATE (created_at) — DATETIME — NOT NULL
- VIEW (view_count) — INT — NOT NULL
- ID (category_id) — INT — Foreign key → CATEGORY.ID — NOT NULL
Untitled (environment)
- Key — Primary key — NOT NULL
- Field
Untitled (disease)
- Key — Primary key — NOT NULL
- Field
Untitled (climate)
- Key — Primary key — NOT NULL
- Field
VIEW (view)
- ID (log_id) — INT — Primary key — NOT NULL
- VIEW (views_at) — DATETIME — NOT NULL
- SESSION (session_id) — VARCHAR(36) — NOT NULL
- ID (data_id) — INT — Foreign key → DATA.ID — NOT NULL