ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| publication_id | UNSIGNED INT | NOT NULL | Primary key |
| creator | UNSIGNED INT | NOT NULL | Unique index. Foreign key references SYSUSERPERM.user_id |
| publication_name | CHAR(128) | NOT NULL | Unique index |
| remarks | LONG VARCHAR | ||
| type | CHAR(1) | NOT NULL |
Each row describes a SQL Remote publication.
publication_id A unique identifying number for the publication.
creator The owner of the publication.
publication_name The name of the publication, which must be a valid identifier.
remarks Descriptive comments.
type This column is deprecated.