ASA SQL Reference
System Tables
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.