CTEC
Tables (7)
Admin (Untitled4)
- admin_id (Key) — Primary key — NOT NULL
- name (Field)
- phone_num (Field2)
- company (Field3)
- email (Field4)
- created_at (Field5)
- updated_at (Field6)
Advisor (Untitled7)
- user_id (Key) — Primary key — NOT NULL
- admin_id (Field2)
Noti (Untitled6)
- admin_id (Field)
- title (Field5)
- content (Field2)
- created_at (Field3)
- updated_at (Field4)
QnA (Untitled5)
- question_id (Key) — Primary key — NOT NULL
- question (Field)
- answer (Field2)
- admin_id (Field3)
- user_id (Field4)
- created_at (Field5)
- updated_at (Field6)
User (Untitled)
- user_id (Key) — Primary key — NOT NULL
- name (Field) — varchar(30)
- phone_num (Field2) — varchar(20)
- lang (Field3) — varchar(20)
- company (Field4) — varchar(30)
- email (Field6) — @
- created_at (Field7) — DateTime
- updated_at (Field8) — DateTime
Video (Untitled2)
- video (Key) — Primary key — NOT NULL
- lang (Key2) — Primary key — NOT NULL
- video description (Field)
- quiz script (Field3)
- quiz ans (Field4)
- created_at (Field5)
- updated_at (Field6)
take (Untitled3)
- user_id (Key) — Primary key — NOT NULL
- date (Field)
- video (Field2)
- take (Field3)