Difference between revisions of "202.2.2.89"

From SPGC Document Wiki
Jump to: navigation, search
 
(25 intermediate revisions by one other user not shown)
Line 1: Line 1:
==paysliplog==
+
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]]
{| class="wikitable" \
+
!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
+
! 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
+
|}
+

Latest revision as of 14:32, 24 August 2016

Main Page > Application Development Team > DB Specs