Certificates
Table for storing certificates with issuer, expiration and tracking information
| Column Name | Data Type | Constraints |
|---|---|---|
| id | bigint | NOT NULL |
| created_at | timestamp with time zone | DEFAULT now() NOT NULL |
| issuer | text | NOT NULL |
| expiration | timestamp with time zone | |
| type | text | NOT NULL |
| tracking_number | text | |
| updated_at | timestamp with time zone | DEFAULT now() |
Security Policies (RLS)
This table has Row Level Security (RLS) enabled with the following policies:
- Read Access: Users with view role (certificate access through device relationships)
- Create/Update/Delete: Users with admin role in relevant herds