You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
306 B
14 lines
306 B
CREATE TABLE TBL_MOBILE_OTP_REQUEST
|
|
(
|
|
ROW_ID BIGINT NOT NULL IDENTITY(1, 1) PRIMARY KEY
|
|
,[USER_ID] VARCHAR(150) NOT NULL
|
|
,OTP_CODE VARCHAR(30) NOT NULL
|
|
,REQUEST_FOR VARCHAR(10) NOT NULL
|
|
,RECEIVER_ID BIGINT NULL
|
|
,REQUESTED_DATE DATETIME
|
|
,VERIFIED_DATE DATETIME
|
|
,IS_EXPIRED BIT
|
|
,IS_SUCCESS BIT
|
|
);
|
|
|
|
|