[507] | 1 | /*
|
---|
| 2 | Table creation script for the aggregation tables. These should be
|
---|
| 3 | loaded into the AGGREGATI0N schema. They are used when doing
|
---|
| 4 | aggregation of responses from multple systems that come in on separate
|
---|
| 5 | threads.
|
---|
| 6 |
|
---|
| 7 | This script was intended to be run on MySQL.
|
---|
| 8 | */
|
---|
| 9 |
|
---|
| 10 | DROP TABLE IF EXISTS agg_transaction CASCADE;
|
---|
| 11 | CREATE TABLE agg_transaction (
|
---|
| 12 | TransactionId VARCHAR(32) NOT NULL COMMENT 'This will be a UUID',
|
---|
| 13 | ServiceType VARCHAR(64) NOT NULL,
|
---|
| 14 | TransactionStartTime DATETIME COMMENT 'Format of YYYYMMDDHHMMSS');
|
---|
| 15 |
|
---|
| 16 | ALTER TABLE agg_transaction
|
---|
| 17 | ADD CONSTRAINT agg_transaction_pk PRIMARY KEY(TransactionId);
|
---|
| 18 |
|
---|
| 19 | DROP TABLE IF EXISTS agg_message_results CASCADE;
|
---|
| 20 | CREATE TABLE agg_message_results (
|
---|
| 21 | MessageId VARCHAR(32) NOT NULL COMMENT 'This will be a UUID.',
|
---|
| 22 | TransactionId VARCHAR(32) NOT NULL COMMENT 'This will be a UUID. - Foreign Key to the agg_transaction table.',
|
---|
| 23 | MessageKey VARCHAR(1000) NOT NULL COMMENT 'This is the key used to tie the response to the original request.',
|
---|
| 24 | MessageOutTime DATETIME COMMENT 'This is the date/time when the outbound request was recorded. Format of YYYYMMDDHHMMSS',
|
---|
| 25 | ResponseReceivedTime DATETIME COMMENT 'This is the date/time when the response was recorded. Format of YYYYMMDDHHMMSS',
|
---|
| 26 | ResponseMessageType VARCHAR(100) COMMENT 'This is the name of the outer layer JAXB class for the response message.',
|
---|
| 27 | ResponseMessage LONGTEXT COMMENT 'The response message in XML - Based on marshalling using JAXB');
|
---|
| 28 |
|
---|
| 29 | ALTER TABLE agg_message_results
|
---|
| 30 | ADD CONSTRAINT agg_message_results_pk PRIMARY KEY (MessageId);
|
---|
| 31 |
|
---|
| 32 |
|
---|
| 33 |
|
---|