-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpawn_testdb_pawnitems.sql
More file actions
67 lines (60 loc) · 6.08 KB
/
pawn_testdb_pawnitems.sql
File metadata and controls
67 lines (60 loc) · 6.08 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
-- MySQL dump 10.13 Distrib 8.0.41, for macos15 (arm64)
--
-- Host: localhost Database: pawn_testdb
-- ------------------------------------------------------
-- Server version 9.2.0
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `pawnitems`
--
DROP TABLE IF EXISTS `pawnitems`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pawnitems` (
`PawnItemID` int NOT NULL AUTO_INCREMENT,
`UserID` int DEFAULT NULL,
`CustomerID` varchar(100) DEFAULT NULL,
`ItemName` varchar(100) DEFAULT NULL,
`Note` varchar(255) DEFAULT NULL,
`Status` enum('Active','Redeem','Expired') NOT NULL,
`ItemWeight` decimal(10,2) DEFAULT NULL,
`ActualPrice` decimal(10,2) DEFAULT NULL,
`LoanPrice` decimal(10,2) DEFAULT NULL,
`NeedPayAmount` decimal(10,2) DEFAULT NULL,
`MonthCount` int DEFAULT NULL,
`PawnDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`DueDate` date DEFAULT NULL,
`Cartage` int NOT NULL,
PRIMARY KEY (`PawnItemID`),
KEY `UserID` (`UserID`),
KEY `CustomerID` (`CustomerID`),
CONSTRAINT `pawnitems_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `users` (`UserID`),
CONSTRAINT `pawnitems_ibfk_2` FOREIGN KEY (`CustomerID`) REFERENCES `customers` (`CustomerID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pawnitems`
--
LOCK TABLES `pawnitems` WRITE;
/*!40000 ALTER TABLE `pawnitems` DISABLE KEYS */;
INSERT INTO `pawnitems` VALUES (1,3,'CUST002','Gold Necklace','18K pure gold necklace with diamonds','Redeem',25.50,150000.00,120000.00,159.96,6,'2025-02-01 13:35:10','2025-08-01',18),(2,3,'CUST12345','Antique Gold Bracelet','24K antique gold bracelet from royal collection','Active',30.20,200000.00,180000.00,-43921.52,3,'2025-02-01 14:36:45','2025-05-01',24),(5,3,'CUST002','Cut Gold Bracelet','22K antique gold bracelet from royal collection','Redeem',30.20,200000.00,180000.00,239.94,3,'2025-02-01 19:37:17','2025-05-02',24),(6,5,'200217201986','Box Chain','No Any Damages ','Active',21.70,100000.00,870.00,580.44,6,'2025-03-16 05:44:06','2025-07-01',22),(7,5,'200217201986','Gold Bangle ','No Any Damages ','Active',12.90,600.00,400.00,4.77,3,'2025-03-16 05:50:07','2026-12-16',22),(8,5,'200217201986','Diamond Chain','Some Small Damage Middle','Redeem',20.12,1200.00,800.00,0.00,6,'2025-03-16 05:53:44','2027-03-16',24),(9,5,'200217201986','Box Chain','No Any Damages','Redeem',23.10,1900.00,1200.00,0.00,6,'2025-03-16 05:57:05','2027-03-16',24),(10,5,'200217201986','Bangle','No Any Damages','Redeem',8.21,1000.00,3000.00,0.00,3,'2025-03-16 06:04:36','2026-12-16',22),(11,5,'200217201986','Box Chain','No Any Damages','Active',12.21,1200.00,900.00,10.80,3,'2025-03-16 06:12:27','2026-12-16',24),(12,5,'200217201986','Braslet ','No Any Damages','Redeem',32.10,1288.00,890.00,0.00,12,'2025-03-16 06:33:03','2042-09-16',22),(13,5,'200217201986','bangale','uwadguj','Redeem',12.40,234.00,423.00,0.00,12,'2025-03-21 04:24:38','2042-09-21',22),(14,5,'200217201986','Gold Chain','No Any Damages','Active',16.00,590.00,430.00,3.99,6,'2025-03-30 12:47:32','2027-03-30',22),(15,5,'200217201986','Dimond Chain','No Any Damages ','Active',16.98,1189.40,1000.00,6.65,3,'2025-03-31 07:00:15','2026-12-31',22),(16,5,'200217201986','Gold Chain','No Any Damages','Redeem',12.65,886.10,200.00,0.00,3,'2025-03-31 07:18:59','2025-05-02',22),(17,5,'200017701065','Box Chain','No Any Damages','Redeem',7.56,495.76,326.00,0.00,6,'2025-03-31 07:45:39','2027-03-31',22),(18,7,'200217201986','Box Chain ','No Any Damages','Active',20.76,1454.18,1000.00,6.65,3,'2025-03-31 08:58:08','2026-12-31',22),(19,7,'200217201980','Box Chain ','No Any damages','Redeem',16.87,1181.70,1000.00,0.00,3,'2025-03-31 11:44:07','2026-12-31',22),(20,7,'200217201980','Gold Ring','No Any Damages','Active',12.80,905.66,200.00,1.08,3,'2025-04-01 19:24:36','2027-10-02',22),(21,7,'200217201980','Diamond Chain','No Any Damages','Active',21.98,1588.29,1000.00,5.32,6,'2025-04-01 19:35:44','2028-01-02',24),(22,5,'200017701065','Gold Ring','Middle Small Scratch','Active',7.98,527.68,500.00,2.68,6,'2025-04-02 14:31:51','2028-01-02',22),(23,5,'200217201986','Diamond Chain','No Any Damages','Active',12.90,911.18,899.00,4.80,3,'2025-04-02 14:56:24','2027-10-02',22),(24,5,'200217201986','Bangle','No Any Damages ','Active',34.30,2422.76,2000.00,9.01,3,'2025-04-02 15:10:19','2027-11-01',22),(25,7,'200017762514','Gold Ring','No Any Damages','Active',12.90,911.18,900.00,4.80,3,'2025-04-02 15:20:34','2027-10-02',22),(26,7,'200017762514','Gold Neckless ','No Any Damages','Active',12.90,853.02,800.00,4.28,6,'2025-04-02 15:30:28','2025-10-02',22),(27,7,'200217201980','Gold Chain','Not any damages','Active',21.40,1524.43,997.00,897.00,6,'2025-05-25 16:00:51','2025-12-24',22),(28,7,'200217201980','Gold Ring','Any No Damages','Redeem',8.00,608.74,400.00,0.00,3,'2025-05-25 17:31:18','2025-10-23',22),(29,7,'200217201980','Chain','Any Damages No','Redeem',8.00,606.31,500.00,0.00,3,'2025-05-26 04:53:15','2025-10-24',22);
/*!40000 ALTER TABLE `pawnitems` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-05-26 18:00:59