/****** key-value值的数据 ******/
CREATE TABLE [Systems](
	[id] [integer] PRIMARY KEY AUTOINCREMENT,
	[name] [nvarchar](100) NOT NULL,
    [session] [nvarchar](100) NULL,
	[key] [nvarchar](100) NULL,
	[value] [text] NULL
);

/****** key-value值的数据 ******/
CREATE TABLE [Datas](
	[id] [integer] PRIMARY KEY AUTOINCREMENT,
	[name] [nvarchar](100) NOT NULL,
    [session] [nvarchar](100) NULL,
	[key] [nvarchar](100) NULL,
	[value] [text] NULL
);

/*********测试项下的测试表****************/
CREATE TABLE [Tables](
        [id] [integer] PRIMARY KEY AUTOINCREMENT,
        [name] [nvarchar](100) NOT NULL,
		[productName] [nvarchar](100) NOT NULL,
		[serial] [nvarchar](100) NULL,
        [result] [nvarchar](100) NULL,
	    [tester] [nvarchar](100) NULL,
	    [type] [nvarchar](100) NULL, 
	    [temperature] [nvarchar](50) NULL,
	    [humidity] [nvarchar](50) NULL,
	    [place] [nvarchar](100) NULL,
		[workstation] [nvarchar](100) NULL,
		[productCode] [nvarchar](100) NULL,
		[lot] [nvarchar](100) NULL,
		[airPressure] [nvarchar](50) NULL,
        [time] [datetime] NOT NULL

);

/*********测试表的行，每行一条记录****************/
CREATE TABLE [Rows](
        [id] [integer] PRIMARY KEY AUTOINCREMENT,
        [tableId] [integer] NOT NULL,
		[groupId] [integer] NOT NULL,
		[rowIndex] [integer] NOT NULL,
        [r0] [text] NULL,
		[r1] [text] NULL,
		[r2] [text] NULL,
		[r3] [text] NULL,
		[r4] [text] NULL,
		[r5] [text] NULL,
		[r6] [text] NULL,
		[r7] [text] NULL,
		[r8] [text] NULL,
		[r9] [text] NULL,
        FOREIGN KEY([tableId]) REFERENCES [Tables]([id])
        ON UPDATE CASCADE
        ON DELETE CASCADE
);
/**
 由于外键的关系，表的创建有先后关系，要先有外键对应的表
**/