CREATE TABLE broadband_card_request_types (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(255) UNIQUE
) ENGINE=InnoDB;

CREATE TABLE broadband_card_data_packages (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	gigabytes TINYINT NOT NULL,
	cost DECIMAL(5,2)
) ENGINE=InnoDB;

CREATE TABLE broadband_card_requests (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	request_id INT NOT NULL,
	request_type_id INT NOT NULL,
	current_number VARCHAR(10) DEFAULT NULL,
	data_id INT NOT NULL,
	approver_service_number INT NOT NULL,
	FOREIGN KEY fk_request_type (request_type_id) REFERENCES broadband_card_request_types (id),
	FOREIGN KEY fk_data_amount (data_id) REFERENCES broadband_card_data_packages (id),
	FOREIGN KEY fk_approver (approver_service_number) REFERENCES users (service_number)
) ENGINE=InnoDB;
