Passport

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
PassportLog.passport_id PassportLog_passport_id_fkeyR
PassportPing.passport_id PassportPing_passport_id_fkeyR
PassportQueueRemote.passport_id PassportQueueRemote_passport_id_fkeyR
PassportQueueServer.passport_id PassportQueueServer_passport_id_fkeyR
PassportSQL.passport_id PassportSQL_passport_id_fkeyR
name varchar 2147483647 null
description varchar 2147483647 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
UPLOAD_ZIP bool 1 false
sftp_link_id uuid 2147483647 √ null
SftpLink.id Passport_sftp_link_id_fkeyR
ALL_DB bool 1 false
ALL_DB_FOLDER varchar 2147483647 ''::character varying
ALL_DB_EXTENSION varchar 2147483647 ''::character varying
ALL_DB_FILES_PREFIX varchar 2147483647 ''::character varying
ALL_DB_PRINT_HEADERS bool 1 false
DATE_FORMAT varchar 2147483647 'yyyy-MM-dd'::character varying
CONNECTION_STRING varchar 2147483647 null
SEPARATOR varchar 2147483647 '|'::character varying
CHUNKS int4 10 1000
TARGET_ENCONDING varchar 2147483647 'utf-8'::character varying
UPLOAD_ZIP_DEFAULT_FOLDER varchar 2147483647 null
UPLOAD_ZIP_DEFAULT_FILE varchar 2147483647 'output.zip'::character varying
is_testing bool 1 false
data_node_id uuid 2147483647 √ null
DataNode.id Passport_data_node_id_fkeyR
enabled bool 1 true

Indexes

Constraint Name Type Sort Column(s)
Passport_pkey1 Primary key Asc id

Relationships

Close relationships within degrees of separation