-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Waktu pembuatan: 15. Juli 2022 jam 17:25
-- Versi Server: 5.5.8
-- Versi PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `warehouse`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `stpj`
--

CREATE TABLE IF NOT EXISTS `stpj` (
  `STPJ_ID` int(100) NOT NULL AUTO_INCREMENT,
  `PlanID` int(11) DEFAULT NULL,
  `Del_ID` int(50) DEFAULT NULL,
  `Kode` varchar(20) DEFAULT NULL,
  `NoLot` varchar(10) DEFAULT NULL,
  `Nick` int(7) DEFAULT NULL,
  `Status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`STPJ_ID`),
  KEY `PlanID` (`PlanID`),
  KEY `Del_ID` (`Del_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=140 ;

--
-- Dumping data untuk tabel `stpj`
--


--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `stpj`
--
ALTER TABLE `stpj`
  ADD CONSTRAINT `stpj_ibfk_2` FOREIGN KEY (`Del_ID`) REFERENCES `deliverytbl` (`Del_ID`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `stpj_ibfk_1` FOREIGN KEY (`PlanID`) REFERENCES `plan` (`PlanID`) ON DELETE CASCADE ON UPDATE NO ACTION;
