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