16 lines
872 B
SQL
16 lines
872 B
SQL
CREATE TABLE IF NOT EXISTS `order_recovery_claims` (
|
|
`id` BIGINT NOT NULL AUTO_INCREMENT,
|
|
`order_no` VARCHAR(255) NOT NULL COMMENT 'Recovered Order No',
|
|
`email` VARCHAR(255) NOT NULL COMMENT 'Claim Email',
|
|
`user_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'User ID',
|
|
`subscribe_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'Subscribe ID',
|
|
`order_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'Recovered Order ID',
|
|
`user_subscribe_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'User Subscribe ID',
|
|
`claimed_at` DATETIME(3) NOT NULL COMMENT 'Claimed Time',
|
|
`created_at` DATETIME(3) DEFAULT NULL COMMENT 'Creation Time',
|
|
`updated_at` DATETIME(3) DEFAULT NULL COMMENT 'Update Time',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `idx_order_recovery_claim_order_no` (`order_no`),
|
|
KEY `idx_order_recovery_claim_email` (`email`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|