2-1-2数据库表搭建

CREATE TABLE {DETAIL_TABLE} ( detail_id INT PRIMARY KEY AUTO_INCREMENT COMMENT '明细ID', main_id INT NOT NULL COMMENT '关联主表ID', chart_type VARCHAR(50) COMMENT '榜单类型', chart_rank INT COMMENT '榜单排名', season VARCHAR(50) COMMENT '发布时间/季度', marketing_fee DECIMAL(10,2) DEFAULT 0.00 COMMENT '营销费用', FOREIGN KEY (main_id) REFERENCES {MAIN_TABLE}(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '音乐榜单明细表';

创建表格后就可以正常插入数据了