// LLP: 09.21.2023 useful table I built but decided not to use
Table 1 describes the table and index schema used throughout the SAI examples.

.Table and index schema
[cols="1,3,3"]
|===

| Table name | Table  | Indexes

|[[vector_search]]comments_vs for vector search
a|[source,sql]
----
include::cassandra:example$CQL/sai/create-vector-table-cycling.cql[tag=createvstable]
----
a|[source,sql]
----
include::cassandra:example$CQL/sai/create-vector-index-cycling.cql[]
----

|[[comments_vs]]comments_vs
a|[source,sql]
----
include::cassandra:example$CQL/sai/create-vector-table-cycling.cql[tag=createvstable]
----
a|[source,sql]
----
include::cassandra:example$CQL/sai/index-sai-multiple-index-match-with-and.cql[]
----

|[[rank-by-year-and-name]]rank_by_year_and_name
a|[source,sql]
----
include::cassandra:example$CQL/sai/rank_by_year_and_name-table.cql[tag=compositepk]
----
a|[source,sql]
----
include::cassandra:example$CQL/sai/index-sai-multiple-index-match-with-and.cql[]
----

|[[cyclist_career_teams]]cyclist_career_teams
a|[source,sql]
----
include::cassandra:example$CQL/sai/cyclist_career_teams-table.cql[tag=setColumn]
----
a|[source,sql]
----
include::cassandra:example$CQL/sai/index-sai-from-set-match.cql[]
----

|[[upcoming_calendar]]upcoming_calendar
a|[source,sql]
----
include::cassandra:example$CQL/sai/upcoming_calendar-table.cql[tag=listColumn]
----
a|[source,sql]
----
include::cassandra:example$CQL/sai/index-sai-from-list-match.cql[]
----

|[[cyclist_teams]]cyclist_teams
a|[source,sql]
----
include::cassandra:example$CQL/sai/cyclist_teams-table.cql[tag=mapColumn]
----
a|[source,sql]
----
include::cassandra:example$CQL/sai/index-sai-from-map-match.cql[]
----
|===