USE [GLOBAL_TABLE]
GO
/****** Object: Schema [sde] Script Date: 12/21/2023 9:00:10 AM ******/
CREATE SCHEMA [sde]
GO
/****** Object: Table [sde].[GLB_SEISMIC_2DLINES_API] Script Date: 12/21/2023 9:00:10 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [sde].[GLB_SEISMIC_2DLINES_API](
[OBJECTID] [int] NOT NULL,
[Shape] [geometry] NULL,
[GDB_GEOMATTR_DATA] [varbinary](max) NULL,
[basin_names] [nvarchar](200) NULL,
[contact] [nvarchar](230) NULL,
[contractor_name] [nvarchar](100) NULL,
[country_names] [nvarchar](84) NULL,
[data_owner] [nvarchar](100) NULL,
[data_quality] [nvarchar](18) NULL,
[data_source] [nvarchar](64) NULL,
[data_source_type] [nvarchar](24) NULL,
[datum] [nvarchar](52) NULL,
[digital_image] [nvarchar](6) NULL,
[end_date] [datetime2](7) NULL,
[energy_source] [nvarchar](54) NULL,
[field_names] [nvarchar](100) NULL,
[fold] [numeric](38, 8) NULL,
[fsp] [nvarchar](16) NULL,
[gg_date] [datetime2](7) NULL,
[gg_oper] [nvarchar](28) NULL,
[globalid] [nvarchar](76) NULL,
[index_x] [numeric](38, 8) NULL,
[isp] [nvarchar](16) NULL,
[length_rep_cal] [nvarchar](6) NULL,
[line_km] [numeric](38, 8) NULL,
[line_name] [nvarchar](56) NULL,
[notes] [nvarchar](202) NULL,
[operator_name] [nvarchar](100) NULL,
[purpose_of_survey] [nvarchar](40) NULL,
[region_name] [nvarchar](36) NULL,
[situation] [nvarchar](32) NULL,
[start_date] [datetime2](7) NULL,
[survey_name] [nvarchar](100) NULL,
[terrain] [nvarchar](32) NULL,
[vessel] [nvarchar](40) NULL,
[vintage] [numeric](38, 8) NULL,
[entitled_key] [nvarchar](12) NULL,
CONSTRAINT [R910_pk] PRIMARY KEY CLUSTERED
(
[OBJECTID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [sde].[GLB_SEISMIC_2DLINES_API] WITH CHECK ADD CONSTRAINT [g787_ck] CHECK (([SHAPE].[STSrid]=(3857)))
GO
ALTER TABLE [sde].[GLB_SEISMIC_2DLINES_API] CHECK CONSTRAINT [g787_ck]
GO