-- Table: public.
customer_type
-- DROP TABLE IF EXISTS public.customer_type;
CREATE TABLE IF NOT EXISTS public.customer_type
id integer NOT NULL DEFAULT nextval('customer_type_id_seq'::regclass),
type_name character varying(50) COLLATE pg_catalog."default" NOT NULL,
description text COLLATE pg_catalog."default",
gl_id integer NOT NULL DEFAULT 1,
status integer NOT NULL DEFAULT 1,
process_status integer NOT NULL DEFAULT 0,
auth_status character varying(64) COLLATE pg_catalog."default" NOT NULL DEFAULT
'PENDING'::character varying,
created_time timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
auth_time timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_userid integer NOT NULL DEFAULT 0,
auth_userid integer NOT NULL DEFAULT 0,
deauth_narration character varying(255) COLLATE pg_catalog."default" NOT NULL DEFAULT
'UNDEFINED'::character varying,
deleted_by integer NOT NULL DEFAULT 0,
is_deleted integer NOT NULL DEFAULT 0,
CONSTRAINT customer_type_pkey PRIMARY KEY (id)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.customer_type
OWNER to coredbuser;
GRANT ALL ON TABLE public.customer_type TO coredbuser;
GRANT ALL ON TABLE public.customer_type TO node_user;
-- Table: public.mms_store_data
-- DROP TABLE IF EXISTS public.mms_store_data;
CREATE TABLE IF NOT EXISTS public.mms_store_data
id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE
2147483647 CACHE 1 ),
store_name character varying(100) COLLATE pg_catalog."default" NOT NULL,
store_id character varying(50) COLLATE pg_catalog."default" NOT NULL,
merchant_id integer,
longitude numeric(11,8) DEFAULT NULL::numeric,
latitude numeric(10,8) DEFAULT NULL::numeric,
address character varying(255) COLLATE pg_catalog."default" NOT NULL,
status integer NOT NULL DEFAULT 1,
process_status integer NOT NULL DEFAULT 0,
auth_status character varying(64) COLLATE pg_catalog."default" NOT NULL DEFAULT
'PENDING'::character varying,
created_time timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
auth_time timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_userid integer NOT NULL DEFAULT 0,
auth_userid integer NOT NULL DEFAULT 0,
deauth_narration character varying(255) COLLATE pg_catalog."default" NOT NULL DEFAULT
'UNDEFINED'::character varying,
deleted_by integer NOT NULL DEFAULT 0,
is_deleted integer NOT NULL DEFAULT 0,
channel_type character varying(20) COLLATE pg_catalog."default",
CONSTRAINT mms_store_data_pkey PRIMARY KEY (id)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.mms_store_data
OWNER to postgres;
GRANT ALL ON TABLE public.mms_store_data TO coredbuser;
GRANT ALL ON TABLE public.mms_store_data TO node_user;
GRANT ALL ON TABLE public.mms_store_data TO postgres;
"[{""id"":22,""type_name"":""INDIVIDUAL"",""description"":""INDIVIDUAL"",""gl_id"":1,""status"":1,""proc
ess_status"":1,""auth_status"":""AUTHORIZED"",""created_time"":""2025-09-
11T06:11:21"",""auth_time"":""2025-09-
11T06:11:21"",""created_userid"":1,""auth_userid"":2,""deauth_narration"":""UNDEFINED"",""deleted_by
"":0,""is_deleted"":0},
{""id"":23,""type_name"":""CORPORATE"",""description"":""CORPORATE"",""gl_id"":2,""status"":1,""proce
ss_status"":1,""auth_status"":""AUTHORIZED"",""created_time"":""2025-09-
11T06:11:21"",""auth_time"":""2025-09-
11T06:11:21"",""created_userid"":1,""auth_userid"":2,""deauth_narration"":""UNDEFINED"",""deleted_by
"":0,""is_deleted"":0}]"
-- Table: public.mms_individual_kyc
-- DROP TABLE IF EXISTS public.mms_individual_kyc;
CREATE TABLE IF NOT EXISTS public.mms_individual_kyc
id integer NOT NULL DEFAULT nextval('mms_individual_kyc_id_seq'::regclass),
merchant_id integer NOT NULL,
first_name character varying(50) COLLATE pg_catalog."default" NOT NULL,
middle_name character varying(50) COLLATE pg_catalog."default",
last_name character varying(50) COLLATE pg_catalog."default" NOT NULL,
date_of_birth date NOT NULL,
gender integer NOT NULL,
merchant_type integer NOT NULL,
category integer NOT NULL,
"[{""id"":1,""merchant_id"":1,""first_name"":""Individual"",""middle_name"":""M"",""last_name"":""User
"",""date_of_birth"":""1990-01-
01"",""gender"":1,""merchant_type"":1,""category"":1,""disability"":1,""networth"":1,""occupation"":1,""
business_type"":1,""annual_income"":1,""mcc"":1,""religion"":1,""bin"":1,""status"":1}]"
disability integer NOT NULL,
networth integer NOT NULL,
occupation integer NOT NULL,
business_type integer NOT NULL,
annual_income integer NOT NULL,
mcc integer NOT NULL,
religion integer NOT NULL,
bin integer NOT NULL,
status integer NOT NULL DEFAULT 1,
CONSTRAINT mms_individual_kyc_pkey PRIMARY KEY (id)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.mms_individual_kyc
OWNER to postgres;
GRANT ALL ON TABLE public.mms_individual_kyc TO coredbuser;
GRANT ALL ON TABLE public.mms_individual_kyc TO node_user;
GRANT ALL ON TABLE public.mms_individual_kyc TO postgres;
"[{""id"":1,""store_name"":""PAYSEPAY
BRANCH"",""store_id"":""STORE00000000001"",""merchant_id"":1,""longitude"":44.00000000,""latitude""
:44.00000000,""address"":""Hyderabad,
Telangana"",""status"":1,""process_status"":1,""auth_status"":""AUTHORIZED"",""created_time"":""2025-
11-27T14:09:21.662071"",""auth_time"":""2025-11-
27T18:49:48.861194"",""created_userid"":1001,""auth_userid"":1001,""deauth_narration"":""UNDEFINED
"",""deleted_by"":0,""is_deleted"":1,""channel_type"":""Merchant""}]"
-- Table: public.mms_corporate_kyc
-- DROP TABLE IF EXISTS public.mms_corporate_kyc;
CREATE TABLE IF NOT EXISTS public.mms_corporate_kyc
id integer NOT NULL DEFAULT nextval('mms_corporate_kyc_id_seq'::regclass),
merchant_id integer NOT NULL,
company_name character varying(255) COLLATE pg_catalog."default" NOT NULL,
reg_num character varying(50) COLLATE pg_catalog."default",
tax_id character varying(50) COLLATE pg_catalog."default",
date_of_reg date,
merchant_type integer NOT NULL,
mcc integer NOT NULL,
business_type integer NOT NULL,
business_nature integer NOT NULL,
bin integer NOT NULL,
status integer NOT NULL DEFAULT 1,
CONSTRAINT mms_corporate_kyc_pkey PRIMARY KEY (id)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.mms_corporate_kyc
OWNER to postgres;
GRANT ALL ON TABLE public.mms_corporate_kyc TO coredbuser;
GRANT ALL ON TABLE public.mms_corporate_kyc TO node_user;
GRANT ALL ON TABLE public.mms_corporate_kyc TO postgres;
"[{""id"":2,""merchant_id"":1,""company_name"":""Corporate
Company"",""reg_num"":""REG123"",""tax_id"":""TAX123"",""date_of_reg"":""2024-01-
01"",""merchant_type"":1,""mcc"":1,""business_type"":1,""business_nature"":1,""bin"":1,""status"":1}]"
{
"message": "Login successful",
"token":
"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJNZXJjaGFudElEIjoiMTAwMiIsImFjdHVhbF9pZCI6MTAwMiwidXNl
cl9uYW1lIjoiY29ycG9yYXRlQGdtYWlsLmNvbSIsIm1lcmNoYW50X3R5cGUiOjIsImF1dGhfc3RhdHVzIjoiQVVUS
E9SSVpFRCIsInVzYWdlX3R5cGUiOjIsImlhdCI6MTc2NDkzODQwMSwiZXhwIjoxNzY0OTQyMDAxfQ.A6UAlfhk3
X3DndKsuQoLxjl6FKgSJczx1lrlmBiISsI",
"refreshToken":
"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJNZXJjaGFudElEIjoiMTAwMiIsImFjdHVhbF9pZCI6MTAwMiwidXNl
cl9uYW1lIjoiY29ycG9yYXRlQGdtYWlsLmNvbSIsIm1lcmNoYW50X3R5cGUiOjIsImF1dGhfc3RhdHVzIjoiQVVUS
E9SSVpFRCIsInVzYWdlX3R5cGUiOjIsImlhdCI6MTc2NDkzODQwMSwiZXhwIjoxNzY1NTQzMjAxfQ.00MSPT2px
bt3NucCVtFbjURnlAvCPsJ_6N1rPMpUouM",
"user": {
"MerchantID": "1002",
"actual_id": 1002,
"user_name": "corporate@[Link]",
"merchant_type": 2,
"auth_status": "AUTHORIZED",
"usage_type": 2
},
"menu": [
"Branch",
"Branch Manager",
"Terminal",
"Terminal User",
"Terminal User Profile",
"Transaction",
"Report"
}
{
"message": "Login successful",
"token":
"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJNZXJjaGFudElEIjoiMSIsImFjdHVhbF9pZCI6MSwidXNlcl9uYW1lIjo
iaW5kaXZpZHVhbEBnbWFpbC5jb20iLCJtZXJjaGFudF90eXBlIjoxLCJhdXRoX3N0YXR1cyI6IkFVVEhPUklaRUQiL
CJ1c2FnZV90eXBlIjozLCJpYXQiOjE3NjQ5Mzg0MzgsImV4cCI6MTc2NDk0MjAzOH0.MIMXqkBll2fmZGEVdgJ3ty
RacQIZ7_3erauqqwFnMis",
"refreshToken":
"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJNZXJjaGFudElEIjoiMSIsImFjdHVhbF9pZCI6MSwidXNlcl9uYW1lIjo
iaW5kaXZpZHVhbEBnbWFpbC5jb20iLCJtZXJjaGFudF90eXBlIjoxLCJhdXRoX3N0YXR1cyI6IkFVVEhPUklaRUQiL
CJ1c2FnZV90eXBlIjozLCJpYXQiOjE3NjQ5Mzg0MzgsImV4cCI6MTc2NTU0MzIzOH0.qBMkPxuDz5WFTZ1XPnCT
3_9xwaJBR72oskcf9WbRgmI",
"user": {
"MerchantID": "1",
"actual_id": 1,
"user_name": "individual@[Link]",
"merchant_type": 1,
"auth_status": "AUTHORIZED",
"usage_type": 3
},
"menu": [
"Branch",
"Branch Manager",
"Terminal",
"Terminal User",
"Terminal User Profile",
"Transaction",
"Report"
-- Table: public.mms_merch_cred
-- DROP TABLE IF EXISTS public.mms_merch_cred;
CREATE TABLE IF NOT EXISTS public.mms_merch_cred
id integer NOT NULL DEFAULT nextval('mms_merch_cred_id_seq'::regclass),
merchant_id integer NOT NULL,
user_name character varying(100) COLLATE pg_catalog."default" NOT NULL,
user_pwd character varying(255) COLLATE pg_catalog."default" NOT NULL,
merchant_type integer NOT NULL,
has_sms integer DEFAULT 0,
has_email integer DEFAULT 0,
is_first_login integer NOT NULL DEFAULT 0,
status integer NOT NULL DEFAULT 1,
process_status integer NOT NULL DEFAULT 0,
auth_status character varying(64) COLLATE pg_catalog."default" NOT NULL DEFAULT
'PENDING'::character varying,
created_time timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_time timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_userid integer NOT NULL DEFAULT 0,
auth_userid integer NOT NULL DEFAULT 0,
is_deleted integer NOT NULL DEFAULT 0,
usage_type integer NOT NULL DEFAULT 0,
session_active integer DEFAULT 0,
current_token character varying(1000) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
last_activity_time timestamp with time zone,
CONSTRAINT mms_merch_cred_pkey PRIMARY KEY (id)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.mms_merch_cred
OWNER to postgres;
GRANT ALL ON TABLE public.mms_merch_cred TO coredbuser;
GRANT ALL ON TABLE public.mms_merch_cred TO node_user;
GRANT ALL ON TABLE public.mms_merch_cred TO postgres;
"[{""id"":14,""merchant_id"":1,""user_name"":""individual@[Link]"",""user_pwd"":""HbdMpenK05T9
SjQqedPC4qtIaQI+ao8vm5/
K3LOT"",""merchant_type"":1,""has_sms"":1,""has_email"":1,""is_first_login"":1,""status"":1,""process_st
atus"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
19T16:23:38.138872"",""updated_time"":""2025-11-
19T16:23:38.138872"",""created_userid"":0,""auth_userid"":0,""is_deleted"":0,""usage_type"":3,""session
_active"":1,""current_token"":""[Link]
bF9pZCI6MSwidXNlcl9uYW1lIjoiaW5kaXZpZHVhbEBnbWFpbC5jb20iLCJtZXJjaGFudF90eXBlIjoxLCJhdXRoX3N
0YXR1cyI6IkFVVEhPUklaRUQiLCJ1c2FnZV90eXBlIjozLCJpYXQiOjE3NjQ5Mzg0MzgsImV4cCI6MTc2NDk0MjAz
OH0.MIMXqkBll2fmZGEVdgJ3tyRacQIZ7_3erauqqwFnMis"",""last_activity_time"":""2025-12-
05T18:10:38.302+05:30""},
{""id"":15,""merchant_id"":1002,""user_name"":""corporate@[Link]"",""user_pwd"":""F7ZavN+ShdK
GiX6Ins2HN7vtcjYB3jpZ"",""merchant_type"":2,""has_sms"":1,""has_email"":1,""is_first_login"":1,""status
"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
19T16:23:38.138872"",""updated_time"":""2025-11-
19T16:23:38.138872"",""created_userid"":0,""auth_userid"":0,""is_deleted"":0,""usage_type"":2,""session
_active"":1,""current_token"":""[Link]
dHVhbF9pZCI6MTAwMiwidXNlcl9uYW1lIjoiY29ycG9yYXRlQGdtYWlsLmNvbSIsIm1lcmNoYW50X3R5cGUiOjIs
ImF1dGhfc3RhdHVzIjoiQVVUSE9SSVpFRCIsInVzYWdlX3R5cGUiOjIsImlhdCI6MTc2NDkzODQwMSwiZXhwIjox
NzY0OTQyMDAxfQ.A6UAlfhk3X3DndKsuQoLxjl6FKgSJczx1lrlmBiISsI"",""last_activity_time"":""2025-12-
05T18:10:01.789+05:30""},
{""id"":19,""merchant_id"":46,""user_name"":""avi@[Link]"",""user_pwd"":""Fa9Bov7Q36GvFEWYsvl
Z44oeLY7MCBLvXEMg"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":1,""status""
:1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
20T16:46:24.810186"",""updated_time"":""2025-11-
20T16:46:24.810186"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":20,""merchant_id"":3,""user_name"":""naveen@[Link]"",""user_pwd"":""beEf+qqXhNOt4+K+s
nCRglDX6+ImUKUYvg=="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status
"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T15:01:14.418328"",""updated_time"":""2025-11-
27T15:01:14.418328"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":21,""merchant_id"":4,""user_name"":""987654321"",""user_pwd"":""beEf+qqXhHwfoLwSJe6pPaJ8
6XHbgj8="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1,""process
_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T17:17:02.176052"",""updated_time"":""2025-11-
27T17:17:02.176052"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":22,""merchant_id"":5,""user_name"":""987654321"",""user_pwd"":""bO4e+auQhdonBob7bUlX7nv
jGNKQIG4="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1,""proce
ss_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T17:17:31.324218"",""updated_time"":""2025-11-
27T17:17:31.324218"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":23,""merchant_id"":6,""user_name"":""9876543211"",""user_pwd"":""PqxAq/
nA05nv5v+bcudsScapXuR9wPAr7w=="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_logi
n"":0,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T17:39:05.589451"",""updated_time"":""2025-11-
27T17:39:05.589451"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":24,""merchant_id"":7,""user_name"":""9876543211"",""user_pwd"":""beEf+qqXhNOt4+K+snCRglD
X6+ImUKUYvg=="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1,""
process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T18:52:00.941821"",""updated_time"":""2025-11-
27T18:52:00.941821"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":25,""merchant_id"":8,""user_name"":""abcdef@[Link]"",""user_pwd"":""E7ZYpd+QhdDiGkD0o
mUgWGE4h8HTntS+"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":1,""status"":
1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T18:53:25.60828"",""updated_time"":""2025-11-
27T18:53:25.60828"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,""s
ession_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":26,""merchant_id"":9,""user_name"":""m@[Link]"",""user_pwd"":""ObdKuvzbzbRIK8/
cDV7F7mjEjKEHVGY="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":
1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T19:30:44.145215"",""updated_time"":""2025-11-
27T19:30:44.145215"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":27,""merchant_id"":10,""user_name"":""b@[Link]"",""user_pwd"":""FbtLjK6RhMDcBXMRqCl5
yiCc3ZFpQaemWf0="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1
,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T19:34:32.40378"",""updated_time"":""2025-11-
27T19:34:32.40378"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,""s
ession_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":28,""merchant_id"":11,""user_name"":""9876543211"",""user_pwd"":""N5FahunIhN7pVAFNFayK3
SayI4m6g6DCJ4kLyYZI6F4="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""sta
tus"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T19:53:41.224705"",""updated_time"":""2025-11-
27T19:53:41.224705"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":29,""merchant_id"":12,""user_name"":""987654321"",""user_pwd"":""PrFPqvvbxJv9xUiDs6Hwack2
wE3+8i9etw=="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1,""pr
ocess_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
27T19:54:15.457049"",""updated_time"":""2025-11-
27T19:54:15.457049"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":30,""merchant_id"":13,""user_name"":"""",""user_pwd"":""HrhLo/DB99CuFX45/
bNTZZsJU+bG4k2hjRU="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status
"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
28T10:25:45.405391"",""updated_time"":""2025-11-
28T10:25:45.405391"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":31,""merchant_id"":14,""user_name"":""9704156957"",""user_pwd"":""Mr5Mv/
rRwICY0iQbQDSB+lJEpUXdOZY3"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,
""status"":2,""process_status"":2,""auth_status"":""AUTH WAIT"",""created_time"":""2025-11-
28T13:02:37.853068"",""updated_time"":""2025-11-
28T13:02:37.853068"",""created_userid"":1,""auth_userid"":0,""is_deleted"":0,""usage_type"":0,""session
_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":32,""merchant_id"":15,""user_name"":""JASMEEN@[Link]"",""user_pwd"":""I79w9afNzrPJAw
NueYO4yVPPXyvfhE92CUhFWpbIkB0="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_logi
n"":0,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
28T16:35:56.155969"",""updated_time"":""2025-11-
28T16:35:56.155969"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":33,""merchant_id"":16,""user_name"":""veeran@[Link]"",""user_pwd"":""FZ1AnM6O77LYayd8
f8PGwRsM5ckZasqTk2kEglIBAgc="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":
0,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
28T16:38:07.994018"",""updated_time"":""2025-11-
28T16:38:07.994018"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":34,""merchant_id"":17,""user_name"":""78945612377"",""user_pwd"":""F7ZavN+ShdKGiX6Ins2HN
7vtcjYB3jpZ"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1,""proce
ss_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
28T16:39:22.617082"",""updated_time"":""2025-11-
28T16:39:22.617082"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":35,""merchant_id"":18,""user_name"":""123456789"",""user_pwd"":""F7ZavN+ShdKGiX6Ins2HN7v
tcjYB3jpZ"",""merchant_type"":3,""has_sms"":0,""has_email"":0,""is_first_login"":0,""status"":1,""process
_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
28T16:46:43.454505"",""updated_time"":""2025-11-
28T16:46:43.454505"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":36,""merchant_id"":19,""user_name"":""888888888888888"",""user_pwd"":""Fod7+9f80qrkUhssM
8uW3g9Brev52fo+Z6lswJFC2bE="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0
,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
29T12:25:06.168472"",""updated_time"":""2025-11-
29T12:25:06.168472"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":37,""merchant_id"":20,""user_name"":""a@[Link]"",""user_pwd"":""FbtLjKuQhdBeeHS9D9Hty
qHPqhkso9/
t"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":1,""status"":1,""process_status""
:0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
29T15:25:50.265858"",""updated_time"":""2025-11-
29T15:25:50.265858"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":38,""merchant_id"":21,""user_name"":""aa@[Link]"",""user_pwd"":""FbtLjKuQhdBeeHS9D9Ht
yqHPqhkso9/
t"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":1,""status"":1,""process_status""
:0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
29T16:05:18.659738"",""updated_time"":""2025-11-
29T16:05:18.659738"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":39,""merchant_id"":22,""user_name"":""manager1@[Link]"",""user_pwd"":""GbhGrfjGxaGtFE
e4byfmdV0W3RuP4gSL7lAO"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":1,""st
atus"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
29T17:05:56.076723"",""updated_time"":""2025-11-
29T17:05:56.076723"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":1,""current_token"":""eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJDdXN0b21lcklEIjoiMjIiLC
JhY3R1YWxfaWQiOjIyLCJ1c2VyX2lkIjoiU1RPUkUwMDAwMDAwMDAyMiIsInVzZXJfbmFtZSI6Im1hbmFnZXIx
QGdtYWlsLmNvbSIsInVzZXJfdHlwZSI6MywiYXV0aF9zdGF0dXMiOiJBVVRIT1JJWkVEIiwibWVyY2hhbnRfdHlwZ
SI6MCwiaWF0IjoxNzY0NDIyMzA0LCJleHAiOjE3NjQ0MjU5MDR9.0P_8ZGiwu_Hk2ACtcyE4PVpk52uZiWYRDi
wVVxPfngo"",""last_activity_time"":""2025-11-29T19:46:20.303+05:30""},
{""id"":40,""merchant_id"":23,""user_name"":""manager2@[Link]"",""user_pwd"":""GbhGrfjGxaGtFE
e4byfmdV0W3RuP4gSL7lAO"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":1,""st
atus"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
29T17:10:28.205103"",""updated_time"":""2025-11-
29T17:10:28.205103"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":1,""current_token"":""eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJDdXN0b21lcklEIjoiMjIiLC
JhY3R1YWxfaWQiOjIyLCJ1c2VyX2lkIjoiU1RPUkUwMDAwMDAwMDAyMiIsInVzZXJfbmFtZSI6Im1hbmFnZXIx
QGdtYWlsLmNvbSIsInVzZXJfdHlwZSI6MywiYXV0aF9zdGF0dXMiOiJBVVRIT1JJWkVEIiwibWVyY2hhbnRfdHlwZ
SI6MCwiaWF0IjoxNzY0NDIyMzA0LCJleHAiOjE3NjQ0MjU5MDR9.0P_8ZGiwu_Hk2ACtcyE4PVpk52uZiWYRDi
wVVxPfngo"",""last_activity_time"":""2025-11-29T19:46:20.303+05:30""},
{""id"":41,""merchant_id"":24,""user_name"":""bmanger@[Link]"",""user_pwd"":""FrRJov7E0pPcFUY
qgKsRnIAeiCZM7hFDNSDLNA=="",""merchant_type"":3,""has_sms"":0,""has_email"":0,""is_first_login"":1,
""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-11-
29T17:15:15.095316"",""updated_time"":""2025-11-
29T17:15:15.095316"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":42,""merchant_id"":25,""user_name"":""dftgh@[Link]"",""user_pwd"":""Orter/
nHzx5GL+UZsSYaTxOhiYeMRSM="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0
,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
01T10:55:02.686081"",""updated_time"":""2025-12-
01T10:55:02.686081"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":43,""merchant_id"":26,""user_name"":""gopichandbullayya1939@[Link]"",""user_pwd"":""ML
9PpPXIroLYVhbldXF81xbqA0hufQ=="",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"
":0,""status"":2,""process_status"":2,""auth_status"":""AUTH WAIT"",""created_time"":""2025-12-
01T16:07:11.410582"",""updated_time"":""2025-12-
01T16:07:11.410582"",""created_userid"":1,""auth_userid"":0,""is_deleted"":0,""usage_type"":0,""session
_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":44,""merchant_id"":27,""user_name"":""cccccccc@[Link]"",""user_pwd"":""F5prj9zg9KJF+QAh
bfkb5Y5NCk7nq2Jm"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1
,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
01T19:19:01.570029"",""updated_time"":""2025-12-
01T19:19:01.570029"",""created_userid"":1001,""auth_userid"":1001,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":45,""merchant_id"":28,""user_name"":""zzzzz@[Link]"",""user_pwd"":""DoNylsUTFdhjp75yDR
5c8FQ2JW7z"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":0,""status"":1,""proc
ess_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
02T11:13:29.611325"",""updated_time"":""2025-12-
02T11:13:29.611325"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":46,""merchant_id"":29,""user_name"":""y@[Link]"",""user_pwd"":""Dehoq/
LC3o0Crh9cBUr5ZnHObRHA1qnP"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":
1,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
02T11:32:23.527259"",""updated_time"":""2025-12-
02T11:32:23.527259"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":1,""current_token"":""[Link]
CJhY3R1YWxfaWQiOjI5LCJ1c2VyX25hbWUiOiJ5QGdtYWlsLmNvbSIsIm1lcmNoYW50X3R5cGUiOjMsImF1dG
hfc3RhdHVzIjoiQVVUSE9SSVpFRCIsInVzYWdlX3R5cGUiOjAsImlhdCI6MTc2NDkzODQ2MCwiZXhwIjoxNzY0OT
QyMDYwfQ.wqpPhHisSGLD5lSC3uBarfL5v5y7FU9bFKlvqzLwAk4"",""last_activity_time"":""2025-12-
05T18:11:00.594+05:30""},
{""id"":47,""merchant_id"":30,""user_name"":""yy@[Link]"",""user_pwd"":""Dehoq/
LC3o0Crh9cBUr5ZnHObRHA1qnP"",""merchant_type"":3,""has_sms"":1,""has_email"":1,""is_first_login"":
1,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
02T11:34:39.697208"",""updated_time"":""2025-12-
02T11:34:39.697208"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":1,""current_token"":""eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJDdXN0b21lcklEIjoiMjkiL
CJhY3R1YWxfaWQiOjI5LCJ1c2VyX2lkIjoiU1RPUkUwMDAwMDAwMDAyOSIsInVzZXJfbmFtZSI6InlAZ21haWw
uY29tIiwidXNlcl90eXBlIjozLCJhdXRoX3N0YXR1cyI6IkFVVEhPUklaRUQiLCJtZXJjaGFudF90eXBlIjowLCJpYXQiOj
E3NjQ5MjA1MzEsImV4cCI6MTc2NDkyNDEzMX0.a_jxAqxQmN8mzMRS_DsVqBqki5hzDTMyKkK4ochCp3g"",
""last_activity_time"":""2025-12-05T13:12:33.64+05:30""},
{""id"":48,""merchant_id"":31,""user_name"":""tmanager@[Link]"",""user_pwd"":""ALRJov7E0pOtZh
N2KomMlKyHseSuZQc64RgNX8YFQA=="",""merchant_type"":3,""has_sms"":0,""has_email"":0,""is_first_lo
gin"":1,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
04T15:03:53.699368"",""updated_time"":""2025-12-
04T15:03:53.699368"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null},
{""id"":49,""merchant_id"":32,""user_name"":""ttmanger@[Link]"",""user_pwd"":""ALRJov7E0pOtZh
N2KomMlKyHseSuZQc64RgNX8YFQA=="",""merchant_type"":3,""has_sms"":0,""has_email"":0,""is_first_lo
gin"":1,""status"":1,""process_status"":0,""auth_status"":""AUTHORIZED"",""created_time"":""2025-12-
04T15:09:03.923647"",""updated_time"":""2025-12-
04T15:09:03.923647"",""created_userid"":1002,""auth_userid"":1002,""is_deleted"":0,""usage_type"":0,"
"session_active"":0,""current_token"":null,""last_activity_time"":null}]"
SELECT json_agg(row_to_json(t))
FROM (
SELECT *
FROM public.merchant_type_master
ORDER BY id ASC
) AS t;
"[{""id"":1,""type"":""Merchant"",""status"":1}, {""id"":2,""type"":""Agent"",""status"":1},
{""id"":3,""type"":""Both"",""status"":1}]"