/********************************************************************************
Target Server  : GPPDBAWS01                       
Target Database: TRUCK
Author         : David Morinello
Date Created   : 08/16/2023
Version        : 0.5 Table Design Inwork
Purpose        : Customer Audit-Table and Trigger to Track Customer Master table changes 
Note           : Create RM00101_Audit_Tracking Table.sql
               : https://truckprovsts.visualstudio.com/TruckPro%20Portfolio%20Project/_workitems/edit/25742
********************************************************************************/
USE [TRUCK]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

DROP TABLE IF EXISTS [dbo].[RM00101_Audit_Tracking] --SQL 2016 Feature

CREATE TABLE [dbo].[RM00101_Audit_Tracking](
	[CUSTNMBR] [CHAR](15) NOT NULL,
	[CUSTNAME] [CHAR](65) NULL,
	[CRLMTAMT] NUMERIC (19,5) NULL,
	[PYMTRMID] [CHAR](21) NULL,
	[PRBTADCD] [CHAR](15) NULL,
    [ChangeNote][CHAR](15) NOT NULL,
	[ChangeDate] [DATETIME] NULL,
	[ChgUser] [NVARCHAR](128) NOT NULL,
--	[DEX_ROW_TS] [DATETIME] NOT NULL,
	[DEX_ROW_ID] [INT] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PKRM00101_Change] PRIMARY KEY NONCLUSTERED 
(
	[CUSTNMBR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO

--ALTER TABLE [dbo].[RM00101_Audit_Tracking] ADD  CONSTRAINT [DF__RM00101_Audit_Tracking__DEX_ROW__1154E6D5]  DEFAULT (GETUTCDATE()) FOR [DEX_ROW_TS]
--GO


/*

Select * from RM00101_Audit_Tracking

sp_helptrigger RM00101

*/