Data Stores

Database schema

sameAs Lite stores equivalent symbols within a single database table which associates an URI with its canon. The schema of this table is as follows:

For MySQL:

+--------+--------------+------+-----+---------+-------+
| Field  | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| canon  | varchar(256) | YES  | MUL | NULL    |       |
| symbol | varchar(256) | NO   | PRI |         |       |
+--------+--------------+------+-----+---------+-------+

For SQLite:

+--------+------+-----+
| Field  | Type | Key |
+--------+------+-----+
| canon  | TEXT |     |
| symbol | TEXT | PRI |
+--------+---- -+-----+

A database index is created on canon.