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