CREATE TABLE "barang" (
	"id"	integer NOT NULL,
	"kode_barang"	varchar NOT NULL,
	"nama_barang"	varchar,
	"jenis"	varchar,
	"kategori"	varchar,
	"satuan"	varchar,
	"isi"	integer DEFAULT '1',
	"harga_beli"	integer NOT NULL,
	"harga_jual"	integer NOT NULL,
	"diskon"	numeric,
	"terjual"	numeric DEFAULT '0',
	"stok"	numeric DEFAULT '0',
	"stok_minimal"	integer DEFAULT '0',
	"supplier_id"	integer,
	"lokasi"	varchar,
	"merek"	varchar,
	"options"	text,
	"expired"	date,
	"created_at"	datetime,
	"updated_at"	datetime,
	PRIMARY KEY("id" AUTOINCREMENT)
);