cesium_map_config_comments.sql 1.7 KB

123456789101112131415161718192021222324252627
  1. -- ----------------------------
  2. -- Comments for CESIUM_MAP_CONFIG
  3. -- ----------------------------
  4. COMMENT ON TABLE WATERSHED.CESIUM_MAP_CONFIG IS '地图配置表';
  5. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.config_id IS '配置ID';
  6. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.user_id IS '用户ID';
  7. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.config_name IS '配置名称';
  8. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.base_layer_type IS '底图类型';
  9. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.base_layer_name IS '底图名称';
  10. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.base_layer_url IS '底图URL';
  11. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.terrain_layer_type IS '地形类型';
  12. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.terrain_layer_name IS '地形名称';
  13. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.terrain_layer_url IS '地形URL';
  14. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.web_services IS '公共服务配置(JSON格式)';
  15. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.loaded_models IS '已加载模型配置(JSON格式)';
  16. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.is_default IS '是否默认配置(0否 1是)';
  17. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.create_by IS '创建者';
  18. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.create_time IS '创建时间';
  19. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.update_by IS '更新者';
  20. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.update_time IS '更新时间';
  21. COMMENT ON COLUMN WATERSHED.CESIUM_MAP_CONFIG.remark IS '备注';
  22. -- ----------------------------
  23. -- Indexes for CESIUM_MAP_CONFIG
  24. -- ----------------------------
  25. CREATE INDEX idx_user_id ON WATERSHED.CESIUM_MAP_CONFIG(user_id);
  26. CREATE INDEX idx_is_default ON WATERSHED.CESIUM_MAP_CONFIG(is_default);