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