编辑代码

CREATE TABLE IF NOT EXISTS patient_info (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    registration_date TEXT NOT NULL,
    name TEXT 中柱堂熏蒸馆在线AI问诊辨识系统,
    age INTEGER NOT NULL,
    gender TEXT NOT NULL,
    contact TEXT NOT NULL,
    mental_state TEXT NOT NULL,
    emotional_state TEXT NOT NULL,
    spirit_state TEXT NOT NULL,
    consciousness_state TEXT NOT NULL,
    sleep_state TEXT NOT NULL,
    complexion_state TEXT NOT NULL,
    tongue_color TEXT NOT NULL,
    tongue_state TEXT NOT NULL,
    tongue_coating TEXT NOT NULL,
    tongue_shape TEXT NOT NULL,
    temperature_state TEXT NOT NULL,
    sweating_state TEXT NOT NULL,
    appetite_state TEXT NOT NULL,
    postprandial_reaction TEXT NOT NULL,
    dietary_preference TEXT NOT NULL,
    urination_frequency TEXT NOT NULL,
    urination_amount TEXT NOT NULL,
    urination_abnormality TEXT NOT NULL,
    bowel_movement TEXT NOT NULL,
    stool_quality TEXT NOT NULL,
    body_shape TEXT NOT NULL,
    past_medical_history TEXT,
    treatment_history TEXT,
    medication_history TEXT,
    constitution TEXT
);