Changeset 22


Ignore:
Timestamp:
02/25/13 14:03:28 (11 years ago)
Author:
lucsch
Message:

Correcting swisstopo data model definition (columns missing)

Location:
trunk/models/swisstopo
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/models/swisstopo/user_structure.sql

    r21 r22  
    109109-- layer_at19 -- 
    110110CREATE TABLE `layer_at19` ( 
     111 `OBJECT_ID` int(10) unsigned NOT NULL, 
    111112 `Fault_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    112113 `Verti_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    123124-- layer_at20 -- 
    124125CREATE TABLE `layer_at20` ( 
     126 `OBJECT_ID` int(10) unsigned NOT NULL, 
    125127 `Fold_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    126128 `Fold_For` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    135137-- layer_at21 -- 
    136138CREATE TABLE `layer_at21` ( 
     139 `OBJECT_ID` int(10) unsigned NOT NULL, 
    137140 `Kind` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    138141 `Plunge_Dir` int(11) DEFAULT NULL, 
     
    144147-- layer_at22 -- 
    145148CREATE TABLE `layer_at22` ( 
     149 `OBJECT_ID` int(10) unsigned NOT NULL, 
    146150 `Polarity` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    147151 `Phase` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    156160-- layer_at23 -- 
    157161CREATE TABLE `layer_at23` ( 
     162 `OBJECT_ID` int(10) unsigned NOT NULL, 
    158163 `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    159164  PRIMARY KEY (`OBJECT_ID`), 
     
    163168-- layer_at24 -- 
    164169CREATE TABLE `layer_at24` ( 
     170 `OBJECT_ID` int(10) unsigned NOT NULL, 
    165171 `Division` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    166172 `System` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    174180 -- layer_at25 -- 
    175181CREATE TABLE `layer_at25` ( 
     182 `OBJECT_ID` int(10) unsigned NOT NULL, 
    176183 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    177184 `Material` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    183190  -- layer_at26 -- 
    184191CREATE TABLE `layer_at26` ( 
     192 `OBJECT_ID` int(10) unsigned NOT NULL, 
    185193 `Chemistry` varchar(254) DEFAULT NULL, 
    186194  PRIMARY KEY (`OBJECT_ID`), 
     
    190198  -- layer_at27 -- 
    191199CREATE TABLE `layer_at27` ( 
     200 `OBJECT_ID` int(10) unsigned NOT NULL, 
    192201 `Orient` int(11) DEFAULT NULL,  
    193202  PRIMARY KEY (`OBJECT_ID`), 
     
    197206 -- layer_at28 -- 
    198207CREATE TABLE `layer_at28` ( 
     208 `OBJECT_ID` int(10) unsigned NOT NULL, 
    199209 `Strati` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    200210 `Name` varchar(254) DEFAULT NULL, 
     
    207217-- layer_at29 -- 
    208218CREATE TABLE `layer_at29` ( 
     219 `OBJECT_ID` int(10) unsigned NOT NULL, 
    209220 `Cong_Spe` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    210221 `Name_Horiz` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    216227-- layer_at31 -- 
    217228CREATE TABLE `layer_at31` ( 
     229 `OBJECT_ID` int(10) unsigned NOT NULL, 
    218230 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    219231  PRIMARY KEY (`OBJECT_ID`), 
     
    223235-- layer_at32 -- 
    224236CREATE TABLE `layer_at32` ( 
     237 `OBJECT_ID` int(10) unsigned NOT NULL, 
    225238 `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    226239 `Dip_Direct` int(11) DEFAULT NULL, 
     
    232245 -- layer_at33 -- 
    233246CREATE TABLE `layer_at33` ( 
     247 `OBJECT_ID` int(10) unsigned NOT NULL, 
    234248 `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    235249 `Altitude` decimal (5,2) DEFAULT NULL, 
     
    240254-- layer_at34 -- 
    241255CREATE TABLE `layer_at34` ( 
     256 `OBJECT_ID` int(10) unsigned NOT NULL, 
    242257 `Dip_Direct` int(11) DEFAULT NULL, 
    243258 `Dip` int(11) DEFAULT NULL, 
     
    250265-- layer_at35 -- 
    251266CREATE TABLE `layer_at35` ( 
     267 `OBJECT_ID` int(10) unsigned NOT NULL, 
    252268 `Confine` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    253269 `Altitude` decimal (5,2) DEFAULT NULL, 
     
    259275-- layer_at36 -- 
    260276CREATE TABLE `layer_at36` ( 
     277 `OBJECT_ID` int(10) unsigned NOT NULL, 
    261278 `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    262279 `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    269286-- layer_at37 -- 
    270287CREATE TABLE `layer_at37` ( 
     288 `OBJECT_ID` int(10) unsigned NOT NULL, 
    271289 `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    272290 `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    278296-- layer_at38 -- 
    279297CREATE TABLE `layer_at38` ( 
     298 `OBJECT_ID` int(10) unsigned NOT NULL, 
    280299 `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    281300 `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    287306-- layer_at39 -- 
    288307CREATE TABLE `layer_at39` ( 
     308 `OBJECT_ID` int(10) unsigned NOT NULL, 
    289309 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    290310 `Depth_Tot` decimal (5,2) DEFAULT NULL, 
     
    296316 -- layer_at40 -- 
    297317CREATE TABLE `layer_at40` ( 
     318 `OBJECT_ID` int(10) unsigned NOT NULL, 
    298319 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    299320  PRIMARY KEY (`OBJECT_ID`), 
     
    303324-- layer_at41 -- 
    304325CREATE TABLE `layer_at41` ( 
     326 `OBJECT_ID` int(10) unsigned NOT NULL, 
    305327 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    306328 `Targ_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    311333-- layer_at42 -- 
    312334CREATE TABLE `layer_at42` ( 
     335 `OBJECT_ID` int(10) unsigned NOT NULL, 
    313336 `Drill_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    314337 `Depth_Bedr` decimal (5,2) DEFAULT NULL, 
     
    330353-- layer_at44 -- 
    331354CREATE TABLE `layer_at44` ( 
     355 `OBJECT_ID` int(10) unsigned NOT NULL, 
    332356 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    333357 `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
     
    341365-- layer_at45 -- 
    342366CREATE TABLE `layer_at45` ( 
     367 `OBJECT_ID` int(10) unsigned NOT NULL, 
    343368 `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    344369  PRIMARY KEY (`OBJECT_ID`), 
     
    348373-- layer_at46 -- 
    349374CREATE TABLE `layer_at46` ( 
     375 `OBJECT_ID` int(10) unsigned NOT NULL, 
    350376 `Rel_Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    351377 `Ref_Year` int(11) DEFAULT NULL, 
     
    357383-- layer_at47 -- 
    358384CREATE TABLE `layer_at47` ( 
     385 `OBJECT_ID` int(10) unsigned NOT NULL, 
    359386 `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    360387  PRIMARY KEY (`OBJECT_ID`), 
     
    364391-- layer_at48 -- 
    365392CREATE TABLE `layer_at48` ( 
     393 `OBJECT_ID` int(10) unsigned NOT NULL, 
    366394 `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
    367395 `Flow_Con` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 
Note: See TracChangeset for help on using the changeset viewer.