CREATE TABLE WisdomBeanRecords ( record_id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, bean_num INT NOT NULL, description TEXT, status VARCHAR(20) NOT NULL, job_id INT, create_time DATETIME DEFAULT CURRENT_TIMESTAMP, update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES Users(user_id), FOREIGN KEY (job_id) REFERENCES Jobs(job_id) );