Base Tables
t_Tables
t_Tables
Detail
Table
Name
Table type
Id
Open Page
Page
Parent table
Layout
Display column
Browser link
Columns
Column List
Lookup Columns
External Lookup Columns
Lookups
Subtables
Looked Up From
Is Base
Referenced By
Views / Siblings
View Count
Row Count
Column Count
Updated at
Exclude From Schema
Is Self Reference
Is Isolated
Is Sync
Open Doc
Syntax
Generate Views Schema
Copy Syntax To Clipboard
Views Schema
Schema Thumbnail
Document
Doc
1
all_Projects
table
grid-LlZMqV14mR
Open Page
all_Projects
default
Name
Name
Description
Start Date
End Date
Tasks
Task Count
Name
Description
Start Date
End Date
Tasks
Task Count
Tasks
Tasks
all_Tasks
all_Tasks
Project
all_Tasks
Projects
1
3
6
6/6/2024, 2:30 PM
Open Doc
Table "all_Projects" {
"Name" text [pk]
"Description" text
"Start Date" date
"End Date" date
"Tasks" lookup
"Task Count" number
}
Table "Projects" [headercolor: #ff9f00] {
layout ganttChart
}
Ref: "all_Projects"."Name" - "Projects".layout
Generate Views Schema
Copy Syntax
98BvRZlG3L
Test Doc
2
Projects
view
table-ai_iRYfKrR
Open Page
Home
all_Projects
ganttChart
c-pW5mcgNU3B
Name
Description
Start Date
End Date
Tasks
Task Count
0
3
6
12/9/2023, 10:21 AM
Open Doc
Generate Views Schema
Copy Syntax
98BvRZlG3L
Test Doc
3
all_Tasks
table
grid-x6qQk79vf-
Open Page
all_Tasks
default
Name
Name
Owner
Status
Project
Priority
Name
Owner
Status
Project
Priority
Status
Project
Status
Project
all_Statuses
all_Projects
Tasks
all_Projects
0
4
5
12/15/2023, 4:06 PM
Open Doc
Generate Views Schema
Copy Syntax
98BvRZlG3L
Test Doc
There are no rows in this table
Load content from dbdiagram.io?
Loading external content may reveal information to 3rd parties. Learn more
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.