Scott用户4个表的表结构及字段含义

[b]scott/tiger[/b]

[img]http://dl.iteye.com/upload/attachment/521355/9a5c7918-accc-3fb4-8e45-78ff947e73f1.png[/img]

[b]1 EMP:雇员表[/b]
记录一个雇员的基本信息

[img]http://dl.iteye.com/upload/attachment/521357/4e534288-a16d-387d-af09-0194c2a34ae7.png[/img]

[b]2 DEPT:部门表[/b]
记录一个部门的具体信息

[img]http://dl.iteye.com/upload/attachment/521365/65529a37-751c-35ca-89cb-1986fdb20507.png[/img]

[b]3 BONUS:奖金表[/b]
记录一个雇员的工资及奖金

[img]http://dl.iteye.com/upload/attachment/521369/55605e49-c1b1-3413-8e30-f8328d19f28b.png[/img]

[b]4 SALGRADE:工资等级表[/b]
记录一个工资的等级

[img]http://dl.iteye.com/upload/attachment/521379/e6836105-f024-31a7-a5a2-fd8cded19455.png[/img]

comment on table BONUS
  is '奖金表:记录一个雇员的工资及奖金';
comment on column BONUS.ENAME
  is '雇员姓名';
comment on column BONUS.JOB
  is '雇员工作';
comment on column BONUS.SAL
  is '雇员工资';
comment on column BONUS.COMM
  is '雇员奖金';


comment on table DEPT
  is '部门:表示一个部门的具体信息';
comment on column DEPT.DEPTNO
  is '部门编号';
comment on column DEPT.DNAME
  is '部门名称';
comment on column DEPT.LOC
  is '部门位置';


comment on table EMP
  is '雇员表：记录了一个雇员的基本信息';
comment on column EMP.EMPNO
  is '雇员编号';
comment on column EMP.ENAME
  is '雇员姓名';
comment on column EMP.JOB
  is '工作职位';
comment on column EMP.MGR
  is '雇员的领导编号';
comment on column EMP.HIREDATE
  is '雇佣日期';
comment on column EMP.SAL
  is '月薪';
comment on column EMP.COMM
  is '奖金或佣金';
comment on column EMP.DEPTNO
  is '部门编号';


comment on table SALGRADE
  is '工资等级表:记录一个工资的等级';
comment on column SALGRADE.GRADE
  is '等级名称';
comment on column SALGRADE.LOSAL
  is '此等级的最低工资';
comment on column SALGRADE.HISAL
  is '此等级的最高工资';