Contents Index SYSARTICLE system table SYSATTRIBUTE system table

ASA SQL Reference
  System Tables

SYSARTICLECOL system table


Column name Column type Column constraint Table constraints
publication_id UNSIGNED INT NOT NULL Primary Key, foreign key references SYSARTICLE
table_id UNSIGNED INT NOT NULL Primary Key, foreign key references SYSARTICLE, SYSCOLUMN
column_id UNSIGNED INT NOT NULL Primary Key, foreign key references SYSCOLUMN

Each row identifies a column in an article.

publication_id    A unique identifier for the publication of which the column is a part.

table_id    The table to which the column belongs.

column_id    The column identifier, from the SYSCOLUMN system table.


Contents Index SYSARTICLE system table SYSATTRIBUTE system table