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