Table Country

DDL

create sequence seqCountry as bigint start with 1;

create table Country (
   cuID pointer not null default next value for seqCountry,
   cuCreatedOn datetime not null default sysdatetime(),
   cuCreatedByFK bigint not null,
   cuChangedOn datetime not null default sysdatetime(),
   cuChangedByFK bigint not NULL,
   cuCountryCode name NOT NULL,
   cuAreaID int NULL,
   cuArea name NULL,
   CONSTRAINT pkCountry PRIMARY KEY (cuID)
);
create unique index udxCountryCode on Country(cuCountryCode);

Default Data

insert into Country (cuID, cuCreatedByFK, cuChangedByFK, cuCountryCode,cuAreaID, cuArea)
 values (0,0,0,'?',0, 'unknown');
insert into Country (cuID, cuCreatedByFK, cuChangedByFK, cuCountryCode,cuAreaID, cuArea)
  values (1,0,0,'LCW',0, 'LCW');

Mapping

Country

Conversion ID:

New	Old
cuID
cuCreatedOn
cuCreatedByFK
cuChangedOn
cuChangedByFK
cuCountryCode	CountryCode
cuAreaID	AREAID
cuArea	AREA

NRW_CI_DET

New	Old
cuID
cuCreatedOn
cuCreatedByFK
cuChangedOn
cuChangedByFK
cuCountryCode	COO
cuAreaID
cuArea