lms

Tables (4)

members

  • id — INT — Primary key — NOT NULL
  • code — VARCHAR(50)
  • member_type — ENUM('teacher','organ','student','parent') — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • social_id — VARCHAR(255)
  • social_type — VARCHAR(50)
  • status — ENUM('active','inactive','banned') — NOT NULL
  • marketing_agree — TINYINT(1) — NOT NULL
  • last_login — DATETIME
  • created_at — DATETIME — NOT NULL

organs

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → members.id
  • code — VARCHAR(50)
  • name — VARCHAR(255) — NOT NULL
  • type — ENUM('school','academy','center')
  • contact_name — VARCHAR(100)
  • contact_phone — VARCHAR(20)
  • contact_email — VARCHAR(255)
  • ceo_name — VARCHAR(100)
  • ceo_phone — VARCHAR(20)
  • ceo_email — VARCHAR(255)
  • address — VARCHAR(255)
  • transport — TEXT
  • status — ENUM('active','inactive') — NOT NULL
  • channel — VARCHAR(100)
  • settlement — TEXT
  • doc_rules — TEXT

students

  • id — INT — Primary key — NOT NULL
  • parent_member_id — INT — Foreign key → members.id
  • member_id — INT — Foreign key → members.id
  • consent_required — TINYINT(1) — NOT NULL
  • consent_status — ENUM('unverified','verified') — NOT NULL
  • consent_method — ENUM('none','phone','name') — NOT NULL
  • consent_at — DATETIME
  • code — VARCHAR(50)
  • birth — DATE
  • age_label — VARCHAR(50)
  • gender — ENUM('M','F')
  • status — ENUM('active','inactive') — NOT NULL
  • address — VARCHAR(255)
  • school_name — VARCHAR(255)
  • school_grade — VARCHAR(50)
  • parent1_name — VARCHAR(100)
  • parent1_relation — VARCHAR(50)
  • parent1_phone — VARCHAR(20)
  • parent2_name — VARCHAR(100)
  • parent2_relation — VARCHAR(50)
  • parent2_phone — VARCHAR(20)
  • marketing_agree — TINYINT(1) — NOT NULL

teachers

  • id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → members.id
  • code — VARCHAR(50)
  • birth — DATE
  • gender — ENUM('M','F')
  • address — VARCHAR(255)
  • transport — TEXT
  • intro — TEXT
  • grade_regular — ENUM('A','B','C')
  • grade_coding — ENUM('A','B','C')
  • fee_rate — DECIMAL(5,2)
  • fee_note — TEXT
  • regions — VARCHAR(255)
  • courses — VARCHAR(255)
  • schedule — JSON
  • app_date — DATE
  • call_time — VARCHAR(100)
  • status — ENUM('active','inactive') — NOT NULL