{
"source" : {
"server" : "mysql"
},
"position" : {
"ts_sec" : 1768368676,
"file" : "mysql-bin.000050",
"pos" : 185989916,
"snapshot" : "INITIAL"
},
"ts_ms" : 1768368676378,
"databaseName" : "consumer_service",
"ddl" : "CREATE TABLE `users` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),\n `modified_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n `account_id` bigint unsigned DEFAULT NULL,\n `kyc_status` tinyint unsigned NOT NULL DEFAULT '0',\n `consumer_status` tinyint unsigned NOT NULL DEFAULT '0',\n `verification_requested_date` datetime(6) DEFAULT NULL,\n `verified_by` varchar(100) DEFAULT NULL,\n `verified_date` datetime(6) DEFAULT NULL,\n `profile_id` int unsigned DEFAULT NULL,\n `location_required` tinyint NOT NULL DEFAULT '0',\n `is_dormant` tinyint NOT NULL DEFAULT '0',\n `user_type` tinyint unsigned DEFAULT NULL,\n `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,\n `is_sanctioned` tinyint NOT NULL DEFAULT '0',\n `sanctioned_checked_date` datetime(6) DEFAULT NULL,\n `dormant_checked_date` datetime(6) DEFAULT NULL,\n `email` varchar(255) DEFAULT NULL,\n `liveliness_status` tinyint unsigned NOT NULL DEFAULT '0',\n `profile_image_id` bigint unsigned DEFAULT NULL,\n `email_status` tinyint unsigned DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `fk_users_file_details` (`profile_image_id`),\n CONSTRAINT `fk_users_file_details` FOREIGN KEY (`profile_image_id`) REFERENCES `file_details` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=1462 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"consumer_service\".\"users\"",
"table" : {
"defaultCharsetName" : "utf8mb4",
"primaryKeyColumnNames" : [ "id" ],
"columns" : [ {
"name" : "id",
"jdbcType" : -5,
"typeName" : "BIGINT UNSIGNED",
"typeExpression" : "BIGINT UNSIGNED",
"charsetName" : null,
"position" : 1,
"optional" : false,
"autoIncremented" : true,
"generated" : true,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "created_at",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"length" : 6,
"position" : 2,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "modified_at",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"length" : 6,
"position" : 3,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "account_id",
"jdbcType" : -5,
"typeName" : "BIGINT UNSIGNED",
"typeExpression" : "BIGINT UNSIGNED",
"charsetName" : null,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "kyc_status",
"jdbcType" : 5,
"typeName" : "TINYINT UNSIGNED",
"typeExpression" : "TINYINT UNSIGNED",
"charsetName" : null,
"position" : 5,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
}, {
"name" : "consumer_status",
"jdbcType" : 5,
"typeName" : "TINYINT UNSIGNED",
"typeExpression" : "TINYINT UNSIGNED",
"charsetName" : null,
"position" : 6,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
}, {
"name" : "verification_requested_date",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"length" : 6,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "verified_by",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8mb4",
"length" : 100,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "verified_date",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"length" : 6,
"position" : 9,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "profile_id",
"jdbcType" : 4,
"typeName" : "INT UNSIGNED",
"typeExpression" : "INT UNSIGNED",
"charsetName" : null,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "location_required",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"position" : 11,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
}, {
"name" : "is_dormant",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"position" : 12,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
}, {
"name" : "user_type",
"jdbcType" : 5,
"typeName" : "TINYINT UNSIGNED",
"typeExpression" : "TINYINT UNSIGNED",
"charsetName" : null,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "name",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8mb4",
"length" : 100,
"position" : 14,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "is_sanctioned",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"position" : 15,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
}, {
"name" : "sanctioned_checked_date",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"length" : 6,
"position" : 16,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "dormant_checked_date",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"length" : 6,
"position" : 17,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "email",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8mb4",
"length" : 255,
"position" : 18,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "liveliness_status",
"jdbcType" : 5,
"typeName" : "TINYINT UNSIGNED",
"typeExpression" : "TINYINT UNSIGNED",
"charsetName" : null,
"position" : 19,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
}, {
"name" : "profile_image_id",
"jdbcType" : -5,
"typeName" : "BIGINT UNSIGNED",
"typeExpression" : "BIGINT UNSIGNED",
"charsetName" : null,
"position" : 20,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "email_status",
"jdbcType" : 5,
"typeName" : "TINYINT UNSIGNED",
"typeExpression" : "TINYINT UNSIGNED",
"charsetName" : null,
"position" : 21,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "0",
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
