level 1
710267819
楼主
我在SqlLiteStudio上操作
建了两个表
一个Student
CREATE TABLE Student (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR( 20 ) NOT NULL,
gender VARCHAR( 1 ) NOT NULL,
school VARCHAR( 20 ) DEFAULT '无',
score SMALLINT CHECK ( score BETWEEN 0 AND 100 )
);
一个School
CREATE TABLE School (
school_id INTEGER IDENTITY( 1, 1 ) PRIMARY KEY,
school_name VARCHAR( 20 ) NOT NULL
);
2015年08月02日 06点08分
1
建了两个表
一个Student
CREATE TABLE Student (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR( 20 ) NOT NULL,
gender VARCHAR( 1 ) NOT NULL,
school VARCHAR( 20 ) DEFAULT '无',
score SMALLINT CHECK ( score BETWEEN 0 AND 100 )
);
一个School
CREATE TABLE School (
school_id INTEGER IDENTITY( 1, 1 ) PRIMARY KEY,
school_name VARCHAR( 20 ) NOT NULL
);