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)
|
);
|
