6d2626ba02774a72a21303d5fdb98190.sql

利用C语言实现的人工智能系统

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

INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Volume', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Area', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'neuron form', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'neuron type', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'neuron function', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Neuron class', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'V', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Vr', 'voltage at rest or equilibrium');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Dendrite type', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Length', 'dimension');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Radius', 'circle or sphere radius');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Diameter', 'dimension');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Time', 'simulation time step');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'R', 'non-resistive axial');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Ra', 'resistive axial');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 't', 'temperature');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Ij', 'injection current');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Name', 'property name');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Description', 'property description');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'creation_date', 'property value creation date');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'created_by', 'user name that created the property value');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Erest', 'rest potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'rm', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'cm', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'ra', '');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Ediff', 'Eleak - Erest');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Im', 'membrane current');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Rm', 'membrane resistivity');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Cm', 'membrane capacitance');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Eleak', 'leakeage potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Em', 'membrane potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Type', 'OBSOLETE PROPERTY = object type');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Pd', 'injection current pulse duration');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'NaChannel', 'hodgkin huxley Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'KChannel', 'hodgkin huxley K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'E', 'equilibrium potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'ENa0', 'sodium equilibrium potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'EK0', 'potassium equilibrium potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'G', 'conductance');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'GNa', 'sodium conductance');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'GK', 'potassium conductance');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'ENa', 'sodium potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'EK', 'potassium potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Gmax_Na', 'maximmum sodium conductance');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Gmax_K', 'maximmum potassium conductance');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Mexp_Na', 'activation gating variable for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Hexp_Na', 'inactivation gating variable for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Mexp_K', 'activation gating variable for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Hexp_K', 'inactivation gating variable for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaM_A_Na', 'alpha function M variable A parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaM_B_Na', 'alpha function M variable B parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaM_V0_Na', 'alpha function M variable V0 parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaM_A_Na', 'beta function M variable A parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaM_B_Na', 'beta function M variable B parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaM_V0_Na', 'beta function M variable V0 parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaH_A_Na', 'alpha function H variable A parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaH_B_Na', 'alpha function H variable B parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaH_V0_Na', 'alpha function H variable V0 parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaH_A_Na', 'beta function H variable A parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaH_B_Na', 'beta function H variable B parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaH_V0_Na', 'beta function H variable V0 parameter for internal Na channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaM_A_K', 'alpha function M variable A parameter for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaM_B_K', 'alpha function M variable B parameter for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AlphaM_V0_K', 'alpha function M variable V0 parameter for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaM_A_K', 'beta function M variable A parameter for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaM_B_K', 'beta function M variable B parameter for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'BetaM_V0_K', 'beta function M variable V0 parameter for internal K channel');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'LastFired', 'last time it fired an action potential');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'AbsRef', 'absolute refractory period');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Thresh', 'threshold voltage');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'DeliveryTime', 'absolute time period it takes for an axon to deliver the action potential to the next object');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'add', 'add field');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Igap', 'gap junction synaptic current');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'DeliveryPoint', 'time step when the axon can deliver the AP received from the axon hillock');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Tau1', 'rise time constant');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Tau2', 'decay time constant');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Weight', 'synaptic weight');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Factor', 'synapse factor');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Isyn', 'synaptic current passed to the compartment');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'A', 'constant');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'B', 'constant');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'Low Threshold', 'threshold value for band-pass, low-pas or high-pass synapse');
INSERT INTO Properties (ID, Name, Description) VALUES (NULL, 'High Threshold', 'threshold value for band-pass, low-pas or high-pass synapse');

CREATE UNIQUE INDEX idxProperties ON Properties (ID ASC);