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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | INTEGER | NO | ||
SESSION_ID | VARCHAR(255) | NO | ||
MESSAGE | VARCHAR(8192) | NO | ||
MSG_SEQ_NUM | INTEGER | NO |
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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | INTEGER | NO | ||
SESSION_ID | VARCHAR(255) | NO | ||
CREATION_TIME | TIMESTAMP | NO | ||
SENDER_SEQ_NUM | INTEGER | NO | ||
TARGET_SEQ_NUM | INTEGER | NO |
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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
ACCOUNT | VARCHAR(255) | YES | ||
AVG_PRICE | NUMBER(17,7) | NO | ||
CUM_QTY | NUMBER(17,7) | NO | ||
EFF_CUM_QTY | NUMBER(17,7) | NO | ||
EXPIRY | VARCHAR(255) | YES | ||
IS_OPEN | NUMBER(1,0) | NO | ||
LAST_PRICE | NUMBER(17,7) | YES | ||
LAST_QTY | NUMBER(17,7) | YES | ||
OPTION_TYPE | BIGINT | YES | ||
ORDER_ID | VARCHAR(255) | NO | ||
ORD_STATUS | BIGINT | NO | ||
ORIG_ORDER_ID | VARCHAR(255) | YES | ||
ROOT_ORDER_ID | VARCHAR(255) | NO | ||
SECURITY_TYPE | BIGINT | NO | ||
SEND_TIME | TIMESTAMP | NO | ||
SIDE | BIGINT | NO | ||
STRIKE_PRICE | NUMBER(17,7) | YES | ||
SYMBOL | VARCHAR(255) | NO | ||
ACTOR_ID | BIGINT | YES | ||
REPORT_ID | BIGINT | NO | ||
VIEWER_ID | BIGINT | YES |
Indexes:
- "exec_reports_pkey" PRIMARY KEY, btree (id)
- "uk_imdq099u0qa8ob9tt5ljm6f7u" UNIQUE CONSTRAINT, btree (report_id)
Foreign-key constraints:
- "fk1celhypj9vint37eobsn22s1b" FOREIGN KEY (viewer_id) REFERENCES users(id)
- "fkfn47lj607ghtt1lfie8adevxc" FOREIGN KEY (actor_id) REFERENCES users(id)
- "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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP(19,0) | NO | ||
UPDATED_COUNT | BIGINT | NO | ||
MESSAGE | CLOB | NO |
Indexes
- 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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP(19,0) | NO | ||
UPDATED_COUNT | BIGINT | NO | ||
ADVICE | VARCHAR(255 CHAR) | YES | ||
DEFAULT_VALUE | VARCHAR(255 CHAR) | YES | ||
DESCRIPTION | VARCHAR(1024 CHAR) | YES | ||
NAME | VARCHAR(255 CHAR) | NO | ||
PATTERN | VARCHAR(255 CHAR) | YES | ||
REQUIRED | NUMBER(1,0) | NO |
Indexes
- SYS_C0057114 (ID)
- 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_ID | BIGINT | NO | ||
VALUE | VARCHAR(255 CHAR) | YES | ||
NAME | VARCHAR(255 CHAR) | NO |
Indexes
- SYS_C0057117 (FIX_SESSION_ID,NAME)
- 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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP(19,0) | NO | ||
UPDATED_COUNT | BIGINT | NO | ||
AFFINITY | BIGINT | NO | ||
BROKER_ID | VARCHAR(255 CHAR) | NO | ||
DESCRIPTION | VARCHAR(255 CHAR) | YES | ||
HOST | VARCHAR(255 CHAR) | NO | ||
ACCEPTOR | NUMBER(1,0) | NO | ||
ENABLED | NUMBER(1,0) | NO | ||
NAME | VARCHAR(255 CHAR) | NO | ||
PORT | BIGINT | NO | ||
SESSION_ID | VARCHAR(255 CHAR) | NO |
Indexes
- SYS_C0057129 (ID)
- UK_687UFWJ0WKN28O0QEVJ8FDC65 (BROKER_ID)
- 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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
NEXT_ID | BIGINT | YES |
Indexes
- 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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
MESSAGE | VARCHAR(4000 CHAR) | NO | ||
MSG_SEQ_NUM | BIGINT | NO | ||
MSG_TYPE | VARCHAR(255 CHAR) | NO | ||
SENDING_TIME | TIMESTAMP | NO | ||
FIX_SESSION | VARCHAR(255 CHAR) | NO |
Indexes
- 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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
BROKER_ID | VARCHAR(255 CHAR) | NO | ||
MESSAGE_TYPE | VARCHAR(255 CHAR) | NO | ||
MSG_SEQ_NUM | BIGINT | YES | ||
SENDER_COMP_ID | VARCHAR(255 CHAR) | NO | ||
SESSION_ID | VARCHAR(255 CHAR) | NO | ||
TARGET_COMP_ID | VARCHAR(255 CHAR) | NO | ||
FIX_MESSAGE_ID | BIGINT | NO |
Indexes
- SYS_C0057201 (ID)
- UK_HXVC6VRTMW1SWIK69WXT0DRLC (FIX_MESSAGE_ID)
- 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_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
DESCRIPTION | VARCHAR(255 CHAR) | YES | ||
NAME | VARCHAR(255 CHAR) | NO |
Indexes
- SYS_C0057206 (ID)
- 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_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | NUMBER(10,) | NO | ||
BROKER_ID | VARCHAR(255 CHAR) | YES | ||
HIERARCHY | BIGINT | YES | ||
ORIGINATOR | BIGINT | YES | ||
REPORT_TYPE | BIGINT | NO | ||
MSG_SEQ_NUM | BIGINT | NO | ||
ORDER_ID | VARCHAR(255 CHAR) | NO | ||
REPORT_ID | BIGINT | NO | ||
SEND_TIME | TIMESTAMP | NO | ||
SESSION_ID | VARCHAR(255 CHAR) | NO | ||
ACTOR_ID | BIGINT | YES | ||
FIX_MESSAGE_ID | BIGINT | NO | ||
VIEWER_ID | BIGINT | YES |
Indexes
- SYS_C0057217 (ID)
- UK_AELY7CHRVTQWV4XFM76XUJ5BH (REPORT_ID)
- UK_CA90A4KKDYCPON22YNLI3D6OI (FIX_MESSAGE_ID)
- REPORTS_INDEX1 (msg_seq_num,order_id,session_id)
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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
DESCRIPTION | VARCHAR(255 CHAR) | YES | ||
NAME | VARCHAR(255 CHAR) | NO |
Indexes
- SYS_C0057222 (ID)
- 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_ID | BIGINT | NO | ||
PERMISSIONS_ID | BIGINT | NO |
Indexes
- 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_ID | BIGINT | NO | ||
SUBJECTS_ID | BIGINT | NO |
Indexes
- 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 |
---|---|---|---|---|
ID | BIGINT | NO | ||
LAST_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
DESCRIPTION | VARCHAR(255 CHAR) | YES | ||
NAME | VARCHAR(255 CHAR) | NO | ||
VALUE | VARCHAR(255 CHAR) | YES |
Indexes
- SYS_C0057233 (ID)
- 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_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
ATTRIBUTE | CLOB | NO | ||
USER_ATTRIBUTE_TYPE | BIGINT | NO | ||
USER_ID | BIGINT | NO |
Indexes
- 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_UPDATED | TIMESTAMP | NO | ||
UPDATE_COUNT | BIGINT | NO | ||
DESCRIPTION | VARCHAR(255 CHAR) | YES | ||
NAME | VARCHAR(255 CHAR) | NO | ||
IS_ACTIVE | NUMBER(1,0) | NO | ||
PASSWORD | VARCHAR(255 CHAR) | NO | ||
IS_SUPERUSER | NUMBER(1,0) | NO | ||
USER_DATA | CLOB | YES |
Indexes
- SYS_C0057248 (ID)
- 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.