< prev

Page 1Page 2Page 3Page 4Page 5Page 6Page 7Page 8Page 9Page 10Page 11Page 12

Page 10 of 12
next >

Majalah Ilmiah UNIKOM

Vol.14 No. 1

138

H a l a m a n

Doni Romdoni Kusnadi, Novrini Hasti

Implementasi Tabel user

CREATE TABLE IF NOT EXISTS `user` (

`iduser` int(20) NOT NULL AUTO_INCREMENT,

`namauser` varchar(20) NOT NULL, `password` varchar(50) NOT NULL,

`level` varchar(20) NOT NULL, PRIMARY KEY (`iduser`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Implementasi Tabel konsumen

CREATE TABLE IF NOT EXISTS `konsumen` (

`idkonsumen` int(20) NOT NULL AUTO_INCREMENT,

`namakonsumen` varchar(20) NOT NULL, `nohpkonsumen` varchar(20) NOT NULL,

`emailkonsumen` varchar(30) NOT NULL, `password` varchar(50) NOT NULL,

`statuskonsumen` int(2) NOT NULL, PRIMARY KEY (`idkonsumen`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

Implementasi Tabel reservasi

CREATE TABLE IF NOT EXISTS `reservasi` (

`idreservasi` int(10) NOT NULL AUTO_INCREMENT,

`nama` varchar(20) NOT NULL, `nohp` varchar(30) NOT NULL,

`tgl` date NOT NULL, `jam` time NOT NULL, `nomeja` int(10) NOT NULL,

`status` varchar(20) NOT NULL, `iduser` varchar(20) NOT NULL,

PRIMARY KEY (`idreservasi`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;

Implementasi Tabel orders

CREATE TABLE IF NOT EXISTS `orders` (

`idorders` int(10) NOT NULL AUTO_INCREMENT, `idreservasi` int(10) NOT NULL, `total`

int(20) NOT NULL, PRIMARY KEY (`idorders`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ;

Implementasi Tabel detail

CREATE TABLE IF NOT EXISTS `detail` (

`no` int(20) NOT NULL AUTO_INCREMENT,

`idorders` int(10) NOT NULL, `idmenu` varchar(10) NOT NULL,

`qty` int(10) NOT NULL, `subtotal` int(20) NOT NULL,

PRIMARY KEY (`no`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

Implementasi Tabel pembayaran

CREATE TABLE IF NOT EXISTS `pembayaran` (

`idtransaksi` int(10) NOT NULL AUTO_INCREMENT,

`idreservasi` int(10) NOT NULL, `tglpembayaran` date NOT NULL,

`totalbayar` int(20) NOT NULL, `status` int(2) NOT NULL,

`idtransfer` varchar(30) NOT NULL, PRIMARY KEY (`idtransaksi`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;