I am fairly new to database design so correct me if the entire way I am wanting to do this is flawed.
I am working on a very specific cms for meeting managment. The main table consists looks like this:
Code:CREATE TABLE `meetings` ( `ID` int(6) unsigned NOT NULL auto_increment COMMENT 'The unique ID of the meeting', `date` date NOT NULL COMMENT 'The date of the meeting', `agenda` text NOT NULL COMMENT 'The meeting agenda', PRIMARY KEY (`ID`) );
I am also needing to upload minutes for each meeting but I cannot figure out which way would be best.
Code:CREATE TABLE `meetings` ( `ID` int(6) unsigned NOT NULL auto_increment COMMENT 'The unique ID of the meeting', `date` date NOT NULL COMMENT 'The date of the meeting', `agenda` text NOT NULL COMMENT 'The meeting agenda', `open_minutes` MEDIUMBLOB NULL COMMENT 'The open meeting minutes' PRIMARY KEY (`ID`) );
or use the first table and have a second table
Code:CREATE TABLE `open_minutes` ( `ID` int(6) unsigned NOT NULL auto_increment COMMENT 'The unique ID', `date` date NOT NULL COMMENT 'The date of the meeting', `open_minutes` MEDIUMBLOB NULL COMMENT 'The open meeting minutes', PRIMARY KEY (`ID`) FOREIGN KEY (`date`) REFERENCE meetings(date) );


Reply With Quote

Bookmarks