hr_data
account_access_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBPathName | text | No | ||||
| DBPageName | text | No | ||||
| DBAccountNum | text | No | ||||
| DBHasAccess | text | No | ||||
| DBSubAccess | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 5263 | A | No | |
| DBPathName | BTREE | No | No | DBPathName (250) | 6 | A | No | |
| DBPageName | BTREE | No | No | DBPageName (250) | 39 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 154 | A | No | |
| DBHasAccess | BTREE | No | No | DBHasAccess (250) | 2 | A | No | |
| DBSubAccess | BTREE | No | No | DBSubAccess (250) | 1 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
account_edit_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBEditBy | text | No | ||||
| DBRemarks | text | No | ||||
| DBDate | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 90 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 90 | A | No | |
| DBEditBy | BTREE | No | No | DBEditBy (250) | 1 | A | No | |
| DBRemarks | BTREE | No | No | DBRemarks (250) | 1 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 3 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
account_schedule_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBHasLunchBreak_Monday | text | No | ||||
| DBWorkDate_Monday | text | No | ||||
| DBTimeIN_Monday | text | No | ||||
| DBTimeOUT_Monday | text | No | ||||
| DBHasLunchBreak_Tuesday | text | No | ||||
| DBWorkDate_Tuesday | text | No | ||||
| DBTimeIN_Tuesday | text | No | ||||
| DBTimeOUT_Tuesday | text | No | ||||
| DBHasLunchBreak_Wednesday | text | No | ||||
| DBWorkDate_Wednesday | text | No | ||||
| DBTimeIN_Wednesday | text | No | ||||
| DBTimeOUT_Wednesday | text | No | ||||
| DBHasLunchBreak_Thursday | text | No | ||||
| DBWorkDate_Thursday | text | No | ||||
| DBTimeIN_Thursday | text | No | ||||
| DBTimeOUT_Thursday | text | No | ||||
| DBHasLunchBreak_Friday | text | No | ||||
| DBWorkDate_Friday | text | No | ||||
| DBTimeIN_Friday | text | No | ||||
| DBTimeOUT_Friday | text | No | ||||
| DBHasLunchBreak_Saturday | text | No | ||||
| DBWorkDate_Saturday | text | No | ||||
| DBTimeIN_Saturday | text | No | ||||
| DBTimeOUT_Saturday | text | No | ||||
| DBHasLunchBreak_Sunday | text | No | ||||
| DBWorkDate_Sunday | text | No | ||||
| DBTimeIN_Sunday | text | No | ||||
| DBTimeOUT_Sunday | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 137 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 137 | A | No | |
| DBHasLunchBreak_Monday | BTREE | No | No | DBHasLunchBreak_Monday (250) | 1 | A | No | |
| DBWorkDate_Monday | BTREE | No | No | DBWorkDate_Monday (250) | 1 | A | No | |
| DBTimeIN_Monday | BTREE | No | No | DBTimeIN_Monday (250) | 3 | A | No | |
| DBTimeOUT_Monday | BTREE | No | No | DBTimeOUT_Monday (250) | 3 | A | No | |
| DBHasLunchBreak_Tuesday | BTREE | No | No | DBHasLunchBreak_Tuesday (250) | 1 | A | No | |
| DBWorkDate_Tuesday | BTREE | No | No | DBWorkDate_Tuesday (250) | 1 | A | No | |
| DBTimeIN_Tuesday | BTREE | No | No | DBTimeIN_Tuesday (250) | 3 | A | No | |
| DBTimeOUT_Tuesday | BTREE | No | No | DBTimeOUT_Tuesday (250) | 3 | A | No | |
| DBHasLunchBreak_Wednesday | BTREE | No | No | DBHasLunchBreak_Wednesday (250) | 1 | A | No | |
| DBWorkDate_Wednesday | BTREE | No | No | DBWorkDate_Wednesday (250) | 1 | A | No | |
| DBTimeIN_Wednesday | BTREE | No | No | DBTimeIN_Wednesday (250) | 3 | A | No | |
| DBTimeOUT_Wednesday | BTREE | No | No | DBTimeOUT_Wednesday (250) | 3 | A | No | |
| DBHasLunchBreak_Thursday | BTREE | No | No | DBHasLunchBreak_Thursday (250) | 1 | A | No | |
| DBWorkDate_Thursday | BTREE | No | No | DBWorkDate_Thursday (250) | 1 | A | No | |
| DBTimeIN_Thursday | BTREE | No | No | DBTimeIN_Thursday (250) | 3 | A | No | |
| DBTimeOUT_Thursday | BTREE | No | No | DBTimeOUT_Thursday (250) | 3 | A | No | |
| DBHasLunchBreak_Friday | BTREE | No | No | DBHasLunchBreak_Friday (250) | 1 | A | No | |
| DBWorkDate_Friday | BTREE | No | No | DBWorkDate_Friday (250) | 1 | A | No | |
| DBTimeIN_Friday | BTREE | No | No | DBTimeIN_Friday (250) | 3 | A | No | |
| DBTimeOUT_Friday | BTREE | No | No | DBTimeOUT_Friday (250) | 3 | A | No | |
| DBHasLunchBreak_Saturday | BTREE | No | No | DBHasLunchBreak_Saturday (250) | 1 | A | No | |
| DBWorkDate_Saturday | BTREE | No | No | DBWorkDate_Saturday (250) | 2 | A | No | |
| DBTimeIN_Saturday | BTREE | No | No | DBTimeIN_Saturday (250) | 4 | A | No | |
| DBTimeOUT_Saturday | BTREE | No | No | DBTimeOUT_Saturday (250) | 4 | A | No | |
| DBHasLunchBreak_Sunday | BTREE | No | No | DBHasLunchBreak_Sunday (250) | 1 | A | No | |
| DBWorkDate_Sunday | BTREE | No | No | DBWorkDate_Sunday (250) | 2 | A | No | |
| DBTimeIN_Sunday | BTREE | No | No | DBTimeIN_Sunday (250) | 5 | A | No | |
| DBTimeOUT_Sunday | BTREE | No | No | DBTimeOUT_Sunday (250) | 5 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
account_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBName | text | No | ||||
| DBRFID_Number | text | No | ||||
| DBAccount_Number | text | No | ||||
| DBBank_Number | text | No | ||||
| DBUsername | text | No | ||||
| DBPassword | text | No | ||||
| DBRole | text | No | ||||
| DBDepartment | text | No | ||||
| DBPosition | text | No | ||||
| DBBirthDate | text | No | ||||
| DBAddress | text | No | ||||
| DBContact | text | No | ||||
| DBTIN | text | No | ||||
| DBSSS | text | No | ||||
| DBPagIbig | text | No | ||||
| DBPhilhealth | text | No | ||||
| DBSSSAmount | text | No | ||||
| DBPagIbigAmount | text | No | ||||
| DBPhilhealthAmount | text | No | ||||
| DBSalary | text | No | ||||
| DBNumberOfWorkingDays | text | No | ||||
| DBStatus | text | No | ||||
| DBLeaveCredits | text | No | ||||
| DBStatusOfEmployment | text | No | ||||
| DBDateHired | text | No | ||||
| DBEmail | text | No | ||||
| DBOvertimePayment | text | No | ||||
| DBBranchNum | text | No | ||||
| DBFixedSalary | text | No | ||||
| DBNoHolidayPay | text | No | ||||
| DBNoOvertimePay | text | No | ||||
| DBNoNDPay | text | No | ||||
| DBAllowance | text | No | ||||
| DBAllowanceType | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBCurrentSession | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 137 | A | No | |
| DBName | BTREE | No | No | DBName (250) | 137 | A | No | |
| DBRFID_Number | BTREE | No | No | DBRFID_Number (250) | 45 | A | No | |
| DBAccount_Number | BTREE | No | No | DBAccount_Number (250) | 68 | A | No | |
| DBBank_Number | BTREE | No | No | DBBank_Number (250) | 137 | A | No | |
| DBUsername | BTREE | No | No | DBUsername (250) | 137 | A | No | |
| DBPassword | BTREE | No | No | DBPassword (250) | 45 | A | No | |
| DBRole | BTREE | No | No | DBRole (250) | 4 | A | No | |
| DBDepartment | BTREE | No | No | DBDepartment (250) | 6 | A | No | |
| DBPosition | BTREE | No | No | DBPosition (250) | 68 | A | No | |
| DBBirthDate | BTREE | No | No | DBBirthDate (250) | 137 | A | No | |
| DBAddress | BTREE | No | No | DBAddress (250) | 68 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 137 | A | No | |
| DBTIN | BTREE | No | No | DBTIN (250) | 45 | A | No | |
| DBSSS | BTREE | No | No | DBSSS (250) | 45 | A | No | |
| DBPagIbig | BTREE | No | No | DBPagIbig (250) | 45 | A | No | |
| DBPhilhealth | BTREE | No | No | DBPhilhealth (250) | 45 | A | No | |
| DBSSSAmount | BTREE | No | No | DBSSSAmount (250) | 19 | A | No | |
| DBPagIbigAmount | BTREE | No | No | DBPagIbigAmount (250) | 3 | A | No | |
| DBPhilhealthAmount | BTREE | No | No | DBPhilhealthAmount (250) | 34 | A | No | |
| DBSalary | BTREE | No | No | DBSalary (250) | 27 | A | No | |
| DBNumberOfWorkingDays | BTREE | No | No | DBNumberOfWorkingDays (250) | 5 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 2 | A | No | |
| DBLeaveCredits | BTREE | No | No | DBLeaveCredits (250) | 3 | A | No | |
| DBStatusOfEmployment | BTREE | No | No | DBStatusOfEmployment (250) | 2 | A | No | |
| DBDateHired | BTREE | No | No | DBDateHired (250) | 45 | A | No | |
| DBEmail | BTREE | No | No | DBEmail (250) | 137 | A | No | |
| DBOvertimePayment | BTREE | No | No | DBOvertimePayment (250) | 10 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No | |
| DBFixedSalary | BTREE | No | No | DBFixedSalary (250) | 2 | A | No | |
| DBNoHolidayPay | BTREE | No | No | DBNoHolidayPay (250) | 2 | A | No | |
| DBNoOvertimePay | BTREE | No | No | DBNoOvertimePay (250) | 2 | A | No | |
| DBNoNDPay | BTREE | No | No | DBNoNDPay (250) | 2 | A | No | |
| DBAllowance | BTREE | No | No | DBAllowance (250) | 5 | A | No | |
| DBAllowanceType | BTREE | No | No | DBAllowanceType (250) | 3 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 1 | A | No | |
| DBCurrentSession | BTREE | No | No | DBCurrentSession (250) | 7 | A | No |
branch_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBBranchName | text | No | ||||
| DBAddress | text | No | ||||
| DBContact | text | No | ||||
| DBEmail | text | No | ||||
| DBStatus | text | No | ||||
| DBDate | text | No | ||||
| DBCode | text | No | ||||
| DBMergeCode | text | No | ||||
| DBAPIKey | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 1 | A | No | |
| DBBranchName | BTREE | No | No | DBBranchName (250) | 1 | A | No | |
| DBAddress | BTREE | No | No | DBAddress (250) | 1 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 1 | A | No | |
| DBEmail | BTREE | No | No | DBEmail (250) | 1 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 1 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1 | A | No | |
| DBCode | BTREE | No | No | DBCode (250) | 1 | A | No | |
| DBMergeCode | BTREE | No | No | DBMergeCode (250) | 1 | A | No | |
| DBAPIKey | BTREE | No | No | DBAPIKey (250) | 1 | A | No |
dailytime_leaveofabsence_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBDate | text | No | ||||
| DBWorkStart | text | No | ||||
| DBWorkEnd | text | No | ||||
| DBTimeIn | text | No | ||||
| DBTimeOut | text | No | ||||
| DBReason | text | No | ||||
| DBStatus | text | No | ||||
| DBApprovedBy | text | No | ||||
| DBDateApproved | text | No | ||||
| DBLeaveType | text | No | ||||
| DBPaymentType | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 4 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 4 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 4 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 4 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 4 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 4 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 4 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 4 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 4 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 4 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 4 | A | No | |
| DBLeaveType | BTREE | No | No | DBLeaveType (250) | 4 | A | No | |
| DBPaymentType | BTREE | No | No | DBPaymentType (250) | 4 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 4 | A | No |
dailytime_notimein_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBDate | text | No | ||||
| DBWorkStart | text | No | ||||
| DBWorkEnd | text | No | ||||
| DBTimeIn | text | No | ||||
| DBTimeOut | text | No | ||||
| DBReason | text | No | ||||
| DBStatus | text | No | ||||
| DBPenalty | text | No | ||||
| DBApprovedBy | text | No | ||||
| DBDateApproved | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 296 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 37 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 32 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 9 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 8 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 98 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 42 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 32 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 2 | A | No | |
| DBPenalty | BTREE | No | No | DBPenalty (250) | 1 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 2 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 9 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
dailytime_overtime_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDailyTimeNum | text | No | ||||
| DBAccountNum | text | No | ||||
| DBDate | text | No | ||||
| DBReason | text | No | ||||
| DBApprovedBy | text | No | ||||
| DBDateApproved | text | No | ||||
| DBStatus | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 36 | A | No | |
| DBDailyTimeNum | BTREE | No | No | DBDailyTimeNum (250) | 18 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 7 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 12 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 9 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 2 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 9 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 2 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
dailytime_shiftschedule_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDateRequest | text | No | ||||
| DBDateFiled | text | No | ||||
| DBDayType | text | No | ||||
| DBHasLunchBreak | text | No | ||||
| DBWorkStart | text | No | ||||
| DBWorkEnd | text | No | ||||
| DBLogBy | text | No | ||||
| DBReason | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 45750 | A | No | |
| DBDateRequest | BTREE | No | No | DBDateRequest (250) | 3519 | A | No | |
| DBDateFiled | BTREE | No | No | DBDateFiled (250) | 3 | A | No | |
| DBDayType | BTREE | No | No | DBDayType (250) | 2 | A | No | |
| DBHasLunchBreak | BTREE | No | No | DBHasLunchBreak (250) | 1 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 3 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 3 | A | No | |
| DBLogBy | BTREE | No | No | DBLogBy (250) | 1 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 1 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 30 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
dailytime_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBDate | text | No | ||||
| DBTimeIn | text | No | ||||
| DBTimeOut | text | No | ||||
| DBLunchOut | text | No | ||||
| DBLunchBack | text | No | ||||
| DBBreakOut1 | text | No | ||||
| DBBreakBack1 | text | No | ||||
| DBBreakOut2 | text | No | ||||
| DBBreakBack2 | text | No | ||||
| DBSalary | text | No | ||||
| DBOvertimePayment | text | No | ||||
| DBWorkStart | text | No | ||||
| DBWorkEnd | text | No | ||||
| DBOvertimeIn | text | No | ||||
| DBOvertimeOut | text | No | ||||
| DBOvertimeStart | text | No | ||||
| DBPaymentStatus | text | No | ||||
| DBDayType | text | No | ||||
| DBBonus | text | No | ||||
| DBPenalty | text | No | ||||
| DBPaidAmount | text | No | ||||
| DBFixedSalary | text | No | ||||
| DBNoHolidayPay | text | No | ||||
| DBNoOvertimePay | text | No | ||||
| DBNoNDPay | text | No | ||||
| DBHasLunchBreak | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 4834 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 53 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 284 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 439 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 268 | A | No | |
| DBLunchOut | BTREE | No | No | DBLunchOut (250) | 284 | A | No | |
| DBLunchBack | BTREE | No | No | DBLunchBack (250) | 284 | A | No | |
| DBBreakOut1 | BTREE | No | No | DBBreakOut1 (250) | 138 | A | No | |
| DBBreakBack1 | BTREE | No | No | DBBreakBack1 (250) | 146 | A | No | |
| DBBreakOut2 | BTREE | No | No | DBBreakOut2 (250) | 7 | A | No | |
| DBBreakBack2 | BTREE | No | No | DBBreakBack2 (250) | 4 | A | No | |
| DBSalary | BTREE | No | No | DBSalary (250) | 53 | A | No | |
| DBOvertimePayment | BTREE | No | No | DBOvertimePayment (250) | 32 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 12 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 14 | A | No | |
| DBOvertimeIn | BTREE | No | No | DBOvertimeIn (250) | 30 | A | No | |
| DBOvertimeOut | BTREE | No | No | DBOvertimeOut (250) | 17 | A | No | |
| DBOvertimeStart | BTREE | No | No | DBOvertimeStart (250) | 10 | A | No | |
| DBPaymentStatus | BTREE | No | No | DBPaymentStatus (250) | 2 | A | No | |
| DBDayType | BTREE | No | No | DBDayType (250) | 2 | A | No | |
| DBBonus | BTREE | No | No | DBBonus (250) | 5 | A | No | |
| DBPenalty | BTREE | No | No | DBPenalty (250) | 8 | A | No | |
| DBPaidAmount | BTREE | No | No | DBPaidAmount (250) | 63 | A | No | |
| DBFixedSalary | BTREE | No | No | DBFixedSalary (250) | 2 | A | No | |
| DBNoHolidayPay | BTREE | No | No | DBNoHolidayPay (250) | 2 | A | No | |
| DBNoOvertimePay | BTREE | No | No | DBNoOvertimePay (250) | 2 | A | No | |
| DBNoNDPay | BTREE | No | No | DBNoNDPay (250) | 2 | A | No | |
| DBHasLunchBreak | BTREE | No | No | DBHasLunchBreak (250) | 1 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
dailytime_timeadjustment_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDailyTimeNum | text | No | ||||
| DBAccountNum | text | No | ||||
| DBDate | text | No | ||||
| DBWorkStart | text | No | ||||
| DBWorkEnd | text | No | ||||
| DBTimeIn | text | No | ||||
| DBTimeOut | text | No | ||||
| DBReason | text | No | ||||
| DBStatus | text | No | ||||
| DBPenalty | text | No | ||||
| DBApprovedBy | text | No | ||||
| DBDateApproved | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 109 | A | No | |
| DBDailyTimeNum | BTREE | No | No | DBDailyTimeNum (250) | 109 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 36 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 18 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 5 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 8 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 54 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 36 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 18 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 2 | A | No | |
| DBPenalty | BTREE | No | No | DBPenalty (250) | 1 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 2 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 9 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
ecommerce_account_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBStoreName | text | No | ||||
| DBMarketPlace | text | No | ||||
| DBStatus | text | No | ||||
| DBDate | text | No | ||||
| seller_id | text | No | ||||
| access_token | text | No | ||||
| refresh_token | text | No | ||||
| country_code | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBStoreName | BTREE | No | No | DBStoreName (250) | A | No | ||
| DBMarketPlace | BTREE | No | No | DBMarketPlace (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| seller_id | BTREE | No | No | seller_id (250) | A | No | ||
| access_token | BTREE | No | No | access_token (250) | A | No | ||
| refresh_token | BTREE | No | No | refresh_token (250) | A | No | ||
| country_code | BTREE | No | No | country_code (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
ecommerce_dropoff_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBTrackingNumber | text | No | ||||
| DBMarketPlace | text | No | ||||
| DBBatchDropIn | text | No | ||||
| DBDropInBy | text | No | ||||
| DBDropInDate | text | No | ||||
| DBDropInTime | text | No | ||||
| DBBatchDropOut | text | No | ||||
| DBDropOutBy | text | No | ||||
| DBDropOutDate | text | No | ||||
| DBDropOutTime | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBTrackingNumber | BTREE | No | No | DBTrackingNumber (250) | A | No | ||
| DBMarketPlace | BTREE | No | No | DBMarketPlace (250) | A | No | ||
| DBBatchDropIn | BTREE | No | No | DBBatchDropIn (250) | A | No | ||
| DBDropInBy | BTREE | No | No | DBDropInBy (250) | A | No | ||
| DBDropInDate | BTREE | No | No | DBDropInDate (250) | A | No | ||
| DBDropInTime | BTREE | No | No | DBDropInTime (250) | A | No | ||
| DBBatchDropOut | BTREE | No | No | DBBatchDropOut (250) | A | No | ||
| DBDropOutBy | BTREE | No | No | DBDropOutBy (250) | A | No | ||
| DBDropOutDate | BTREE | No | No | DBDropOutDate (250) | A | No | ||
| DBDropOutTime | BTREE | No | No | DBDropOutTime (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
ecommerce_order_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBOrderNumber | text | No | ||||
| DBTrackingNumber | text | No | ||||
| DBBatchUpload | text | No | ||||
| DBBatchReleased | text | No | ||||
| DBStatus | text | No | ||||
| DBInventoryNum | text | No | ||||
| DBPrice | text | No | ||||
| DBCost | text | No | ||||
| DBUploadedBy | text | No | ||||
| DBDateUpload | text | No | ||||
| DBTimeUpload | text | No | ||||
| DBPreparedBy | text | No | ||||
| DBDatePrepared | text | No | ||||
| DBTimePrepared | text | No | ||||
| DBCheckedBy | text | No | ||||
| DBDateChecked | text | No | ||||
| DBTimeChecked | text | No | ||||
| DBReleasedBy | text | No | ||||
| DBDateReleased | text | No | ||||
| DBTimeReleased | text | No | ||||
| DBReturnedBy | text | No | ||||
| DBDateReturned | text | No | ||||
| DBTimeReturned | text | No | ||||
| DBCancelledBy | text | No | ||||
| DBDateCancelled | text | No | ||||
| DBTimeCancelled | text | No | ||||
| DBPrintedBy | text | No | ||||
| DBDatePrinted | text | No | ||||
| DBTimePrinted | text | No | ||||
| DBCustomer | text | No | ||||
| DBCustomerContact | text | No | ||||
| DBCourier | text | No | ||||
| DBMarketPlace | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBNote | text | No | ||||
| DBPaymentStatus | text | No | ||||
| DBDeductionType | text | No | ||||
| DBSellerNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBOrderNumber | BTREE | No | No | DBOrderNumber (250) | A | No | ||
| DBTrackingNumber | BTREE | No | No | DBTrackingNumber (250) | A | No | ||
| DBBatchUpload | BTREE | No | No | DBBatchUpload (250) | A | No | ||
| DBBatchReleased | BTREE | No | No | DBBatchReleased (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBPrice | BTREE | No | No | DBPrice (250) | A | No | ||
| DBCost | BTREE | No | No | DBCost (250) | A | No | ||
| DBUploadedBy | BTREE | No | No | DBUploadedBy (250) | A | No | ||
| DBDateUpload | BTREE | No | No | DBDateUpload (250) | A | No | ||
| DBTimeUpload | BTREE | No | No | DBTimeUpload (250) | A | No | ||
| DBPreparedBy | BTREE | No | No | DBPreparedBy (250) | A | No | ||
| DBDatePrepared | BTREE | No | No | DBDatePrepared (250) | A | No | ||
| DBTimePrepared | BTREE | No | No | DBTimePrepared (250) | A | No | ||
| DBCheckedBy | BTREE | No | No | DBCheckedBy (250) | A | No | ||
| DBDateChecked | BTREE | No | No | DBDateChecked (250) | A | No | ||
| DBTimeChecked | BTREE | No | No | DBTimeChecked (250) | A | No | ||
| DBReleasedBy | BTREE | No | No | DBReleasedBy (250) | A | No | ||
| DBDateReleased | BTREE | No | No | DBDateReleased (250) | A | No | ||
| DBTimeReleased | BTREE | No | No | DBTimeReleased (250) | A | No | ||
| DBReturnedBy | BTREE | No | No | DBReturnedBy (250) | A | No | ||
| DBDateReturned | BTREE | No | No | DBDateReturned (250) | A | No | ||
| DBTimeReturned | BTREE | No | No | DBTimeReturned (250) | A | No | ||
| DBCancelledBy | BTREE | No | No | DBCancelledBy (250) | A | No | ||
| DBDateCancelled | BTREE | No | No | DBDateCancelled (250) | A | No | ||
| DBTimeCancelled | BTREE | No | No | DBTimeCancelled (250) | A | No | ||
| DBPrintedBy | BTREE | No | No | DBPrintedBy (250) | A | No | ||
| DBDatePrinted | BTREE | No | No | DBDatePrinted (250) | A | No | ||
| DBTimePrinted | BTREE | No | No | DBTimePrinted (250) | A | No | ||
| DBCustomer | BTREE | No | No | DBCustomer (250) | A | No | ||
| DBCustomerContact | BTREE | No | No | DBCustomerContact (250) | A | No | ||
| DBCourier | BTREE | No | No | DBCourier (250) | A | No | ||
| DBMarketPlace | BTREE | No | No | DBMarketPlace (250) | A | No | ||
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBPaymentStatus | BTREE | No | No | DBPaymentStatus (250) | A | No | ||
| DBDeductionType | BTREE | No | No | DBDeductionType (250) | A | No | ||
| DBSellerNum | BTREE | No | No | DBSellerNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
ecommerce_payment_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBOrderNumber | text | No | ||||
| DBAmount | text | No | ||||
| DBCount | text | No | ||||
| DBDate | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBOrderNumber | BTREE | No | No | DBOrderNumber (250) | A | No | ||
| DBAmount | BTREE | No | No | DBAmount (250) | A | No | ||
| DBCount | BTREE | No | No | DBCount (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
error_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBMessage | text | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBMessage | BTREE | No | No | DBMessage (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No |
holidays_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDate | text | No | ||||
| DBHolidayDate | text | No | ||||
| DBHoliday | text | No | ||||
| DBType | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBHolidayDate | BTREE | No | No | DBHolidayDate (250) | A | No | ||
| DBHoliday | BTREE | No | No | DBHoliday (250) | A | No | ||
| DBType | BTREE | No | No | DBType (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
inventory_daily_record_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDate | text | No | ||||
| DBInventoryTotalAmount | text | No | ||||
| DBInventoryTotalStock | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 105 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 105 | A | No | |
| DBInventoryTotalAmount | BTREE | No | No | DBInventoryTotalAmount (250) | 1 | A | No | |
| DBInventoryTotalStock | BTREE | No | No | DBInventoryTotalStock (250) | 1 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No |
inventory_edit_stock_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBInventoryNum | text | No | ||||
| DBEditBy | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBPreviousQuantity | text | No | ||||
| DBNewQuantity | text | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No | ||||
| DBTransactionType | text | No | ||||
| DBRemarks | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBEditBy | BTREE | No | No | DBEditBy (250) | A | No | ||
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | A | No | ||
| DBPreviousQuantity | BTREE | No | No | DBPreviousQuantity (250) | A | No | ||
| DBNewQuantity | BTREE | No | No | DBNewQuantity (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBTransactionType | BTREE | No | No | DBTransactionType (250) | A | No | ||
| DBRemarks | BTREE | No | No | DBRemarks (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
inventory_edit_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBInventoryNum | text | No | ||||
| DBEditBy | text | No | ||||
| DBRemarks | text | No | ||||
| DBEditRemarks | text | No | ||||
| DBDate | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBEditBy | BTREE | No | No | DBEditBy (250) | A | No | ||
| DBRemarks | BTREE | No | No | DBRemarks (250) | A | No | ||
| DBEditRemarks | BTREE | No | No | DBEditRemarks (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
inventory_subitem_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDate | text | No | ||||
| DBSubSKU | text | No | ||||
| DBInventoryNumList | text | No | ||||
| DBQuantityList | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBSubSKU | BTREE | No | No | DBSubSKU (250) | A | No | ||
| DBInventoryNumList | BTREE | No | No | DBInventoryNumList (250) | A | No | ||
| DBQuantityList | BTREE | No | No | DBQuantityList (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
inventory_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBProductName | text | No | ||||
| DBBarcode | text | No | ||||
| DBSKU | text | No | ||||
| DBBrand | text | No | ||||
| DBCategory | text | No | ||||
| DBUnit | text | No | ||||
| DBPrice1 | text | No | ||||
| DBPrice2 | text | No | ||||
| DBPrice3 | text | No | ||||
| DBCost | text | No | ||||
| DBThreshold | text | No | ||||
| DBStatus | text | No | ||||
| DBOnlinePrice | text | No | ||||
| DBOnlineDiscount | text | No | ||||
| DBOnlineDescription | text | No | ||||
| DBDate | text | No | ||||
| DBQuantity | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBProductName | BTREE | No | No | DBProductName (250) | A | No | ||
| DBBarcode | BTREE | No | No | DBBarcode (250) | A | No | ||
| DBSKU | BTREE | No | No | DBSKU (250) | A | No | ||
| DBBrand | BTREE | No | No | DBBrand (250) | A | No | ||
| DBCategory | BTREE | No | No | DBCategory (250) | A | No | ||
| DBUnit | BTREE | No | No | DBUnit (250) | A | No | ||
| DBPrice1 | BTREE | No | No | DBPrice1 (250) | A | No | ||
| DBPrice2 | BTREE | No | No | DBPrice2 (250) | A | No | ||
| DBPrice3 | BTREE | No | No | DBPrice3 (250) | A | No | ||
| DBCost | BTREE | No | No | DBCost (250) | A | No | ||
| DBThreshold | BTREE | No | No | DBThreshold (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBOnlinePrice | BTREE | No | No | DBOnlinePrice (250) | A | No | ||
| DBOnlineDiscount | BTREE | No | No | DBOnlineDiscount (250) | A | No | ||
| DBOnlineDescription | BTREE | No | No | DBOnlineDescription (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBQuantity | BTREE | No | No | DBQuantity (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
payslip_deduction_payment_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDeductionNum | text | No | ||||
| DBDate | text | No | ||||
| DBPayment | text | No | ||||
| DBLogBy | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 52 | A | No | |
| DBDeductionNum | BTREE | No | No | DBDeductionNum (250) | 52 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 52 | A | No | |
| DBPayment | BTREE | No | No | DBPayment (250) | 52 | A | No | |
| DBLogBy | BTREE | No | No | DBLogBy (250) | 52 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 52 | A | No |
payslip_deduction_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDetails | text | No | ||||
| DBAmount | text | No | ||||
| DBLogBy | text | No | ||||
| DBDate | text | No | ||||
| DBUnderBy | text | No | ||||
| DBType | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 14 | A | No | |
| DBDetails | BTREE | No | No | DBDetails (250) | 14 | A | No | |
| DBAmount | BTREE | No | No | DBAmount (250) | 14 | A | No | |
| DBLogBy | BTREE | No | No | DBLogBy (250) | 14 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 14 | A | No | |
| DBUnderBy | BTREE | No | No | DBUnderBy (250) | 14 | A | No | |
| DBType | BTREE | No | No | DBType (250) | 14 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 14 | A | No |
pos_cashcount_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No | ||||
| DBAmount | text | No | ||||
| DBAccountNum | text | No | ||||
| DBCheckedBy | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBAmount | BTREE | No | No | DBAmount (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBCheckedBy | BTREE | No | No | DBCheckedBy (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
pos_cashrecord_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBTransactionNumber | text | No | ||||
| DBTransactionType | text | No | ||||
| DBAmount | text | No | ||||
| DBCashFlow | text | No | ||||
| DBModeOfPayment | text | No | ||||
| DBNote | text | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBTransactionNumber | BTREE | No | No | DBTransactionNumber (250) | A | No | ||
| DBTransactionType | BTREE | No | No | DBTransactionType (250) | A | No | ||
| DBAmount | BTREE | No | No | DBAmount (250) | A | No | ||
| DBCashFlow | BTREE | No | No | DBCashFlow (250) | A | No | ||
| DBModeOfPayment | BTREE | No | No | DBModeOfPayment (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
pos_customer_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBCustomerName | text | No | ||||
| DBAddress | text | No | ||||
| DBContact | text | No | ||||
| DBOtherInformation | text | No | ||||
| DBStatus | text | No | ||||
| DBDate | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBCustomerName | BTREE | No | No | DBCustomerName (250) | A | No | ||
| DBAddress | BTREE | No | No | DBAddress (250) | A | No | ||
| DBContact | BTREE | No | No | DBContact (250) | A | No | ||
| DBOtherInformation | BTREE | No | No | DBOtherInformation (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
pos_payment_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBPayment | text | No | ||||
| DBModeOfPayment | text | No | ||||
| DBNote | text | No | ||||
| DBDate | text | No | ||||
| DBPaymentDate | text | No | ||||
| DBTime | text | No | ||||
| DBAccountNum | text | No | ||||
| DBCustomerNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBPayment | BTREE | No | No | DBPayment (250) | A | No | ||
| DBModeOfPayment | BTREE | No | No | DBModeOfPayment (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBPaymentDate | BTREE | No | No | DBPaymentDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBCustomerNum | BTREE | No | No | DBCustomerNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
pos_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBInvoiceNumber | text | No | ||||
| DBDraft | text | No | ||||
| DBTransactionType | text | No | ||||
| DBQuantity | text | No | ||||
| DBPrice | text | No | ||||
| DBCost | text | No | ||||
| DBDiscount | text | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No | ||||
| DBInvoiceDate | text | No | ||||
| DBPaymentDate | text | No | ||||
| DBInventoryNum | text | No | ||||
| DBAccountNum | text | No | ||||
| DBCustomerNum | text | No | ||||
| DBCustomerType | text | No | ||||
| DBBranchNum | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBShippingFee | text | No | ||||
| DBPreparedBy | text | No | ||||
| DBDatePrepared | text | No | ||||
| DBTimePrepared | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | A | No | ||
| DBDraft | BTREE | No | No | DBDraft (250) | A | No | ||
| DBTransactionType | BTREE | No | No | DBTransactionType (250) | A | No | ||
| DBQuantity | BTREE | No | No | DBQuantity (250) | A | No | ||
| DBPrice | BTREE | No | No | DBPrice (250) | A | No | ||
| DBCost | BTREE | No | No | DBCost (250) | A | No | ||
| DBDiscount | BTREE | No | No | DBDiscount (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | A | No | ||
| DBPaymentDate | BTREE | No | No | DBPaymentDate (250) | A | No | ||
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBCustomerNum | BTREE | No | No | DBCustomerNum (250) | A | No | ||
| DBCustomerType | BTREE | No | No | DBCustomerType (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No | ||
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | A | No | ||
| DBShippingFee | BTREE | No | No | DBShippingFee (250) | A | No | ||
| DBPreparedBy | BTREE | No | No | DBPreparedBy (250) | A | No | ||
| DBDatePrepared | BTREE | No | No | DBDatePrepared (250) | A | No | ||
| DBTimePrepared | BTREE | No | No | DBTimePrepared (250) | A | No |
purchase_order_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBInvoiceNumber | text | No | ||||
| DBStatus | text | No | ||||
| DBInventoryNum | text | No | ||||
| DBOldCost | text | No | ||||
| DBNewCost | text | No | ||||
| DBQuantity | text | No | ||||
| DBNote | text | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No | ||||
| DBDateApproved | text | No | ||||
| DBTimeApproved | text | No | ||||
| DBApprovedBy | text | No | ||||
| DBSupplierNum | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBOldCost | BTREE | No | No | DBOldCost (250) | A | No | ||
| DBNewCost | BTREE | No | No | DBNewCost (250) | A | No | ||
| DBQuantity | BTREE | No | No | DBQuantity (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | A | No | ||
| DBTimeApproved | BTREE | No | No | DBTimeApproved (250) | A | No | ||
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | A | No | ||
| DBSupplierNum | BTREE | No | No | DBSupplierNum (250) | A | No | ||
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
registration_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBEmail | text | No | ||||
| DBPassword | text | No | ||||
| DBDate | text | No | ||||
| DBStatus | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBEmail | BTREE | No | No | DBEmail (250) | A | No | ||
| DBPassword | BTREE | No | No | DBPassword (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No |
rental_billing_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBBillingName | text | No | ||||
| DBBillingCode | text | No | ||||
| DBAmount | text | No | ||||
| DBStatus | text | No | ||||
| DBAutoInput | text | No | ||||
| DBDateCreated | text | No | ||||
| DBTimeCreated | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBBillingName | BTREE | No | No | DBBillingName (250) | A | No | ||
| DBBillingCode | BTREE | No | No | DBBillingCode (250) | A | No | ||
| DBAmount | BTREE | No | No | DBAmount (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBAutoInput | BTREE | No | No | DBAutoInput (250) | A | No | ||
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | A | No | ||
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
rental_invoice_payment_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBPayment | text | No | ||||
| DBModeOfPayment | text | No | ||||
| DBNote | text | No | ||||
| DBDate | text | No | ||||
| DBPaymentDate | text | No | ||||
| DBTime | text | No | ||||
| DBAccountNum | text | No | ||||
| DBPropertyNum | text | No | ||||
| DBPropertyOwnerNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBPayment | BTREE | No | No | DBPayment (250) | A | No | ||
| DBModeOfPayment | BTREE | No | No | DBModeOfPayment (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBPaymentDate | BTREE | No | No | DBPaymentDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBPropertyNum | BTREE | No | No | DBPropertyNum (250) | A | No | ||
| DBPropertyOwnerNum | BTREE | No | No | DBPropertyOwnerNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
rental_invoice_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBInvoiceNumber | text | No | ||||
| DBBillingNum | text | No | ||||
| DBBillReading | text | No | ||||
| DBRate | text | No | ||||
| DBAmount | text | No | ||||
| DBPropertyOwnerNum | text | No | ||||
| DBPropertyNum | text | No | ||||
| DBIsVoid | text | No | ||||
| DBVoidDate | text | No | ||||
| DBVoidTime | text | No | ||||
| DBVoidBy | text | No | ||||
| DBInvoiceDate | text | No | ||||
| DBDateCreated | text | No | ||||
| DBTimeCreated | text | No | ||||
| DBAccountNum | text | No | ||||
| DBDueDate | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | A | No | ||
| DBBillingNum | BTREE | No | No | DBBillingNum (250) | A | No | ||
| DBBillReading | BTREE | No | No | DBBillReading (250) | A | No | ||
| DBRate | BTREE | No | No | DBRate (250) | A | No | ||
| DBAmount | BTREE | No | No | DBAmount (250) | A | No | ||
| DBPropertyOwnerNum | BTREE | No | No | DBPropertyOwnerNum (250) | A | No | ||
| DBPropertyNum | BTREE | No | No | DBPropertyNum (250) | A | No | ||
| DBIsVoid | BTREE | No | No | DBIsVoid (250) | A | No | ||
| DBVoidDate | BTREE | No | No | DBVoidDate (250) | A | No | ||
| DBVoidTime | BTREE | No | No | DBVoidTime (250) | A | No | ||
| DBVoidBy | BTREE | No | No | DBVoidBy (250) | A | No | ||
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | A | No | ||
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | A | No | ||
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBDueDate | BTREE | No | No | DBDueDate (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
rental_properties_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBProperty | text | No | ||||
| DBPropertyType | text | No | ||||
| DBDescription | text | No | ||||
| DBBuildingNumber | text | No | ||||
| DBPropertyOwnerNum | text | No | ||||
| DBTenantNum | text | No | ||||
| DBSquareMeter | text | No | ||||
| DBRentalRate | text | No | ||||
| DBAssociationDue | text | No | ||||
| DBElectricty_PER_KWH | text | No | ||||
| DBWater_PER_CUBIC | text | No | ||||
| DBOccupiedDate | text | No | ||||
| DBDateCreated | text | No | ||||
| DBTimeCreated | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBProperty | BTREE | No | No | DBProperty (250) | A | No | ||
| DBPropertyType | BTREE | No | No | DBPropertyType (250) | A | No | ||
| DBDescription | BTREE | No | No | DBDescription (250) | A | No | ||
| DBBuildingNumber | BTREE | No | No | DBBuildingNumber (250) | A | No | ||
| DBPropertyOwnerNum | BTREE | No | No | DBPropertyOwnerNum (250) | A | No | ||
| DBTenantNum | BTREE | No | No | DBTenantNum (250) | A | No | ||
| DBSquareMeter | BTREE | No | No | DBSquareMeter (250) | A | No | ||
| DBRentalRate | BTREE | No | No | DBRentalRate (250) | A | No | ||
| DBAssociationDue | BTREE | No | No | DBAssociationDue (250) | A | No | ||
| DBElectricty_PER_KWH | BTREE | No | No | DBElectricty_PER_KWH (250) | A | No | ||
| DBWater_PER_CUBIC | BTREE | No | No | DBWater_PER_CUBIC (250) | A | No | ||
| DBOccupiedDate | BTREE | No | No | DBOccupiedDate (250) | A | No | ||
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | A | No | ||
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
rental_property_owner_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBName | text | No | ||||
| DBEmail | text | No | ||||
| DBContact | text | No | ||||
| DBPassword | text | No | ||||
| DBStatus | text | No | ||||
| DBDateCreated | text | No | ||||
| DBTimeCreated | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBName | BTREE | No | No | DBName (250) | A | No | ||
| DBEmail | BTREE | No | No | DBEmail (250) | A | No | ||
| DBContact | BTREE | No | No | DBContact (250) | A | No | ||
| DBPassword | BTREE | No | No | DBPassword (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | A | No | ||
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
rental_tenant_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBName | text | No | ||||
| DBEmail | text | No | ||||
| DBContact | text | No | ||||
| DBPassword | text | No | ||||
| DBStatus | text | No | ||||
| DBDateCreated | text | No | ||||
| DBTimeCreated | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBName | BTREE | No | No | DBName (250) | A | No | ||
| DBEmail | BTREE | No | No | DBEmail (250) | A | No | ||
| DBContact | BTREE | No | No | DBContact (250) | A | No | ||
| DBPassword | BTREE | No | No | DBPassword (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | A | No | ||
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
stockin_pending_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBStockInID | text | No | ||||
| DBStockReceived | text | No | ||||
| DBAccountNum | text | No | ||||
| DBDate | text | No | ||||
| DBTime | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBStockInID | BTREE | No | No | DBStockInID (250) | A | No | ||
| DBStockReceived | BTREE | No | No | DBStockReceived (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBTime | BTREE | No | No | DBTime (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
stockin_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBInvoiceNumber | text | No | ||||
| DBInvoiceQuantity | text | No | ||||
| DBActualQuantity | text | No | ||||
| DBCost | text | No | ||||
| DBNewCost | text | No | ||||
| DBOldCost | text | No | ||||
| DBNote | text | No | ||||
| DBDate | text | No | ||||
| DBInvoiceDate | text | No | ||||
| DBInventoryNum | text | No | ||||
| DBSupplierNum | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | A | No | ||
| DBInvoiceQuantity | BTREE | No | No | DBInvoiceQuantity (250) | A | No | ||
| DBActualQuantity | BTREE | No | No | DBActualQuantity (250) | A | No | ||
| DBCost | BTREE | No | No | DBCost (250) | A | No | ||
| DBNewCost | BTREE | No | No | DBNewCost (250) | A | No | ||
| DBOldCost | BTREE | No | No | DBOldCost (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | A | No | ||
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBSupplierNum | BTREE | No | No | DBSupplierNum (250) | A | No | ||
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
stockout_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBReferenceNumber | text | No | ||||
| DBInvoiceNumber | text | No | ||||
| DBQuantity | text | No | ||||
| DBCost | text | No | ||||
| DBNote | text | No | ||||
| DBDate | text | No | ||||
| DBInvoiceDate | text | No | ||||
| DBInventoryNum | text | No | ||||
| DBFilterChecker | text | No | ||||
| DBAccountNum | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | A | No | ||
| DBQuantity | BTREE | No | No | DBQuantity (250) | A | No | ||
| DBCost | BTREE | No | No | DBCost (250) | A | No | ||
| DBNote | BTREE | No | No | DBNote (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | A | No | ||
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | A | No | ||
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | A | No | ||
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |
supplier_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBSupplierName | text | No | ||||
| DBAddress | text | No | ||||
| DBContact | text | No | ||||
| DBStatus | text | No | ||||
| DBDate | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 0 | A | No | |
| DBSupplierName | BTREE | No | No | DBSupplierName (250) | A | No | ||
| DBAddress | BTREE | No | No | DBAddress (250) | A | No | ||
| DBContact | BTREE | No | No | DBContact (250) | A | No | ||
| DBStatus | BTREE | No | No | DBStatus (250) | A | No | ||
| DBDate | BTREE | No | No | DBDate (250) | A | No | ||
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | A | No |