contoh penulisan syntax database

create database jaenuri;


create table jaenuri.buku (
kd_buku varchar(10)not null,
judul varchar(10)not null,
pengarang varchar(10)not null,
penerbit varchar(10) not null,
jumlah varchar(10)not null,
primary key(kd_buku)
)engine=innodb;

create table jaenuri.anggota (
kd_anggota varchar(10)not null,
nama varchar(10)not null,
no_telp varchar(10)not null,
alamat varchar(10) not null,
aktif varchar(10)not null,
tgl_bergabung date not null,
primary key(kd_anggota)
)engine=innodb;

create table jaenuri.login (
pasword varchar(10)not null,
username varchar(10)not null,
primary key(pasword)
)engine=innodb;

create table jaenuri.peminjaman (
id_pinjam varchar(10)not null,
kd_anggota varchar(10)not null,
tgl_pinjam varchar(10)not null,
tgl_hrskembali varchar(10) not null,
primary key(id_pinjam),
foreign key(kd_anggota)references jaenuri.anggota(kd_anggota)
)engine=innodb;

create table jaenuri.copy_buku (
kd_copy_buku varchar(10)not null,
kd_buku varchar(10)not null,
status varchar(10)not null,
jumlah varchar(10)not null,
primary key(kd_copy_buku),
foreign key(kd_buku)references
jaenuri.buku(kd_buku)
)engine=innodb;


create table jaenuri.detil_pinjam (
pinjaman varchar (20) not null,
id_pinjam varchar(10)not null,
kd_copy_buku varchar(10)not null,
status varchar(10)not null,
keterangan varchar(10)not null,
primary key(status),
foreign key(kd_copy_buku)references jaenuri.copy_buku(kd_copy_buku),
foreign key(id_pinjam)references jaenuri.peminjaman(id_pinjam)
)engine=innodb;

create table jaenuri.pengembalian (
id_kembali varchar(10)not null,
id_pinjam varchar(10)not null,
tgl_kembali date not null,
terlambat varchar(10) not null,
denda varchar(10)not null,
primary key(id_kembali),
foreign key(id_pinjam)references jaenuri.peminjaman(id_pinjam)
)engine=innodb;