Translately DB ERD
Tables (3)
Subtitle File (subtitle)
- Sub Key (sub_key) — INT — Primary key — NOT NULL
- User Key (pk) — INT — Foreign key → Userinfo.User Key — NOT NULL
- Thumbnail (T_nail) — TEXT
- Subtitle File (sub_file) — TEXT
- Youtube URL (u_url) — VARCHAR(255)
- Video Name (video_name) — VARCHAR(100)
Subtitle Q (subtitle_q)
- PK (Key) — INT — Primary key — NOT NULL
- Sub Key (sub_key) — INT — Foreign key → Subtitle File.Sub Key — NOT NULL
- User Key (pk) — INT — Foreign key → Subtitle File.User Key — NOT NULL
- Start Sub (start_sub) — TEXT
- Target Sub (target_sub) — TEXT
- Start Time (start_time) — INT
- End Time (end_time) — INT
Userinfo (userinfo)
- User Key (pk) — INT — Primary key — NOT NULL
- Email(User ID) (email) — VARCHAR(20)
- Username (name) — VARCHAR(20)
- Password (password) — VARCHAR(20)
- Available Time (AT) — INT
- Created Time (created_at) — DATETIME
- Updated Time (updated_at) — DATETIME