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