个人名片唯一性验证

数据库

wiki

SQL

ALTER TABLE tb_company_personal_card
ADD `id_card` VARCHAR(18) NOT NULL DEFAULT '' COMMENT '审核通过的身份证' AFTER phone;
ALTER TABLE tb_company_personal_card
ADD INDEX `idx_phone` (`phone`),
ADD INDEX `idx_id_card` (`id_card`);