Table ArticleLink

DDL

create sequence seqArticleLink as bigint start with 1;

create table ArticleLink (
   alID bigint not null default next value for seqArticleLink,
   alCreatedOn datetime not null default sysdatetime(),
   alCreatedByFK bigint not null,
   alChangedOn datetime not null default sysdatetime(),
   alChangedByFK bigint not NULL,
   alArticleFK pointer not null,
   alLinkedArticleFK pointer not null,
   alQuantity integer not null default 1,
  CONSTRAINT pkArticleLink PRIMARY key (alID)
);
create unique index udxArticleLink on ArticleLink(alARticleFK,alLinkedArticleFK);

alter table ArticleLink add constraint fkArticleLinkArticle foreign key (alArticleFK) references Article(aID) on update cascade on delete cascade;
alter table ArticleLink add constraint fkArticleLinkLinkedArticle foreign key (alLinkedArticleFK) references Article(aID);

Default Data

None

Mapping

ARTICLELINK

Conversion ID: .cnv ID

New	Old
alID
alCreatedOn
alCreatedByFK
alChangedOn
alChangedByFK
alARticleFK	ARTCODE
alLinkedArticleFK	LINKEDARTCODE
alQuantity	QTY