DBMS Constraints on Upload Table
1. The Table File Name
Table file names can be no more than 16 characters
using only letters, numbers or underscores ("_"). File
names are case insensitive, may not begin with numbers
due to database restrictions and should not contain any
spaces.
Seyferts.tbl, MyListJ2k, LBD4_16A.dat.
Examples of invalid names:
PleaseGoALongWithTheseFileNameConventionsForThisService.tbl
(too many characters), 2mass.tbl (begins with
a number), my file name (contains spaces).
Caution:
Database treats "MyTable" and "mytable" as the same table names, because table names are case insensitive.
2. Column Name
- Column names are case insensitive and can be no more
than 16 characters long.
Please avoid to use lower/upper cases to clarify the column name.You may use underscores "_" to break up multiple words in column names.
- Do not include columns with names "x", "y", or "z"
(lower or UPPER case).
The IRSA table ingesting software (DBIN) automatically computes unit sphere coordinates with column names x,y,and z and adds them to the DBMS table for efficient spatial searches.
For example, 'z' for redshift must not be used; simply give the column an unique name, such as 'redshift'. - Alpha, numeric, and underscores characters
only.
No blanks or white space are allowed, and table column names cannot start with an numeric character.
Invalid column names for a database table:
B-V (includes dash "-")Valid column names for a database table:
L+V (includes plus "+")
U mag (includes space)
2mass (starts with a number)
mag.b (includes dot ".")
B_V
U_mag or
twomass
- Positional comparisons require column names
"ra" and "dec".
Positional comparisons (rather than a relational join on an integer or character columns) require columns named "ra" and "dec", in equatorial J2000 coordinates in decimal degrees, which are reserved names for that purpose only. Your table must contain valid "ra" and "dec" columns for positional searching to be performed. More flexibility on input coordinate names and types will be considered in future versions.
3. Other
- The leading character in the table header cannot be blank space, the header rows must start with the '|' character.
- Empty rows in the upload table are not permitted.