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)
);
dBforums
>
Inserting a File into a table
02-19-10, 10:44
Inserting a File into a table
Linear Mode
