-
-
Notifications
You must be signed in to change notification settings - Fork 9
Description
Add this table to the tests project and all the tests will disappear and the searcher will throw the error. It is not supposed to be temporal table, so all the temporal syntax can be excluded.
CREATE TABLE [dbo].[commercial_credit]
(
[lease_application] CHAR(8) NOT NULL PRIMARY KEY
, [lessee_name] CHAR(30) NULL
, [lessee_dba_name] CHAR(30) NULL
, [lessee_address_1] CHAR(30) NULL
, [lessee_address_2] CHAR(30) NULL
, [lessee_city] CHAR(17) NULL
, [lessee_state] CHAR(2) NULL
, [lessee_zip_code] CHAR(9) NULL
, [cellular_number] CHAR(10) NULL
, [bill_to_name] CHAR(30) NULL
, [bill_to_address_line_1] CHAR(30) NULL
, [bill_to_address_line_2] CHAR(30) NULL
, [bill_to_address_city] CHAR(17) NULL
, [bill_to_address_state] CHAR(2) NULL
, [bill_to_address_zip_code] CHAR(9) NULL
, [bill_to_contact] CHAR(30) NULL
, [bill_to_contact_phone] CHAR(18) NULL
, [tax_rate] DECIMAL(10, 4) NULL
, [tax_state] CHAR(2) NULL
, [primary_bank_name] CHAR(30) NULL
, [primary_bank_officer] CHAR(30) NULL
, [primary_bank_phone_number] CHAR(18) NULL
, [trade_1_name] CHAR(30) NULL
, [trade_1_phone_number] CHAR(18) NULL
, [trade_2_name] CHAR(30) NULL
, [trade_2_phone_number] CHAR(18) NULL
, [years_in_business] DECIMAL(5, 1) NULL
, [business_size] SMALLINT NULL
, [business_organization] CHAR(1) NULL
, [tax_exempt_indicator] CHAR(1) NULL
, [standard_industry_code] CHAR(5) NULL
, [bank_account_number] CHAR(17) NULL
, [bank_transit_number] CHAR(9) NULL
, [lessee_fed_id_number] CHAR(9) NULL
, [duns_number] CHAR(9) NULL
, [dba_duns_number] CHAR(9) NULL
, [debit_account_type] CHAR(1) NULL
, [debit_account_class] CHAR(1) NULL
, [lessee_contact] CHAR(30) NULL
, [lessee_email] CHAR(100) NULL
, [SysStart] DATETIME2(7) GENERATED ALWAYS AS ROW START NOT NULL
, [SysEnd] DATETIME2(7) GENERATED ALWAYS AS ROW END NOT NULL
, PERIOD FOR SYSTEM_TIME([SysStart], [SysEnd])
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = [dbo].[commercial_credit_history], DATA_CONSISTENCY_CHECK = ON));
GO
CREATE UNIQUE NONCLUSTERED INDEX [nu_commercial_credit__lease_application]
ON [dbo].[commercial_credit] ([lease_application] ASC);
GO
/*
CREATE NONCLUSTERED INDEX [_dta_index_commercial_credit_10_533576939__k1_3_4_6_7_8_17_40]
ON [dbo].[commercial_credit] ([lease_application] ASC)
INCLUDE
([lessee_dba_name]
,[lessee_address_1]
,[lessee_city]
,[lessee_state]
,[lessee_zip_code]
,[bill_to_contact_phone]
,[lessee_email]
) ;
GO
CREATE NONCLUSTERED INDEX [_dta_index_commercial_credit_10_533576939__k1_2_3_4_6_7_8_17]
ON [dbo].[commercial_credit] ([lease_application] ASC)
INCLUDE
([lessee_name]
,[lessee_dba_name]
,[lessee_address_1]
,[lessee_city]
,[lessee_state]
,[lessee_zip_code]
,[bill_to_contact_phone]
) ;
*/