CONTOH LIST CODE MEMBUAT DATA BASE DENGAN SQL

# SINTAKS DATA BASE

 CREATE DATABASE LATIHAN:

1.MAKANAN

create table makanan (idmakanan int primary key auto_increment, makananname varchar (100), Description text, price int, status char(1));

2.Pegawai

create table pegawai (idpegawai int primary key auto_increment, namapegawai varchar(100) , passwordd varchar (100), alamatpegawai text, tlppegawai varchar(60), status char(1), email varchar(100));

3.RawMaterial

Create table rawmaterial (rawmaterialid int primary key auto_increment,                 rawmaterialname varchar(200),                 description text,                 idpegawai int ,                 inputedDate datetime,                 status char(1),                 Foreign key (idpegawai)                 references pegawai (idpegawai));

4.ResepHeader

create table resepheader (idresep int PRIMARY KEY AUTO_INCREMENT,                 idmakanan int,                 outputunitpieces int,                 description text,                 idpegawai int,                 createdate datetime, status char(1), foreign key (idmakanan) references makanan(idmakanan), foreign key (idpegawai) references pegawai(idpegawai));

ResepDetail

CREATE table resepdetail (idresep int ,                            rawmaterialid INT,                            weightingram INT, PRIMARY KEY (idresep,rawmaterialid), FOREIGN KEY (idresep) REFERENCES resepheader(idresep), FOREIGN KEY (rawmaterialid) REFERENCES rawmaterial(rawmaterialid));

Production Header

CREATE TABLE productiondetail (productionid int PRIMARY KEY AUTO_INCREMENT,                                productiondate datetime,                                description text,                                idpegawai int,                                STATUS char (1),                                FOREIGN KEY (idpegawai)                                REFERENCES pegawai(idpegawai));

Production Detail

CREATE TABLE productiondetail (batchnumber int auto_increment,                                productionid int,                                idmakanan int,                                productionoutputqty int,                                expireddate datetime,   PRIMARY key(productionid,batchnumber ,idmakanan),   FOREIGN KEY(productionid) REFERENCES productionheader (productionid),                                FOREIGN KEY (idmakanan)                                REFERENCES makanan (idmakanan));

RawMaterial Intake

CREATE TABLE productiondetail (productionid int,                                batchnumber int,                                idmakanan int,                                productionoutputqty int,                                expireddate datetime,   PRIMARY key(productionid,batchnumber ,idmakanan),   FOREIGN KEY(productionid) REFERENCES productionheader (productionid),                                FOREIGN KEY (idmakanan)                                REFERENCES makanan (idmakanan));

IncomingRawmaterialheader

CREATE TABLE incomingrawmaterialheader(incomingrawmaterialid  int PRIMARY KEY AUTO_INCREMENT,                                        incomingdate datetime,                                        idpegawai int ,                                        description text, FOREIGN KEY (idpegawai) REFERENCES pegawai (idpegawai));

IncomingrawmaterialDetail

CREATE table incomingrawmaterialdetail(incomingrawmaterialid int,                                        incomingdate datetime,                                        idpegawai int,                                        description text,                                        PRIMARY KEY (incomingrawmaterialid,rawmaterialid),                                        foreign KEY (incomingrawmaterialid)                                        REFERENCES incomingrawmaterialheader (incomingrawmaterialid),                                        FOREIGN KEY (rawmaterialid)                                        REFERENCES rawmaterial(rawmaterialid));

Selling Header

Create table sellingheader (sellingid int PRIMARY KEY AUTO_INCREMENT, sellingdate datetime, discount int, idpegawai int, FOREIGN key (idpegawai) REFERENCES pegawai(idpegawai));

Selling Detail

CREATE table sellingdetail(sellingid int ,                            idmakanan int,                            batchnumber int,                            qty int,                            price int,                            PRIMARY KEY (sellingid,idmakanan,batchnumber), FOREIGN key (sellingid) REFERENCES sellingheader(sellingid), FOREIGN KEY (idmakanan) REFERENCES makanan (idmakanan), FOREIGN key (batchnumber) REFERENCES productiondetail(productionid));