public.iot_credentials
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | integer | nextval('iot_credentials_id_seq'::regclass) | false | Credential record identifier. | ||
| device_id | uuid | false | public.devices | Associated device ID. | ||
| thing_name | varchar(128) | false | AWS IoT Thing name. | |||
| certificate_arn | varchar(255) | false | AWS IoT certificate ARN. | |||
| certificate_id | varchar(64) | false | AWS IoT certificate ID. | |||
| policy_name | varchar(128) | false | AWS IoT policy name. | |||
| status | varchar(50) | false | Credential status: ACTIVE, REVOKED, or ROTATION_REQUIRED. | |||
| created_at | timestamp with time zone | false | Record creation timestamp. | |||
| updated_at | timestamp with time zone | false | Record last update timestamp. | |||
| last_connected_at | timestamp with time zone | true | Last MQTT connection timestamp. |
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