根据用户输入的需求,以下是创建表的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语句基于给定的概念模型,并使用了适当的数据类型和约束来定义每个字段。