1spaces: spaces {
2  shape: sql_table
3  id: varchar(30) {constraint: primary_key}
4  slug: varchar(64) {constraint: unique}
5  name: text
6  owner_id: varchar(30)
7  visibility: varchar(10)
8  space_type: varchar(20)
9  created_at: timestamptz
10  updated_at: timestamptz
11}
12
13items: items {
14  shape: sql_table
15  id: varchar(30) {constraint: primary_key}
16  space_id: varchar(30) {constraint: foreign_key}
17  parent_id: varchar(30)
18  name: text
19  kind: varchar(10)
20  content_hash: text
21  type: varchar(50)
22  path: ltree
23  created_at: timestamptz
24  updated_at: timestamptz
25}
26
27versions: versions {
28  shape: sql_table
29  id: varchar(30) {constraint: primary_key}
30  item_id: varchar(30) {constraint: foreign_key}
31  content_hash: text
32  size: bigint
33  branch: varchar(100)
34  message: text
35  created_at: timestamptz
36}
37
38commits: commits {
39  shape: sql_table
40  id: varchar(30) {constraint: primary_key}
41  space_id: varchar(30) {constraint: foreign_key}
42  commit_hash: char(40)
43  tree_hash: char(40)
44  parent_hash: char(40)
45  message: text
46  author_name: text
47  created_at: timestamptz
48}
49
50spaces -> items: "1:N"
51items -> versions: "1:N"
52spaces -> commits: "1:N"