defs
Within a project, you create table definitions that describe tables and their schemas. These table definitions can be deployed to Tableland. This table tracks all table definitions.
| created_at | description | id | name | schema | slug | updated_at |
|---|---|---|---|---|---|---|
| table for students | 99993336-69fe-4bec-808f-907d33e2a489 | students | {"columns":[{"name":"id","type":"integer","constraints":["primary key"]},{"name":"name","type":"text","constraints":["not null"]},{"name":"grade","type":"text"}]} | students | ||
| teachers table | 3ae76b4c-fc49-4ac4-b9fd-8d3956aaa742 | teachers | {"columns":[{"name":"id","type":"integer","constraints":["primary key"]},{"name":"name","type":"text","constraints":["not null"]},{"name":"salary","type":"int"},{"name":"dob","type":"text"}]} | teachers | ||
| TCR of netspan | 0d1aa8eb-1532-45b8-9098-67bf2c9b4007 | tcr | {"columns":[{"name":"plmn","type":"text","constraints":["not null","primary key","unique"]},{"name":"proposer","type":"text","constraints":["not null"]},{"name":"provider","type":"text","constraints":["not null"]},{"name":"region","type":"text","constraints":["not null"]}]} | tcr | ||
| tcr of netspan | 179f142d-78c4-43c2-84e2-862f48fd5195 | tc | {"columns":[{"name":"plmn","type":"text","constraints":["not null","primary key"]}]} | tc | ||
| this is a test | 8dfd9846-1268-4875-8e8d-2813bd5a1f25 | test | {"columns":[{"name":"id","type":"text","constraints":["primary key","unique"]},{"name":"name","type":"text","constraints":["not null"]},{"name":"address","type":"text","constraints":["not null"]}]} | test | ||
| This table holds a record of all table migrations that have been applied as we've developed Studio. | 807684e8-28c9-4f15-ab8f-70ee24710afb | migrations | {"columns":[{"name":"id","type":"integer","constraints":["primary key autoincrement"]},{"name":"file","type":"text","constraints":["not null","unique"]},{"name":"hash","type":"text","constraints":["not null"]}]} | migrations | ||
| The deployments table holds records, for all Studio Teams, of all Table definitions that have been deployed to the Tableland network. | fc8688dc-c94b-4fc8-93db-421fda212be3 | deployments | {"columns":[{"name":"`table_id`","type":"text","constraints":["not null"]},{"name":"`environment_id`","type":"text","constraints":["not null"]},{"name":"`table_name`","type":"text","constraints":["not null"]},{"name":"`chain_id`","type":"integer","constraints":["not null"]},{"name":"`token_id`","type":"text","constraints":["not null"]},{"name":"`block_number`","type":"integer"},{"name":"`txn_hash`","type":"text"},{"name":"`created_at`","type":"text","constraints":["not null"]}],"tableConstraints":["primary key(`environment_id`,`table_id`)"]} | deployments | ||
| The environments table holds records of the Environments defined for each Studio project. | ffb984de-5e0a-4cd6-9cc5-91ca0f5abb64 | environments | {"columns":[{"name":"`id`","type":"text","constraints":["primary key","not null"]},{"name":"`project_id`","type":"text","constraints":["not null"]},{"name":"`name`","type":"text","constraints":["not null"]},{"name":"`slug`","type":"text","constraints":["not null"]}],"tableConstraints":["unique(`project_id`,`slug`)"]} | environments | ||
| test | 0bb059c0-0c57-4c92-a1ea-0d31a4aedee7 | test | {"columns":[{"name":"id","type":"integer","constraints":["not null"]},{"name":"role","type":"text","constraints":["not null"]},{"name":"description","type":"text","constraints":["not null"]}]} | test | ||
| test | ae0e81d4-4aab-4e0b-bb70-099c5e892edc | user | {"columns":[{"name":"name","type":"text"},{"name":"email","type":"text"},{"name":"address","type":"text"}]} | user | ||
| test | fdd1d1ee-efc3-4684-9dc0-5b9653252864 | test | {"columns":[{"name":"test","type":"text"}]} | test | ||
| This table relates Projects to Tables and supports a many to many relationship between them. | 96001862-66eb-4258-aaeb-2309d2a4bc9c | project_tables | {"columns":[{"name":"`project_id`","type":"text","constraints":["not null"]},{"name":"`table_id`","type":"text","constraints":["not null"]}],"tableConstraints":["unique(`project_id`,`table_id`)"]} | project_tables | ||
| current table as of 10/23 | 53f257bb-9831-425f-997a-69c54b42d991 | final | {"columns":[{"name":"id","type":"integer","constraints":["primary key autoincrement"]},{"name":"name","type":"text"}]} | final | ||
| Success3 projects | 425724b5-c7ff-4c6c-af8d-a7ef112aa28a | projects | {"columns":[]} | projects | ||
| ngo desc | ab4b8417-c253-4780-9e5a-4db2f83b46e4 | ngo | {"columns":[{"name":"id","type":"int","constraints":["not null","primary key","unique"]},{"name":"name","type":"text","constraints":["not null","unique"]}]} | ngo |