Trebam pomoc za er model i relacioni model baze i opis tabela-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 19, 2011 at 01:08 AM
-- Server version: 4.1.9
-- PHP Version: 4.3.10
--
-- Database: `student`
--
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE `members` (
`member_id` int(11) unsigned NOT NULL auto_increment,
`firstname` varchar(100) default NULL,
`lastname` varchar(100) default NULL,
`login` varchar(100) NOT NULL default '',
`passwd` varchar(32) NOT NULL default '',
`priority` varchar(200) NOT NULL default '',
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` VALUES (1, 'igi', 'milj', 'admin', 'admin', 'admin');
INSERT INTO `members` VALUES (2, 'sekretar', 'skole', 'sekretar', 'sekretar', 'sekretar');
INSERT INTO `members` VALUES (4, 'igor', 'milj', 'igor', 'igor', 'student');
-- --------------------------------------------------------
--
-- Table structure for table `predmet`
--
CREATE TABLE `predmet` (
`id` tinyint(5) NOT NULL auto_increment,
`pred_id` tinyint(4) NOT NULL default '0',
`kolokvijum` tinyint(4) NOT NULL default '0',
`kolokvijum2` tinyint(5) NOT NULL default '0',
`ispit` tinyint(2) NOT NULL default '0',
`seminarski` text NOT NULL,
`seminarski_file` varchar(200) NOT NULL default '',
`polozio` tinyint(4) NOT NULL default '0',
`ocjena` tinyint(5) NOT NULL default '0',
`student_id` tinyint(4) NOT NULL default '0',
`prijavio` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `predmet`
--
INSERT INTO `predmet` VALUES (1, 1, 15, 15, 33, 'Tema: Test', 'sasas.doc', 1, 6, 1, 1);
INSERT INTO `predmet` VALUES (2, 2, 33, 33, 33, 'Tema: Test', 'saasa.doc', 1, 10, 1, 1);
INSERT INTO `predmet` VALUES (3, 3, 22, 1, 22, 'Tema: Test', 'tutor_login_icon.png', 1, 6, 2, 1);
INSERT INTO `predmet` VALUES (4, 4, 0, 0, 0, '', 'tutor_login_icon.png', 0, 0, 2, 1);
INSERT INTO `predmet` VALUES (7, 4, 11, 22, 33, 'asdasda', 'Iva.docx', 1, 10, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `predmet_info`
--
CREATE TABLE `predmet_info` (
`predmet_id` tinyint(5) NOT NULL auto_increment,
`smjer_id` tinyint(5) default NULL,
`predmet_ime` varchar(200) default NULL,
`godina_p` tinyint(5) NOT NULL default '0',
`profesor` varchar(200) default NULL,
PRIMARY KEY (`predmet_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `predmet_info`
--
INSERT INTO `predmet_info` VALUES (1, 1, 'predmet1', 1, 'profesor1');
INSERT INTO `predmet_info` VALUES (2, 2, 'predmet2', 1, 'profesor2');
INSERT INTO `predmet_info` VALUES (3, 2, 'predmet3', 2, 'profesor3');
INSERT INTO `predmet_info` VALUES (4, 2, 'predmet4', 3, 'profesor4');
INSERT INTO `predmet_info` VALUES (5, 2, 'predmet5', 2, 'profesor5');
-- --------------------------------------------------------
--
-- Table structure for table `student_info`
--
CREATE TABLE `student_info` (
`id` int(15) NOT NULL auto_increment,
`ime` varchar(100) NOT NULL default '0',
`prezime` varchar(100) NOT NULL default '0',
`ind` tinyint(5) NOT NULL default '0',
`tel` int(52) NOT NULL default '0',
`login` varchar(100) NOT NULL default '',
`passwd` varchar(100) NOT NULL default '',
`placeno` tinyint(3) NOT NULL default '0',
`smjer_id` tinyint(5) NOT NULL default '0',
`godina` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=48 ;
--
-- Dumping data for table `student_info`
--
INSERT INTO `student_info` VALUES (1, 'marko s', 'markovic11', 55, 2234234, 'sasa', 'sasa', 1, 2, 3);
INSERT INTO `student_info` VALUES (2, 'marko111', 'markovic 2', 56, 22342344, 'sasa1', 'sasa1', 0, 1, 1);
sasa
