SchemaSpy Analysis of d66vta52qi8mtp.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on 金 9 12 20:50 JST 2014 |
| ||||||
|
d66vta52qi8mtp.public contains 17 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
emp | hiredate | date | 13 | √ | null | 入社日 | |
dept | active | numeric | 1 | √ | null | 有効 | |
dept | deptno | numeric | 2 | 部署番号 | |||
emp | deptno | numeric | 2 | √ | null | 部署 | |
emp | empno | numeric | 4 | 社員番号 | |||
emp | mgr | numeric | 4 | √ | null | 上長 | |
emp | comm | numeric | 7,2 | √ | null | 歩合給 | |
emp | sal | numeric | 7,2 | √ | null | 基本給 | |
dept | versionno | numeric | 8 | √ | null | バージョン番号 | |
changelog | id | numeric | 20 | ||||
emp | tstamp | timestamp | 29,6 | √ | null | タイムスタンプ | |
emp | job | varchar | 9 | √ | null | 職種 | |
emp | ename | varchar | 10 | √ | null | 氏名 | |
dept | loc | varchar | 13 | √ | null | 地域 | |
dept | dname | varchar | 14 | √ | null | ||
changelog | applied_at | varchar | 25 | ||||
changelog | description | varchar | 255 |