CREATE TABLE IF NOT EXISTS mp_visitor (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    uuid VARCHAR(64) NOT NULL,
    version BIGINT NOT NULL DEFAULT 1,
    create_id BIGINT NULL,
    create_time DATETIME NULL,
    update_id BIGINT NULL,
    update_time DATETIME NULL,
    del_flag INT NOT NULL DEFAULT 0,
    mp_user_id BIGINT NOT NULL,
    visitor_name VARCHAR(30) NOT NULL,
    visitor_mobile VARCHAR(11) NOT NULL,
    visitor_company VARCHAR(128) NOT NULL,
    id_card_cipher VARCHAR(256) NOT NULL,
    gender VARCHAR(2) NOT NULL,
    UNIQUE KEY uk_mp_visitor_uuid (uuid),
    KEY idx_mp_visitor_user_del (mp_user_id, del_flag, id)
);