naEbQDBj

1/*==============================================================*/
2/* DBMS name:      MySQL 5.0                                    */
3/* Created on:     3/22/2018 7:54:10 PM                         */
4/*==============================================================*/
5
6
7drop table if exists DETAIL_PEMBELIAN;
8
9drop table if exists KASIR;
10
11drop table if exists PELANGGAN;
12
13drop table if exists PRODUK;
14
15drop table if exists ROTI;
16
17drop table if exists TRANSAKSI;
18
19/*==============================================================*/
20/* Table: DETAIL_PEMBELIAN                                      */
21/*==============================================================*/
22create table DETAIL_PEMBELIAN
23(
24   ID_TRANSAKSI         int not null,
25   KODE_PRODUK          varchar(7) not null,
26   JUMLAH               int,
27   primary key (ID_TRANSAKSI, KODE_PRODUK)
28);
29
30/*==============================================================*/
31/* Table: KASIR                                                 */
32/*==============================================================*/
33create table KASIR
34(
35   ID_KARYAWAN          int not null,
36   NAMA_KARYAWAN        varchar(20),
37   JK                   char(1),
38   ALAMAT               varchar(10),
39   TELEPON              varchar(12),
40   primary key (ID_KARYAWAN)
41);
42
43/*==============================================================*/
44/* Table: PELANGGAN                                             */
45/*==============================================================*/
46create table PELANGGAN
47(
48   ID_PELANGGAN         int not null,
49   NAMA_PELANGGAN       varchar(20),
50   JK                   char(1),
51   ALAMAT               varchar(10),
52   TELEPON              varchar(12),
53   primary key (ID_PELANGGAN)
54);
55
56/*==============================================================*/
57/* Table: PRODUK                                                */
58/*==============================================================*/
59create table PRODUK
60(
61   KODE_PRODUK          varchar(7) not null,
62   KODE_ROTI            varchar(5) not null,
63   RASA                 varchar(15),
64   STOK                 int,
65   primary key (KODE_PRODUK)
66);
67
68/*==============================================================*/
69/* Table: ROTI                                                  */
70/*==============================================================*/
71create table ROTI
72(
73   KODE_ROTI            varchar(5) not null,
74   NAMA_ROTI            varchar(15) not null,
75   HARGA_ROTI           int not null,
76   primary key (KODE_ROTI)
77);
78
79/*==============================================================*/
80/* Table: TRANSAKSI                                             */
81/*==============================================================*/
82create table TRANSAKSI
83(
84   ID_TRANSAKSI         int not null,
85   ID_PELANGGAN         int not null,
86   ID_KARYAWAN          int not null,
87   TANGGAL              date,
88   primary key (ID_TRANSAKSI)
89);
90
91alter table DETAIL_PEMBELIAN add constraint FK_DETAIL_PEMBELIAN foreign key (ID_TRANSAKSI)
92      references TRANSAKSI (ID_TRANSAKSI) on delete restrict on update restrict;
93
94alter table DETAIL_PEMBELIAN add constraint FK_DETAIL_PEMBELIAN2 foreign key (KODE_PRODUK)
95      references PRODUK (KODE_PRODUK) on delete restrict on update restrict;
96
97alter table PRODUK add constraint FK_IDENTIFIKASI foreign key (KODE_ROTI)
98      references ROTI (KODE_ROTI) on delete restrict on update restrict;
99
100alter table TRANSAKSI add constraint FK_PEMBELIAN foreign key (ID_PELANGGAN)
101      references PELANGGAN (ID_PELANGGAN) on delete restrict on update restrict;
102
103alter table TRANSAKSI add constraint FK_PENJUALAN foreign key (ID_KARYAWAN)
104      references KASIR (ID_KARYAWAN) on delete restrict on update restrict;