ETL_DWH_LOCOSOFT/schema/LOCOSOFT/tables/privacy_protection_consent.sql

CREATE TABLE [dbo].[privacy_protection_consent] (
   [customer_number] [int] NOT NULL,
   [subsidiary_to_company_ref] [int] NOT NULL,
   [make_name] [varchar](50) NOT NULL
      CONSTRAINT [DF_privacy_protection_consent_make_name] DEFAULT (''),
   [validity_date_start] [datetime] NULL,
   [validity_date_end] [datetime] NULL,
   [created_print_time] [datetime] NULL,
   [created_employee_no] [int] NULL,
   [last_change_print_time] [datetime] NULL,
   [last_change_employee_no] [int] NULL,
   [first_ackno_print_time] [datetime] NULL,
   [first_ackno_employee_no] [int] NULL,
   [last_ackno_print_time] [datetime] NULL,
   [last_ackno_employee_no] [int] NULL,
   [first_consent_print_time] [datetime] NULL,
   [first_consent_employee_no] [int] NULL,
   [last_consent_print_time] [datetime] NULL,
   [last_consent_employee_no] [int] NULL,
   [internal_id] [bigint] NULL,
   [client_db] [varchar](20) NOT NULL

   ,CONSTRAINT [privacy_protection_consent$0] PRIMARY KEY CLUSTERED ([customer_number], [subsidiary_to_company_ref], [make_name], [client_db])
)


GO