qlab

Tables (7)

datasets

  • id — SERIAL
  • project_id — INT — Foreign key → projects.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • content — JSONB — NOT NULL
  • uploader_id — INT — Foreign key → users.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

project_members

  • project_id — INT — Foreign key → projects.id
  • user_id — INT — Foreign key → users.id
  • joined_at — TIMESTAMP

projects

  • id — SERIAL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • owner_id — INT — Foreign key → users.id — NOT NULL
  • default_weights — JSONB — NOT NULL
  • created_at — TIMESTAMP

run_details

  • id — SERIAL
  • run_id — INT — Foreign key → runs.id — NOT NULL
  • row_index — INT — NOT NULL
  • user_input — TEXT — NOT NULL
  • reference — TEXT
  • retrieved_contexts — JSONB
  • model_outputs — JSONB
  • created_at — TIMESTAMP

run_results

  • id — SERIAL
  • run_id — INT — Foreign key → runs.id — NOT NULL
  • total_rows — INT
  • model_summaries — JSONB
  • created_at — TIMESTAMP

runs

  • id — SERIAL
  • project_id — INT — Foreign key → projects.id — NOT NULL
  • dataset_id — INT — Foreign key → datasets.id
  • executor_id — INT — Foreign key → users.id
  • name — VARCHAR(255) — NOT NULL
  • compare_models — JSONB
  • created_at — TIMESTAMP

users

  • id — SERIAL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • profile_image_url — TEXT
  • global_role — VARCHAR(20)
  • created_at — TIMESTAMP