Found 28 statements ✓ INSERT INTO users (ho_ten, email, mat_khau, so_dien_thoai, v... ✗ INSERT INTO properties (chu_nha_id, ten_nha_tro, dia_chi, so... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'chu_nha_id' in 'INSERT INTO' ✗ INSERT INTO rooms (nha_tro_id, so_phong, tang, dien_tich, gi... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dien_tich' in 'INSERT INTO' ✗ INSERT INTO rooms (nha_tro_id, so_phong, tang, dien_tich, gi... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dien_tich' in 'INSERT INTO' ✗ INSERT INTO services (nha_tro_id, ten_dich_vu, mo_ta, loai_t... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mo_ta' in 'INSERT INTO' ✗ INSERT INTO electricity_tiers (nha_tro_id, bac, tu_kwh, den_... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nha_tro_id' in 'INSERT INTO' ✗ INSERT INTO tenants (ho_ten, so_cmnd_cccd, so_dien_thoai, em... Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '123456789012' for key 'tenants_so_cmnd_cccd_unique' ✗ INSERT INTO contracts (phong_id, dai_dien_thue_id, so_hop_do... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`contracts`, CONSTRAINT `fk_contracts_phong` FOREIGN KEY (`phong_id`) REFERENCES `rooms` (`id`)) ✗ INSERT INTO meter_readings (phong_id, dich_vu_id, ngay_ghi, ... Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'dich_vu_id' cannot be null ✗ INSERT INTO meter_readings (phong_id, dich_vu_id, ngay_ghi, ... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`meter_readings`, CONSTRAINT `fk_mr_phong` FOREIGN KEY (`phong_id`) REFERENCES `rooms` (`id`)) ✗ INSERT INTO invoices (hop_dong_id, so_hoa_don, ky_thanh_toan... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`invoices`, CONSTRAINT `fk_invoices_hop_dong` FOREIGN KEY (`hop_dong_id`) REFERENCES `contracts` (`id`)) ✗ INSERT INTO invoice_items (hoa_don_id, dich_vu_id, chi_so_do... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`invoice_items`, CONSTRAINT `fk_ii_hoa_don` FOREIGN KEY (`hoa_don_id`) REFERENCES `invoices` (`id`)) ✗ INSERT INTO invoice_items (hoa_don_id, dich_vu_id, chi_so_do... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`invoice_items`, CONSTRAINT `fk_ii_hoa_don` FOREIGN KEY (`hoa_don_id`) REFERENCES `invoices` (`id`)) ✗ INSERT INTO invoice_items (hoa_don_id, dich_vu_id, chi_so_do... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`invoice_items`, CONSTRAINT `fk_ii_hoa_don` FOREIGN KEY (`hoa_don_id`) REFERENCES `invoices` (`id`)) ✗ INSERT INTO invoice_items (hoa_don_id, dich_vu_id, chi_so_do... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`invoice_items`, CONSTRAINT `fk_ii_hoa_don` FOREIGN KEY (`hoa_don_id`) REFERENCES `invoices` (`id`)) ✓ UPDATE invoices SET tong_tien = 3300000.00 WHERE id = 1... ✓ UPDATE invoices SET tong_tien = 3200000.00 WHERE id = 2... ✓ UPDATE invoices SET tong_tien = 2800000.00 WHERE id = 3... ✓ UPDATE invoices SET tong_tien = 3800000.00 WHERE id = 4... ✓ UPDATE invoices SET tong_tien = 3500000.00 WHERE id = 5... ✓ UPDATE invoices SET tong_tien = 3400000.00 WHERE id = 6... ✓ UPDATE invoices SET tong_tien = 3800000.00 WHERE id = 7... ✓ UPDATE invoices SET tong_tien = 3600000.00 WHERE id = 8... ✗ INSERT INTO payments (hoa_don_id, so_tien, ngay_thanh_toan, ... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`payments`, CONSTRAINT `fk_payments_hoa_don` FOREIGN KEY (`hoa_don_id`) REFERENCES `invoices` (`id`)) ✗ INSERT INTO maintenance_requests (phong_id, nguoi_thue_id, t... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`maintenance_requests`, CONSTRAINT `fk_maint_phong` FOREIGN KEY (`phong_id`) REFERENCES `rooms` (`id`)) ✗ INSERT INTO announcements (nha_tro_id, nguoi_tao_id, tieu_de... Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bhqbrean2m96_doan2`.`announcements`, CONSTRAINT `fk_ann_nha_tro` FOREIGN KEY (`nha_tro_id`) REFERENCES `properties` (`id`) ON DELETE SET NULL) ✗ INSERT INTO temporary_residences (phong_id, nguoi_thue_id, s... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'so_ho_khau' in 'INSERT INTO' ✗ INSERT INTO handover_records (phong_id, hop_dong_id, loai, n... Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'phong_id' in 'INSERT INTO' === Results === Executed: 9 Failed: 19 === Data Summary === users : 12 properties : 2 rooms : 12 tenants : 18 contracts : 7 invoices : 5 payments : 2 maintenance_requests : 8