Services
services¶
- Schema: public
- PK: (service_type, region, cloud_project, configuration_name) — composite, all text NOT NULL
Columns¶
| Column | Type | Nullable | Default | Notes |
|---|---|---|---|---|
| service_type | text | NO | Part of PK | |
| region | text | NO | Part of PK | |
| cloud_project | text | NO | Part of PK | |
| configuration_name | text | NO | Part of PK | |
| base_url | text | NO | ||
| is_default_cloud_project | bool | YES | false | |
| is_default_configuration | bool | YES | false | |
| is_default_cloud_project_and_configuration | bool | YES | false | |
| options | jsonb | YES | {} | |
| cloud_provider_region | varchar | YES | ||
| service_name | varchar | YES | ||
| cloud_provider | varchar | YES | ||
| is_active | bool | YES | true | |
| last_modified_time | timestamp | YES | now() | |
| created_time | timestamp | YES | now() |
Key indexes¶
- PK on (service_type, region, cloud_project, configuration_name)
- Multiple unique indexes enforce at most one default per dimension (is_default_cloud_project, is_default_configuration, is_default_cloud_project_and_configuration)