AdvancedReports: dataset.txt

group: StockManagement

users = {
user_id:number, username:string, password:string, full_name:string, email:string, role:string, is_active:number
1, ceyda_admin, test123, Ceyda_Huseini, ceyda_gmail.com, Admin, 1
2, gjorgji_adm, pass123, Gjorgji_Naumov, gjorgji_system.mk, Admin, 1
3, elena_inv, pass456, Elena_Stojanovska, elena_system.mk, InventoryManager, 1
4, zoran_sales, pass789, Zoran_Milevski, zoran_system.mk, SalesPersonnel, 1
5, stefan_wh, pass000, Stefan_Trajkovski, stefan_system.mk, WarehouseStaff, 1
}

customer = {
customer_id:number, name:string, email:string, phone:string, address:string
1, Petar_Naumovski, petar_email.mk, 38970123456, Skopje
2, Marija_Jovanovska, marija_email.mk, 38971987654, Bitola
3, Igor_Angelov, igor_email.mk, 38975555444, Kumanovo
}

category = {
category_id:number, name:string, description:string
1, IT_Oprema, Kompjuteri_laptopi_mrezna_oprema
2, Kancelariska_Oprema, Mebeli_materijali_kancelarija
}

supplier = {
supplier_id:number, name:string, contact_person:string, phone:string, email:string, address:string
1, Makedonski_Telekom, Darko_Kolev, 38923100000, contact_telekom.mk, Skopje
2, Anhoch_PC_Market, Bojan_Janev, 38923111888, prodazba_anhoch.com, Skopje
3, Prosvetno_Delo, Ana_Ristovska, 38923222111, info_prosvetno.mk, Vizbegovo
}

product = {
product_id:number, name:string, description:string, sku:string, unit_price:number, reorder_level:number, category_id:number, supplier_id:number, is_active:number
1, Monitor_Dell_24, Full_HD_IPS_Monitor, DELL-24-IPS, 9500.00, 10, 1, 2, 1
2, Laptop_HP_250_G8, Core_i5_8GB_256GB, HP-250-G8, 32000.00, 5, 1, 2, 1
3, Kancelariski_Stol, Crna_koza_podesiva, CHAIR-ERG-01, 6500.00, 15, 2, 3, 1
}

warehouse = {
warehouse_id:number, name:string, location:string, capacity:number
1, Skopje_Magacin, Vizbegovo_Skopje, 10000
2, Bitola_Centar, Kravarski_Bitola, 4000
}

warehouse_stock = {
warehouse_id:number, product_id:number, quantity_on_hand:number
1, 1, 45
1, 2, 12
2, 2, 5
2, 3, 30
}

sale = {
sale_id:number, total_amount:number, user_id:number, customer_id:number, warehouse_id:number
1, 41500.00, 3, 1, 1
2, 6500.00, 3, 2, 2
}

sale_item = {
sale_id:number, product_id:number, quantity:number, unit_price_at_sale:number
1, 2, 1, 32000.00
1, 1, 1, 9500.00
2, 3, 1, 6500.00
}

purchase_order = {
po_id:number, order_date:date, expected_delivery_date:date, status:string, supplier_id:number, warehouse_id:number
1, 2025-01-15, 2025-02-01, Pending, 2, 1
2, 2025-01-15, 2025-02-05, Confirmed, 3, 2
}

purchase_order_item = {
po_id:number, product_id:number, quantity:number, unit_cost:number, received_quantity:number
1, 2, 10, 28000.00, 0
2, 3, 20, 5000.00, 0
}