CTEC

Tables (10)

admin

  • admin_id — varchar(36) — Primary key — NOT NULL
  • user_id — varchar(36) — Foreign key → users.user_id — NOT NULL

advisor

  • user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
  • admin_id — varchar(36) — Foreign key → admin.admin_id — NOT NULL

company

  • company_id — int — Primary key — NOT NULL
  • company_name — varchar(255) — NOT NULL

dailyAssignedVideo

  • date — DATETIME — Primary key — NOT NULL
  • admin_id — varchar(36) — Foreign key → admin.admin_id — NOT NULL
  • video_id — int — NOT NULL

language

  • language_id — int — Primary key — NOT NULL
  • language_name — varchar(255) — NOT NULL

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • title — varchar(255)
  • content — text — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • admin_id — varchar(36) — Foreign key → admin.admin_id — NOT NULL

qna

  • question_id — BIGINT — Primary key — NOT NULL
  • user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
  • question — text — NOT NULL
  • answer — text
  • created_at — DATETIME — NOT NULL
  • updated_at — text — NOT NULL
  • admin_id — varchar(36) — Foreign key → admin.admin_id — NOT NULL

takes

  • user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
  • video_id — int — Foreign key → video.video_id — NOT NULL
  • language_id — int — Foreign key → video.language_id — NOT NULL
  • date — DATETIME — NOT NULL
  • take — boolean — NOT NULL

users

  • user_id — varchar(36) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • phone_num — varchar(10) — NOT NULL
  • language_id — int — Foreign key → language.language_id — NOT NULL
  • company_id — int — Foreign key → company.company_id — NOT NULL
  • email — varchar(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • role — int — NOT NULL — 0 = worker, 1 = admin

video

  • video_id — int — Primary key — NOT NULL
  • language_id — int — Foreign key → language.language_id — NOT NULL
  • title — text
  • description — text
  • thumbnail_url — varchar(2048)
  • video_url — varchar(2048) — NOT NULL
  • quiz_script — text
  • quiz_ans — text
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL