Struktur
Tabel / File
Adapun penentuan struktur dari tabel-tabel
database minimarket(data1) adalah sebagai berikut :
Nama
Tabel : tb_supplier
Primary
Key : kode_supplier
|
No
|
Nama Field
|
Tipe
|
Ukuran
|
Kunci
|
Keterangan
|
|
1.
|
kode_supplier
|
character
|
10
|
*
|
Kode supplier
|
|
2.
|
nama
|
character
|
20
|
|
Nama supplier
|
|
3.
|
alamat
|
character
|
30
|
|
Alamat supplier
|
|
4.
|
kota
|
character
|
20
|
|
Kota supplier
|
|
5.
|
telepon_hp
|
character
|
12
|
|
No.Telepon
atau HP
|
Nama
Tabel : tb_pembelian
Primary
Key : id_pembelian
|
No
|
Nama Field
|
Tipe
|
Ukuran
|
Kunci
|
Keterangan
|
|
1.
|
id_pembelian
|
Integer (Auto
Inc)
|
4
|
*
|
Kode pembelian
|
|
2.
|
tanggal
|
date
|
8
|
|
Tanggal pembelian
|
|
3.
|
nota
|
numeric
|
8
|
|
Nota pembelian
|
|
4.
|
kode_supplier
|
character
|
10
|
**
|
Kode supplier
|
|
5.
|
kode
|
character
|
4
|
**
|
Kode barang
|
|
6.
|
nama
|
character
|
20
|
|
Nama barang
|
|
7.
|
satuan
|
numeric
|
12
|
|
Satuan
|
|
8.
|
quantity
|
numeric
|
12
|
|
Kuantitas
|
|
9.
|
harga
|
numeric
|
12
|
|
Harga barang
|
Nama
Tabel : tb_barang
Primary
Key : kode
|
No
|
Nama Field
|
Tipe
|
Ukuran
|
Kunci
|
Keterangan
|
|
1.
|
kode
|
character
|
4
|
*
|
Kode barang
|
|
2.
|
nama
|
character
|
20
|
|
Nama barang
|
|
3.
|
kategori
|
character
|
15
|
|
Kategori barang
|
|
4.
|
harga
|
numeric
|
12
|
|
Harga barang
|
Nama
Tabel : tb_penjualan
Primary
Key : id_penjualan
|
No
|
Nama Field
|
Tipe
|
Ukuran
|
Kunci
|
Keterangan
|
|
1.
|
id_penjualan
|
Integer (Auto
Inc)
|
4
|
*
|
Kode penjualan
|
|
2.
|
tanggal
|
date
|
8
|
|
Tanggal penjualan
|
|
3.
|
nota
|
numeric
|
8
|
|
Nota penjualan
|
|
4.
|
kode_customer
|
character
|
10
|
**
|
Kode customer
|
|
5.
|
kode
|
character
|
4
|
**
|
Kode barang
|
|
6.
|
nama
|
character
|
20
|
|
Nama barang
|
|
7.
|
satuan
|
numeric
|
12
|
|
Satuan
|
|
8.
|
quantity
|
numeric
|
12
|
|
Kuantitas
|
|
9.
|
harga
|
numeric
|
12
|
|
Harga barang
|
|
10.
|
bayar
|
numeric
|
12
|
|
Bayar
|
|
11.
|
kembali
|
numeric
|
12
|
|
Kembali
|
Nama
Tabel : tb_customer
Primary
Key : kode_customer
|
No
|
Nama Field
|
Tipe
|
Ukuran
|
Kunci
|
Keterangan
|
|
1.
|
kode_customer
|
character
|
10
|
*
|
Kode customer
|
|
2.
|
nama
|
character
|
20
|
|
Nama customer
|
|
3.
|
alamat
|
character
|
30
|
|
Alamat customer
|
|
4.
|
kota
|
character
|
20
|
|
Kota customer
|
|
5.
|
Telepon_hp
|
character
|
12
|
|
No.Telepon
atau HP
|
Tidak ada komentar:
Posting Komentar