databasematrix.sql

-- Example of Database created in Space and Time SxT

-- Database for Chainlink Matrix RWA Bridge Project
-- ASTM C39/C39M-21 (Compressive-Strength) Standard Concrete test


--ID
mainid VARCHAR PRIMARY KEY,


--Location/Site
locationid VARCHAR,

--TIME
startid TIMESTAMP,
endid TIMESTAMP,

--Length/Width ASTM
lengthid DECIMAL(10,3),
diameterid DECIMAL(10,3),

--FORCE in pounds(lb)
forceid DECIMAL(15,2),

--Visual Component (ASTM C39)
--Cone1, Cone/Split2, Columnar3, Shear4, Corner5, End6
visualid INT,


--Witness/Technician/Lab-Tech Wallet Signature
operatorid VARCHAR


) WITH ("public_key=0x000000000000000000000000316d7a2ec3478b39de1806cbf8b6569229e3596d";) 

--Live on SXT chain (Proof of SQL)
--MATRIXRWA_316D7A2EC3478B39DE1806CBF8B6569229E3596D.MATRIXRWADATABASE