[FEAT] NTML database access pseudocode

[jpeterson1346]

Contact Details

usa9

Is your feature request related to a problem? If so, please describe.

Nope

What is your new feature idea or request?

I can give you credentials for my already-existing SQL server if you'd like. Just PM me or email me. Here's a gist of what it looks like:

GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NTML](
    [ENTRY_ID] [int] NOT NULL,
    [ntml_timestamp] [timestamp] NOT NULL,
    [ntml_entry_time] [datetime2](7) NULL,
    [ntml_restriction_type] [text] NULL,
    [requesting_facility] [text] NULL,
    [providing_facility] [text] NULL,
    [airport] [text] NULL,
    [via] [text] NULL,
    [MIT_restriction] [real] NULL,
    [MINIT_restriction] [real] NULL,
    [free_text] [text] NULL,
    [start_time] [datetime2](7) NULL,
    [end_time] [datetime2](7) NULL,
    [acft_type] [text] NULL,
    [speed] [int] NULL,
    [speed_qualifier] [text] NULL,
    [altitude] [int] NULL,
    [altitude_qualifier] [text] NULL,
    [restriction_qualifier] [text] NULL,
    [restriction_causal_factor] [text] NULL,
    [restriction_specific_impact] [text] NULL,
    [exclusions] [text] NULL,
    [proposed] [bit] NULL,
    [approved] [bit] NULL,
    [rejected] [bit] NULL,
    [passback] [bit] NULL,
    [delay_type] [text] NULL,
    [delay_causal_factor] [text] NULL,
    [delay_specific_impact] [text] NULL,
    [facility_holding] [text] NULL,
    [delay_arriving] [text] NULL,
    [delay_departing] [text] NULL,
    [delay_number_of_acft] [int] NULL,
    [delay_length] [int] NULL,
    [delay_qualifier] [text] NULL,
    [delay_time] [datetime2](7) NULL,
    [delay_fix] [text] NULL,
    [config_airport] [text] NULL,
    [config_weather] [text] NULL,
    [config_arrival_runway] [text] NULL,
    [config_departure_runway] [text] NULL,
    [config_strat_aar] [int] NULL,
    [config_adr] [int] NULL,
    [config_aar_adjustment] [text] NULL,
    [config_dyn_aar] [int] NULL,
    [specialist_id] [text] NULL,
    [ntml_restriction_scope] [text] NULL,
    [ntml_remarks] [text] NULL,
    [aprvl] [text] NULL,
    [specialist_facility] [text] NULL,
    [facilityTable] [text] NULL,
    [ntml_guid] [uniqueidentifier] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[NTML] ADD PRIMARY KEY CLUSTERED 
(
    [ENTRY_ID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_ntml_entry_time]  DEFAULT (getdate()) FOR [ntml_entry_time]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_ntml_restriction_type]  DEFAULT ('Default') FOR [ntml_restriction_type]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_requesting_facility]  DEFAULT ('ZXX') FOR [requesting_facility]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_providing_facility]  DEFAULT ('ZYY') FOR [providing_facility]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_airport]  DEFAULT ('XXX') FOR [airport]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_via]  DEFAULT ('Default') FOR [via]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_MIT_restriction]  DEFAULT ((-1)) FOR [MIT_restriction]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_MINIT_restriction]  DEFAULT ((-1)) FOR [MINIT_restriction]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_free_text]  DEFAULT ('[Enter text here]') FOR [free_text]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_start_time]  DEFAULT ('2001-01-01 00:00:00.000') FOR [start_time]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_end_time]  DEFAULT ('2001-01-01 23:59:59.999') FOR [end_time]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_acft_type]  DEFAULT ('Default') FOR [acft_type]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_speed]  DEFAULT ((-1)) FOR [speed]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_speed_qualifier]  DEFAULT ('') FOR [speed_qualifier]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_altitude]  DEFAULT ((-1)) FOR [altitude]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_altitude_qualifier]  DEFAULT ('') FOR [altitude_qualifier]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_restriction_qualifier]  DEFAULT ('') FOR [restriction_qualifier]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_restriction_causal_factor]  DEFAULT ('VOLUME') FOR [restriction_causal_factor]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_exclusions]  DEFAULT ('NONE') FOR [exclusions]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_ntml_restriction_scope]  DEFAULT ('En Route') FOR [ntml_restriction_scope]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_aprvl]  DEFAULT ('Unknown') FOR [aprvl]
GO
ALTER TABLE [dbo].[NTML] ADD  CONSTRAINT [df_specialist_facility]  DEFAULT ('ZXX') FOR [specialist_facility]
GO