Informatik

CREATE TABLE `fund` (
  `snr` mediumint(9) NOT NULL,
  `pnr` mediumint(9) NOT NULL,
  PRIMARY KEY  (`snr`,`pnr`)
);

CREATE TABLE `person` (
  `pnr` mediumint(9) NOT NULL auto_increment,
  `vorname` varchar(25) default NULL,
  `name` varchar(25) NOT NULL,
  `tel` varchar(15) default NULL,
  `email` varchar(50) default NULL,
  PRIMARY KEY  (`pnr`)
);

CREATE TABLE `sache` (
  `snr` mediumint(9) NOT NULL auto_increment,
  `bezeichnung` varchar(50) NOT NULL,
  `fundort` varchar(50) default NULL,
  `datum` date default NULL,
  PRIMARY KEY  (`snr`)
);