labeleling-erd

Tables (6)

audio_file (Untitled)

  • Key — BIGINT — Primary key — NOT NULL
  • Field — VARCHAR(200)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — INT
  • Field5 — BIGINT
  • Field6 — VARCHAR(20)
  • Field7 — TIMESTAMP
  • Key (Key2) — BIGINT NULL — Foreign key → users.Key — NOT NULL

audio_segment (Untitled4)

  • Key — BIGINT — Primary key — NOT NULL
  • Field — INT
  • Field2 — INT
  • Field3 — TIMESTAMP
  • Key (Key2) — BIGINT — Foreign key → audio_file.Key — NOT NULL

task_review (Untitled6)

  • Key — BIGINT — Primary key — NOT NULL
  • Field — TEXT
  • Field2 — TIMESTAMP
  • Field3 — VARCHAR
  • Field4 — VARCHAR(20)
  • Key (Key2) — BIGINT — Foreign key → transcribe_task.Key — NOT NULL
  • Key (Key3) — BIGINT — Foreign key → users.Key — NOT NULL

transcribe_label_result (Untitled5)

  • Key — BIGINT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — TEXT
  • Field3 — TIMESTAMP
  • Key (Key2) — BIGINT — Foreign key → transcribe_task.Key — NOT NULL
  • Key (Key4) — BIGINT — Foreign key → users.Key — NOT NULL
  • Key (Key3) — BIGINT — Foreign key → audio_segment.Key — NOT NULL

transcribe_task (Untitled3)

  • Key — BIGINT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR
  • Field3 — VARCHAR(20)
  • Field4 — TIMESTAMP
  • Field5 — TEXT
  • Key (Key2) — BIGINT — Foreign key → audio_file.Key — NOT NULL

users (Untitled2)

  • Key — BIGINT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR
  • Field3 — VARCHAR
  • Field4 — VARCHAR
  • Field5 — TIMESTAMP
  • Field6 — TIMESTAMP
  • Field7 — TIMESTAMP
  • Field8 — TIMESTAMP
  • Field9 — TEXT