Data Sample

Use a Records block to add example rows to a table. Define it inside or outside the table; values are type-checked against each column (full syntax).

Table plans {
  id int [pk]
  name varchar
  price decimal

  Records {
    1, 'Free', 0
    2, 'Pro', 8
  }
}

Table users {
  id int [pk]
  email varchar
  plan_id int [ref: > plans.id]

  Records {
    1, '[email protected]', 2
    2, '[email protected]', 1
  }
}

Table projects {
  id int [pk]
  name varchar
  owner_id int [ref: > users.id]
}

// records can also be defined outside the table
Records projects(id, name, owner_id) {
  1, 'Website redesign', 1
  2, 'Data warehouse', 1
  3, 'Mobile app', 2
}

info

Hover a table header to reveal the records icon, then click it to open the data sample popup. From there you can edit the Records block in the editor or download the rows as CSV.