Table ArticleTranslation

DDL

create sequence seqArticleTranslation as bigint start with 1;

create table ArticleTranslation (
   arID bigint not null default next value for seqArticleTranslation,
   arCreatedOn datetime not null default sysdatetime(),
   arCreatedByFK pointer not null,
   arChangedOn datetime not null default sysdatetime(),
   arChangedByFK pointer not null,
   arArticleFK pointer not null,
   arLanguage NVARCHAR(2) NOT NULL,
   arDescription description not null,
   CONSTRAINT pkArticleTranslation PRIMARY key (arID)
);
create unique index udxArticleTranslation on ArticleTranslation(arLanguage,arArticleFK);

Mapping

Article

Conversion ID: article.cnvArticleTranslationID

New	Old
arID	None
arCreatedOn	None
arCreatedByFK
arChangedOn
arChangedByFK
arArticleFK	article.cnvArticleID
arLanguage	NO for aname2no, SE for aName2se, DE for aname2DE
arDescription	One of aname2no, aName2se, aname2DE