根据用户输入的需求,以下是创建表的SQL语句:

sql
-- 会员主档表
CREATE TABLE m_member (
  id BIGINT PRIMARY KEY,
  tenant_id BIGINT NOT NULL,
  unique_account_id VARCHAR(255) NOT NULL,
  status INT NOT NULL,
  unique_identifier_key VARCHAR(255),
  unique_identifier VARCHAR(255),
  ext_json TEXT,
  clubs TEXT,
  channel VARCHAR(255)
);

--俱乐部会员表
CREATE TABLE club_member_do (
  id BIGINT PRIMARY KEY,
  tenant_id BIGINT NOT NULL,
  club_id BIGINT NOT NULL, 
unique_account_id VARCHAR(255) NOT NULL, 
member_no VARCHAR(255), 
level_num INT, 
level_expired_time DATETIME, 
nickname VARCHAR(255), 
channel VARCHAR (255),  
certificate_type VARCHAR (50),  
certificate_no VARCH AR (50 ),  
email VARCH AR (100),  
country_code VARCH AR (10 ),  
address LONGTEXT ,   
ext_json LONGTEXT ,   
status INT
);

--会员变动日志表
CREATE TABLE m_member_operation_log (
id BIGINT PRIMARY KEY ,
tenant_idB I G I NT N O TNULL ,
club_ i d B I GI NT N O TNULL ,
un ique_account_i dV A R C HAR (2S5 )N O TNU L L ,
operation_typeV A R C HAR (2S5 )N O TNU L L ,
remarkV A R C HAR (2S5 )
);

请注意,这些SQL语句基于给定的概念模型,并使用了适当的数据类型和约束来定义每个字段。