Difference between revisions of "202.2.2.89"
From SPGC Document Wiki
Line 2: | Line 2: | ||
{| class="wikitable" \ | {| class="wikitable" \ | ||
!colspan="7" | paysliplog | !colspan="7" | paysliplog | ||
+ | |- | ||
+ | ! style="text-align:left;" | Column Name | ||
+ | ! Data Type | ||
+ | ! Length | ||
+ | ! Is PrimaryKey | ||
+ | ! Is Not Null | ||
+ | ! Auto Increment | ||
+ | |- | ||
+ | |Id | ||
+ | |int | ||
+ | |11 | ||
+ | |Yes | ||
+ | |Yes | ||
+ | |No | ||
+ | |- | ||
+ | |EmployeeNo | ||
+ | |varchar | ||
+ | |20 | ||
+ | |No | ||
+ | |Yes | ||
+ | |No | ||
+ | |- | ||
+ | |PayDate | ||
+ | |date | ||
+ | |0 | ||
+ | |No | ||
+ | |Yes | ||
+ | |No | ||
+ | |- | ||
+ | |DateOpen | ||
+ | |datetime | ||
+ | |0 | ||
+ | |No | ||
+ | |Yes | ||
+ | |No | ||
+ | |- | ||
+ | |IpAddress | ||
+ | |varchar | ||
+ | |50 | ||
+ | |No | ||
+ | |Yes | ||
+ | |No | ||
+ | |} | ||
+ | |||
+ | ==pd2014== | ||
+ | {| class="wikitable" \ | ||
+ | !colspan="7" | pd2014 | ||
|- | |- | ||
! style="text-align:left;" | Column Name | ! style="text-align:left;" | Column Name |
Revision as of 11:23, 4 August 2016
paysliplog
paysliplog | ||||||
---|---|---|---|---|---|---|
Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
Id | int | 11 | Yes | Yes | No | |
EmployeeNo | varchar | 20 | No | Yes | No | |
PayDate | date | 0 | No | Yes | No | |
DateOpen | datetime | 0 | No | Yes | No | |
IpAddress | varchar | 50 | No | Yes | No |
pd2014
pd2014 | ||||||
---|---|---|---|---|---|---|
Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
Id | int | 11 | Yes | Yes | No | |
EmployeeNo | varchar | 20 | No | Yes | No | |
PayDate | date | 0 | No | Yes | No | |
DateOpen | datetime | 0 | No | Yes | No | |
IpAddress | varchar | 50 | No | Yes | No |