一,5大约束constraint
1,主键 primary key
2,非空 not null
3,唯一 unique
4,外键 foreign key
5,检查 check
例子:
create table t_type_info(
typeId number(10) primary key,
type varchar2(5) not null,
typeDescZh varchar2(50),
typeDescEn varchar2(50)
);
create table t_basic_info (
contentId number(10) primary key,
name varchar2(20) unique,
source varchar2(3) not null,
type varchar2(5) references t_type_info(type), --外键
sex varchar2 default '男' check(sex in('男','女')), --check
srNo number(10) check(srNo between 1 and 30)
);
create table t_basic_info (
contentId number(10),
name varchar2(20),
source varchar2(3) not null,
type varchar2(5), --外键
sex varchar2 default '男',
srNo number(10),
-- 注意:not null约束只能在列级上定义
constraint info_id primary key(contentId),
constraint info_name unique(name),
constraint info_type_pk foreign key(type) references t_type_info(type),
constraint info_sex check(sex in('男','女&#