Uploaded by User96235

ERD barangNew

advertisement
tbl_user
Kode_User VARCHAR(5)
Nm_User CHAR(120)
Pass_User CHAR(6)
Level_User VARCHAR(80)
Indexes
tbl_barang
Kode_Barang VARCHAR(7)
Nama_Barang CHAR(150)
Satuan_Barang CHAR(30)
Stok_Barang INT(11)
Indexes
tbl_supplier
Kode_Supplier VARCHAR(7)
Nama_Supplier CHAR(60)
Alamat_Supplier CHAR(120)
HP_Supplier VARCHAR(13)
Indexes
tbl_detailbarangmasuk
No_BrgMasuk VARCHAR(13)
Kode_Barang VARCHAR(7)
Jumlah_BrMasuk INT(255)
Indexes
tbl_barang_masuk
No_BrgMasuk VARCHAR(13)
Tgl_BrgMasuk DATE
Total_BrgMasuk INT(11)
Kode_Supplier VARCHAR(7)
Kode_User VARCHAR(5)
Indexes
Download