Table d66vta52qi8mtp.public.emp
従業員

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
empno numeric 4 社員番号
ename varchar 10  √  null 氏名
job varchar 9  √  null 職種
mgr numeric 4  √  null 上長
hiredate date 13  √  null 入社日
sal numeric 7,2  √  null 基本給
comm numeric 7,2  √  null 歩合給
deptno numeric 2  √  null
dept.deptno Implied Constraint R
部署
tstamp timestamp 29,6  √  null タイムスタンプ

Table contained 0 rows at 金 9 12 20:50 JST 2014

Indexes:
Column(s) Type Sort Constraint Name
empno Primary key Asc emp_pkey

Close relationships: