Deep Bin Repository

Supported Repository Database Types Changing Repository Type Repository Tables user group group_members login_log form grid workflow page select data data_value lookup lookup_value meta_data Backing Up Repository Restoring Repository

The default repository type is SQLite, it works very well with a small amount of data. For high-load systems, we recommend using different database type

Supported Repository Database Types

  • SQLite
  • Postgres
  • MySQL
  • MariaDB
  • Microsoft SQL Server
  • Oracle

Changing Repository Type

  • Set ENABLE_SECURITY=0
  • Set RUN_SQL_SCRIPTS=1
  • Set Set CONNECTION_TYPE, DB_USER, DB_PASS, DB_NAME, DB_HOST, DB_PORT, DB_INSTANCE to appropriate values
  • Restart Deep Bin
  • Recreate/Enable Groups
  • Recreate/Enable Users
  • Set ENABLE_SECURITY=1
  • Restart Deep Bin

Repository Tables

The tables can be grouped into two categories Metadata tables and User data tables

The Meta tables hold definitions of deep bin objects and information about users.

User data tables are used to store the data created by the users.

Extra fields

Most of the tables have fields which are not being used by default, for example users table has date_field_01..date_field_20, char_field_01..char_field_20, boolean_field_01..boolean_field_20, numeric_field_01..numeric_field_20 fields. They can be used to store additional data. One of the benefits of using Deep Bin is that it allows for overwriting default forms for example the user may decide to create a custom registration form and include additional fields into it.

user

Metadata table which holds the list of Users

Field Name Type PK Nullable
id Number True False
email Varchar False False
password Varchar False True
title Varchar False True
first_name Varchar False True
last_name Varchar False True
work_phone Varchar False True
mobile_phone Varchar False True
last_logged_in Date False True
failed_login_attempts Number False False
front_page Varchar False False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
date_field_01..date_field_20 Date False True
char_field_01..char_field_20 Varchar False True
boolean_field_01..boolean_field_20 Boolean False True
numeric_field_01..numeric_field_20 Decimal(18,4) False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

group

Metadata table which holds the list of Groups

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

group_members

Metadata table which holds the link between Groups and Users

Field Name Type PK Nullable
group_id Number True False
user_id Number True False

login_log

Metadata table which holds the list of failed login attempts

Field Name Type PK Nullable
id Number True False
email Varchar False True
status Varchar False True
ip Varchar False True
logged_in Date False True

form

Metadata table which holds the forms’ definitions

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
model Varchar False True
definition Text False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

grid

Metadata table which holds the grids’ definitions

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
definition Text False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

workflow

Metadata table which holds the workflows’ definitions

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
definition Text False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

page

Metadata table which holds the pages’ definitions

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
definition Text False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

select

Metadata table which holds the selects’ definitions

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
use_default Boolean False True
default_key Varchar False True
default_value Varchar False True
sql Text False False
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

data

User data table, linked to data_values table

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

data_value

User data table usually used to store data values

Field Name Type PK Nullable
id Number True False
data_id Number False False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
date_field_01..date_field_20 Date False True
char_field_01..char_field_20 Varchar False True
boolean_field_01..boolean_field_20 Boolean False True
numeric_field_01..numeric_field_20 Decimal(18,4) False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

lookup

User data table, linked to lookup_values table

Field Name Type PK Nullable
id Number True False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

lookup_value

User data table usually used to store lookup values

Field Name Type PK Nullable
id Number True False
lookup_id Number False False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
date_field_01..date_field_20 Date False True
char_field_01..char_field_20 Varchar False True
boolean_field_01..boolean_field_20 Boolean False True
numeric_field_01..numeric_field_20 Decimal(18,4) False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

meta_data

A basic User data table

Field Name Type PK Nullable
id Number True False
object_id Number False False
meta_id Number False False
locked Boolean False True
enabled Boolean False True
code Varchar False False
name Varchar False True
description Varchar False True
category Varchar False True
date_field_01..date_field_20 Date False True
char_field_01..char_field_20 Varchar False True
boolean_field_01..boolean_field_20 Boolean False True
numeric_field_01..numeric_field_20 Decimal(18,4) False True
password Varchar False True
notes Text False True
created_at Date False True
created_by Varchar False False
updated_at Date False True
updated_by Varchar False False

Backing Up Repository

Backing Up Repository

Restoring Repository

Restoring Repository

Download Deep Bin

Confused? Ask question on our ETL-Tools Support Forum

Deep Bin   Repository  
Deep Bin   Repository  
Posted on May 12, 2022 • 6 min read • 1,174 words
On this page:
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License