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