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
psp_id	integer		false		public.psps
merchant_code	varchar(50)		false
merchant_name	varchar(255)		false
payment_config	json		true
contact_email	varchar(255)		true
contact_phone	varchar(20)		true
status	varchar(50)		true
created_at	timestamp with time zone		true
updated_at	timestamp with time zone		true
psp_managed_id	varchar(100)		true
business_registration_number	varchar(100)		true
receipt_info	json		true

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