CREATE TABLE [dbo].[auth_main]
(
auth_key int primary key identity(1,1) not null ,
proc_user_id int not null,
proc_status_id int not null,
pt_key int not null ,
auth_ref_no nvarchar(20) not null ,
auth_version_no int not null ,
prov_key int null ,
prov_sys_key int null ,
prov_prac_key INT not null ,
prov_unit_key int not null ,
auth_create_dt datetime not null ,
auth_from_dt datetime null ,
auth_till_dt datetime null ,
auth_type_key int not null ,
auth_process_status_key int not null ,
auth_to_scheme_dt datetime null ,
auth_scheme_status_key int null ,
auth_scheme_ref nvarchar(20) null ,
auth_cloning_ref int null,
modified_dt datetime not null ,
modified_by uniqueidentifier not null
)
