5b174ca605b042b285cd310abf5289a7.sql

来自「利用C语言实现的人工智能系统」· SQL 代码 · 共 28 行

CREATE TABLE Units (
	ID INTEGER NOT NULL PRIMARY KEY,
	Name VARCHAR(50) NOT NULL,
	Description VARCHAR(150) NOT NULL
);

INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'none', 'no unit');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'hertz', '');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'ohm', '');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'mvolt', 'millivolt');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'uFarad', 'conductance');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'cm3', '');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'um2', '');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'um', 'micrometer');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 's', 'second');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'celsius degree', 'temperature');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'ohm-cm2', 'area resistance');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'ohm-cm', 'length resistence');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'uF/cm2', 'conductance per area');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'Kohm-cm^2', '');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'Kohm-cm', '');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'Kohm-cm^2)/cm^2', 'membrane resistance for the entire area');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'string', 'sequence of characters value');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'S', 'siemens');
INSERT INTO Units (ID, Name, Description) VALUES (NULL, 'number', 'real or integer');

CREATE UNIQUE INDEX idxUnits ON Units (ID ASC);