| ID | Name | Role | |
|---|---|---|---|
| 1 | Administrator | admin@tokobuku.test | admin |
| 2 | Budi Santoso | budi@gmail.com | buyer |
| 3 | Siti Aminah | siti@gmail.com | buyer |
| 4 | Andi Wijaya | andi@gmail.com | buyer |
| ID | Title | Author | ISBN | Price | Stock |
|---|---|---|---|---|---|
| 1 | Belajar Laravel untuk Pemula | Andi Pratama | 9786021111001 | 100000.00 | 18 |
| 2 | PHP Modern untuk Web Developer | Budi Hartono | 9786021111002 | 85000.00 | 22 |
| 3 | MySQL Dasar dan Praktik | Citra Dewi | 9786021111003 | 75000.00 | 29 |
| 4 | HTML dan CSS untuk Pemula | Deni Kurniawan | 9786021111004 | 65000.00 | 24 |
| 5 | JavaScript Dasar | Eko Saputra | 9786021111005 | 90000.00 | 18 |
| 6 | Pemrograman Web dengan MVC | Fajar Nugroho | 9786021111006 | 110000.00 | 14 |
| 7 | REST API dengan Laravel | Gilang Ramadhan | 9786021111007 | 120000.00 | 14 |
| 8 | Git dan GitHub untuk Developer | Hendra Wijaya | 9786021111008 | 80000.00 | 19 |
| ID | User ID | Order Date | Total | Status | Shipping Address |
|---|---|---|---|---|---|
| 1001 | 2 | 2026-01-05 10:15:00 | 340000.00 | completed | Jl. Melati No. 10, Bandung |
| 1002 | 3 | 2026-01-15 14:20:00 | 455000.00 | completed | Jl. Mawar No. 25, Jakarta Selatan |
| 1003 | 4 | 2026-01-25 19:45:00 | 290000.00 | completed | Jl. Kenanga No. 8, Surabaya |
| ID | Order ID | Book ID | Qty | Price | Subtotal |
|---|---|---|---|---|---|
| 1 | 1001 | 1 | 2 | 100000.00 | 200000.00 |
| 2 | 1001 | 3 | 1 | 75000.00 | 75000.00 |
| 3 | 1001 | 4 | 1 | 65000.00 | 65000.00 |
| 4 | 1002 | 2 | 1 | 85000.00 | 85000.00 |
| 5 | 1002 | 5 | 2 | 90000.00 | 180000.00 |
| 6 | 1002 | 6 | 1 | 110000.00 | 110000.00 |
| 7 | 1002 | 8 | 1 | 80000.00 | 80000.00 |
| 8 | 1003 | 7 | 1 | 120000.00 | 120000.00 |
| 9 | 1003 | 2 | 2 | 85000.00 | 170000.00 |
| ID | Order ID | Payment Method | Amount | Payment Date | Status |
|---|---|---|---|---|---|
| 1 | 1001 | bank_transfer | 340000.00 | 2026-01-05 10:30:00 | paid |
| 2 | 1002 | e_wallet | 455000.00 | 2026-01-15 14:35:00 | paid |
| 3 | 1003 | credit_card | 290000.00 | 2026-01-25 20:00:00 | paid |