CREATE TABLE fb_modules (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(124) NOT NULL,
remarks VARCHAR(125) NOT NULL,
config JSON,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
INSERT INTO fb_modules (name, remarks, config)
VALUES ("Registration Form Builder", "This builder is to manage reg form buildesr", '{}');
CREATE TABLE fb_fields (
id INT AUTO_INCREMENT PRIMARY KEY,
fb_modules_id INT,
name VARCHAR(125) NOT NULL,
status BOOLEAN DEFAULT FALSE,
type VARCHAR(125) NOT NULL, -- set this as enum <<< better.
label VARCHAR(125) NOT NULL,
is_mandatory BOOLEAN DEFAULT FALSE,
config JSON,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (fb_modules_id) REFERENCES fb_modules(id)
);