Studio

tables_42170_12

Deployed to

Arbitrum Nova

Tableland Table

Token ID

12

Studio projects using this table

descriptionidnameschemaslug
table for students99993336-69fe-4bec-808f-907d33e2a489students{"columns":[{"name":"id","type":"integer","constraints":["primary key"]},{"name":"name","type":"text","constraints":["not null"]},{"name":"grade","type":"text"}]}students
teachers table3ae76b4c-fc49-4ac4-b9fd-8d3956aaa742teachers{"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 netspan0d1aa8eb-1532-45b8-9098-67bf2c9b4007tcr{"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 netspan179f142d-78c4-43c2-84e2-862f48fd5195tc{"columns":[{"name":"plmn","type":"text","constraints":["not null","primary key"]}]}tc
this is a test8dfd9846-1268-4875-8e8d-2813bd5a1f25test{"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-70ee24710afbmigrations{"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-421fda212be3deployments{"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-91ca0f5abb64environments{"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
test0bb059c0-0c57-4c92-a1ea-0d31a4aedee7test{"columns":[{"name":"id","type":"integer","constraints":["not null"]},{"name":"role","type":"text","constraints":["not null"]},{"name":"description","type":"text","constraints":["not null"]}]}test
testae0e81d4-4aab-4e0b-bb70-099c5e892edcuser{"columns":[{"name":"name","type":"text"},{"name":"email","type":"text"},{"name":"address","type":"text"}]}user
testfdd1d1ee-efc3-4684-9dc0-5b9653252864test{"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-2309d2a4bc9cproject_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/2353f257bb-9831-425f-997a-69c54b42d991final{"columns":[{"name":"id","type":"integer","constraints":["primary key autoincrement"]},{"name":"name","type":"text"}]}final
Success3 projects425724b5-c7ff-4c6c-af8d-a7ef112aa28aprojects{"columns":[]}projects
ngo descab4b8417-c253-4780-9e5a-4db2f83b46e4ngo{"columns":[{"name":"id","type":"int","constraints":["not null","primary key","unique"]},{"name":"name","type":"text","constraints":["not null","unique"]}]}ngo