inflearn

Tables (4)

Class

  • id — INT — Primary key — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • classname — VARCHAR(50)
  • summary — VARCHAR(200) — NOT NULL
  • price — INT — NOT NULL
  • public — TINYINT
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • teacher_id — INT — Foreign key → Teacher.id — NOT NULL

Register

  • id — INT — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • student_id — INT — Foreign key → Student.id — NOT NULL
  • class_id — INT — Foreign key → Class.id — NOT NULL

Student

  • id — INT — Primary key — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • email — VARCHAR(50) — Unique Key
  • nickname — VARCHAR(20) — NOT NULL

Teacher

  • id — INT — Primary key — NOT NULL
  • teacher_name — VARCHAR(20) — NOT NULL