While the relational model of Coda is very similar to a database one, there are some formalities that have been “bent” to provide a workable schema.
Primary (and foreign) keys are not part of the Coda table model, therefore in order to provide a good proxy, I considered the display column as the primary key of a table. After all is the way they are “seen” when referenced. Also a lookup relationships are one-to-many when they are single select, and many-to-many when they are multiple select.
Doc's Tables and Views
3
Name
Table type
Id
Is Sync
Layout
Row Count
View Count
Is Isolated
Page
Search
Detail
Name
Table type
Is Sync
i
Id
Layout
Row Count
Column Count
View Count
i
Browser link
Page
Is Isolated
i
Exclude From Schema
i
Detail
Name
Table type
Is Sync
i
Id
Layout
Row Count
Column Count
View Count
i
Browser link
Page
Is Isolated
i
Exclude From Schema
i
1
all_Projects
table
grid-LlZMqV14mR
default
3
6
1
all_Projects
2
all_Statuses
table
grid-JdTQlclqgX
default
3
1
0
all_Statuses
3
all_Tasks
table
grid-x6qQk79vf-
default
4
5
0
all_Tasks
4
Projects
view
table-ai_iRYfKrR
ganttChart
3
6
0
Home
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (