ComponentVersion
ID | Component | Component Version | Release Date |
1 | Base | 1.0 | 2006-01-07 |
3 | Base | 1.1 | NULL |
CREATE TABLE component_version (
id INT NOT NULL AUTO_INCREMENT,
component_name VARCHAR(64) NOT NULL,
component_version VARCHAR(16) NOT NULL,
release_date date,
PRIMARY KEY (id),
UNIQUE KEY name_version (component_name, component_version)
) ENGINE=InnoDB;
DeveloperComponentVersion
Component Version ID | Developer Name |
1 | Derick |
3 | Sergey |
CREATE TABLE developer_component_version (
component_version_id INTEGER NOT NULL,
developer_name VARCHAR(64) NOT NULL,
PRIMARY KEY (component_version_id, developer_name)
) ENGINE=InnoDB;