Specification » History » Version 1
chin-yeh, 08/02/2011 03:27 PM
1 | 1 | chin-yeh | {{toc}} |
---|---|---|---|
2 | |||
3 | h1. Specification |
||
4 | |||
5 | h2. Table(s) Used |
||
6 | |||
7 | h3. DP_INTERFACE |
||
8 | |||
9 | <pre> |
||
10 | <code class="SQL"> |
||
11 | create table dp_interface ( |
||
12 | id int not null generated always as identity, |
||
13 | trx_id varchar(30) not null, |
||
14 | trx_type varchar(15), |
||
15 | status varchar(15), |
||
16 | last_updated timestamp, |
||
17 | error_code varchar(10), |
||
18 | error_message varchar(255), |
||
19 | primary key (id) |
||
20 | ); |
||
21 | |||
22 | create unique index idx_dp_trx_id on dp_interface(trx_id); |
||
23 | |||
24 | create index idx_dp_status on dp_interface(status); |
||
25 | create index idx_dp_err_code on dp_interface(error_code); |
||
26 | </code> |
||
27 | </pre> |