ICD Data Model (platform admin)
Live schema, generated 2026-10-03 02:58 UTC · 14 tables · 126 columns · schemas: dori
schema: dori
app_user
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('user_id_seq'::regclass) |
| user_id | character varying | not null | |
| company_id | integer | not null | → dori.company.id |
| email | character varying | not null | |
| password | character varying | null | NULL::character varying |
| first_name | character varying | null | NULL::character varying |
| last_name | character varying | null | NULL::character varying |
| location_id | integer | null | → dori.location.id |
| is_active | boolean | not null | true |
| user_role | character varying | null | NULL::character varying |
| phone | character varying | null | NULL::character varying |
| active_contact | character varying | null | NULL::character varying |
client
| Column | Type | Null | Default / FK |
|---|
| id | bigint | not null | nextval('client_id_seq'::regclass) |
| name | character varying | null | |
| app_server_url | character varying | not null | |
| dashboard_url | character varying | null | |
| is_active | boolean | not null | true |
client_user
| Column | Type | Null | Default / FK |
|---|
| id | bigint | not null | nextval('client_user_id_seq'::regclass) |
| client_id | bigint | not null | → dori.client.id |
| user_id | bigint | not null | → dori.app_user.id |
cloud_store_config
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('auth_aws_id_seq'::regclass) |
| company_id | integer | not null | → dori.company.id |
| access_key_id | character varying | null | |
| secret_access_key | character varying | null | |
| bucket | character varying | null | NULL::character varying |
| file_path | character varying | null | NULL::character varying |
| region | character varying | null | NULL::character varying |
| provider | character varying | not null | 'aws'::character varying |
| account_name | character varying | null | |
| container_name | character varying | null | |
| endpoint | character varying | null | |
| project_id | character varying | null | |
| service_account_json | text | null | |
company
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('company_id_seq'::regclass) |
| company_id | character varying | null | NULL::character varying |
| name | character varying | null | NULL::character varying |
| display_name | character varying | null | NULL::character varying |
| last_run | bigint | null | |
| ux_config | text | null | |
company_config
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('company_config_id_seq'::regclass) |
| company_id | integer | not null | → dori.company.id |
| config_key | character varying | not null | |
| config_value | character varying | null | |
event_type
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('event_type_id_seq'::regclass) |
| service_bundle_id | integer | not null | → dori.service_bundle.id |
| name | character varying | not null | |
| description | character varying | null | NULL::character varying |
| is_message | boolean | null | false |
| is_notification | boolean | null | false |
| is_trigger | boolean | null | false |
mlc
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('mlc_id_seq'::regclass) |
| name | character varying | null | NULL::character varying |
| url | character varying | null | NULL::character varying |
| status | character varying | null | NULL::character varying |
| callback_url | character varying | null | NULL::character varying |
| mount_point | character varying | null | NULL::character varying |
| auth_token | character varying | null | NULL::character varying |
| deployment_id | character varying | null | NULL::character varying |
| sort_order | integer | null | |
| model_class | character varying | null | NULL::character varying |
| last_active_call_time | timestamp without time zone | null | |
| last_healthcheck | timestamp without time zone | null | |
| instance_type | character varying | null | NULL::character varying |
| is_active | boolean | not null | true |
| service_bundle_id | integer | null | → dori.service_bundle.id |
| max_capacity | integer | null | |
| current_capacity | integer | not null | 0 |
| is_deployed | boolean | not null | false |
| is_configured | boolean | not null | false |
| poll_count | integer | not null | 0 |
| media_server_url | character varying | null | NULL::character varying |
mlc_config
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('mlc_config_id_seq'::regclass) |
| mlc_id | integer | null | → dori.mlc.id |
| predictdb_url | character varying | null | NULL::character varying |
| predictdb_port | character varying | null | NULL::character varying |
| predictdb_name | character varying | null | NULL::character varying |
| predictdb_user | character varying | null | NULL::character varying |
| predictdb_password | character varying | null | NULL::character varying |
| eventdb_url | character varying | null | NULL::character varying |
| eventdb_port | character varying | null | NULL::character varying |
| eventdb_name | character varying | null | NULL::character varying |
| eventdb_user | character varying | null | NULL::character varying |
| eventdb_password | character varying | null | NULL::character varying |
| frame_window | integer | not null | 0 |
| max_queue_depth | integer | not null | 0 |
| queue_upper_bound | integer | not null | 0 |
| queue_lower_bound | integer | not null | 0 |
| is_benchmark | boolean | null | true |
| is_postgres | boolean | null | true |
| skip_count | integer | not null | 1 |
| scale | integer | not null | 100 |
| fps | integer | not null | 1 |
| non_max_suppression_conf | numeric | not null | 0.25 |
| non_max_suppression_iou | numeric | not null | 0.45 |
| second_model_def_state | boolean | null | false |
| inference_processes | integer | not null | 3 |
| name | character varying | null | |
mlc_config_company
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('mlc_config_company_id_seq'::regclass) |
| mlc_config_id | integer | not null | → dori.mlc_config.id |
| company_id | integer | not null | → dori.company.id |
notification_route
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('notification_route_id_seq'::regclass) |
| company_id | integer | not null | → dori.company.id |
| match_event_type | character varying | null | |
| scope_location_id | integer | null | |
| scope_device_id | integer | null | |
| contact_point_id | integer | not null | → dori.contact_point.id |
| cooloff_seconds | integer | not null | 0 |
| is_active | boolean | not null | true |
| template_text | text | null | |
| created_at | timestamp with time zone | not null | now() |
service_bundle
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('service_bundle_id_seq'::regclass) |
| name | character varying | null | NULL::character varying |
| version | character varying | null | NULL::character varying |
| description | character varying | null | NULL::character varying |
| service_bundle_url | character varying | null | NULL::character varying |
| service_bundle_config | text | null | |
service_bundle_company
| Column | Type | Null | Default / FK |
|---|
| id | integer | not null | nextval('service_bundle_company_id_seq'::regclass) |
| company_id | integer | not null | → dori.company.id |
| service_bundle_id | integer | not null | → dori.service_bundle.id |