db_percetakan

/*
MySQL Data Transfer
Source Host: localhost
Source Database: percetakan
Target Host: localhost
Target Database: percetakan
Date: 7/9/2013 8:58:35 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bayar
-- ----------------------------
CREATE TABLE `bayar` (
  `kd_trans` varchar(11) NOT NULL,
  `kd_order` varchar(11) DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `bayar` double(15,0) DEFAULT NULL,
  `kembali` double(15,0) DEFAULT NULL,
  PRIMARY KEY (`kd_trans`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for order
-- ----------------------------
CREATE TABLE `order` (
  `kd_order` varchar(11) NOT NULL,
  `kd_pelanggan` varchar(11) DEFAULT NULL,
  `nama_pelanggan` varchar(50) DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `ukuran` varchar(5) DEFAULT NULL,
  `harga` double(15,0) DEFAULT NULL,
  `status` enum('N','Y') DEFAULT 'N',
  `kd_pegawai` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`kd_order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for pegawai
-- ----------------------------
CREATE TABLE `pegawai` (
  `kd_pegawai` varchar(11) NOT NULL,
  `nama_pegawai` varchar(50) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `jabatan` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`kd_pegawai`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for pelanggan
-- ----------------------------
CREATE TABLE `pelanggan` (
  `kd_pelanggan` varchar(10) NOT NULL,
  `nama_pelanggan` varchar(50) DEFAULT NULL,
  `alamat` varchar(50) DEFAULT NULL,
  `hp` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`kd_pelanggan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for user
-- ----------------------------
CREATE TABLE `user` (
  `nama_pengguna` varchar(25) DEFAULT NULL,
  `login` varchar(25) NOT NULL,
  `password` varchar(25) NOT NULL,
  PRIMARY KEY (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------