Skip to end of metadata
Go to start of metadata

Tables

message_store_messages

Purpose

Holds messages sent by acceptor and initiator sessions for the current session

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTINTEGERNO

SESSION_IDVARCHAR(255)NO

MESSAGEVARCHAR(8192)NO

MSG_SEQ_NUMINTEGERNO

Indexes

Record Volume

The volume of this table will correspond to the volume of data sent from acceptor and initiator sessions during a particular session. This volume will vary daily and can be quite high.

message_store_sessions

Purpose

Holds session information for acceptor and initiator sessions

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTINTEGERNO

SESSION_IDVARCHAR(255)NO

CREATION_TIMETIMESTAMPNO

SENDER_SEQ_NUMINTEGERNO

TARGET_SEQ_NUMINTEGERNO

Indexes

Record Volume


The volume in this table corresponds to the number of acceptor and initiator sessions. The volume will be low.

exec_reports

Purpose

Tracks execution reports received from the broker

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

ACCOUNTVARCHAR(255)YES

AVG_PRICENUMBER(17,7)NO

CUM_QTYNUMBER(17,7)NO

EFF_CUM_QTYNUMBER(17,7)NO

EXPIRYVARCHAR(255)YES

IS_OPENNUMBER(1,0)NO

LAST_PRICENUMBER(17,7)YES

LAST_QTYNUMBER(17,7)YES

OPTION_TYPEBIGINTYES

ORDER_IDVARCHAR(255)NO

ORD_STATUSBIGINTNO

ORIG_ORDER_IDVARCHAR(255)YES

ROOT_ORDER_IDVARCHAR(255)NO

SECURITY_TYPEBIGINTNO

SEND_TIMETIMESTAMPNO

SIDEBIGINTNO

STRIKE_PRICENUMBER(17,7)YES

SYMBOLVARCHAR(255)NO

ACTOR_IDBIGINTYES

REPORT_IDBIGINTNO

VIEWER_IDBIGINTYES

Indexes:

  1. "exec_reports_pkey" PRIMARY KEY, btree (id)
  2. "uk_imdq099u0qa8ob9tt5ljm6f7u" UNIQUE CONSTRAINT, btree (report_id)

Foreign-key constraints:

  1. "fk1celhypj9vint37eobsn22s1b" FOREIGN KEY (viewer_id) REFERENCES users(id)
  2. "fkfn47lj607ghtt1lfie8adevxc" FOREIGN KEY (actor_id) REFERENCES users(id)
  3. "fkn47ta2b6e9wih8b97oubxvd3s" FOREIGN KEY (report_id) REFERENCES reports(id)

Record Volume

The volume of this table corresponds to the number of executions received from the brokers. The volume in this table will be high.

fix_messages

Purpose

Stores raw FIX messages in a common table

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMP(19,0)NO

UPDATED_COUNTBIGINTNO

MESSAGECLOBNO

Indexes

  1. SYS_C0057108 (ID)

Record Volume

The volume in this table corresponds to the volume of FIX messages handled by the system, both incoming and outgoing. Volume in this table will be very high.

fix_session_attr_dscrptrs

Purpose

Stores FIX session attribute descriptors which are used by the UI to help the user construct FIX sessions

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMP(19,0)NO

UPDATED_COUNTBIGINTNO

ADVICEVARCHAR(255 CHAR)YES

DEFAULT_VALUEVARCHAR(255 CHAR)YES

DESCRIPTIONVARCHAR(1024 CHAR)YES

NAMEVARCHAR(255 CHAR)NO

PATTERNVARCHAR(255 CHAR)YES

REQUIREDNUMBER(1,0)NO

Indexes

  1. SYS_C0057114 (ID)
  2. UK_GB3X058KYH5S4FXW1FI67BYSC (NAME)

Record Volume

The volume in this table corresponds to the number of FIX session attributes that are displayed in the UI. Volume in this table is very low.

fix_session_attributes

Purpose

Stores attributes associated with FIX sessions

Description

Column Name

Type/Length

Null

Data Element Name

Source

FIX_SESSION_IDBIGINTNO

VALUEVARCHAR(255 CHAR)YES

NAMEVARCHAR(255 CHAR)NO

Indexes

  1. SYS_C0057117 (FIX_SESSION_ID,NAME)
  2. UK_27G5LMKIQXLIYC4UTHPEE84Y0 (NAME)

Record Volume

Volume in this table corresponds to the number of attributes for a FIX session multiplied by the number of FIX sessions. Volume in this table will be low.

fix_sessions

Purpose

Stores FIX sessions to be created by the system

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMP(19,0)NO

UPDATED_COUNTBIGINTNO

AFFINITYBIGINTNO

BROKER_IDVARCHAR(255 CHAR)NO

DESCRIPTIONVARCHAR(255 CHAR)YES

HOSTVARCHAR(255 CHAR)NO

ACCEPTORNUMBER(1,0)NO

ENABLEDNUMBER(1,0)NO

NAMEVARCHAR(255 CHAR)NO

PORTBIGINTNO

SESSION_IDVARCHAR(255 CHAR)NO

Indexes

  1. SYS_C0057129 (ID)
  2. UK_687UFWJ0WKN28O0QEVJ8FDC65 (BROKER_ID)
  3. UK_PCFNP5Y816L25AYQ2LLE6BK8P (SESSION_ID)

Record Volume

The volume in this table corresponds to the number of FIX sessions in the system. The volume in this table will be very low.

id_repository

Purpose

Stores unique identifiers to be used by the system

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

NEXT_IDBIGINTYES

Indexes

  1. SYS_C0057133 (ID)

Record Volume

The volume in this table will be very low, typically a single record.

incoming_fix_messages

Purpose

Stores incoming messages to a FIX session

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

MESSAGEVARCHAR(4000 CHAR)NO

MSG_SEQ_NUMBIGINTNO

MSG_TYPEVARCHAR(255 CHAR)NO

SENDING_TIMETIMESTAMPNO

FIX_SESSIONVARCHAR(255 CHAR)NO

Indexes

  1. SYS_C0057140 (ID)

Record Volume

The volume in this table corresponds to the volume of FIX messages being received by the system for all sessions. The volume in this table will be very high.

outgoing_messages

Purpose

Stores messages created and sent out by DARE

Description

Column Name

Type/Length

Null

Data Element Name

Source

IDBIGINTNO

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

BROKER_IDVARCHAR(255 CHAR)NO

MESSAGE_TYPEVARCHAR(255 CHAR)NO

MSG_SEQ_NUMBIGINTYES

SENDER_COMP_IDVARCHAR(255 CHAR)NO

SESSION_IDVARCHAR(255 CHAR)NO

TARGET_COMP_IDVARCHAR(255 CHAR)NO

FIX_MESSAGE_IDBIGINTNO

Indexes

  1. SYS_C0057201 (ID)
  2. UK_HXVC6VRTMW1SWIK69WXT0DRLC (FIX_MESSAGE_ID)
  3. OUTGOING_MESSAGES_INDEX1 (SENDER_COMP_ID,TARGET_COMP_ID,MSG_SEQ_NUM)

Record Volume

The volume in this table corresponds to the number of messages sent out from LVTS to brokers. Volume in this table will be moderate to high.

permissions

Purpose

Stores permissions known to the system. Actions in the system can execute a check for a particular permission.

Description 

Column Name

Type/Length

Null

Data Element Name

Source

ID BIGINT NO 

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

DESCRIPTIONVARCHAR(255 CHAR)YES

NAMEVARCHAR(255 CHAR)NO

Indexes

  1. SYS_C0057206 (ID)
  2. UK_PNVTWLIIS6P05PN6I3NDJRQT2 (NAME)

Record Volume

The volume in this table corresponds to the number of distinct permissions defined to the system. The volume in this table will be low.

reports

Purpose

Stores all application messages received from the broker

Description 

Column Name

Type/Length

Null

Data Element Name

Source

ID BIGINT NO 

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTNUMBER(10,)NO

BROKER_IDVARCHAR(255 CHAR)YES

HIERARCHYBIGINTYES

ORIGINATORBIGINTYES

REPORT_TYPEBIGINTNO

MSG_SEQ_NUMBIGINTNO

ORDER_IDVARCHAR(255 CHAR)NO

REPORT_IDBIGINTNO

SEND_TIMETIMESTAMPNO

SESSION_IDVARCHAR(255 CHAR)NO

ACTOR_IDBIGINTYES

FIX_MESSAGE_IDBIGINTNO

VIEWER_IDBIGINTYES

Indexes

  1. SYS_C0057217 (ID)
  2. UK_AELY7CHRVTQWV4XFM76XUJ5BH (REPORT_ID)
  3. UK_CA90A4KKDYCPON22YNLI3D6OI (FIX_MESSAGE_ID)
  4. REPORTS_INDEX1 (msg_seq_num,order_id,session_id)
  5. REPORTS_INDEX2 (MSG_SEQ_NUM,ORDER_ID)

Record Volume

The volume in this table corresponds to the number of application messages received from the broker. The volume in this table will be very high.

roles

Purpose

Defines roles for users that describe a set of permissions that can be assigned

Description 

Column Name

Type/Length

Null

Data Element Name

Source

 IDBIGINT NO 

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

DESCRIPTIONVARCHAR(255 CHAR)YES

NAMEVARCHAR(255 CHAR)NO

Indexes

  1. SYS_C0057222 (ID)
  2. UK_OFX66KERUAPI6VYQPV6F2OR37 (NAME)

Record Volume

The volume in this table corresponds to the number of distinct roles defined to the system. The volume of this table will be very low.

roles_permissions

Purpose

Join table that assigns permissions to roles

Description 

Column Name

Type/Length

Null

Data Element Name

Source

 ROLES_IDBIGINT NO 

PERMISSIONS_IDBIGINTNO

Indexes

  1. SYS_C0057225 (ROLES_ID,PERMISSIONS_ID)

Record Volume

This table is used as a join table in a many-to-many relationship between roles and permissions. The volume of this table will be very low.

roles_users

Purpose

Join table that assigns roles to users

Description 

Column Name

Type/Length

Null

Data Element Name

Source

 ROLES_IDBIGINT NO 

SUBJECTS_IDBIGINTNO

Indexes

  1. SYS_C0057228 (ROLES_ID,SUBJECTS_ID)

Record Volume

This table is used as a join table in a many-to-many relationship between roles and users. The volume of this table will be very low.

system_info

Purpose

Contains key/value pairs that describe system attributes like current schema version, etc

Description 

Column Name

Type/Length

Null

Data Element Name

Source

 IDBIGINT NO 

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

DESCRIPTIONVARCHAR(255 CHAR)YES

NAMEVARCHAR(255 CHAR)NO

VALUEVARCHAR(255 CHAR)YES

Indexes

  1. SYS_C0057233 (ID)
  2. UK_457M1GI0J3JFT2B5WQ33ICCXK (NAME)

Record Volume

The volume in this table will be very low.

user_attributes

Purpose

Associates attributes with a user. Attributes can be used for a variety of system application functions (like preferences, e.g.)

Description 

Column Name

Type/Length

Null

Data Element Name

Source

ID BIGINT NO 

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

ATTRIBUTECLOBNO

USER_ATTRIBUTE_TYPEBIGINTNO

USER_IDBIGINTNO

Indexes

  1. SYS_C0057240 (ID)

Record Volume

The volume in this table corresponds to the number of users and the number of attributes stored for each user. The volume in this table will scale as a linear function of the number of users.

users

Purpose

Stores users for the application

Description 

Column Name

Type/Length

Null

Data Element Name

Source

Column Name

Type/Length

Null

Data Element Name

Source

ID BIGINT NO 

LAST_UPDATEDTIMESTAMPNO

UPDATE_COUNTBIGINTNO

DESCRIPTIONVARCHAR(255 CHAR)YES

NAMEVARCHAR(255 CHAR)NO

IS_ACTIVENUMBER(1,0)NO

PASSWORDVARCHAR(255 CHAR)NO

IS_SUPERUSERNUMBER(1,0)NO

USER_DATACLOBYES
 

Indexes

  1. SYS_C0057248 (ID)
  2. UK_3G1J96G94XPK3LPXL2QBL985X (NAME)

Record Volume

The volume of this table is related to the number of users defined to the system. The volume of this table will be low to moderate.


  • No labels