cesium_map_config.sql 687 B

12345678910111213141516171819202122
  1. -- ----------------------------
  2. -- Table structure for cesium_map_config
  3. -- ----------------------------
  4. CREATE TABLE WATERSHED.CESIUM_MAP_CONFIG (
  5. config_id BIGINT IDENTITY(1,1) PRIMARY KEY,
  6. user_id BIGINT NOT NULL,
  7. config_name VARCHAR(100) DEFAULT '默认配置',
  8. base_layer_type VARCHAR(50),
  9. base_layer_name VARCHAR(100),
  10. base_layer_url VARCHAR(500),
  11. terrain_layer_type VARCHAR(50),
  12. terrain_layer_name VARCHAR(100),
  13. terrain_layer_url VARCHAR(500),
  14. web_services CLOB,
  15. loaded_models CLOB,
  16. is_default INT DEFAULT 0,
  17. create_by VARCHAR(64) DEFAULT '',
  18. create_time TIMESTAMP,
  19. update_by VARCHAR(64) DEFAULT '',
  20. update_time TIMESTAMP,
  21. remark VARCHAR(500)
  22. );