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)