captions
Key
id    
bigserial
NN
Key
content_id    
bigint
NN
start    
float8
NN
end    
float8
NN
users
Key
id    
bigserial
NN
Key
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
modified_at    
timestamp with time zone
NN
Key
username    
varchar(255)
NN
Key
email    
varchar(255)
NN
password    
varchar(255)
NN
salt    
varchar(255)
NN
display_name    
varchar(255)
is_active    
bool
NN
documents
Key
id    
bigserial
NN
Key
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
modified_at    
timestamp with time zone
NN
Key
owner_id    
bigint
NN
type    
smallint
NN
status    
smallint
NN
reason    
text
requests
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
owner_id    
bigint
NN
peer_args    
jsonb
NN
is_async    
bool
NN
status    
smallint
NN
reason    
text
contents
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
document_id    
bigint
NN
pos    
bigint
NN
lang    
varchar(4)
is_original    
bool
NN
key    
varchar(128)
NN
value    
text
NN
confidence    
float8
NN
status    
smallint
NN
reason    
text
medias
Key
id    
bigserial
NN
Key
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
document_id    
bigint
NN
Key
uri    
text
Key
path    
text
NN
filename    
text
NN
title    
text
NN
Key
cid    
varchar(64)
NN
mime    
varchar(96)
NN
extension    
varchar(32)
NN
size    
bigint
NN
duration    
float8
NN
purpose    
media_purpose
NN
status    
smallint
NN
reason    
text
access_tokens
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
owner_id    
bigint
NN
name    
varchar(255)
Key
key    
varchar(255)
NN
Key
token    
varchar(255)
NN
is_active    
bool
NN
valid_until    
timestamp with time zone
bearer_tokens
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
owner_id    
bigint
NN
token    
varchar(255)
NN
is_active    
bool
NN
valid_until    
timestamp with time zone
settings
Key
id    
varchar(127)
NN
created_at    
timestamp with time zone
NN
modified_at    
timestamp with time zone
NN
name    
varchar(255)
default_lang    
varchar(4)
NN
default_ttl    
bigint
NN
transcription_segments
Key
id    
bigserial
NN
Key
transcription_id    
bigint
NN
pos    
bigint
NN
seek    
float4
NN
start    
float8
NN
end    
float8
NN
text    
text
NN
temperature    
float4
NN
avg_logprob    
float8
NN
compression_ratio    
float4
NN
no_speech_prob    
float8
NN
confidence    
float8
NN
transcription_words
Key
id    
bigserial
NN
Key
segment_id    
bigint
NN
pos    
bigint
NN
start    
float8
NN
end    
float8
NN
text    
text
NN
confidence    
float8
NN
transcriptions
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
media_id    
bigint
NN
lang    
varchar(4)
status    
smallint
NN
reason    
text
transcription_language_probs
Key
id    
integer
NN
Key
transcription_id    
bigint
NN
Key
lang    
varchar(4)
NN
probability    
float8
NN
transcription_speech_activities
Key
id    
integer
NN
Key
transcription_id    
bigint
NN
pos    
bigint
NN
start    
float8
NN
end    
float8
NN
peer_connection_paths
Key
id    
bigserial
NN
Key
connection_id    
bigint
NN
Key
method    
smallint
NN
Key
path    
text
NN
type    
smallint
NN
encoding    
smallint
NN
param_schema    
jsonb
NN
Key
token_id    
bigint
peer_connections
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
peer_id    
bigint
NN
Key
key    
varchar(128)
NN
peers
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
owner_id    
bigint
NN
Key
host    
varchar(255)
NN
peer_access_tokens
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
peer_id    
bigint
NN
name    
varchar(255)
Key
key    
varchar(255)
Key
token    
varchar(255)
NN
is_active    
bool
NN
valid_until    
timestamp with time zone
peer_bearer_tokens
Key
id    
bigserial
NN
created_at    
timestamp with time zone
NN
Key
peer_id    
bigint
NN
token    
varchar(255)
NN
is_active    
bool
NN
valid_until    
timestamp with time zone
groups
Key
id    
bigserial
NN
Key
name    
varchar(255)
NN
user_group_links
Key
user_id    
bigint
NN
Key
group_id    
bigint
NN
roles
Key
id    
bigserial
NN
Key
name    
varchar(255)
NN
user_role_links
Key
user_id    
bigint
NN
Key
role_id    
bigint
NN
group_role_links
Key
group_id    
bigint
NN
Key
role_id    
bigint
NN
request_connection_links
Key
request_id    
bigint
NN
Key
connection_id    
bigint
NN
permissions
Key
id    
bigserial
NN
Key
role_id    
bigint
NN
Key
resource_key    
varchar(255)
NN
actions    
jsonb
NN
conditions    
jsonb
NN
request_document_links
Key
request_id    
bigint
NN
Key
document_id    
bigint
NN
workflows
Key
id    
bigserial
NN
Key
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
document_id    
bigint
NN
progress    
float8
NN
status    
smallint
NN
reason    
text
workflow_templates
Key
id    
bigserial
NN
Key
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
owner_id    
bigint
NN
template    
jsonb
NN
workflow_steps
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
Key
workflow_id    
bigint
NN
pos    
integer
NN
allow_if_previous_failed    
bool
NN
action    
varchar(255)
NN
topic_send    
varchar(255)
topic_receive    
varchar(255)
progress    
float8
NN
status    
smallint
NN
reason    
text
pipeline_producers
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
pipeline_id    
bigint
NN
name    
varchar(255)
client_id    
varchar(255)
NN
transactional_id    
varchar(255)
NN
pipeline_consumers
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
pipeline_id    
bigint
NN
name    
varchar(255)
client_id    
varchar(255)
NN
group_id    
varchar(255)
NN
pipeline_servers
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
pipeline_id    
bigint
NN
name    
varchar(255)
host    
varchar(255)
NN
port    
integer
NN
pipelines
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
settings_id    
varchar(127)
NN
name    
varchar(255)
pipeline_connectors
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
Key
pipeline_id    
bigint
NN
name    
varchar(255)
pipeline_options
Key
id    
bigserial
NN
Key
parent_id    
bigint
NN
Key
key    
varchar(255)
NN
value    
text
NN
type    
smallint
NN
pipeline_producer_options
Key
id    
bigserial
NN
Key
parent_id    
bigint
NN
Key
key    
varchar(255)
NN
value    
text
NN
type    
smallint
NN
pipeline_consumer_options
Key
id    
bigserial
NN
Key
parent_id    
bigint
NN
Key
key    
varchar(255)
NN
value    
text
NN
type    
smallint
NN
metadata_items
Key
id    
integer
NN
created_at    
timestamp with time zone
NN
key    
varchar(255)
NN
label    
varchar(255)
media_metadata_links
Key
media_id    
bigint
NN
Key
metadata_id    
bigint
NN
metadata_metadata_links
Key
parent_id    
bigint
NN
Key
child_id    
bigint
NN
Key
key    
varchar(255)
NN
label    
varchar(255)
pos    
integer
NN
metadata_item_properties
Key
id    
bigserial
NN
Key
item_id    
integer
NN
key    
varchar(255)
NN
label    
varchar(255)
value    
text
datatype    
metadata_property_datatype
NN
pos    
integer
NN
jobs
Key
id    
bigserial
NN
uuid    
varchar(64)
NN
created_at    
timestamp with time zone
NN
finished_at    
timestamp with time zone
Key
owner_id    
bigint
NN
action    
job_action
NN
async_request    
bool
NN
status    
record_status
NN
reason    
text
job_document_links
Key
job_id    
bigint
NN
Key
document_id    
bigint
NN
job_connection_links
Key
job_id    
bigint
NN
Key
connection_id    
bigint
NN

Document Type Values

  • 0 = Default / Not Set
  • 1 = Document Original
  • 2 = Document Related
  • 3 = Transcription Original
  • 4 = Transcription Related

Additional privileges

GRANT ALL ON DATABASE database_name TO database_user;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO database_user;

GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO database_user;

Media Type Values

  • 0 = Default / Not Set
  • 1 = Audio
  • 2 = Video
  • 3 = Audio Prepared
  • 4 = Video Prepared

CREATE USER "transposer_datapool_admin" WITH

 LOGIN

 NOSUPERUSER

 NOCREATEDB

 NOCREATEROLE

 INHERIT

 NOREPLICATION

 CONNECTION LIMIT -1

 PASSWORD '*******';

CREATE DATABASE transposer_datapool

 WITH 

 OWNER = transposer_datapool_admin

 ENCODING = 'UTF8'

 LC_COLLATE = 'en_US.utf8'

 LC_CTYPE = 'en_US.utf8'

 TABLESPACE = pg_default

 CONNECTION LIMIT = -1;

GRANT ALL ON DATABASE transposer_datapool TO transposer_datapool_admin;

DROP DATABASE transposer_datapool;

SELECT pg_terminate_backend(pg_stat_activity.pid)

FROM pg_stat_activity

WHERE pg_stat_activity.datname = 'transposer_datapool'

AND pid <> pg_backend_pid();

Document Type Values Addendum

It should be ough to only use Document and Transcription,because different languages can be related to the same document

  • 0 = Default / Not Set
  • 1 = Document
  • 2 = Transcription

HTTP Method Values

Data/Action Types

  • 0 = RESULT
  • 1 = STATUS
  • 2 = PROGRESS

HTML Form Encodings

  • 0 = NO BODY
  • 1 = URLENCODED
  • 2 = MULTIPART
  • 3 = PLAIN

Resource Actions (Permissions)

This is a JSON array. Possible values are:

  • 'read' = Read data
  • 'create' = Create new record
  • 'owner_list' = List records owned by user
  • 'owner_update' = Update records owned by user
  • 'owner_delete' = Delete records owned by user
  • 'list' = List records
  • 'update' = Update records
  • 'delete' = Delete records

Resource Conditions (Permissions)

This is a JSON object. Conditions allow to define additional rules, influencing the set actions.

Status Values

  • 0 = Default / Not Set
  • 1 = Created
  • 2 = In Progress
  • 3 = Done Success
  • 4 = Done Incomplete
  • 5 = Done Error

Media Type Values

  • 'none' = Default / Not Set
  • 'audio' = Audio
  • 'video' = Video
  • 'image' = Image
  • 'document' = Document
  • 'audio_prepared' = Audio Prepared
  • 'video_prepared' = Video Prepared
Enum
media_purpose
Purpose, the media is meant for
Enum
record_status
Status of a record
Enum
metadata_property_datatype
Datatypes of metadata item properties
Enum
job_action
Job actions define the tasks to perform.

Documentation for project Transposer Datapool
Transposer Datapool
Project
Name
Transposer Datapool
Diagram
Name
Main Diagram
Report
Generated
14.5.2024 | 21:19:28
tables
Name
captions
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
content_id
bigint
Yes
start
float8
Yes
Default value
-1.0
Description
timestamp in milliseconds
end
float8
Yes
Default value
-1.0
Description
timestamp in milliseconds
Keys
captions_pkey
Column in captions_pkey
id
Relations
Name
Parent
Child
captions_content_id_fkey
contents
captions
Name
users
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
modified_at
timestamp with time zone
Yes
Default value
now()
username
varchar
255
Yes
email
varchar
255
Yes
password
varchar
255
Yes
salt
varchar
255
Yes
display_name
varchar
255
is_active
bool
Yes
Default value
true
Keys
users_pkey
Column in users_pkey
id
users_unique_username
Column in users_unique_username
username
users_unique_email
Column in users_unique_email
email
users_unique_uuid
Column in users_unique_uuid
uuid
Relations
Name
Parent
Child
documents_owner_id_fkey
users
documents
requests_owner_id_fkey
users
requests
access_tokens_owner_id_fkey
users
access_tokens
bearer_tokens_owner_id_fkey
users
bearer_tokens
peers_owner_id_fkey
users
peers
user_group_links_user_id_fkey
users
user_group_links
user_role_links_user_id_fkey
users
user_role_links
workflow_templates_owner_id_fkey
users
workflow_templates
jobs_owner_id_fkey
users
jobs
Name
documents
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
modified_at
timestamp with time zone
Yes
Default value
now()
owner_id
bigint
Yes
type
smallint
Yes
Default value
0
status
smallint
Yes
Default value
0
reason
text
Keys
documents_pkey
Column in documents_pkey
id
documents_unique_uuid
Column in documents_unique_uuid
uuid
Relations
Name
Parent
Child
documents_owner_id_fkey
users
documents
contents_document_id_fkey
documents
contents
medias_document_id_fkey
documents
medias
request_document_links_document_id_fkey
documents
request_document_links
workflows_document_id_fkey
documents
workflows
job_document_links_document_id_fkey
documents
job_document_links
Name
requests
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
owner_id
bigint
Yes
peer_args
jsonb
Yes
Default value
'{}'
Description
Optional arguments, sent alongside the request. These arguments will be interpolated into the path and sent back as part of the body.
is_async
bool
Yes
Default value
false
status
smallint
Yes
Default value
0
reason
text
Keys
requests_pkey
Column in requests_pkey
id
Relations
Name
Parent
Child
requests_owner_id_fkey
users
requests
request_connection_links_request_id_fkey
requests
request_connection_links
request_document_links_request_id_fkey
requests
request_document_links
Name
contents
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
document_id
bigint
Yes
pos
bigint
Yes
Default value
0
lang
varchar
4
is_original
bool
Yes
Default value
false
key
varchar
128
Yes
value
text
Yes
confidence
float8
Yes
Default value
-1.0
status
smallint
Yes
Default value
0
reason
text
Keys
contents_pkey
Column in contents_pkey
id
Relations
Name
Parent
Child
contents_document_id_fkey
documents
contents
captions_content_id_fkey
contents
captions
Name
medias
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
document_id
bigint
Yes
uri
text
path
text
Yes
filename
text
Yes
title
text
Yes
cid
varchar
64
Yes
mime
varchar
96
Yes
extension
varchar
32
Yes
size
bigint
Yes
Default value
0
duration
float8
Yes
Default value
0.0
purpose
media_purpose
Yes
Default value
'original'
Description
Purpose of this media
status
smallint
Yes
Default value
0
reason
text
Keys
medias_pkey
Column in medias_pkey
id
medias_unique_uri
Column in medias_unique_uri
uri
medias_unique_cid
Column in medias_unique_cid
cid
medias_unique_uuid
Column in medias_unique_uuid
uuid
medias_unique_path
Column in medias_unique_path
path
Relations
Name
Parent
Child
medias_document_id_fkey
documents
medias
transcriptions_media_id_fkey
medias
transcriptions
media_metadata_links_media_id_fkey
medias
media_metadata_links
Name
access_tokens
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
owner_id
bigint
Yes
name
varchar
255
key
varchar
255
Yes
token
varchar
255
Yes
is_active
bool
Yes
Default value
true
valid_until
timestamp with time zone
Keys
access_tokens_pkey
Column in access_tokens_pkey
id
access_tokens_unique_owner_id_key
Column in access_tokens_unique_owner_id_key
owner_id
Column in access_tokens_unique_owner_id_key
key
access_tokens_unique_owner_id_token
Column in access_tokens_unique_owner_id_token
owner_id
Column in access_tokens_unique_owner_id_token
token
Relations
Name
Parent
Child
access_tokens_owner_id_fkey
users
access_tokens
Name
bearer_tokens
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
owner_id
bigint
Yes
token
varchar
255
Yes
is_active
bool
Yes
Default value
true
valid_until
timestamp with time zone
Keys
bearer_tokens_pkey
Column in bearer_tokens_pkey
id
Relations
Name
Parent
Child
bearer_tokens_owner_id_fkey
users
bearer_tokens
Name
settings
Columns
Name
Data type
Param
Key
Not Null
id
varchar
127
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
modified_at
timestamp with time zone
Yes
Default value
now()
name
varchar
255
default_lang
varchar
4
Yes
Default value
'en'
default_ttl
bigint
Yes
Default value
3600000
Keys
settings_pkey
Column in settings_pkey
id
Relations
Name
Parent
Child
pipelines_settings_id_fkey
settings
pipelines
Name
transcription_segments
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
transcription_id
bigint
Yes
pos
bigint
Yes
Default value
0
seek
float4
Yes
Default value
-1.0
start
float8
Yes
Default value
-1.0
end
float8
Yes
Default value
-1.0
text
text
Yes
temperature
float4
Yes
Default value
-1.0
avg_logprob
float8
Yes
Default value
-1.0
compression_ratio
float4
Yes
Default value
-1.0
no_speech_prob
float8
Yes
Default value
-1.0
confidence
float8
Yes
Default value
-1.0
Keys
transcription_segments_pkey
Column in transcription_segments_pkey
id
Relations
Name
Parent
Child
transcription_words_segment_id_fkey
transcription_segments
transcription_words
transcription_segments_transcription_id_fkey
transcriptions
transcription_segments
Name
transcription_words
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
segment_id
bigint
Yes
pos
bigint
Yes
Default value
0
start
float8
Yes
Default value
-1.0
end
float8
Yes
Default value
-1.0
text
text
Yes
confidence
float8
Yes
Default value
-1.0
Keys
transcription_words_pkey
Column in transcription_words_pkey
id
Relations
Name
Parent
Child
transcription_words_segment_id_fkey
transcription_segments
transcription_words
Name
transcriptions
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
media_id
bigint
Yes
lang
varchar
4
status
smallint
Yes
Default value
0
reason
text
Keys
transcriptions_pkey
Column in transcriptions_pkey
id
Relations
Name
Parent
Child
transcription_segments_transcription_id_fkey
transcriptions
transcription_segments
transcription_language_probs_transcription_id_fkey
transcriptions
transcription_language_probs
transcription_speech_activities_transcription_id_fkey
transcriptions
transcription_speech_activities
transcriptions_media_id_fkey
medias
transcriptions
Name
transcription_language_probs
Columns
Name
Data type
Param
Key
Not Null
id
integer
Yes
Yes
transcription_id
bigint
Yes
lang
varchar
4
Yes
probability
float8
Yes
Default value
-1.0
Keys
transcription_language_probs_pkey
Column in transcription_language_probs_pkey
id
transcription_language_probs_unique_transcription_lang
Column in transcription_language_probs_unique_transcription_lang
transcription_id
Column in transcription_language_probs_unique_transcription_lang
lang
Relations
Name
Parent
Child
transcription_language_probs_transcription_id_fkey
transcriptions
transcription_language_probs
Name
transcription_speech_activities
Columns
Name
Data type
Param
Key
Not Null
id
integer
Yes
Yes
transcription_id
bigint
Yes
pos
bigint
Yes
Default value
0
start
float8
Yes
Default value
-1.0
end
float8
Yes
Default value
-1.0
Keys
transcription_speech_activities_pkey
Column in transcription_speech_activities_pkey
id
Relations
Name
Parent
Child
transcription_speech_activities_transcription_id_fkey
transcriptions
transcription_speech_activities
Name
peer_connection_paths
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
connection_id
bigint
Yes
method
smallint
Yes
Default value
0
Description
HTTP method
path
text
Yes
Description
Path part of the URL. Can contain placeholders for interpolation.
type
smallint
Yes
Default value
0
Description
Data/Action type using this connection
encoding
smallint
Yes
Default value
0
Description
HTML form encoding
param_schema
jsonb
Yes
Default value
'{}'
Description
String, representing a template for the data
token_id
bigint
Keys
peer_connection_paths_pkey
Column in peer_connection_paths_pkey
id
peer_connection_paths_unique_connection_method_path
Column in peer_connection_paths_unique_connection_method_path
connection_id
Column in peer_connection_paths_unique_connection_method_path
method
Column in peer_connection_paths_unique_connection_method_path
path
Relations
Name
Parent
Child
peer_connection_paths_connection_id_fkey
peer_connections
peer_connection_paths
peer_connection_paths_token_id_fkey
peer_access_tokens
peer_connection_paths
Name
peer_connections
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
peer_id
bigint
Yes
key
varchar
128
Yes
Keys
peer_connections_pkey
Column in peer_connections_pkey
id
data_connections_unique_peer_key
Column in data_connections_unique_peer_key
peer_id
Column in data_connections_unique_peer_key
key
Relations
Name
Parent
Child
peer_connection_paths_connection_id_fkey
peer_connections
peer_connection_paths
peer_connections_peer_id_fkey
peers
peer_connections
request_connection_links_connection_id_fkey
peer_connections
request_connection_links
job_connection_links_connection_id_fkey
peer_connections
job_connection_links
Name
peers
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
owner_id
bigint
Yes
host
varchar
255
Yes
Keys
peers_pkey
Column in peers_pkey
id
data_peers_unique_owner_domain
Column in data_peers_unique_owner_domain
owner_id
Column in data_peers_unique_owner_domain
host
Relations
Name
Parent
Child
peers_owner_id_fkey
users
peers
peer_connections_peer_id_fkey
peers
peer_connections
peer_access_tokens_peer_id_fkey
peers
peer_access_tokens
peer_bearer_tokens_peer_id_fkey
peers
peer_bearer_tokens
Name
peer_access_tokens
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
peer_id
bigint
Yes
name
varchar
255
key
varchar
255
token
varchar
255
Yes
is_active
bool
Yes
Default value
true
valid_until
timestamp with time zone
Keys
peer_access_tokens_pkey
Column in peer_access_tokens_pkey
id
peer_access_tokens_peer_id_key_key
Column in peer_access_tokens_peer_id_key_key
peer_id
Column in peer_access_tokens_peer_id_key_key
key
peer_access_tokens_peer_id_token_key
Column in peer_access_tokens_peer_id_token_key
peer_id
Column in peer_access_tokens_peer_id_token_key
token
Relations
Name
Parent
Child
peer_access_tokens_peer_id_fkey
peers
peer_access_tokens
peer_connection_paths_token_id_fkey
peer_access_tokens
peer_connection_paths
Name
peer_bearer_tokens
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
peer_id
bigint
Yes
token
varchar
255
Yes
is_active
bool
Yes
Default value
true
valid_until
timestamp with time zone
Keys
peer_bearer_tokens_pkey
Column in peer_bearer_tokens_pkey
id
Relations
Name
Parent
Child
peer_bearer_tokens_peer_id_fkey
peers
peer_bearer_tokens
Name
groups
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
name
varchar
255
Yes
Keys
groups_pkey
Column in groups_pkey
id
groups_unique_name
Column in groups_unique_name
name
Relations
Name
Parent
Child
user_group_links_group_id_fkey
groups
user_group_links
group_role_links_group_id_fkey
groups
group_role_links
Name
user_group_links
Columns
Name
Data type
Param
Key
Not Null
user_id
bigint
Yes
Yes
group_id
bigint
Yes
Yes
Keys
user_group_links_pkey
Column in user_group_links_pkey
user_id
Column in user_group_links_pkey
group_id
Relations
Name
Parent
Child
user_group_links_user_id_fkey
users
user_group_links
user_group_links_group_id_fkey
groups
user_group_links
Name
roles
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
name
varchar
255
Yes
Keys
roles_pkey
Column in roles_pkey
id
roles_unique_name
Column in roles_unique_name
name
Relations
Name
Parent
Child
user_role_links_role_id_fkey
roles
user_role_links
group_role_links_role_id_fkey
roles
group_role_links
permissions_role_id_fkey
roles
permissions
Name
user_role_links
Columns
Name
Data type
Param
Key
Not Null
user_id
bigint
Yes
Yes
role_id
bigint
Yes
Yes
Keys
user_role_links_pkey
Column in user_role_links_pkey
user_id
Column in user_role_links_pkey
role_id
Relations
Name
Parent
Child
user_role_links_user_id_fkey
users
user_role_links
user_role_links_role_id_fkey
roles
user_role_links
Name
group_role_links
Columns
Name
Data type
Param
Key
Not Null
group_id
bigint
Yes
Yes
role_id
bigint
Yes
Yes
Keys
group_role_links_pkey
Column in group_role_links_pkey
group_id
Column in group_role_links_pkey
role_id
Relations
Name
Parent
Child
group_role_links_group_id_fkey
groups
group_role_links
group_role_links_role_id_fkey
roles
group_role_links
Name
request_connection_links
Columns
Name
Data type
Param
Key
Not Null
request_id
bigint
Yes
Yes
connection_id
bigint
Yes
Yes
Keys
request_connection_links_pkey
Column in request_connection_links_pkey
request_id
Column in request_connection_links_pkey
connection_id
Relations
Name
Parent
Child
request_connection_links_request_id_fkey
requests
request_connection_links
request_connection_links_connection_id_fkey
peer_connections
request_connection_links
Name
permissions
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
role_id
bigint
Yes
resource_key
varchar
255
Yes
actions
jsonb
Yes
Default value
'[]'
conditions
jsonb
Yes
Default value
'{}'
Keys
permissions_pkey
Column in permissions_pkey
id
permissions_unique_role_id_resource_key
Column in permissions_unique_role_id_resource_key
role_id
Column in permissions_unique_role_id_resource_key
resource_key
Relations
Name
Parent
Child
permissions_role_id_fkey
roles
permissions
Name
request_document_links
Columns
Name
Data type
Param
Key
Not Null
request_id
bigint
Yes
Yes
document_id
bigint
Yes
Yes
Keys
request_document_links_pkey
Column in request_document_links_pkey
request_id
Column in request_document_links_pkey
document_id
Relations
Name
Parent
Child
request_document_links_request_id_fkey
requests
request_document_links
request_document_links_document_id_fkey
documents
request_document_links
Name
workflows
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
document_id
bigint
Yes
progress
float8
Yes
Default value
0.0
status
smallint
Yes
Default value
0
reason
text
Keys
workflows_pkey
Column in workflows_pkey
id
workflows_unique_uuid
Column in workflows_unique_uuid
uuid
Relations
Name
Parent
Child
workflow_steps_workflow_id_fkey
workflows
workflow_steps
workflows_document_id_fkey
documents
workflows
Name
workflow_templates
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
owner_id
bigint
Yes
template
jsonb
Yes
Default value
'{}'
Keys
workflow_templates_pkey
Column in workflow_templates_pkey
id
workflow_templates_unique_uuid
Column in workflow_templates_unique_uuid
uuid
Relations
Name
Parent
Child
workflow_templates_owner_id_fkey
users
workflow_templates
Name
workflow_steps
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
workflow_id
bigint
Yes
pos
integer
Yes
Default value
0
allow_if_previous_failed
bool
Yes
Default value
false
action
varchar
255
Yes
topic_send
varchar
255
topic_receive
varchar
255
progress
float8
Yes
Default value
0.0
status
smallint
Yes
Default value
0
reason
text
Keys
workflow_steps_pkey
Column in workflow_steps_pkey
id
Relations
Name
Parent
Child
workflow_steps_workflow_id_fkey
workflows
workflow_steps
Name
pipeline_producers
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
pipeline_id
bigint
Yes
name
varchar
255
client_id
varchar
255
Yes
Description
Client identifier. Default value will be a UUIDv4.
transactional_id
varchar
255
Yes
Description
System uses transactional producers. Default value will be a UUIDv4.
Keys
pipeline_producers_pkey
Column in pipeline_producers_pkey
id
Relations
Name
Parent
Child
pipeline_producers_pipeline_id_fkey
pipelines
pipeline_producers
pipeline_producer_options_parent_id_fkey
pipeline_producers
pipeline_producer_options
Name
pipeline_consumers
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
pipeline_id
bigint
Yes
name
varchar
255
client_id
varchar
255
Yes
Description
Client identifier. Default value will be a UUIDv4.
group_id
varchar
255
Yes
Description
Group identifier. Default value will be a UUIDv4, which will build groups of 1.
Keys
pipeline_consumers_pkey
Column in pipeline_consumers_pkey
id
Relations
Name
Parent
Child
pipeline_consumers_pipeline_id_fkey
pipelines
pipeline_consumers
pipeline_consumer_options_parent_id_fkey
pipeline_consumers
pipeline_consumer_options
Name
pipeline_servers
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
pipeline_id
bigint
Yes
name
varchar
255
host
varchar
255
Yes
Default value
'127.0.0.1'
port
integer
Yes
Default value
9092
Keys
pipeline_servers_pkey
Column in pipeline_servers_pkey
id
Relations
Name
Parent
Child
pipeline_servers_pipeline_id_fkey
pipelines
pipeline_servers
Name
pipelines
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
settings_id
varchar
127
Yes
name
varchar
255
Keys
pipelines_pkey
Column in pipelines_pkey
id
Relations
Name
Parent
Child
pipelines_settings_id_fkey
settings
pipelines
pipeline_producers_pipeline_id_fkey
pipelines
pipeline_producers
pipeline_consumers_pipeline_id_fkey
pipelines
pipeline_consumers
pipeline_servers_pipeline_id_fkey
pipelines
pipeline_servers
pipeline_connectors_pipeline_id_fkey
pipelines
pipeline_connectors
pipeline_options_parent_id_fkey
pipelines
pipeline_options
Name
pipeline_connectors
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
pipeline_id
bigint
Yes
name
varchar
255
Keys
pipeline_connectors_pkey
Column in pipeline_connectors_pkey
id
Relations
Name
Parent
Child
pipeline_connectors_pipeline_id_fkey
pipelines
pipeline_connectors
Name
pipeline_options
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
parent_id
bigint
Yes
key
varchar
255
Yes
value
text
Yes
type
smallint
Yes
Default value
0
Description
Data type of 'value': 0: String (default) 1: Integer 2: Float 3: Boolean 4: JSON 5: CSV 6: XML Data will get interpreted according to this type.
Keys
pipeline_options_pkey
Column in pipeline_options_pkey
id
pipeline_options_unique_parent_id_key
Column in pipeline_options_unique_parent_id_key
parent_id
Column in pipeline_options_unique_parent_id_key
key
Relations
Name
Parent
Child
pipeline_options_parent_id_fkey
pipelines
pipeline_options
Name
pipeline_producer_options
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
parent_id
bigint
Yes
key
varchar
255
Yes
value
text
Yes
type
smallint
Yes
Default value
0
Description
Data type of 'value': 0: String (default) 1: Integer 2: Float 3: Boolean 4: JSON 5: CSV 6: XML Data will get interpreted according to this type.
Keys
pipeline_producer_options_pkey
Column in pipeline_producer_options_pkey
id
pipeline_producer_options_unique_parent_id_key
Column in pipeline_producer_options_unique_parent_id_key
parent_id
Column in pipeline_producer_options_unique_parent_id_key
key
Relations
Name
Parent
Child
pipeline_producer_options_parent_id_fkey
pipeline_producers
pipeline_producer_options
Name
pipeline_consumer_options
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
parent_id
bigint
Yes
key
varchar
255
Yes
value
text
Yes
type
smallint
Yes
Default value
0
Description
Data type of 'value': 0: String (default) 1: Integer 2: Float 3: Boolean 4: JSON 5: CSV 6: XML Data will get interpreted according to this type.
Keys
pipeline_consumer_options_pkey
Column in pipeline_consumer_options_pkey
id
pipeline_consumer_options_unique_parent_id_key
Column in pipeline_consumer_options_unique_parent_id_key
parent_id
Column in pipeline_consumer_options_unique_parent_id_key
key
Relations
Name
Parent
Child
pipeline_consumer_options_parent_id_fkey
pipeline_consumers
pipeline_consumer_options
Name
metadata_items
Columns
Name
Data type
Param
Key
Not Null
id
integer
Yes
Yes
created_at
timestamp with time zone
Yes
Default value
now()
key
varchar
255
Yes
label
varchar
255
Keys
metadata_items_pkey
Column in metadata_items_pkey
id
Relations
Name
Parent
Child
media_metadata_links_metadata_id_fkey
metadata_items
media_metadata_links
metadata_metadata_links_parent_id_fkey
metadata_items
metadata_metadata_links
metadata_metadata_links_child_id_fkey
metadata_items
metadata_metadata_links
metadata_item_properties_item_id_fkey
metadata_items
metadata_item_properties
Name
media_metadata_links
Columns
Name
Data type
Param
Key
Not Null
media_id
bigint
Yes
Yes
metadata_id
bigint
Yes
Yes
Keys
media_metadata_links_pkey
Column in media_metadata_links_pkey
media_id
Relations
Name
Parent
Child
media_metadata_links_media_id_fkey
medias
media_metadata_links
media_metadata_links_metadata_id_fkey
metadata_items
media_metadata_links
Name
metadata_metadata_links
Columns
Name
Data type
Param
Key
Not Null
parent_id
bigint
Yes
Yes
child_id
bigint
Yes
Yes
key
varchar
255
Yes
Yes
label
varchar
255
pos
integer
Yes
Default value
0
Keys
metadata_metadata_links_pkey
Column in metadata_metadata_links_pkey
parent_id
Column in metadata_metadata_links_pkey
child_id
Column in metadata_metadata_links_pkey
key
Relations
Name
Parent
Child
metadata_metadata_links_parent_id_fkey
metadata_items
metadata_metadata_links
metadata_metadata_links_child_id_fkey
metadata_items
metadata_metadata_links
Name
metadata_item_properties
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
item_id
integer
Yes
key
varchar
255
Yes
label
varchar
255
value
text
datatype
metadata_property_datatype
Yes
Default value
'string'
pos
integer
Yes
Default value
0
Keys
metadata_item_properties_pkey
Column in metadata_item_properties_pkey
id
Relations
Name
Parent
Child
metadata_item_properties_item_id_fkey
metadata_items
metadata_item_properties
Name
jobs
Columns
Name
Data type
Param
Key
Not Null
id
bigserial
Yes
Yes
uuid
varchar
64
Yes
created_at
timestamp with time zone
Yes
Default value
now()
finished_at
timestamp with time zone
owner_id
bigint
Yes
action
job_action
Yes
Default value
'transcribe'
async_request
bool
Yes
Default value
false
status
record_status
Yes
Default value
'undefined'
reason
text
Keys
jobs_pkey
Column in jobs_pkey
id
Relations
Name
Parent
Child
jobs_owner_id_fkey
users
jobs
job_document_links_job_id_fkey
jobs
job_document_links
job_connection_links_job_id_fkey
jobs
job_connection_links
Name
job_document_links
Columns
Name
Data type
Param
Key
Not Null
job_id
bigint
Yes
Yes
document_id
bigint
Yes
Yes
Keys
job_document_links_pkey
Column in job_document_links_pkey
job_id
Column in job_document_links_pkey
document_id
Relations
Name
Parent
Child
job_document_links_job_id_fkey
jobs
job_document_links
job_document_links_document_id_fkey
documents
job_document_links
Name
job_connection_links
Columns
Name
Data type
Param
Key
Not Null
job_id
bigint
Yes
Yes
connection_id
bigint
Yes
Yes
Keys
job_connection_links_pkey
Column in job_connection_links_pkey
job_id
Column in job_connection_links_pkey
connection_id
Relations
Name
Parent
Child
job_connection_links_connection_id_fkey
peer_connections
job_connection_links
job_connection_links_job_id_fkey
jobs
job_connection_links
relationships
Name
documents_owner_id_fkey
Name
Source
Target
documents_owner_id_fkey
users
documents
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in documents
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
requests_owner_id_fkey
Name
Source
Target
requests_owner_id_fkey
users
requests
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in requests
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
contents_document_id_fkey
Name
Source
Target
contents_document_id_fkey
documents
contents
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in contents
documents_pkey
id
document_id
Properties
Rerefential integrity - parent delete
Cascade
Name
medias_document_id_fkey
Name
Source
Target
medias_document_id_fkey
documents
medias
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in medias
documents_pkey
id
document_id
Properties
Rerefential integrity - parent delete
Cascade
Name
captions_content_id_fkey
Name
Source
Target
captions_content_id_fkey
contents
captions
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in contents
Column in captions
contents_pkey
id
content_id
Properties
Rerefential integrity - parent delete
Cascade
Name
access_tokens_owner_id_fkey
Name
Source
Target
access_tokens_owner_id_fkey
users
access_tokens
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in access_tokens
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
bearer_tokens_owner_id_fkey
Name
Source
Target
bearer_tokens_owner_id_fkey
users
bearer_tokens
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in bearer_tokens
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
transcription_words_segment_id_fkey
Name
Source
Target
transcription_words_segment_id_fkey
transcription_segments
transcription_words
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in transcription_segments
Column in transcription_words
transcription_segments_pkey
id
segment_id
Properties
Rerefential integrity - parent delete
Cascade
Name
transcription_segments_transcription_id_fkey
Name
Source
Target
transcription_segments_transcription_id_fkey
transcriptions
transcription_segments
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in transcriptions
Column in transcription_segments
transcriptions_pkey
id
transcription_id
Properties
Rerefential integrity - parent delete
Cascade
Name
transcription_language_probs_transcription_id_fkey
Name
Source
Target
transcription_language_probs_transcription_id_fkey
transcriptions
transcription_language_probs
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in transcriptions
Column in transcription_language_probs
transcriptions_pkey
id
transcription_id
Properties
Rerefential integrity - parent delete
Cascade
Name
transcription_speech_activities_transcription_id_fkey
Name
Source
Target
transcription_speech_activities_transcription_id_fkey
transcriptions
transcription_speech_activities
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in transcriptions
Column in transcription_speech_activities
transcriptions_pkey
id
transcription_id
Properties
Rerefential integrity - parent delete
Cascade
Name
peer_connection_paths_connection_id_fkey
Name
Source
Target
peer_connection_paths_connection_id_fkey
peer_connections
peer_connection_paths
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peer_connections
Column in peer_connection_paths
peer_connections_pkey
id
connection_id
Properties
Rerefential integrity - parent delete
Cascade
Name
peers_owner_id_fkey
Name
Source
Target
peers_owner_id_fkey
users
peers
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in peers
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
peer_connections_peer_id_fkey
Name
Source
Target
peer_connections_peer_id_fkey
peers
peer_connections
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peers
Column in peer_connections
peers_pkey
id
peer_id
Properties
Rerefential integrity - parent delete
Cascade
Name
peer_access_tokens_peer_id_fkey
Name
Source
Target
peer_access_tokens_peer_id_fkey
peers
peer_access_tokens
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peers
Column in peer_access_tokens
peers_pkey
id
peer_id
Properties
Rerefential integrity - parent delete
Cascade
Name
peer_bearer_tokens_peer_id_fkey
Name
Source
Target
peer_bearer_tokens_peer_id_fkey
peers
peer_bearer_tokens
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peers
Column in peer_bearer_tokens
peers_pkey
id
peer_id
Properties
Rerefential integrity - parent delete
Cascade
Name
user_group_links_user_id_fkey
Name
Source
Target
user_group_links_user_id_fkey
users
user_group_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in user_group_links
users_pkey
id
user_id
Properties
Rerefential integrity - parent delete
Cascade
Name
user_group_links_group_id_fkey
Name
Source
Target
user_group_links_group_id_fkey
groups
user_group_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in groups
Column in user_group_links
groups_pkey
id
group_id
Properties
Rerefential integrity - parent delete
Cascade
Name
user_role_links_user_id_fkey
Name
Source
Target
user_role_links_user_id_fkey
users
user_role_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in user_role_links
users_pkey
id
user_id
Properties
Rerefential integrity - parent delete
Cascade
Name
user_role_links_role_id_fkey
Name
Source
Target
user_role_links_role_id_fkey
roles
user_role_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in roles
Column in user_role_links
roles_pkey
id
role_id
Properties
Rerefential integrity - parent delete
Cascade
Name
group_role_links_group_id_fkey
Name
Source
Target
group_role_links_group_id_fkey
groups
group_role_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in groups
Column in group_role_links
groups_pkey
id
group_id
Properties
Rerefential integrity - parent delete
Cascade
Name
group_role_links_role_id_fkey
Name
Source
Target
group_role_links_role_id_fkey
roles
group_role_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in roles
Column in group_role_links
roles_pkey
id
role_id
Properties
Rerefential integrity - parent delete
Cascade
Name
transcriptions_media_id_fkey
Name
Source
Target
transcriptions_media_id_fkey
medias
transcriptions
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in medias
Column in transcriptions
medias_pkey
id
media_id
Properties
Rerefential integrity - parent delete
Cascade
Name
request_connection_links_request_id_fkey
Name
Source
Target
request_connection_links_request_id_fkey
requests
request_connection_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in requests
Column in request_connection_links
requests_pkey
id
request_id
Properties
Rerefential integrity - parent delete
Cascade
Name
request_connection_links_connection_id_fkey
Name
Source
Target
request_connection_links_connection_id_fkey
peer_connections
request_connection_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peer_connections
Column in request_connection_links
peer_connections_pkey
id
connection_id
Properties
Rerefential integrity - parent delete
Cascade
Name
permissions_role_id_fkey
Name
Source
Target
permissions_role_id_fkey
roles
permissions
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in roles
Column in permissions
roles_pkey
id
role_id
Properties
Rerefential integrity - parent delete
Cascade
Name
request_document_links_request_id_fkey
Name
Source
Target
request_document_links_request_id_fkey
requests
request_document_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in requests
Column in request_document_links
requests_pkey
id
request_id
Properties
Rerefential integrity - parent delete
Cascade
Name
request_document_links_document_id_fkey
Name
Source
Target
request_document_links_document_id_fkey
documents
request_document_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in request_document_links
documents_pkey
id
document_id
Properties
Rerefential integrity - parent delete
Cascade
Name
peer_connection_paths_token_id_fkey
Name
Source
Target
peer_connection_paths_token_id_fkey
peer_access_tokens
peer_connection_paths
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peer_access_tokens
Column in peer_connection_paths
peer_access_tokens_pkey
id
token_id
Properties
Rerefential integrity - parent delete
Set null
Name
workflow_steps_workflow_id_fkey
Name
Source
Target
workflow_steps_workflow_id_fkey
workflows
workflow_steps
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in workflows
Column in workflow_steps
workflows_pkey
id
workflow_id
Properties
Rerefential integrity - parent delete
Cascade
Name
workflow_templates_owner_id_fkey
Name
Source
Target
workflow_templates_owner_id_fkey
users
workflow_templates
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in workflow_templates
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
workflows_document_id_fkey
Name
Source
Target
workflows_document_id_fkey
documents
workflows
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in workflows
documents_pkey
id
document_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipelines_settings_id_fkey
Name
Source
Target
pipelines_settings_id_fkey
settings
pipelines
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in settings
Column in pipelines
settings_pkey
id
settings_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_producers_pipeline_id_fkey
Name
Source
Target
pipeline_producers_pipeline_id_fkey
pipelines
pipeline_producers
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipelines
Column in pipeline_producers
pipelines_pkey
id
pipeline_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_consumers_pipeline_id_fkey
Name
Source
Target
pipeline_consumers_pipeline_id_fkey
pipelines
pipeline_consumers
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipelines
Column in pipeline_consumers
pipelines_pkey
id
pipeline_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_servers_pipeline_id_fkey
Name
Source
Target
pipeline_servers_pipeline_id_fkey
pipelines
pipeline_servers
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipelines
Column in pipeline_servers
pipelines_pkey
id
pipeline_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_connectors_pipeline_id_fkey
Name
Source
Target
pipeline_connectors_pipeline_id_fkey
pipelines
pipeline_connectors
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipelines
Column in pipeline_connectors
pipelines_pkey
id
pipeline_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_options_parent_id_fkey
Name
Source
Target
pipeline_options_parent_id_fkey
pipelines
pipeline_options
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipelines
Column in pipeline_options
pipelines_pkey
id
parent_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_producer_options_parent_id_fkey
Name
Source
Target
pipeline_producer_options_parent_id_fkey
pipeline_producers
pipeline_producer_options
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipeline_producers
Column in pipeline_producer_options
pipeline_producers_pkey
id
parent_id
Properties
Rerefential integrity - parent delete
Cascade
Name
pipeline_consumer_options_parent_id_fkey
Name
Source
Target
pipeline_consumer_options_parent_id_fkey
pipeline_consumers
pipeline_consumer_options
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in pipeline_consumers
Column in pipeline_consumer_options
pipeline_consumers_pkey
id
parent_id
Properties
Rerefential integrity - parent delete
Cascade
Name
media_metadata_links_media_id_fkey
Name
Source
Target
media_metadata_links_media_id_fkey
medias
media_metadata_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in medias
Column in media_metadata_links
medias_pkey
id
media_id
Properties
Rerefential integrity - parent delete
Cascade
Name
media_metadata_links_metadata_id_fkey
Name
Source
Target
media_metadata_links_metadata_id_fkey
metadata_items
media_metadata_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in metadata_items
Column in media_metadata_links
metadata_items_pkey
id
metadata_id
Properties
Rerefential integrity - parent delete
Cascade
Name
metadata_metadata_links_parent_id_fkey
Name
Source
Target
metadata_metadata_links_parent_id_fkey
metadata_items
metadata_metadata_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in metadata_items
Column in metadata_metadata_links
metadata_items_pkey
id
parent_id
Properties
Rerefential integrity - parent delete
Cascade
Name
metadata_metadata_links_child_id_fkey
Name
Source
Target
metadata_metadata_links_child_id_fkey
metadata_items
metadata_metadata_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in metadata_items
Column in metadata_metadata_links
metadata_items_pkey
id
child_id
Properties
Rerefential integrity - parent delete
Cascade
Name
metadata_item_properties_item_id_fkey
Name
Source
Target
metadata_item_properties_item_id_fkey
metadata_items
metadata_item_properties
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in metadata_items
Column in metadata_item_properties
metadata_items_pkey
id
item_id
Properties
Rerefential integrity - parent delete
Cascade
Name
jobs_owner_id_fkey
Name
Source
Target
jobs_owner_id_fkey
users
jobs
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in jobs
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
job_document_links_job_id_fkey
Name
Source
Target
job_document_links_job_id_fkey
jobs
job_document_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in jobs
Column in job_document_links
jobs_pkey
id
job_id
Properties
Rerefential integrity - parent delete
Cascade
Name
job_document_links_document_id_fkey
Name
Source
Target
job_document_links_document_id_fkey
documents
job_document_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in job_document_links
documents_pkey
id
document_id
Properties
Rerefential integrity - parent delete
Cascade
Name
job_connection_links_connection_id_fkey
Name
Source
Target
job_connection_links_connection_id_fkey
peer_connections
job_connection_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in peer_connections
Column in job_connection_links
peer_connections_pkey
id
connection_id
Properties
Rerefential integrity - parent delete
Cascade
Name
job_connection_links_job_id_fkey
Name
Source
Target
job_connection_links_job_id_fkey
jobs
job_connection_links
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in jobs
Column in job_connection_links
jobs_pkey
id
job_id
Properties
Rerefential integrity - parent delete
Cascade
Other objects
Name
media_purpose
Type
Enum
Description
Purpose, the media is meant for
Enum values
'original','transcription'
Name
record_status
Type
Enum
Description
Status of a record
Enum values
'undefined','created','processing','canceled','success','incomplete','error'
Name
metadata_property_datatype
Type
Enum
Description
Datatypes of metadata item properties
Enum values
'string','integer','float','json'
Name
job_action
Type
Enum
Description
Job actions define the tasks to perform.
Enum values
'transcribe','translate'
Notes
Name
Document Type Values
Note

Document Type Values

  • 0 = Default / Not Set
  • 1 = Document Original
  • 2 = Document Related
  • 3 = Transcription Original
  • 4 = Transcription Related
Name
Additional Privileges
Note

Additional privileges

GRANT ALL ON DATABASE database_name TO database_user;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO database_user;

GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO database_user;

Name
Media Type Values
Note

Media Type Values

  • 0 = Default / Not Set
  • 1 = Audio
  • 2 = Video
  • 3 = Audio Prepared
  • 4 = Video Prepared
Name
CREATE transposer_datapool_admin
Note

CREATE USER "transposer_datapool_admin" WITH

 LOGIN

 NOSUPERUSER

 NOCREATEDB

 NOCREATEROLE

 INHERIT

 NOREPLICATION

 CONNECTION LIMIT -1

 PASSWORD '*******';

Name
CREATE DATABASE transposer_datapool
Note

CREATE DATABASE transposer_datapool

 WITH 

 OWNER = transposer_datapool_admin

 ENCODING = 'UTF8'

 LC_COLLATE = 'en_US.utf8'

 LC_CTYPE = 'en_US.utf8'

 TABLESPACE = pg_default

 CONNECTION LIMIT = -1;

Name
CREATE DATABASE transposer_datapool1
Note

GRANT ALL ON DATABASE transposer_datapool TO transposer_datapool_admin;

Name
CREATE DATABASE transposer_datapool2
Note

DROP DATABASE transposer_datapool;

Name
CREATE DATABASE transposer_datapool3
Note

SELECT pg_terminate_backend(pg_stat_activity.pid)

FROM pg_stat_activity

WHERE pg_stat_activity.datname = 'transposer_datapool'

AND pid <> pg_backend_pid();

Name
Document Type Values - Addendum
Note

Document Type Values Addendum

It should be ough to only use Document and Transcription,because different languages can be related to the same document

  • 0 = Default / Not Set
  • 1 = Document
  • 2 = Transcription
Name
HTTP Method Values
Note

HTTP Method Values

Name
Data/Action Types
Note

Data/Action Types

  • 0 = RESULT
  • 1 = STATUS
  • 2 = PROGRESS
Name
HTML Form Encodings
Note

HTML Form Encodings

  • 0 = NO BODY
  • 1 = URLENCODED
  • 2 = MULTIPART
  • 3 = PLAIN
Name
Resource Actions (Permissions)
Note

Resource Actions (Permissions)

This is a JSON array. Possible values are:

  • 'read' = Read data
  • 'create' = Create new record
  • 'owner_list' = List records owned by user
  • 'owner_update' = Update records owned by user
  • 'owner_delete' = Delete records owned by user
  • 'list' = List records
  • 'update' = Update records
  • 'delete' = Delete records
Name
Resource Conditions (Permissions)
Note

Resource Conditions (Permissions)

This is a JSON object. Conditions allow to define additional rules, influencing the set actions.

Name
Status Values
Note

Status Values

  • 0 = Default / Not Set
  • 1 = Created
  • 2 = In Progress
  • 3 = Done Success
  • 4 = Done Incomplete
  • 5 = Done Error
Name
Media Type Values1
Note

Media Type Values

  • 'none' = Default / Not Set
  • 'audio' = Audio
  • 'video' = Video
  • 'image' = Image
  • 'document' = Document
  • 'audio_prepared' = Audio Prepared
  • 'video_prepared' = Video Prepared
Details