Oracle-教师信息表（Teacher）

最新推荐文章于 2023-03-23 16:55:42 发布

weixin_30258901

最新推荐文章于 2023-03-23 16:55:42 发布

阅读量1.5k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/miss123/p/5567417.html

版权

教师信息表（Teacher）

 1 -- Create table
 2 create table TEACHER
 3 (
 4   tno       VARCHAR2(3) not null,
 5   tname     VARCHAR2(4) not null,
 6   tsex      VARCHAR2(2) not null,
 7   tbirthday DATE,
 8   prof      VARCHAR2(6),
 9   depart    VARCHAR2(10) not null
10 )
11 tablespace TEST
12   pctfree 10
13   initrans 1
14   maxtrans 255
15   storage
16   (
17     initial 64K
18     next 1M
19     minextents 1
20     maxextents unlimited
21   );
22 -- Add comments to the table 
23 comment on table TEACHER
24   is '教师表';
25 -- Add comments to the columns 
26 comment on column TEACHER.tno
27   is '教工编号（主键）';
28 comment on column TEACHER.tname
29   is '教工姓名';
30 comment on column TEACHER.tsex
31   is '教工性别';
32 comment on column TEACHER.tbirthday
33   is '教工出生年月';
34 comment on column TEACHER.prof
35   is '职称';
36 comment on column TEACHER.depart
37   is '教工所在部门';