27,579
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('key_info') IS NOT NULL DROP TABLE key_info
IF OBJECT_ID('key_data') IS NOT NULL DROP TABLE key_data
CREATE TABLE key_info(
keyId INT PRIMARY KEY,
keyName NVARCHAR(20) NOT NULL
)
CREATE TABLE key_data(
id INT IDENTITY(1,1) PRIMARY KEY,
keyId INT NOT NULL,
keyData INT NOT NULL --4 种情况
)
IF OBJECT_ID('key_info') IS NOT NULL DROP TABLE key_info
IF OBJECT_ID('key_data') IS NOT NULL DROP TABLE key_data
CREATE TABLE key_info(
keyId INT PRIMARY KEY,
keyName NVARCHAR(20) NOT NULL
)
CREATE TABLE key_data(
id INT IDENTITY(1,1) PRIMARY KEY,
keyId INT NOT NULL,
keyData1 INT NOT NULL,
keyData2 INT NOT NULL,
keyData3 INT NOT NULL,
keyData4 INT NOT NULL,
)
具体的业务逻辑你最清楚了吧, 不怕的