public.iot_credentials

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('iot_credentials_id_seq'::regclass)	false
device_id	uuid		false		public.devices
thing_name	varchar(128)		false
certificate_arn	varchar(255)		false
certificate_id	varchar(64)		false
policy_name	varchar(128)		false
status	varchar(50)		false
created_at	timestamp with time zone		false
updated_at	timestamp with time zone		false
last_connected_at	timestamp with time zone		true

Viewpoints

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

Constraints

Name	Type	Definition
iot_credentials_device_id_fkey	FOREIGN KEY	FOREIGN KEY (device_id) REFERENCES devices(device_id) ON DELETE CASCADE
iot_credentials_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
iot_credentials_pkey	CREATE UNIQUE INDEX iot_credentials_pkey ON public.iot_credentials USING btree (id)
ix_iot_credentials_certificate_id	CREATE UNIQUE INDEX ix_iot_credentials_certificate_id ON public.iot_credentials USING btree (certificate_id)
ix_iot_credentials_device_id	CREATE UNIQUE INDEX ix_iot_credentials_device_id ON public.iot_credentials USING btree (device_id)
ix_iot_credentials_thing_name	CREATE UNIQUE INDEX ix_iot_credentials_thing_name ON public.iot_credentials USING btree (thing_name)

Relations

---

Generated by tbls