1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
CREATE TABLE GENERATED_MESSAGE (
id_id_gme INT NOT NULL,
tme_since_gme DATETIME NOT NULL,
tor_since_gme CHAR ( 3 ) NOT NULL,
tme_until_gme DATETIME,
int_occur_gme MEDIUMINT NOT NULL,
stm_status_gme VARCHAR ( 30 ) NOT NULL,
knd_ima_gme VARCHAR ( 3 ),
int_event_gme MEDIUMINT NOT NULL,
cla_class_gme TINYINT NOT NULL,
int_msn_acf MEDIUMINT NOT NULL,
id_id_phi INT NOT NULL,
int_id_syb MEDIUMINT NOT NULL,
sid_side_bas MEDIUMINT NOT NULL,
fmc_code_fau INT NOT NULL,
int_version_top MEDIUMINT NOT NULL,
boo_gndscan_gme TINYINT(1),
PRIMARY KEY (id_id_gme),
INDEX gme_index (int_id_syb, sid_side_bas, fmc_code_fau, int_version_top)) TYPE = InnoDB
CREATE TABLE FDCE_CODE (
id_id_fdv INT NOT NULL AUTO_INCREMENT,
fde_code_fdv MEDIUMINT NOT NULL,
fdt_type_fdv MEDIUMINT NOT NULL,
id_id_gme INT NOT NULL,
boo_isfromcd_fdv TINYINT(1),
PRIMARY KEY (id_id_fdv, fde_code_fdv),
INDEX fdecode_index (id_id_gme),
FOREIGN KEY (id_id_gme) REFERENCES GENERATED_MESSAGE (id_id_gme)) TYPE = InnoDB
CREATE TABLE COMPLEMENTARY_DATA (
id_id_cod INT NOT NULL AUTO_INCREMENT,
int_set_cod TINYINT NOT NULL,
bin_codata_cod BLOB,
tme_newconfirmation_cod DATETIME NOT NULL,
id_id_gme INT NOT NULL,
fmcgroup_code_cod MEDIUMINT,
PRIMARY KEY (id_id_cod),
INDEX cd_index (id_id_gme),
FOREIGN KEY (id_id_gme) REFERENCES GENERATED_MESSAGE (id_id_gme)) TYPE = InnoDB |
