Schema 'OCS.io Core'

id

Internal ID, generated from the 'registration_seq' Sequence.

bigint

X

ref_id

Ref ID of the AuthRegistration.

varchar(40)

X

auth_type

Authorization Type.

varchar(80)

X

organization_name

Name of the Organization.

varchar(80)

organization_url

URL of the Organization.

varchar(255)

organization_id

Foreign Key to Organization.

varchar(50)

organization

time_zone

Time Zone.

varchar(255)

email

Email of the Organization Manager.

varchar(80)

identity

Identity as provided by OAuth Authority.

varchar(512)

full_name

Full Name of the Organization Manager.

varchar(255)

X

user_id

Foreign key to AuthUser.

varchar(50)

auth_user

invitation_token

Invitation Token.

varchar(128)

encoded_password

Password in Encoded form.

varchar(512)

registration_created

Timestamp when Registration was created.

timestamptz

registration_finished

Timestamp when Registration was finished.

timestamptz

email_confirmed

Timestamp when Email was confirmed.

timestamptz

id

Internal ID, generated from the 'auth_role_seq' Sequence.

bigint

X

ref_id

Ref ID of the AuthRole.

varchar(40)

X

name

Name of the AuthRole.

varchar(80)

X

description

Description of the AuthRole.

varchar(255)

internal_code

${FIELD.DESCRIPTION}

varchar(60)

X

server_dependent

${FIELD.DESCRIPTION}

boolean

system_role

${FIELD.DESCRIPTION}

boolean

default_role

${FIELD.DESCRIPTION}

boolean

id

Internal ID, generated from the 'auth_user_seq' Sequence.

bigint

X

ref_id

Ref ID of the AuthUser.

varchar(40)

X

email

Registered Email of the user.

varchar(80)

X

identity

Identity as returned by provider.

varchar(512)

full_name

Full name (First name + Last name) of the user.

varchar(255)

roles

Roles assigned to user.

text

is_account_enabled

Only in case Account Enabled = TRUE, user can sign-in.

boolean

account_expiration

Date when account expires. After this date, user cannot sign-in.

timestamptz

registered

Date when user was registered.

timestamptz

registration_type

Registration type.

varchar(30)

last_logged_gui

Date when user was logged last time via GUI.

timestamptz

last_logged_api

Date when user was logged last time via API.

timestamptz

auth_type

Authentication type.

varchar(80)

password

Password of the user, never stored as plain text.

varchar(1024)

organization_id

Foreign key to Organization.

varchar(50)

organization

master_auth_user_id

Foreign key to master AuthUser.

varchar(50)

auth_user

token

${FIELD.DESCRIPTION}

varchar(128)

locale

Locale of the user.

varchar(80)

id

Internal ID, generated from the 'auth_user_detail_seq' Sequence.

bigint

X

ref_id

Ref ID of the AuthUserDetail.

varchar(40)

X

fist_name

${FIELD.DESCRIPTION}

varchar(80)

last_name

${FIELD.DESCRIPTION}

varchar(80)

language

${FIELD.DESCRIPTION}

varchar(3)

auth_user_id

${FIELD.DESCRIPTION}

varchar(50)

auth_user

id

Internal ID, generated from the 'auth_user_session_seq' Sequence.

bigint

X

ref_id

Ref ID of the AuthUserSession.

varchar(40)

X

auth_user_id

${FIELD.DESCRIPTION}

bigint

organization_id

${FIELD.DESCRIPTION}

bigint

id

Internal ID, generated from the 'invitation_seq' Sequence.

bigint

X

ref_id

Ref ID of the Invitation.

varchar(40)

X

auth_user_created_id

${FIELD.DESCRIPTION}

varchar(50)

auth_user

organization_id

${FIELD.DESCRIPTION}

varchar(50)

organization

token

${FIELD.DESCRIPTION}

varchar(128)

X

email

${FIELD.DESCRIPTION}

varchar(255)

X

name

${FIELD.DESCRIPTION}

varchar(80)

X

message

${FIELD.DESCRIPTION}

varchar(255)

created

${FIELD.DESCRIPTION}

timestamptz

X

expiry_days

${FIELD.DESCRIPTION}

bigint

roles

${FIELD.DESCRIPTION}

text

accepted

${FIELD.DESCRIPTION}

timestamptz

auth_user_accepted_id

${FIELD.DESCRIPTION}

varchar(50)

auth_user

id

Internal ID, generated from the 'organization_seq' Sequence.

bigint

X

ref_id

Ref ID of the Organization.

varchar(40)

X

name

Name of the Organization.

varchar(80)

X

description

Description of the Organization.

varchar(255)

url

URL of the organization. Must be unique.

varchar(255)

X

time_zone

Time Zone.

varchar(255)

id

Internal ID, generated from the 'user_session_seq' Sequence.

bigint

X

ref_id

Ref ID of the PbsUserSession.

varchar(40)

X

auth_user_id

${FIELD.DESCRIPTION}

bigint

view_id

${FIELD.DESCRIPTION}

varchar(50)

view

id

Internal ID, generated from the 'cron_job_cfg_seq' Sequence.

bigint

X

ref_id

Ref ID of the CronJobCfg.

varchar(40)

X

name

Name of the CronJobCfg.

varchar(80)

X

description

Description of the CronJobCfg.

varchar(255)

internal_code

Internal Code of the CronJobCfg.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the CronJobCfg may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

cron_job_type_id

Foreign Key to CronJobType.

varchar(50)

X

cron_job_type

cron_expression

Cron expression.

varchar(255)

last_cron_job_run_id

Foreign Key to last CronJobRun.

varchar(50)

cron_job_run

last_execution

Last Execution of the Cron Job.

timestamptz

disabled

Indicates, whether Cron Job is temporarily disabled.

boolean

id

Internal ID, generated from the 'cron_job_run_seq' Sequence.

bigint

X

ref_id

Ref ID of the CronJobRun.

varchar(40)

X

cron_job_cfg_id

Foreign Key to CronJobCfg.

varchar(50)

X

cron_job_cfg

cron_job_start

Date/Time when Cron Job was started.

timestamptz

X

cron_job_end

Date/Time when Cron Job finished.

timestamptz

cron_job_duration

Duration of the Cron Job in millis.

bigint

error_code

Code of the Error.

varchar(255)

entities_processed

Number of entities processed.

bigint

id

Internal ID, generated from the 'cron_job_type_seq' Sequence.

bigint

X

ref_id

Ref ID of the CronJobType.

varchar(40)

X

name

Name of the CronJobType.

varchar(80)

X

description

Description of the CronJobType.

varchar(255)

internal_code

Internal Code of the CronJobType.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the CronJobType may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

class_name

Cron Job’s Class name.

varchar(255)

X

namespace

Namespace of the Cron Job.

varchar(60)

X

id

Internal ID, generated from the 'extract_cfg_seq' Sequence.

bigint

X

ref_id

Ref ID of the ExtractCfg.

varchar(40)

X

name

Name of the ExtractCfg.

varchar(80)

X

description

Description of the ExtractCfg.

varchar(255)

internal_code

Internal Code of the ExtractCfg.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the ExtractCfg may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

extract_type_id

Foreign Key to ExtractType.

varchar(50)

X

extract_type

compressed

Indicates whether Extract is compressed.

boolean

id

Internal ID, generated from the 'extract_run_seq' Sequence.

bigint

X

ref_id

Ref ID of the ExtractRun.

varchar(40)

X

extract_cfg_id

Foreign Key to ExtractCfg.

varchar(50)

X

extract_cfg

extract_start

Date/Time of Extract started.

timestamptz

X

extract_end

Date/Time when Extract finished.

timestamptz

extract_duration

Duration of the Extract.

bigint

rows_extracted

Number of rows extracted.

bigint

id

Internal ID, generated from the 'extract_type_seq' Sequence.

bigint

X

ref_id

Ref ID of the ExtractType.

varchar(40)

X

name

Name of the ExtractType.

varchar(80)

X

description

Description of the ExtractType.

varchar(255)

internal_code

Internal Code of the ExtractType.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the ExtractType may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

class_name

Extract’s Class name.

varchar(255)

sql_statement

Extract’s SQL.

varchar

payload_class_name

Payload’s Class name, null in case payload is generic.

varchar(255)

format

Extract format, e.g. 'JSON', 'CSV', etc.

varchar(30)

compress_capable

Indicates whether Extract could be compressed.

boolean

fs_capable

Indicates whether Extract is possible to File System.

boolean

url

${FIELD.DESCRIPTION}

varchar(60)

X

has_preprocessor

Indicates whether Extract has Pre-Processor.

boolean

id

Internal ID, generated from the 'localization_seq' Sequence.

bigint

X

ref_id

Ref ID of the LocalizationModel.

varchar(40)

X

loc_key

${FIELD.DESCRIPTION}

varchar(255)

X

class_name

${FIELD.DESCRIPTION}

varchar(255)

category

${FIELD.DESCRIPTION}

varchar(512)

X

sub_category

${FIELD.DESCRIPTION}

varchar(512)

html

${FIELD.DESCRIPTION}

boolean

values_json

${FIELD.DESCRIPTION}

text

id

Internal ID, generated from the 'navigation_seq' Sequence.

bigint

X

ref_id

Ref ID of the Navigation.

varchar(40)

X

name

Name of the Navigation.

varchar(80)

X

description

Description of the Navigation.

varchar(255)

internal_code

Internal Code of the Navigation.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the Navigation may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

version

Version of the Navigation.

varchar(30)

X

id

Internal ID, generated from the 'navigation_item_seq' Sequence.

bigint

X

ref_id

Ref ID of the NavigationItem.

varchar(40)

X

name

Name of the NavigationItem.

varchar(80)

X

description

Description of the NavigationItem.

varchar(255)

navigation_id

${FIELD.DESCRIPTION}

varchar(50)

X

navigation

navigation_item_type_id

${FIELD.DESCRIPTION}

varchar(50)

X

navigation_item_type

page_id

${FIELD.DESCRIPTION}

varchar(50)

page_model

page_parameters

${FIELD.DESCRIPTION}

varchar(255)

link

${FIELD.DESCRIPTION}

varchar(255)

item_label

${FIELD.DESCRIPTION}

varchar(80)

icon_prepended

${FIELD.DESCRIPTION}

varchar(80)

icon_appended

${FIELD.DESCRIPTION}

varchar(80)

seqno

${FIELD.DESCRIPTION}

bigint

roles

${FIELD.DESCRIPTION}

varchar(500)

item_hidden

Indicates whether item is itemHidden.

boolean

id

Internal ID, generated from the 'navigation_item_type_seq' Sequence.

bigint

X

ref_id

Ref ID of the NavigationItemType.

varchar(40)

X

name

Name of the NavigationItemType.

varchar(80)

X

description

Description of the NavigationItemType.

varchar(255)

internal_code

Internal Code of the NavigationItemType.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the NavigationItemType may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

custom

${FIELD.DESCRIPTION}

boolean

class_name

${FIELD.DESCRIPTION}

varchar(255)

id

Internal ID, generated from the 'page_seq' Sequence.

bigint

X

ref_id

Ref ID of the PageModel.

varchar(40)

X

name

Name of the PageModel.

varchar(80)

X

description

Description of the PageModel.

varchar(255)

page_id

${FIELD.DESCRIPTION}

varchar(255)

X

class_name

${FIELD.DESCRIPTION}

varchar(255)

X

path

${FIELD.DESCRIPTION}

varchar(512)

X

url_coding_strategy

${FIELD.DESCRIPTION}

varchar(80)

arr_parameter_names

${FIELD.DESCRIPTION}

text

category

${FIELD.DESCRIPTION}

varchar(512)

X

sub_category

${FIELD.DESCRIPTION}

varchar(512)

css_reference

${FIELD.DESCRIPTION}

varchar(512)

abstr

${FIELD.DESCRIPTION}

boolean

model_class_name

${FIELD.DESCRIPTION}

varchar(255)

id

Internal ID, generated from the 'gui_view_seq' Sequence.

bigint

X

ref_id

Ref ID of the View.

varchar(40)

X

name

Name of the View.

varchar(80)

X

description

Description of the View.

varchar(255)

internal_code

Internal Code of the View.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the View may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

top_navigation_id

${FIELD.DESCRIPTION}

varchar(50)

navigation

top_right_navigation_id

${FIELD.DESCRIPTION}

varchar(50)

navigation

left_navigation_id

${FIELD.DESCRIPTION}

varchar(50)

navigation

right_navigation_id

${FIELD.DESCRIPTION}

varchar(50)

navigation

home_page_id

${FIELD.DESCRIPTION}

varchar(50)

X

page_model

item_label

${FIELD.DESCRIPTION}

varchar(80)

icon_prepended

${FIELD.DESCRIPTION}

varchar(80)

icon_appended

${FIELD.DESCRIPTION}

varchar(80)

seqno

${FIELD.DESCRIPTION}

bigint

roles

${FIELD.DESCRIPTION}

varchar(500)

dflt

${FIELD.DESCRIPTION}

boolean

version

Version of the View.

varchar(30)

X

id

Internal ID, generated from the 'notification_schedule_seq' Sequence.

bigint

X

ref_id

Ref ID of the Notification.

varchar(40)

X

notification_name

Name of the Notification Type.

varchar(60)

X

notification_code

Code of the Notification ad defined in Notification Cfg.

varchar(60)

X

notification_cfg_id

Foreign Key to NotificationCfg.

varchar(50)

X

notification_cfg

notification_endpoint_id

Foreign Key to NotificationEndpoint.

varchar(50)

X

pub_sub_endpoint

payload_json

Payload in JSON.

varchar

X

ent_date

Date/Time when Notification was enetered.

timestamptz

X

next_try_millis

Date/Time of the Next try in Millis.

bigint

retry_count

Number of Retries.

bigint

last_try_date

Date/Time of the Last Try.

timestamptz

success_try_date

Date/Time of the Successfull Try.

timestamptz

last_try_response_code

Response Code of the Last Try.

varchar(80)

last_try_response_content

Response Content of the Last Try.

varchar(255)

id

Internal ID, generated from the 'notification_cfg_seq' Sequence.

bigint

X

ref_id

Ref ID of the NotificationCfg.

varchar(40)

X

name

Name of the NotificationCfg.

varchar(80)

X

description

Description of the NotificationCfg.

varchar(255)

internal_code

Internal Code of the NotificationCfg.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the NotificationCfg may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

endpoint_type

Endpoint Type.

varchar(80)

X

notification_type_id

Foreign Key to NotificationType.

varchar(50)

X

notification_type

pubsub_endpoint_id

Foreign Key to PubSubEndpoint in case NotificationType = PUBSUB.

varchar(50)

pub_sub_endpoint

topic

Topic to send Notification, concatenated with Pub-Sub Endpoint topic.

varchar(255)

rest_endpoint_id

Foreign Key to RestEndpoint in case NotificationType = REST.

varchar(50)

pub_sub_endpoint

retry_count

Number of retries in case of error.

bigint

retry_wait

Number of Seconds engine waits between Retries.

bigint

is_disabled

Indicates, whether Notification is temporarily disabled.

boolean

is_stored

Indicates, whether Notification is stored when sent.

boolean

id

Internal ID, generated from the 'notification_hist_seq' Sequence.

bigint

X

ref_id

Ref ID of the NotificationHistory.

varchar(40)

X

notification_name

Name of the Notification Type.

varchar(60)

X

notification_code

Code of the Notification ad defined in Notification Cfg.

varchar(60)

X

notification_cfg_id

Foreign Key to NotificationCfg.

varchar(50)

X

notification_cfg

notification_endpoint_id

Foreign Key to NotificationEndpoint.

varchar(50)

X

pub_sub_endpoint

payload_json

Payload in JSON.

varchar

X

ent_date

Date/Time when Notification was enetered.

timestamptz

X

next_try_millis

Date/Time of the Next try in Millis.

bigint

retry_count

Number of Retries.

bigint

last_try_date

Date/Time of the Last Try.

timestamptz

success_try_date

Date/Time of the Successfull Try.

timestamptz

last_try_response_code

Response Code of the Last Try.

varchar(80)

last_try_response_content

Response Content of the Last Try.

varchar(255)

partition_code

Partition code for easier deletion.

varchar(80)

X

fmt_month

${FIELD.DESCRIPTION}

text

fmt_day

${FIELD.DESCRIPTION}

text

id

Internal ID, generated from the 'notification_type_seq' Sequence.

bigint

X

ref_id

Ref ID of the NotificationType.

varchar(40)

X

name

Name of the NotificationType.

varchar(80)

X

description

Description of the NotificationType.

varchar(255)

internal_code

Internal Code of the NotificationType.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the NotificationType may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

class_name

Notification’s Class name.

varchar(255)

method_name

Notifications' Method name, null in case annotation is on Class.

varchar(255)

payload_class_name

Payload’s Class name, null in case payload is generic.

varchar(255)

pubsub_capable

Indicates whether Notification is PUB/SUB Capable.

boolean

topic

Topic to send Notification, concatenated with Pub-Sub Endpoint topic.

varchar(255)

rest_capable

Indicates whether Notification is REST Capable.

boolean

max_tries

Max Tries for given Notification Type.

bigint

min_wait

Min Wait for given Notification Type.

bigint

id

Internal ID, generated from the 'external_process_seq' Sequence.

bigint

X

ref_id

Ref ID of the ExternalProcess.

varchar(40)

X

name

Name of the ExternalProcess.

varchar(80)

X

description

Description of the ExternalProcess.

varchar(255)

internal_code

Internal Code of the ExternalProcess.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the ExternalProcess may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

class_name

Process’s Class name.

varchar(255)

X

url

${FIELD.DESCRIPTION}

varchar(255)

X

workers

Number of concurrent workers.

bigint

is_disabled

Indicates whether External Process is disabled.

boolean

id

Internal ID, generated from the 'api_request_hist_seq' Sequence.

bigint

X

ref_id

Ref ID of the ApiRequestHistory.

varchar(40)

X

request_id

ID of the Request as received.

varchar(255)

X

request_date

Timestamp of the Request.

timestamptz

X

request_name

Name of the Request.

varchar(255)

X

response_id

ID of the Response.

varchar(255)

response_date

Timestamp of the Response.

timestamptz

response_name

Name of the Response. In case of Bulk Response, name is taken from main Response.

varchar(255)

response_status

HTTP Response Status. 200=OK, other according to REST patterns.

text

bulk_response

Indicates whether Response is Bulk.

boolean

error_code

Code of the Error.

varchar(255)

request

JSON containing Request.

varchar

response

JSON containing Response.

varchar

parameters

Main parameters of the request using for filtering.

text

partition_id

Partition ID, consist of Request Name and Year, Month, Day.

varchar(255)

duration

Duration of the request performing.

bigint

id

Internal ID, generated from the 'checksum_seq' Sequence.

bigint

X

ref_id

Ref ID of the Checksum.

varchar(40)

X

tkey

${FIELD.DESCRIPTION}

varchar(255)

X

checksum

${FIELD.DESCRIPTION}

varchar(255)

X

last_updated

${FIELD.DESCRIPTION}

timestamptz

X

id

Internal ID, generated from the 'clob_store_seq' Sequence.

bigint

X

ref_id

Ref ID of the Clob.

varchar(40)

X

name

${FIELD.DESCRIPTION}

varchar(255)

X

entity

${FIELD.DESCRIPTION}

varchar(255)

X

cl

${FIELD.DESCRIPTION}

text

X

id

Internal ID, generated from the 'configuration_seq' Sequence.

bigint

X

ref_id

Ref ID of the ConfigurationModel.

varchar(40)

X

name

Name of the ConfigurationModel.

varchar(80)

X

description

Description of the ConfigurationModel.

varchar(255)

tkey

${FIELD.DESCRIPTION}

varchar(255)

X

class_name

${FIELD.DESCRIPTION}

varchar(255)

category

${FIELD.DESCRIPTION}

varchar(512)

X

sub_category

${FIELD.DESCRIPTION}

varchar(512)

value_type

${FIELD.DESCRIPTION}

varchar(80)

visibility

${FIELD.DESCRIPTION}

varchar(80)

inherited

${FIELD.DESCRIPTION}

boolean

value

${FIELD.DESCRIPTION}

varchar(255)

id

Internal ID, generated from the 'custom_attribute_seq' Sequence.

bigint

X

ref_id

Ref ID of the CustomAttribute.

varchar(40)

X

name

Name of the CustomAttribute.

varchar(80)

X

description

Description of the CustomAttribute.

varchar(255)

internal_code

Internal Code of the CustomAttribute.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the CustomAttribute may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

custom_entity_id

Foreign Key to CustomEntity.

varchar(50)

X

custom_entity

attribute_type

Type of the Attribute.

varchar(80)

X

nullable

Indicates whether Value could be null.

boolean

min_length

Minimal Length for String values.

bigint

max_length

Maximal Length for String values.

bigint

range_from

Range From for Number values.

bigint

range_to

Range To for Number values.

bigint

regexpcond

Regular Expression condition.

varchar(255)

seqno

Seq No for ordering of the attributes within one Entity.

bigint

X

id

Internal ID, generated from the 'custom_entity_seq' Sequence.

bigint

X

ref_id

Ref ID of the CustomEntity.

varchar(40)

X

name

Name of the CustomEntity.

varchar(80)

X

description

Description of the CustomEntity.

varchar(255)

internal_code

Internal Code of the CustomEntity.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the CustomEntity may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

url

Entity piece in URL for REST GET API.

varchar(60)

X

singleton

Indicates whether only one Instance (Singleton) of the Entity is allowd.

boolean

id

Internal ID, generated from the 'custom_entity_inst_seq' Sequence.

bigint

X

ref_id

Ref ID of the CustomEntityInstance.

varchar(40)

X

name

Name of the CustomEntityInstance.

varchar(80)

X

description

Description of the CustomEntityInstance.

varchar(255)

internal_code

Internal Code of the CustomEntityInstance.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the CustomEntityInstance may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

custom_entity_id

Foreign Key to CustomEntity.

varchar(50)

X

custom_entity

url

Instance piece in URL for REST GET API.

varchar(60)

X

id

Internal ID, generated from the 'custom_entity_inst_val_seq' Sequence.

bigint

X

ref_id

Ref ID of the CustomEntityInstanceValue.

varchar(40)

X

custom_entity_instance_id

Foreign Key to CustomEntityInstance.

varchar(50)

X

custom_entity_instance

custom_entity_id

Foreign Key to CustomEntity.

varchar(50)

X

custom_entity

name

Name of the value (version).

varchar(80)

X

description

Description of the value (version).

varchar(255)

value_ent_date

Entry Date of Value.

timestamptz

X

value_valid_from

Date from when Value is valid.

timestamptz

value_valid_to

Date till when Value is valid.

timestamptz

value_json

Values in JSON.

varchar

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

id

Internal ID, generated from the 'deployment_set_seq' Sequence.

bigint

X

ref_id

Ref ID of the DeploymentSet.

varchar(40)

X

name

Name of the DeploymentSet.

varchar(80)

X

description

Description of the DeploymentSet.

varchar(255)

deployment_status

Status of the Deployment.

varchar(80)

X

created_by_id

User created the Deployment Set.

varchar(50)

X

auth_user

created

Timestamp when Set was created.

timestamptz

X

deployed_by_id

User deployed Deployment Set.

varchar(50)

auth_user

deployed

Timestamp when Set was deployed.

timestamptz

effective_date

Effective Date/Time of Deployment.

timestamptz

deployment_set_hidden

Indicates whether Set is hidden from the GUI.

boolean

id

Internal ID, generated from the 'deployment_set_entity_seq' Sequence.

bigint

X

ref_id

Ref ID of the DeploymentSetEntity.

varchar(40)

X

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

X

deployment_set

entity_class_name

Class Name of the Entity.

varchar(255)

X

srv_class_name

Class Name of the SRV behind Entity.

varchar(255)

X

page_class_name

Class Name of the Page with Entity’s form.

varchar(255)

entity

Foreign Key to Entity.

varchar(50)

X

[model]

entity_name

Name of the Entity, if apply.

varchar(80)

entity_internal_code

Internal Code of the Entity, if apply.

varchar(60)

entity_description

Description of the Entity, if apply.

varchar(255)

entity_deployable

Indicates whether Entity is deployable.

boolean

validation_code

Deployment validation code, if apply.

varchar(30)

validation_error

Deployment validation error, if apply.

varchar(255)

order_id

Order ID composed from Time in millis.

bigint

componsed_index

Composed index, consists of deploymentSet:entityClassName:entity.

varchar(255)

id

Internal ID, generated from the 'entity_tag_seq' Sequence.

bigint

X

ref_id

Ref ID of the EntityTag.

varchar(40)

X

entity_class_name

Class Name of the Entity.

varchar(255)

X

entity_id

Foreign Key to Entity.

varchar(50)

X

[model]

tag_id

Foreign Key to Tag.

varchar(50)

X

tag

composed_index

Composed index, consists of entityClassName:entity.

varchar(255)

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

id

Internal ID, generated from the 'language_seq' Sequence.

bigint

X

ref_id

Ref ID of the Language.

varchar(40)

X

name

Name of the Language.

varchar(80)

X

description

Description of the Language.

varchar(255)

internal_code

Internal Code of the Language.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the Language may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

iso639

ISO 639 code (2 letters).

varchar(2)

X

id

Internal ID, generated from the 'entity_lock_seq' Sequence.

bigint

X

ref_id

Ref ID of the Lock.

varchar(40)

X

entity

${FIELD.DESCRIPTION}

varchar(255)

X

locked_by_id

${FIELD.DESCRIPTION}

varchar(50)

auth_user

locked_date

${FIELD.DESCRIPTION}

timestamptz

X

id

Internal ID, generated from the 'module_seq' Sequence.

bigint

X

ref_id

Ref ID of the Module.

varchar(40)

X

name

Name of the Module.

varchar(80)

X

description

Description of the Module.

varchar(255)

internal_code

Internal Code of the Module.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the Module may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

module_type_id

Foreign Key to ModuleType.

varchar(50)

X

[module_type]

config

${FIELD.DESCRIPTION}

varchar

is_disabled

Indicates, whether Module is temporarily disabled.

boolean

id

Internal ID, generated from the 'plugin_seq' Sequence.

bigint

X

ref_id

Ref ID of the PluginModel.

varchar(40)

X

name

Name of the PluginModel.

varchar(80)

X

description

Description of the PluginModel.

varchar(255)

internal_code

Internal Code of the PluginModel.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the PluginModel may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

base_class_name

Base class name from which Plugin class is derived.

varchar(255)

X

class_name

Class name of the plugin.

varchar(255)

X

category

Category of the Plugin.

varchar(255)

X

sub_category

Subcategory of the plugin.

varchar(255)

plugin_id

Unique identification of the Plugin, taken from metadata.

varchar(255)

X

version

Version of the plugin, taken from Plugin metadata. Based on the version, plugins are re-deployed.

varchar(30)

X

version_deployed

Timestamp when actual version was deployed.

timestamptz

X

active

Plugin is active?.

boolean

X

id

Internal ID, generated from the 'process_status_seq' Sequence.

bigint

X

ref_id

Ref ID of the ProcessStatus.

varchar(40)

X

auth_user_id

${FIELD.DESCRIPTION}

bigint

process_name

${FIELD.DESCRIPTION}

varchar(80)

X

is_async

${FIELD.DESCRIPTION}

boolean

X

current_step

${FIELD.DESCRIPTION}

bigint

steps

${FIELD.DESCRIPTION}

bigint

status

${FIELD.DESCRIPTION}

varchar(80)

X

created

${FIELD.DESCRIPTION}

timestamptz

X

last_updated

${FIELD.DESCRIPTION}

timestamptz

finished

${FIELD.DESCRIPTION}

timestamptz

payload

${FIELD.DESCRIPTION}

varchar

exception

${FIELD.DESCRIPTION}

varchar

err_code

${FIELD.DESCRIPTION}

varchar

err_msg

${FIELD.DESCRIPTION}

varchar(255)

id

Internal ID, generated from the 'rest_service_seq' Sequence.

bigint

X

ref_id

Ref ID of the RestServiceModel.

varchar(40)

X

tkey

${FIELD.DESCRIPTION}

varchar(80)

X

path

${FIELD.DESCRIPTION}

varchar(80)

X

http_method

${FIELD.DESCRIPTION}

varchar(80)

produces

${FIELD.DESCRIPTION}

varchar(80)

return_type

${FIELD.DESCRIPTION}

varchar(80)

srv_class_name

${FIELD.DESCRIPTION}

varchar(255)

X

model_class_name

${FIELD.DESCRIPTION}

varchar(255)

X

id

Internal ID, generated from the 'sequence_def_seq' Sequence.

bigint

X

ref_id

Ref ID of the SequenceDef.

varchar(40)

X

name

Name of the SequenceDef.

varchar(80)

X

description

Description of the SequenceDef.

varchar(255)

sequence_db_name

DB Name of the Sequence.

varchar(80)

X

initial_value

Initial value of the Sequence.

bigint

id

Internal ID, generated from the 'spreadsheet_api_seq' Sequence.

bigint

X

ref_id

Ref ID of the SpreadsheetApi.

varchar(40)

X

name

Name of the SpreadsheetApi.

varchar(80)

X

description

Description of the SpreadsheetApi.

varchar(255)

path

URL path of the API.

varchar(255)

X

read_only

Indicates whether method is read-only.

boolean

seqno

bigint

X

id

Internal ID, generated from the 'tag_seq' Sequence.

bigint

X

ref_id

Ref ID of the Tag.

varchar(40)

X

name

Name of the Tag.

varchar(80)

X

description

Description of the Tag.

varchar(255)

internal_code

Internal Code of the Tag.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the Tag may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

entity_class_name

Class Name of the Entity.

varchar(255)

id

Internal ID, generated from the 'pub_sub_endpoint_seq' Sequence.

bigint

X

ref_id

Ref ID of the PubSubEndpoint.

varchar(40)

X

name

Name of the PubSubEndpoint.

varchar(80)

X

description

Description of the PubSubEndpoint.

varchar(255)

internal_code

Internal Code of the PubSubEndpoint.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the PubSubEndpoint may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

topic

Topic to send Event concatenated with Pub-Sub Message topic.

varchar(255)

custom_headers

Custom Headers / Parameters in JSON.

varchar

key_stripped

Indicates whether Key is stripped.

boolean

is_disabled

Indicates, whether Pub-Sub Message is temporarily disabled.

boolean

id

Internal ID, generated from the 'pub_sub_history_seq' Sequence.

bigint

X

ref_id

Ref ID of the PubSubHistory.

varchar(40)

X

publish_date

Date/Time when Message is published.

timestamptz

X

code

Code of the Message.

varchar(255)

X

topic

Topic to which Message is published.

varchar(255)

X

key

Key of the Message.

varchar(255)

payload_class_name

Class Name of the Payload.

varchar(255)

X

payload

Payload of the Message.

varchar

custom_headers

Custom Headers of the Message.

text

parameters

Main parameters of the Message using for filtering.

text

error_code

Code of the Error.

varchar(255)

id

Internal ID, generated from the 'pub_sub_message_cfg_seq' Sequence.

bigint

X

ref_id

Ref ID of the PubSubMessageCfg.

varchar(40)

X

name

Name of the PubSubMessageCfg.

varchar(80)

X

description

Description of the PubSubMessageCfg.

varchar(255)

internal_code

Internal Code of the PubSubMessageCfg.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the PubSubMessageCfg may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

pub_sub_message_type_id

Foreign Key to PubSubMessageType.

varchar(50)

X

pub_sub_message_type

pub_sub_endpoint_id

Foreign Key to PubSubEndpoint.

varchar(50)

X

pub_sub_endpoint

topic

Topic to send Event, concatenated with Pub-Sub Endpoint topic.

varchar(255)

is_disabled

Indicates, whether Pub-Sub Message is temporarily disabled.

boolean

is_stored

Indicates, whether Notification is stored when sent.

boolean

id

Internal ID, generated from the 'pub_sub_message_type_seq' Sequence.

bigint

X

ref_id

Ref ID of the PubSubMessageType.

varchar(40)

X

name

Name of the PubSubMessageType.

varchar(80)

X

description

Description of the PubSubMessageType.

varchar(255)

internal_code

Internal Code of the PubSubMessageType.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the PubSubMessageType may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

class_name

PubSub Message’s Class name.

varchar(255)

method_name

PubSub Message’s Method name, null in case annotation is on Class.

varchar(255)

payload_class_name

Payload’s Class name, null in case payload is generic.

varchar(255)

topic

Topic to send Event.

varchar(255)

X

id

Internal ID, generated from the 'srv_content_seq' Sequence.

bigint

X

ref_id

Ref ID of the Content.

varchar(40)

X

value_set_on

Discriminator column to recognize which entity sets the value.

varchar(80)

class_name

Stored value Class name.

varchar(255)

product_value_id

Foreign Key to ProductValue.

varchar(50)

product_value

service_id

Foreign Key to Service.

varchar(50)

service

product_service_id

Foreign Key to ProductService.

varchar(50)

product_service

product_id

Foreign Key to Product.

varchar(50)

product

customer_id

Foreign Key to Customer.

varchar(50)

customer

customer_segment_id

Foreign Key to CustomerSegment.

varchar(50)

customer_segment

account_id

Foreign Key to Account.

varchar(50)

account

account_segment_id

Foreign Key to AccountSegment.

varchar(50)

account_segment

subscriber_id

Foreign Key to Subscriber.

varchar(50)

subscriber

subscriber_segment_id

Foreign Key to SubscriberSegment.

varchar(50)

subscriber_segment

offer_subscription_id

Foreign Key to OfferSubscription.

varchar(50)

offer_subscription

service_subscription_id

Foreign Key to ServiceSubscription.

varchar(50)

service_subscription

offer_id

Foreign Key to Offer.

varchar(50)

offer

currency_id

Foreign Key to Currency.

varchar(50)

currency

value_ent_date

Entry Date of Value.

timestamptz

X

value_valid_from

Date from when Value is valid.

timestamptz

value_valid_to

Date till when Value is valid.

timestamptz

reference_id

Reference to another ServiceValue which holds actual value.

varchar(50)

[service_value]

composed_index

Composed index, consists of indexType:entity:productService.

varchar(255)

content_def_id

Foreign Key to ContentDef.

varchar(50)

X

content_def

id

Internal ID, generated from the 'content_category_seq' Sequence.

bigint

X

ref_id

Ref ID of the ContentCategory.

varchar(40)

X

name

Name of the ContentCategory.

varchar(80)

X

description

Description of the ContentCategory.

varchar(255)

internal_code

Internal Code of the ContentCategory.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the ContentCategory may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

content_def_id

Foreign Key to ContentDef.

varchar(50)

X

content_def

charging_class_id

Foreign Key to ChargingClass.

varchar(50)

X

charging_class

id

Internal ID, generated from the 'content_def_seq' Sequence.

bigint

X

ref_id

Ref ID of the ContentDef.

varchar(40)

X

name

Name of the ContentDef.

varchar(80)

X

description

Description of the ContentDef.

varchar(255)

internal_code

Internal Code of the ContentDef.

varchar(60)

X

server_dependent

Indicates whether 'internalCode' of the ContentDef may be changed.

boolean

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

content_analysis_type

varchar(80)

X

id

Internal ID, generated from the 'content_item_seq' Sequence.

bigint

X

ref_id

Ref ID of the ContentItem.

varchar(40)

X

name

Name of the ContentItem.

varchar(80)

X

description

Description of the ContentItem.

varchar(255)

content_def_id

Foreign Key to ContentDef.

varchar(50)

X

content_def

content_category_id

Foreign Key to ContentCategory.

varchar(50)

content_category

charging_key

Charging Key based on which Content is identified.

varchar(255)

X

charging_class_id

Foreign Key to ChargingClass.

varchar(50)

charging_class

priority

Priority used for evaluation of Regular Expressions.

bigint

deployment_status

Status of the Deployment.

varchar(80)

deployment_valid_from

Deployment Valid From.

timestamptz

deployment_set_id

Foreign Key to DeploymentSet.

varchar(50)

deployment_set

id

Internal ID, generated from the 'content_usage_charge_seq' Sequence.

bigint

X

ref_id

Ref ID of the ContentUsageCharge.

varchar(40)

X

service_value_id

Foreign Key to ServiceValue.

varchar(50)

[service_value]

charge

${FIELD.DESCRIPTION}

varchar

charge_valid_from

Timestamp from when Charge is valid.

timestamptz

charge_valid_to

Timestamp till when Charge is valid.

timestamptz

composed_index

Composed index, consists of serviceValueClass:serviceValue:chargingClass.

varchar(255)

X

id

Internal ID, generated from the 'account_seq' Sequence.

bigint

X

ref_id

Ref ID of the Account.

varchar(40)

X

account_type_id

Foreign Key to AccountType.

varchar(50)

X

account_type

account_segment_id

Foreign Key to Account Segment.

varchar(50)

account_segment

customer_id

Foreign Key to Customer.

varchar(50)

X

customer

currency_id

Foreign Key to Currency.

varchar(50)

X

currency

external_id

External ID of the Account.

varchar(255)

custom_name

Custom Account name.

varchar(255)

custom_attributes

Custom attributes, Key - Value (String) Map.

text

bill_cycle_id

Foreign Key to BillCycle. Only for Payment responsible accounts.

varchar(50)

bill_cycle

bill_cycle_ent_date

Timestamp when BillCycle was entered.

timestamptz

bill_cycle_valid_from

Timestamp from when BillCycle is Valid.

timestamptz

bill_cycle_individual

Indicates whether standard Billing Cycle per Account is individual (due to Billing Cycle change, On-Demand billing, etc.).

boolean

billing_day

Day of the Billing in case Billing Cycle per Account is individual.

bigint

billing_month

Month of the Billing in case Billing Cycle per Account is individual.

bigint

billing_year

Year of the Billing in case Billing Cycle per Account is individual.

bigint

parent_id

Foreign Key to parent Account.

varchar(50)

account

payment_responsible

Indicates whether Account is Payment Responsible.

boolean

payment_responsible_account_id

Foreign Key to Payment Responsible Account. Not populated when Account is Payment responsible itself.

varchar(50)

account

tax_exemption

Indicates whether Account is subject of Tax exemption. If true, TaxExemptionType on Invoice is set to ACCOUNT.

boolean

tax_residence

Tax Residence of the Payment Responsible Account.

varchar(255)

state

State of the Account.

varchar(80)

X

state_reason_id

Reason associated with State.

varchar(50)

state_reason

state_ent_date

Timestamp when State was entered.

timestamptz

X

state_valid_from

Timestamp from when State is Valid.

timestamptz

X

state_transaction_id

Transaction ID for grouping changing of States into one logical transaction.

varchar(255)

X

inactive_reason_id

Reason associated with Inactive State.

varchar(50)

state_reason

inactive_ent_date

Timestamp when Inactive State was entered.

timestamptz

inactive_valid_from

Timestamp from when Inactive State is Valid and when Inactive State was entered.

timestamptz

activated_reason_id

Reason associated with Activated State.

varchar(50)

state_reason

activated_ent_date

Timestamp when Activated State was entered.

timestamptz

activated_valid_from

Timestamp from when Activated State is Valid.

timestamptz

re_activated_reason_id

Reason associated with Re-Activated State.

varchar(50)

state_reason

re_activated_ent_date

Timestamp when Re-Activated State was entered.

timestamptz

re_activated_valid_from

Timestamp from when Re-Activated State is Valid.

timestamptz

suspended_reason_id

Reason associated with Suspended State.

varchar(50)

state_reason

suspended_ent_date

Timestamp when Suspended State was entered.

timestamptz

suspended_valid_from

Timestamp from when Suspended State is Valid.

timestamptz

deactivated_reason_id

Reason associated with Deactivated State.

varchar(50)

state_reason

deactivated_ent_date

Timestamp when Deactivated State was entered.

timestamptz

deactivated_valid_from

Timestamp from when Deactivated State is Valid.

timestamptz

bill_cycle_change_id

Foreign Key to AccountBillCycleChange. Populated when Bill Cycle Change is scheduled.

varchar(50)

account_bill_cycle_change

pending_state_id

Foreign Key to PendingState. Populated when Account is in Pending state.

varchar(50)

pending_state

test_account

Indicates whether Account is a Test Account.

boolean

priority

Priority of the Account within Billing and Invoicing processing.

bigint

id

Internal ID, generated from the 'account_bill_cycle_change_seq' Sequence.

bigint

X

ref_id

Ref ID of the AccountBillCycleChange.

varchar(40)

X

account_id

Foreign Key to Account.

varchar(50)

X

account

bill_cycle_id

Foreign Key to Bill Cycle.

varchar(50)

X

bill_cycle

bill_cycle_individual

Indicates whether standard Billing Cycle per Account is individual (due to Billing Cycle change, On-Demand billing, etc.).

boolean

billing_day

Day of the Billing in case Billing Cycle per Account is individual.

bigint

billing_month

Month of the Billing in case Billing Cycle per Account is individual.

bigint

billing_year

Year of the Billing in case Billing Cycle per Account is individual.

bigint

bill_cycle_ent_date

Timestamp when Bill Cycle was entered.

timestamptz

X

bill_cycle_valid_from

Timestamp from when Bill Cycle is Valid.

timestamptz

X

transaction_id

Transaction ID for grouping changing of Change into one logical transaction.

varchar(255)

X

bill_cycle_changed_date

Timestamp when Bill Cycle Change was realized.

timestamptz

bill_cycle_cancelled_date

Timestamp when Bill Cycle Change was cancelled.

timestamptz

scheduled_run

Scheduled Date/Time of the Bill Cycle Change Run.

timestamptz

id

Internal ID, generated from the 'account_bill_cycle_hist_seq' Sequence.

bigint

X

ref_id

Ref ID of the AccountBillCycleHistory.

varchar(40)

X

account_id

Foreign Key to Account.

varchar(50)

X

account

bill_cycle_id

Foreign Key to Bill Cycle.

varchar(50)

X

bill_cycle

bill_cycle_individual

Indicates whether standard Billing Cycle per Account is individual (due to Billing Cycle change, On-Demand billing, etc.).

boolean

billing_day

Day of the Billing in case Billing Cycle per Account is individual.

bigint

billing_month

Month of the Billing in case Billing Cycle per Account is individual.

bigint

billing_year

Year of the Billing in case Billing Cycle per Account is individual.

bigint

bill_cycle_ent_date

Timestamp when Bill Cycle was entered.

timestamptz

X

bill_cycle_valid_from

Timestamp from when Bill Cycle is Valid.

timestamptz

X

bill_cycle_valid_to

Timestamp till when Bill Cycle is Valid.

timestamptz

transaction_id

Transaction ID for grouping changing of Change into one logical transaction.

varchar(255)

X

id

Internal ID, generated from the 'account_bill_cycle_run_seq' Sequence.

bigint

X

ref_id

Ref ID of the AccountBillCycleRun.

varchar(40)

X

account_id

Foreign Key to Account.

varchar(50)

X

account

bill_cycle_id

Foreign Key to Bill Cycle.

varchar(50)

X

bill_cycle

bill_cycle_type

Type of the Billing Cycle.

varchar(80)

X

invoice_reason

Reason for Invoicing.

varchar(80)