public.merchants

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('merchants_id_seq'::regclass)	false	public.coupons public.customers public.loyalty_programs public.stores public.devices public.orders public.bills public.payments public.settlements public.bill_operation_histories public.slips		Merchant unique identifier.
psp_id	integer		false		public.psps	Parent PSP ID.
merchant_code	varchar(50)		false			Unique merchant code.
merchant_name	varchar(255)		false			Merchant display name.
payment_config	json		true			Payment gateway configuration (JSON).
contact_email	varchar(255)		true			Primary contact email.
contact_phone	varchar(20)		true			Primary contact phone.
status	varchar(50)		true			Entity status: Active, Inactive, or Suspended.
created_at	timestamp with time zone		true			Record creation timestamp.
updated_at	timestamp with time zone		true			Record last update timestamp.
psp_managed_id	varchar(100)		true			PSP-assigned merchant identifier.
business_registration_number	varchar(100)		true			Business registration number.
receipt_info	json		true			Corporate receipt information (JSON).

Viewpoints

Name	Definition
Merchant Hierarchy	Multi-tenant hierarchy — PSP → Merchant → Store → Staff/Devices

Constraints

Name	Type	Definition
merchants_psp_id_fkey	FOREIGN KEY	FOREIGN KEY (psp_id) REFERENCES psps(id) ON DELETE RESTRICT
merchants_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
merchants_pkey	CREATE UNIQUE INDEX merchants_pkey ON public.merchants USING btree (id)
ix_merchants_merchant_code	CREATE UNIQUE INDEX ix_merchants_merchant_code ON public.merchants USING btree (merchant_code)
ix_merchants_psp_id	CREATE INDEX ix_merchants_psp_id ON public.merchants USING btree (psp_id)

Relations

---

Generated by tbls