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.