1 | -- layer_at1 -- |
---|
2 | CREATE TABLE `layer_at1` ( |
---|
3 | `OBJECT_ID` int(10) unsigned NOT NULL, |
---|
4 | `D_C_UNDERG` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
5 | `MAIN_TARG` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
6 | `DEPTH_TOT` int(11) DEFAULT NULL, |
---|
7 | `FM_A` int(11) DEFAULT NULL, |
---|
8 | `DEPTH_FM_A` int(11) DEFAULT NULL, |
---|
9 | PRIMARY KEY (`OBJECT_ID`), |
---|
10 | KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) |
---|
11 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
12 | |
---|
13 | -- layer_at2 -- |
---|
14 | CREATE TABLE `layer_at2` ( |
---|
15 | `OBJECT_ID` int(10) unsigned NOT NULL, |
---|
16 | `STATUS` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
17 | `TYPE` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
18 | `TEMP` int(11) DEFAULT NULL, |
---|
19 | PRIMARY KEY (`OBJECT_ID`), |
---|
20 | KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) |
---|
21 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
22 | |
---|
23 | -- layer_at3 -- |
---|
24 | CREATE TABLE `layer_at3` ( |
---|
25 | `OBJECT_ID` int(10) unsigned NOT NULL, |
---|
26 | `PHASE` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
27 | `DIP_DIRECT` int(11) DEFAULT NULL COMMENT 'ORIENTATION', |
---|
28 | `DIP` int(11) DEFAULT NULL, |
---|
29 | PRIMARY KEY (`OBJECT_ID`), |
---|
30 | KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) |
---|
31 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
32 | |
---|
33 | -- layer_at4 -- |
---|
34 | CREATE TABLE `layer_at4` ( |
---|
35 | `OBJECT_ID` int(10) unsigned NOT NULL, |
---|
36 | `PHASE` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
37 | `PLUNGE_DIR` int(11) DEFAULT NULL COMMENT 'ORIENTATION', |
---|
38 | `PLUNGE` int(11) DEFAULT NULL, |
---|
39 | PRIMARY KEY (`OBJECT_ID`), |
---|
40 | KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) |
---|
41 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
42 | |
---|
43 | -- layer_at7 -- |
---|
44 | CREATE TABLE `layer_at7` ( |
---|
45 | `OBJECT_ID` int(10) unsigned NOT NULL, |
---|
46 | `LIM_TECT_U` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
47 | `STATUS` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
48 | `ACTIVITY` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
49 | PRIMARY KEY (`OBJECT_ID`), |
---|
50 | KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) |
---|
51 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
52 | |
---|
53 | -- layer_at9 -- |
---|
54 | CREATE TABLE `layer_at9` ( |
---|
55 | `OBJECT_ID` int(10) unsigned NOT NULL, |
---|
56 | `STATUS` int(11) DEFAULT NULL COMMENT 'ENUMERATION', |
---|
57 | PRIMARY KEY (`OBJECT_ID`), |
---|
58 | KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) |
---|
59 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
60 | |
---|