transposer-datapool-schema.belowtoxic.cloud Open in urlscan Pro
159.69.18.254  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Diagram
Tables
Relationships
Notes
Project
 * caption_items
 * users
 * documents
 * requests
 * content_items
 * sources
 * access_tokens
 * response_tokens



 * documents_owner_id_fkey
 * requests_owner_id_fkey
 * caption_items_doc_id_fkey
 * requests_doc_id_fkey
 * content_items_doc_id_fkey
 * sources_doc_id_fkey
 * caption_items_content_id_fkey
 * access_tokens_owner_id_fkey
 * response_tokens_owner_id_fkey
 * requests_token_id_fkey



 * Status Values
 * Document Type Values
 * Additional Privileges
 * Media Type Values
 * CREATE transposer_datapool_admin
 * CREATE DATABASE transposer_datapool
 * CREATE DATABASE transposer_datapool1
 * CREATE DATABASE transposer_datapool2
 * CREATE DATABASE transposer_datapool3
 * Document Type Values - Addendum

caption_items

id    
bigserial
NN

content_id    
bigint
NN

doc_id    
bigint


start_ts    
bigint
NN

end_ts    
bigint
NN

users

id    
bigserial
NN

created_at    
timestamp with time zone
NN

modified_at    
timestamp with time zone


username    
varchar(255)
NN

email    
varchar(255)
NN

password    
varchar(255)
NN

salt    
varchar(255)
NN

display_name    
varchar(255)


is_active    
bool
NN

documents

id    
bigserial
NN

owner_id    
bigint
NN

created_at    
timestamp with time zone
NN

modified_at    
timestamp with time zone


type    
smallint
NN

uuid    
varchar(128)
NN

status    
smallint
NN

reason    
text


requests

id    
bigserial
NN

owner_id    
bigint


doc_id    
bigint


token_id    
bigint


created_at    
timestamp with time zone
NN

foreign_ref    
varchar(255)


response_uri    
text


is_async    
bool
NN

status    
smallint
NN

reason    
text


content_items

id    
bigserial
NN

doc_id    
bigint
NN

created_at    
timestamp with time zone
NN

lang    
varchar(4)


is_original    
bool
NN

confidence    
integer
NN

key    
varchar(128)
NN

value    
text
NN

status    
smallint
NN

reason    
text


sources

id    
bigserial
NN

doc_id    
bigint
NN

created_at    
timestamp with time zone
NN

uri    
text
NN

cid    
varchar(128)
NN

type    
smallint
NN

status    
smallint
NN

reason    
text


access_tokens

id    
bigserial
NN

owner_id    
bigint
NN

created_at    
timestamp with time zone
NN

key    
varchar(255)
NN

token    
varchar(255)
NN

response_tokens

id    
bigserial
NN

owner_id    
bigint
NN

created_at    
timestamp with time zone
NN

key    
varchar(255)


token    
varchar(255)
NN



STATUS VALUES

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


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


Documentation for project Transposer Datapool
Transposer Datapool
Project
Name
Transposer Datapool
Diagram
Name
Main Diagram
Report
Generated
7.4.2024 | 11:17:58
tables
Name
caption_items
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

content_id
bigint


Yes

doc_id
bigint




start_ts
bigint


Yes
Default value
-1
Description
timestamp in milliseconds

end_ts
bigint


Yes
Default value
-1
Description
timestamp in milliseconds
Keys
caption_items_pkey
Column in caption_items_pkey
id
Relations
Name
Parent
Child

caption_items_doc_id_fkey
documents
caption_items

caption_items_content_id_fkey
content_items
caption_items
Name
users
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

created_at
timestamp with time zone


Yes
Default value
now()

modified_at
timestamp with time zone




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
Relations
Name
Parent
Child

documents_owner_id_fkey
users
documents

requests_owner_id_fkey
users
requests

access_tokens_owner_id_fkey
users
access_tokens

response_tokens_owner_id_fkey
users
response_tokens
Name
documents
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

owner_id
bigint


Yes

created_at
timestamp with time zone


Yes
Default value
now()

modified_at
timestamp with time zone




type
smallint


Yes
Default value
0

uuid
varchar
128

Yes

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

caption_items_doc_id_fkey
documents
caption_items

requests_doc_id_fkey
documents
requests

content_items_doc_id_fkey
documents
content_items

sources_doc_id_fkey
documents
sources
Name
requests
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

owner_id
bigint




doc_id
bigint




token_id
bigint




created_at
timestamp with time zone


Yes
Default value
now()

foreign_ref
varchar
255



response_uri
text




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

requests_doc_id_fkey
documents
requests

requests_token_id_fkey
response_tokens
requests
Name
content_items
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

doc_id
bigint


Yes

created_at
timestamp with time zone


Yes
Default value
now()

lang
varchar
4



is_original
bool


Yes
Default value
false

confidence
integer


Yes
Default value
-1

key
varchar
128

Yes

value
text


Yes

status
smallint


Yes
Default value
0

reason
text



Keys
content_items_pkey
Column in content_items_pkey
id
Relations
Name
Parent
Child

content_items_doc_id_fkey
documents
content_items

caption_items_content_id_fkey
content_items
caption_items
Name
sources
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

doc_id
bigint


Yes

created_at
timestamp with time zone


Yes
Default value
now()

uri
text


Yes

cid
varchar
128

Yes

type
smallint


Yes
Default value
0

status
smallint


Yes
Default value
0

reason
text



Keys
sources_pkey
Column in sources_pkey
id
sources_unique_uri
Column in sources_unique_uri
uri
sources_unique_cid
Column in sources_unique_cid
cid
Relations
Name
Parent
Child

sources_doc_id_fkey
documents
sources
Name
access_tokens
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

owner_id
bigint


Yes

created_at
timestamp with time zone


Yes
Default value
now()

key
varchar
255

Yes

token
varchar
255

Yes
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
response_tokens
Columns
Name
Data type
Param
Key
Not Null

id
bigserial

Yes
Yes

owner_id
bigint


Yes

created_at
timestamp with time zone


Yes
Default value
now()

key
varchar
255



token
varchar
255

Yes
Keys
response_tokens_pkey
Column in response_tokens_pkey
id
response_tokens_unique_owner_id_key
Column in response_tokens_unique_owner_id_key
owner_id
Column in response_tokens_unique_owner_id_key
key
response_tokens_unique_owner_id_token
Column in response_tokens_unique_owner_id_token
owner_id
Column in response_tokens_unique_owner_id_token
token
Relations
Name
Parent
Child

response_tokens_owner_id_fkey
users
response_tokens

requests_token_id_fkey
response_tokens
requests


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
Set null
Name
caption_items_doc_id_fkey
Name
Source
Target

caption_items_doc_id_fkey
documents
caption_items
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in caption_items
documents_pkey
id
doc_id
Properties
Rerefential integrity - parent delete
Set null
Name
requests_doc_id_fkey
Name
Source
Target

requests_doc_id_fkey
documents
requests
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in requests
documents_pkey
id
doc_id
Properties
Rerefential integrity - parent delete
Set null
Name
content_items_doc_id_fkey
Name
Source
Target

content_items_doc_id_fkey
documents
content_items
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in content_items
documents_pkey
id
doc_id
Properties
Rerefential integrity - parent delete
Cascade
Name
sources_doc_id_fkey
Name
Source
Target

sources_doc_id_fkey
documents
sources
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in documents
Column in sources
documents_pkey
id
doc_id
Properties
Rerefential integrity - parent delete
Cascade
Name
caption_items_content_id_fkey
Name
Source
Target

caption_items_content_id_fkey
content_items
caption_items
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in content_items
Column in caption_items
content_items_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
response_tokens_owner_id_fkey
Name
Source
Target

response_tokens_owner_id_fkey
users
response_tokens
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in users
Column in response_tokens
users_pkey
id
owner_id
Properties
Rerefential integrity - parent delete
Cascade
Name
requests_token_id_fkey
Name
Source
Target

requests_token_id_fkey
response_tokens
requests
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in response_tokens
Column in requests
response_tokens_pkey
id
token_id
Properties
Rerefential integrity - parent delete
Set null


Notes
Name
Status Values
Note


STATUS VALUES

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

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

Details

Close