AI Interpreter

Tables (10)

Company

  • id (Key2) — uuid — Foreign key → User.id — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • address1 — VARCHAR(255)
  • address2 — VARCHAR(255)
  • phone — VARCHAR(20)
  • description — TEXT
  • website — VARCHAR(50)
  • email — VARCHAR(50)
  • created_at — TIMESTAMP
  • created_by — uuid
  • updated_at — TIMESTAMP
  • updated_by — uuid

Lecture

  • project_id (Key) — uuid — Primary key — NOT NULL
  • id (Key2) — uuid — Foreign key → Project.id — NOT NULL
  • start_date — TIMESTAMP — NOT NULL
  • end_date — TIMESTAMP — NOT NULL
  • speaker_id — uuid — NOT NULL
  • pm_url — TEXT
  • audience_url — TEXT
  • created_at — TIMESTAMP
  • created_by — uuid
  • updated_at — TIMESTAMP
  • updated_by — uuid
  • presentation_file — TEXT
  • rehearsal_start_date — TIMESTAMP
  • rehearsal_end_date — TIMESTAMP
  • translation_profile — TEXT[]
  • stt_type — VARCHAR(50)
  • tts_type — VARCHAR(50)
  • source_lang — VARCHAR(10)
  • target_lang — TEXT[]

LectureLog

  • id (Key2) — uuid — Foreign key → Lecture.id — NOT NULL
  • lecture_id — uuid — NOT NULL
  • stt_time — FLOAT
  • tts_time — FLOAT
  • count_translated — INT
  • number_audience — INT
  • created_at — TIMESTAMP
  • created_by — uuid
  • number_speaker — INT
  • Field

Metadata (Untitled)

  • id (Key) — Primary key — NOT NULL
  • service_type — ENUM(TRANSLATION/STT/TTS)
  • service_provider — ENUM(SYSTRANS/DAGLO/GOOGLE)
  • service_key — TEXT
  • service_url — TEXT
  • tts_type — ENUM (M/F)
  • service_email — TEXT
  • service_encoding — TEXT
  • service_sample_rate — TEXT
  • service_project_id — TEXT
  • Field

Project

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Key2) — uuid — Foreign key → User.id — NOT NULL
  • project_name — VARCHAR(255)
  • description — TEXT
  • created_at — TIMESTAMP
  • created_by — uuid
  • updated_at — TIMESTAMP
  • updated_by — uuid

Role

  • id (Key) — uuid — Primary key — NOT NULL
  • role_name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • created_by — uuid
  • updated_at — TIMESTAMP
  • updated_by — uuid

TranslationProfile

  • id (Key) — Primary key — NOT NULL
  • stt_lang — VARCHAR(10) — NOT NULL
  • target_lang — VARCHAR(10) — NOT NULL
  • profile_name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • created_by — uuid
  • updated_at — TIMESTAMP
  • updated_by — uuid

User

  • id (Key) — uuid — Primary key — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(255)
  • fullname — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • company_id — uuid
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(255)
  • phonenumber — VARCHAR(20)

User_Roles

  • role_id (Key) — uuid — Foreign key → Role.id — NOT NULL
  • user_id (Key2) — uuid — Foreign key → User.id — NOT NULL
  • created_at — TIMESTAMP
  • created_by — uuid
  • updated_at — TIMESTAMP
  • updated_by — uuid

lecture_translation_profile

  • lecture_id (Key2) — uuid — Foreign key → Lecture.id — NOT NULL
  • translation_profile_id (Key) — Foreign key → TranslationProfile.id — NOT NULL