group: Apotik

Pelanggan=
{
	IdPelanggan:string, NamaPelanggan:string, JenisKelamin:string, Alamat:string
	'0001'            , 'Angelica'          , 'P'                , 'Jl. Rambutan No 1'
	'0044'            , 'Fina'              , 'P'                , 'Jl. Pepaya No 120'
	'0136'            , 'Hasna'             , 'P'                , 'Jl. Durian No 36'
	'0009'            , 'Nul'               , 'L'                , 'Jl. Semangka No 6'
	'0027'            , 'Devi'              , 'P'                , 'Jl. Kiwi No 8'
	'0055'            , 'Rama'              , 'L'                , 'Jl. Durian Runtuh No 76'
	'0177'            , 'Zaki'              , 'L'                , 'Jl. Mangga No 89'
	'0467'            , 'Luthfi'            , 'L'                , 'Jl. Pepaya no 87'
}

Pegawai=
{
	IdPegawai:string, NamaPegawai:string, JenisKelamin:string, Alamat:string      , TanggalLahir:string, NoTelp:string , Jabatan:string , Gaji:number
	'1007'          , 'Ana'             , 'P'                , 'Jl. Brokoli No 77', '13-01-1990'       , '089672849399', 'Apoteker'     , 3500000
	'1046'          , 'Rafi'            , 'L'                , 'Jl. Wortel No 125', '16-01-1988'       , '081234778899', 'Kepala Apotik', 5000000
	'1077'          , 'Dimas'           , 'L'                , 'Jl. Tomat No 56'  , '05-05-1993'       , '085678853056', 'Apoteker'     , 3500000
	'1135'          , 'Bella'           , 'P'                , 'Jl. Jagung No 98' , '30-11-1990'       , '083888999234', 'Administrasi' , 2000000
}

Obat=
{
	IdObat:string, NamaObat:string, Harga:number, Stok:number, IdJenisObat:string
	'2005'       , 'Antimo'       , 5000        , 25         , '3001'
	'2015'       , 'Antangin'     , 2500        , 90         , '3001'
	'2083'       , 'Vicks'        , 4500        , 20         , '3001'
	'2245'       , 'Bodrex'       , 8300        , 10         , '3002'
	'2158'       , 'Decolgen'     , 2500        , 69         , '3002'
	'2009'       , 'Entrostop'    , 8000        , 75         , '3002'
	'2047'       , 'Konidin'      , 4500        , 5          , '3001'
	'2004'       , 'Mylanta'      , 15300       , 18         , '3001'
	'2036'       , 'Paracetamol'  , 4100        , 70         , '3002'
	'2001'       , 'Amoxicilin'   , 3900        , 35         , '3002'
	'2078'       , 'Blackmores'   , 52500       , 7          , '3003'
}

JenisObat=
{
	IdJenisObat:string, JenisObat:string
	'3001'            , 'Sirup'
	'3002'            , 'Tablet'
	'3003'            , 'Kapsul'
}

Penjualan=
{
	KodeTransaksi:string, Tanggal:string, IdPelanggan:string, IdPegawai:string, IdObat:string, IdJenisObat:string, JumlahObat:number, TotalHarga:number
	'4131'                , '13-06-19'    , '0001'            , '1007'          , '2083'        , '3001'           , 3                , 13500
	'4062'               , '06-06-19'    , '0027'            , '1007'          , '2158'        , '3002'           , 10               , 25000
	'4171'               , '17-07-19'    , '0177'            , '1077'          , '2004'        , '3001'           , 6                , 91800
	'4313'               , '31-07-19'    , '0044'            , '1007'          , '2078'        , '3003'           , 1                , 52500
	'4022'               , '02-08-19'    , '0136'            , '1077'          , '2158'        , '3002'           , 17               , 42500
	'4251'               , '25-07-19'    , '0177'            , '1077'          , '2015'        , '3001'            , 8                , 20000
}