CREATE TABLE `bahan` (
`id_bahan` int(11) NOT NULL PRIMARY KEY,
`id_pengguna` int(11) NOT NULL,
`id_barang` int(11) NOT NULL,
`stok_awal` int(11) NOT NULL,
`jumlah` int(11) NOT NULL,
`stok_akhir` int(11) NOT NULL,
`tanggal` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `bahan`
ADD KEY `id_pengguna` (`id_pengguna`),
ADD KEY `id_barang` (`id_barang`);
CREATE TABLE `barang` (
`id_barang` int(11) NOT NULL PRIMARY KEY,
`kode_barang` varchar(50) NOT NULL,
`id_jenis` int(11) NOT NULL,
`id_satuan` int(11) NOT NULL,
`id_kategori` int(11) NOT NULL,
`nama_barang` varchar(100) NOT NULL,
`harga_barang` int(11) NOT NULL,
`ukuran` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `barang`
ADD KEY `id_jenis` (`id_jenis`),
ADD KEY `id_kategori` (`id_kategori`),
ADD KEY `id_satuan` (`id_satuan`);
CREATE TABLE `barangmasuk` (
`id_barangmasuk` int(11) NOT NULL PRIMARY KEY,
`id_barang` int(11) NOT NULL,
`jumlah` int(11) NOT NULL,
`jumlah_sisa` int(11) NOT NULL,
`tanggal_pesanan` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `barangmasuk`
ADD KEY `id_obat` (`id_barang`);
CREATE TABLE `jenis` (
`id_jenis` int(11) NOT NULL PRIMARY KEY,
`nama_jenis` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `kategori` (
`id_kategori` int(11) NOT NULL PRIMARY KEY,
`nama_kategori` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `ordermasuk` (
`id_ordermasuk` int(11) NOT NULL PRIMARY KEY,
`id_barang` int(11) DEFAULT NULL,
`id_pengguna` int(11) NOT NULL,
`jumlah` int(11) NOT NULL,
`tanggal` date DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ADD KEY `id_obat` (`id_barang`),
ADD KEY `id_pengguna` (`id_pengguna`);
CREATE TABLE `pengguna` (
`id_pengguna` int(11) NOT NULL PRIMARY KEY,
`id_unit` int(11) DEFAULT NULL,
`nama_pengguna` varchar(50) NOT NULL,
`alamat_pengguna` varchar(50) NOT NULL,
`telp_pengguna` varchar(13) NOT NULL,
`email` varchar(50) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`level` enum('admin','user') NOT NULL,
`status` enum('Aktif','Tidak Aktif') NOT NULL,
`token` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ADD KEY `id_unit` (`id_unit`);
CREATE TABLE `satuan` (
`id_satuan` int(11) NOT NULL PRIMARY KEY,
`nama_satuan` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `stok_opname` (
`id_stok_opname` int(11) NOT NULL PRIMARY KEY,
`id_barang` int(11) NOT NULL,
`jumlah` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ADD KEY `id_barang` (`id_barang`);
CREATE TABLE `stok_opname_outlet` (
`id_stok_opname_outlet` int(11) NOT NULL PRIMARY KEY,
`id_pengguna` int(11) NOT NULL,
`id_barang` int(11) NOT NULL,
`jumlah` int(11) NOT NULL,
`jumlah_satuan` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ADD KEY `id_pengguna` (`id_pengguna`),
ADD KEY `id_barang` (`id_barang`);
CREATE TABLE `unit` (
`id_unit` int(11) NOT NULL PRIMARY KEY,
`nama_unit` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;