WW3vYDAc

1USE `sekolah`;
2
3--
4-- Table structure for table `absensi`
5--
6
7DROP TABLE IF EXISTS `absensi`;
8/*!40101 SET @saved_cs_client     = @@character_set_client */;
9/*!40101 SET character_set_client = utf8 */;
10CREATE TABLE `absensi` (
11  `kode_absen` varchar(3) NOT NULL,
12  `NISN` varchar(10) NOT NULL,
13  `Kode_Semester` varchar(5) NOT NULL,
14  `jenis_absen` enum('Sakit','Izin','Alpha') DEFAULT NULL,
15  `tgl_absen` date NOT NULL,
16  KEY `NISN` (`NISN`),
17  KEY `Kode_Semester` (`Kode_Semester`),
18  CONSTRAINT `absensi_ibfk_1` FOREIGN KEY (`NISN`) REFERENCES `siswa` (`NISN`) ON DELETE CASCADE ON UPDATE CASCADE,
19  CONSTRAINT `absensi_ibfk_2` FOREIGN KEY (`Kode_Semester`) REFERENCES `semester` (`Kode_Semester`) ON DELETE CASCADE ON UPDATE CASCADE
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;