⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 7059086ca44840f3b5c2ef482ec6a250.sql

📁 利用C语言实现的人工智能系统
💻 SQL
字号:
CREATE TABLE Property_Values
(
	Object_Property_ID INTEGER NOT NULL,
	Time_ID INTEGER NOT NULL,
	Property_Value VARCHAR(100) NOT NULL 
);

INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '30e-4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '30e-4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-59.4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '100e-4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '2e-4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-59.4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '10.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1.00');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.05');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '10.6');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '10.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1.00');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.05');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '10.6');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '2');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.050');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '45.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-82.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1200.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '360.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-0.1E6');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-0.010');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-45');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '4.0E3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-18.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '70.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-20.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1.0E3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-10.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-40');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-10.0E3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-10.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-60');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '125.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-80.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '45.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-82.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '360.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1200.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '360.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-0.1E6');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-0.010');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-45');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '4.0E3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-18.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '70.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-20.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '1.0E3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-10.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-40');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-10.0E3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-10.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-60');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '125.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-80.0E-3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '-70');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.010');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '3');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '4');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '5');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'soma');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'dendrite');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'injection current');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'hodgkin huxley soma channel');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'hodgkin huxley dendrite channel');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'axon hillock');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'axon');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.010');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '200e-12');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, 'gap junction');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '6');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');
INSERT INTO Property_Values (Object_Property_ID, Time_ID, Property_Value) VALUES(NULL, 1, '0.0');

CREATE UNIQUE INDEX idxPropertyValues ON Property_Values (Object_Property_ID ASC);
CREATE UNIQUE INDEX idxPropertyTimes ON Property_Values (Object_Property_ID ASC, Time_ID ASC);

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -