Pembuatan database

CREATE DATABASE perp25;
USE perp25;

CREATE TABLE admins (
    ID INT(10) PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL
);

CREATE TABLE kategori (
		ID_kat INT(15) AUTO_INCREMENT PRIMARY KEY,
		nama_kat VARCHAR(50) UNIQUE NOT NULL,
		kode_rak VARCHAR(20)
);

CREATE TABLE books (
		ID_book INT(15) PRIMARY KEY,
		ID_kat INT(15) NOT NULL,
		judul VARCHAR(100) NOT NULL,
		penulis VARCHAR(100),
		penerbit VARCHAR(100),
		stok INT(10) DEFAULT 0,
		FOREIGN KEY (ID_Kat) REFERENCES kategori(ID_kat) ON DELETE CASCADE
);

CREATE TABLE members (
		ID_member INT(15) PRIMARY KEY,
		nama VARCHAR(100) NOT NULL,
		nimornik VARCHAR(20) UNIQUE NOT NULL,
		jurusan VARCHAR(100),
		no_hp VARCHAR(20)
);

CREATE TABLE loans (
		ID_loan INT(15) PRIMARY KEY,
		ID_member INT(15) NOT NULL,
		ID_book INT(15) NOT NULL,
		tanggal_pinjam DATETIME DEFAULT CURRENT_TIMESTAMP,
		tanggal_tenggang DATE,
		tanggal_pengembalian DATE NULL,
		status ENUM('Diajukan','Dipinjam','Dikembalikan') DEFAULT 'Diajukan',
		FOREIGN KEY (ID_member) REFERENCES members(ID_member) ON DELETE CASCADE,
		FOREIGN KEY (ID_book) REFERENCES books(ID_book) ON DELETE CASCADE
);