erp_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 | 1234 | A | No | |
| DBPathName | BTREE | No | No | DBPathName (250) | 12 | A | No | |
| DBPageName | BTREE | No | No | DBPageName (250) | 64 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 64 | A | No | |
| DBHasAccess | BTREE | No | No | DBHasAccess (250) | 4 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 10 | A | No | |
| DBSubAccess | BTREE | No | No | DBSubAccess (250) | 4 | 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 | 6 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 6 | A | No | |
| DBEditBy | BTREE | No | No | DBEditBy (250) | 2 | A | No | |
| DBRemarks | BTREE | No | No | DBRemarks (250) | 2 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 6 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | 629 | A | No | |
| DBWorkDate_Monday | BTREE | No | No | DBWorkDate_Monday (250) | 2 | A | No | |
| DBTimeIN_Monday | BTREE | No | No | DBTimeIN_Monday (250) | 8 | A | No | |
| DBTimeOUT_Monday | BTREE | No | No | DBTimeOUT_Monday (250) | 8 | A | No | |
| DBWorkDate_Tuesday | BTREE | No | No | DBWorkDate_Tuesday (250) | 2 | A | No | |
| DBTimeIN_Tuesday | BTREE | No | No | DBTimeIN_Tuesday (250) | 8 | A | No | |
| DBTimeOUT_Tuesday | BTREE | No | No | DBTimeOUT_Tuesday (250) | 8 | A | No | |
| DBWorkDate_Wednesday | BTREE | No | No | DBWorkDate_Wednesday (250) | 4 | A | No | |
| DBTimeIN_Wednesday | BTREE | No | No | DBTimeIN_Wednesday (250) | 8 | A | No | |
| DBTimeOUT_Wednesday | BTREE | No | No | DBTimeOUT_Wednesday (250) | 8 | A | No | |
| DBWorkDate_Thursday | BTREE | No | No | DBWorkDate_Thursday (250) | 2 | A | No | |
| DBTimeIN_Thursday | BTREE | No | No | DBTimeIN_Thursday (250) | 8 | A | No | |
| DBTimeOUT_Thursday | BTREE | No | No | DBTimeOUT_Thursday (250) | 8 | A | No | |
| DBWorkDate_Friday | BTREE | No | No | DBWorkDate_Friday (250) | 2 | A | No | |
| DBTimeIN_Friday | BTREE | No | No | DBTimeIN_Friday (250) | 8 | A | No | |
| DBTimeOUT_Friday | BTREE | No | No | DBTimeOUT_Friday (250) | 8 | A | No | |
| DBWorkDate_Saturday | BTREE | No | No | DBWorkDate_Saturday (250) | 2 | A | No | |
| DBTimeIN_Saturday | BTREE | No | No | DBTimeIN_Saturday (250) | 8 | A | No | |
| DBTimeOUT_Saturday | BTREE | No | No | DBTimeOUT_Saturday (250) | 8 | A | No | |
| DBWorkDate_Sunday | BTREE | No | No | DBWorkDate_Sunday (250) | 4 | A | No | |
| DBTimeIN_Sunday | BTREE | No | No | DBTimeIN_Sunday (250) | 8 | A | No | |
| DBTimeOUT_Sunday | BTREE | No | No | DBTimeOUT_Sunday (250) | 8 | A | No | |
| DBAccountID | BTREE | No | No | DBAccountNum (250) | 62 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 8 | A | No | |
| DBHasLunchBreak_Monday | BTREE | No | No | DBHasLunchBreak_Monday (250) | 4 | A | No | |
| DBHasLunchBreak_Tuesday | BTREE | No | No | DBHasLunchBreak_Tuesday (250) | 4 | A | No | |
| DBHasLunchBreak_Wednesday | BTREE | No | No | DBHasLunchBreak_Wednesday (250) | 4 | A | No | |
| DBHasLunchBreak_Thursday | BTREE | No | No | DBHasLunchBreak_Thursday (250) | 4 | A | No | |
| DBHasLunchBreak_Friday | BTREE | No | No | DBHasLunchBreak_Friday (250) | 4 | A | No | |
| DBHasLunchBreak_Saturday | BTREE | No | No | DBHasLunchBreak_Saturday (250) | 4 | A | No | |
| DBHasLunchBreak_Sunday | BTREE | No | No | DBHasLunchBreak_Sunday (250) | 4 | 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 | 31 | A | No | |
| IDAccount_Name | BTREE | No | No | DBName (250) | 31 | A | No | |
| IDAccount_Number | BTREE | No | No | DBRFID_Number (250) | 31 | A | No | |
| IDAccount_Username | BTREE | No | No | DBUsername (250) | 31 | A | No | |
| IDAccount_Password | BTREE | No | No | DBPassword (250) | 31 | A | No | |
| IDAccount_Role | BTREE | No | No | DBRole (250) | 15 | A | No | |
| IDAccount_Department | BTREE | No | No | DBDepartment (250) | 31 | A | No | |
| IDAccount_Position | BTREE | No | No | DBPosition (250) | 31 | A | No | |
| IDAccount_BirthDate | BTREE | No | No | DBBirthDate (250) | 31 | A | No | |
| IDAccount_Address | BTREE | No | No | DBAddress (250) | 31 | A | No | |
| IDAccount_ContactNumber | BTREE | No | No | DBContact (250) | 31 | A | No | |
| IDAccount_TIN | BTREE | No | No | DBTIN (250) | 31 | A | No | |
| IDAccount_SSS | BTREE | No | No | DBSSS (250) | 31 | A | No | |
| IDAccount_PagIbig | BTREE | No | No | DBPagIbig (250) | 31 | A | No | |
| IDAccount_Philhealth | BTREE | No | No | DBPhilhealth (250) | 31 | A | No | |
| IDSSSAmount | BTREE | No | No | DBSSSAmount (250) | 15 | A | No | |
| IDPagIbigAmount | BTREE | No | No | DBPagIbigAmount (250) | 15 | A | No | |
| IDPhilhealthAmount | BTREE | No | No | DBPhilhealthAmount (250) | 15 | A | No | |
| IDSalary | BTREE | No | No | DBSalary (250) | 31 | A | No | |
| IDStatus | BTREE | No | No | DBStatus (250) | 4 | A | No | |
| IDDate | BTREE | No | No | DBDateHired (250) | 31 | A | No | |
| IDAccount_Email | BTREE | No | No | DBEmail (250) | 31 | A | No | |
| IDOvertimePayment | BTREE | No | No | DBOvertimePayment (250) | 4 | A | No | |
| IDWarehouseNum | BTREE | No | No | DBBranchNum (250) | 10 | A | No | |
| IDFixedSalary | BTREE | No | No | DBFixedSalary (250) | 4 | A | No | |
| IDNoHolidayPay | BTREE | No | No | DBNoHolidayPay (250) | 4 | A | No | |
| IDNoOvertimePay | BTREE | No | No | DBNoOvertimePay (250) | 4 | A | No | |
| IDNoNDPay | BTREE | No | No | DBNoNDPay (250) | 4 | A | No | |
| IDAllowance | BTREE | No | No | DBAllowance (250) | 2 | A | No | |
| IDAccount_Number2 | BTREE | No | No | DBAccount_Number (250) | 31 | A | No | |
| IDStatusOfEmployment | BTREE | No | No | DBStatusOfEmployment (250) | 2 | A | No | |
| IDAccount_Number3 | BTREE | No | No | DBBank_Number (250) | 31 | A | No | |
| DBLeaveCredits | BTREE | No | No | DBLeaveCredits (250) | 10 | A | No | |
| DBAllowanceType | BTREE | No | No | DBAllowanceType (250) | 4 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 2 | A | No | |
| DBCurrentSession | BTREE | No | No | DBCurrentSession (250) | 31 | A | No | |
| DBNumberOfWorkingDays | BTREE | No | No | DBNumberOfWorkingDays (250) | 2 | 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 | ||||
| DBDoubleScan | 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 | 3 | A | No | |
| DBBranchName | BTREE | No | No | DBBranchName (250) | 3 | A | No | |
| DBAddress | BTREE | No | No | DBAddress (250) | 3 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 3 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 3 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 3 | A | No | |
| DBDoubleScan | BTREE | No | No | DBDoubleScan (250) | 3 | A | No | |
| DBCode | BTREE | No | No | DBCode (250) | 3 | A | No | |
| DBEmail | BTREE | No | No | DBEmail (250) | 3 | A | No | |
| DBMergeCode | BTREE | No | No | DBMergeCode (250) | 3 | A | No | |
| DBAPIKey | BTREE | No | No | DBAPIKey (768) | 3 | 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 | 163 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 18 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 163 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 8 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 8 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 8 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 8 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 163 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 8 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 6 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 163 | A | No | |
| DBLeaveType | BTREE | No | No | DBLeaveType (250) | 8 | A | No | |
| DBPaymentType | BTREE | No | No | DBPaymentType (250) | 4 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | 212 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 23 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 212 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 16 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 14 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 53 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 30 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 106 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 8 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 8 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 106 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No | |
| DBPenalty | BTREE | No | No | DBPenalty (250) | 2 | 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 | 179 | A | No | |
| DBDailyTimeNum | BTREE | No | No | DBDailyTimeNum (250) | 179 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 22 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 179 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 179 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 6 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 179 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 8 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | 11 | A | No | |
| DBDateRequest | BTREE | No | No | DBDateRequest (250) | 11 | A | No | |
| DBDateFiled | BTREE | No | No | DBDateFiled (250) | 11 | A | No | |
| DBDayType | BTREE | No | No | DBDayType (250) | 2 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 5 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 5 | A | No | |
| DBLogBy | BTREE | No | No | DBLogBy (250) | 2 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 2 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 11 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No | |
| DBHasLunchBreak | BTREE | No | No | DBHasLunchBreak (250) | 2 | A | No |
dailytime_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBTimeIn | text | No | ||||
| DBTimeOut | text | No | ||||
| DBDate | text | No | ||||
| DBLunchOut | text | No | ||||
| DBLunchBack | text | No | ||||
| DBWorkStart | text | No | ||||
| DBWorkEnd | text | No | ||||
| DBDayType | text | No | ||||
| DBSalary | text | No | ||||
| DBPaymentStatus | text | No | ||||
| DBPenalty | text | No | ||||
| DBBonus | text | No | ||||
| DBOvertimeStart | text | No | ||||
| DBOvertimeIn | text | No | ||||
| DBOvertimeOut | text | No | ||||
| DBBreakOut1 | text | No | ||||
| DBBreakBack2 | text | No | ||||
| DBBreakOut2 | text | No | ||||
| DBFixedSalary | text | No | ||||
| DBNoHolidayPay | text | No | ||||
| DBNoOvertimePay | text | No | ||||
| DBNoNDPay | text | No | ||||
| DBHasLunchBreak | text | No | ||||
| DBOvertimePayment | text | No | ||||
| DBPaidAmount | text | No | ||||
| DBBreakBack1 | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 8241 | A | No | |
| IDAccountNum | BTREE | No | No | DBAccountNum (250) | 42 | A | No | |
| IDTimeIn | BTREE | No | No | DBTimeIn (250) | 8241 | A | No | |
| IDTimeOUT | BTREE | No | No | DBTimeOut (250) | 4120 | A | No | |
| IDDate | BTREE | No | No | DBDate (250) | 2060 | A | No | |
| IDLunchOut | BTREE | No | No | DBLunchOut (250) | 4120 | A | No | |
| IDLunchBack | BTREE | No | No | DBLunchBack (250) | 4120 | A | No | |
| IDWorkStart | BTREE | No | No | DBWorkStart (250) | 206 | A | No | |
| IDWorkEnd | BTREE | No | No | DBWorkEnd (250) | 201 | A | No | |
| IDDayType | BTREE | No | No | DBDayType (250) | 8 | A | No | |
| IDSalary | BTREE | No | No | DBSalary (250) | 30 | A | No | |
| IDStatus | BTREE | No | No | DBPaymentStatus (250) | 4 | A | No | |
| IDDeduction | BTREE | No | No | DBPenalty (250) | 12 | A | No | |
| IDOvertimeStart | BTREE | No | No | DBOvertimeStart (250) | 222 | A | No | |
| IDAddition | BTREE | No | No | DBBonus (250) | 4 | A | No | |
| IDOvertimeIn | BTREE | No | No | DBOvertimeIn (250) | 38 | A | No | |
| IDOvertimeOut | BTREE | No | No | DBOvertimeOut (250) | 179 | A | No | |
| IDBreakOut1 | BTREE | No | No | DBBreakOut1 (250) | 8 | A | No | |
| IDBreakBack1 | BTREE | No | No | DBBreakBack1 (250) | 6 | A | No | |
| IDFixedSalary | BTREE | No | No | DBFixedSalary (250) | 2 | A | No | |
| IDNoHolidayPay | BTREE | No | No | DBNoHolidayPay (250) | 4 | A | No | |
| IDNoOvertimePay | BTREE | No | No | DBNoOvertimePay (250) | 2 | A | No | |
| IDNoNDPay | BTREE | No | No | DBNoNDPay (250) | 2 | A | No | |
| IDOvertimePayment | BTREE | No | No | DBOvertimePayment (250) | 2 | A | No | |
| IDPaidAmount | BTREE | No | No | DBPaidAmount (250) | 1177 | A | No | |
| IDBreakBack2 | BTREE | No | No | DBBreakBack2 (250) | 4 | A | No | |
| IDBreakOut2 | BTREE | No | No | DBBreakOut2 (250) | 4 | A | No | |
| DBHasLunchBreak | BTREE | No | No | DBHasLunchBreak (250) | 4 | 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 | 334 | A | No | |
| DBDailyTimeNum | BTREE | No | No | DBDailyTimeNum (250) | 334 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 25 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 334 | A | No | |
| DBWorkStart | BTREE | No | No | DBWorkStart (250) | 14 | A | No | |
| DBWorkEnd | BTREE | No | No | DBWorkEnd (250) | 14 | A | No | |
| DBTimeIn | BTREE | No | No | DBTimeIn (250) | 334 | A | No | |
| DBTimeOut | BTREE | No | No | DBTimeOut (250) | 167 | A | No | |
| DBReason | BTREE | No | No | DBReason (250) | 334 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 8 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 8 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 334 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No | |
| DBPenalty | BTREE | No | No | DBPenalty (250) | 2 | 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 | 5 | A | No | |
| DBStoreName | BTREE | No | No | DBStoreName (250) | 5 | A | No | |
| DBMarketPlace | BTREE | No | No | DBMarketPlace (250) | 5 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 2 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 5 | A | No | |
| seller_id | BTREE | No | No | seller_id (250) | 5 | A | No | |
| access_token | BTREE | No | No | access_token (250) | 5 | A | No | |
| refresh_token | BTREE | No | No | refresh_token (250) | 5 | A | No | |
| country_code | BTREE | No | No | country_code (250) | 2 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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) | 0 | A | No | |
| DBMarketPlace | BTREE | No | No | DBMarketPlace (250) | 0 | A | No | |
| DBBatchDropIn | BTREE | No | No | DBBatchDropIn (250) | 0 | A | No | |
| DBDropInBy | BTREE | No | No | DBDropInBy (250) | 0 | A | No | |
| DBDropInDate | BTREE | No | No | DBDropInDate (250) | 0 | A | No | |
| DBDropInTime | BTREE | No | No | DBDropInTime (250) | 0 | A | No | |
| DBBatchDropOut | BTREE | No | No | DBBatchDropOut (250) | 0 | A | No | |
| DBDropOutBy | BTREE | No | No | DBDropOutBy (250) | 0 | A | No | |
| DBDropOutDate | BTREE | No | No | DBDropOutDate (250) | 0 | A | No | |
| DBDropOutTime | BTREE | No | No | DBDropOutTime (250) | 0 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 0 | 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 | 67642 | A | No | |
| DBOrderNumber | BTREE | No | No | DBOrderNumber (250) | 67642 | A | No | |
| DBTrackingNumber | BTREE | No | No | DBTrackingNumber (250) | 67642 | A | No | |
| DBBatchUpload | BTREE | No | No | DBBatchUpload (250) | 7515 | A | No | |
| DBBatchReleased | BTREE | No | No | DBBatchReleased (250) | 5636 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 10 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 1989 | A | No | |
| DBPrice | BTREE | No | No | DBPrice (250) | 13528 | A | No | |
| DBCost | BTREE | No | No | DBCost (250) | 483 | A | No | |
| DBUploadedBy | BTREE | No | No | DBUploadedBy (250) | 10 | A | No | |
| DBDateUpload | BTREE | No | No | DBDateUpload (250) | 1166 | A | No | |
| DBTimeUpload | BTREE | No | No | DBTimeUpload (250) | 7515 | A | No | |
| DBPreparedBy | BTREE | No | No | DBPreparedBy (250) | 12 | A | No | |
| DBDatePrepared | BTREE | No | No | DBDatePrepared (250) | 1166 | A | No | |
| DBTimePrepared | BTREE | No | No | DBTimePrepared (250) | 33821 | A | No | |
| DBCheckedBy | BTREE | No | No | DBCheckedBy (250) | 10 | A | No | |
| DBReleasedBy | BTREE | No | No | DBReleasedBy (250) | 12 | A | No | |
| DBDateReleased | BTREE | No | No | DBDateReleased (250) | 1166 | A | No | |
| DBTimeReleased | BTREE | No | No | DBTimeReleased (250) | 33821 | A | No | |
| DBReturnedBy | BTREE | No | No | DBReturnedBy (250) | 12 | A | No | |
| DBDateReturned | BTREE | No | No | DBDateReturned (250) | 690 | A | No | |
| DBTimeReturned | BTREE | No | No | DBTimeReturned (250) | 1470 | A | No | |
| DBCancelledBy | BTREE | No | No | DBCancelledBy (250) | 12 | A | No | |
| DBDateCancelled | BTREE | No | No | DBDateCancelled (250) | 118 | A | No | |
| DBTimeCancelled | BTREE | No | No | DBTimeCancelled (250) | 194 | A | No | |
| DBCustomer | BTREE | No | No | DBCustomer (250) | 33821 | A | No | |
| DBCustomerContact | BTREE | No | No | DBCustomerContact (250) | 1127 | A | No | |
| DBCourier | BTREE | No | No | DBCourier (250) | 32 | A | No | |
| DBMarketPlace | BTREE | No | No | DBMarketPlace (250) | 6 | A | No | |
| DBSellerNum | BTREE | No | No | DBSellerNum (250) | 10 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 6 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 316 | A | No | |
| DBPaymentStatus | BTREE | No | No | DBPaymentStatus (250) | 4 | A | No | |
| DBDateChecked | BTREE | No | No | DBDateChecked (250) | 442 | A | No | |
| DBTimeChecked | BTREE | No | No | DBTimeChecked (250) | 8455 | A | No | |
| DBPrintedBy | BTREE | No | No | DBPrintedBy (250) | 2 | A | No | |
| DBDatePrinted | BTREE | No | No | DBDatePrinted (250) | 2 | A | No | |
| DBTimePrinted | BTREE | No | No | DBTimePrinted (250) | 2 | A | No | |
| DBDeductionType | BTREE | No | No | DBDeductionType (250) | 4 | 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 | 3570 | A | No | |
| DBOrderNumber | BTREE | No | No | DBOrderNumber (250) | 3570 | A | No | |
| DBAmount | BTREE | No | No | DBAmount (250) | 3570 | A | No | |
| DBCount | BTREE | No | No | DBCount (250) | 64 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 510 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No |
ecommerce_waybill_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBTrackingNumber | 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 | |
| DBTrackingNumber | BTREE | No | No | DBTrackingNumber (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 |
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 | 188 | A | No | |
| DBMessage | BTREE | No | No | DBMessage (250) | 47 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 94 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 188 | 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 | 55 | A | No | |
| IDDate | BTREE | No | No | DBDate (250) | 55 | A | No | |
| IDHolidayDate | BTREE | No | No | DBHolidayDate (250) | 55 | A | No | |
| IDHoliday | BTREE | No | No | DBHoliday (250) | 55 | A | No | |
| IDType | BTREE | No | No | DBType (250) | 4 | A | No | |
| IDAccountNum | BTREE | No | No | DBAccountNum (250) | 6 | 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 | 1420 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 710 | A | No | |
| DBInventoryTotalAmount | BTREE | No | No | DBInventoryTotalAmount (250) | 1420 | A | No | |
| DBInventoryTotalStock | BTREE | No | No | DBInventoryTotalStock (250) | 1420 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | 92445 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 5777 | A | No | |
| DBEditBy | BTREE | No | No | DBEditBy (250) | 24 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 6 | A | No | |
| DBPreviousQuantity | BTREE | No | No | DBPreviousQuantity (250) | 18489 | A | No | |
| DBNewQuantity | BTREE | No | No | DBNewQuantity (250) | 18489 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1339 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 46222 | A | No | |
| DBTransactionType | BTREE | No | No | DBTransactionType (250) | 6 | A | No | |
| DBRemarks | BTREE | No | No | DBRemarks (250) | 92445 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 6 | 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 | 1446 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 1446 | A | No | |
| DBEditBy | BTREE | No | No | DBEditBy (250) | 18 | A | No | |
| DBRemarks | BTREE | No | No | DBRemarks (250) | 1446 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1446 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 6 | A | No | |
| DBEditRemarks | BTREE | No | No | DBEditRemarks (250) | 1446 | 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) | 0 | A | No | |
| DBSubSKU | BTREE | No | No | DBSubSKU (250) | 0 | A | No | |
| DBInventoryNumList | BTREE | No | No | DBInventoryNumList (250) | 0 | A | No | |
| DBQuantityList | BTREE | No | No | DBQuantityList (250) | 0 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 0 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 0 | 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 | ||||
| TSUTSUME | text | No | ||||
| CG | text | No | ||||
| JF | text | No | ||||
| FMAC | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 8026 | A | No | |
| DBProductName | BTREE | No | No | DBProductName (250) | 8026 | A | No | |
| DBBarcode | BTREE | No | No | DBBarcode (250) | 8026 | A | No | |
| DBSKU | BTREE | No | No | DBSKU (250) | 8026 | A | No | |
| DBBrand | BTREE | No | No | DBBrand (250) | 573 | A | No | |
| DBCategory | BTREE | No | No | DBCategory (250) | 267 | A | No | |
| DBPrice1 | BTREE | No | No | DBPrice1 (250) | 1605 | A | No | |
| DBPrice2 | BTREE | No | No | DBPrice2 (250) | 1337 | A | No | |
| DBPrice3 | BTREE | No | No | DBPrice3 (250) | 1337 | A | No | |
| DBCost | BTREE | No | No | DBCost (250) | 1605 | A | No | |
| DBThreshold | BTREE | No | No | DBThreshold (250) | 42 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 4 | A | No | |
| DBOnlinePrice | BTREE | No | No | DBOnlinePrice (250) | 2 | A | No | |
| DBOnlineDiscount | BTREE | No | No | DBOnlineDiscount (250) | 2 | A | No | |
| DBOnlineDescription | BTREE | No | No | DBOnlineDescription (250) | 2 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 802 | A | No | |
| DBQuantity | BTREE | No | No | DBQuantity (250) | 668 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 6 | A | No | |
| FMAC | BTREE | No | No | FMAC (250) | 308 | A | No | |
| JF | BTREE | No | No | JF (250) | 6 | A | No | |
| CG | BTREE | No | No | CG (250) | 28 | A | No | |
| TSUTSUME | BTREE | No | No | TSUTSUME (250) | 6 | A | No | |
| DBUnit | BTREE | No | No | DBUnit (250) | 68 | 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 | 1615 | A | No | |
| IDLogbookNum | BTREE | No | No | DBDeductionNum (250) | 1615 | A | No | |
| IDDate | BTREE | No | No | DBDate (250) | 179 | A | No | |
| IDPayment | BTREE | No | No | DBPayment (250) | 95 | A | No | |
| IDLogBy | BTREE | No | No | DBLogBy (250) | 6 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | ||||
| DBStatus | text | No | ||||
| DBType | text | No | ||||
| DBBranchNum | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | DBID | 724 | A | No | |
| IDDetails | BTREE | No | No | DBDetails (250) | 42 | A | No | |
| IDAmount | BTREE | No | No | DBAmount (250) | 72 | A | No | |
| IDLogBy | BTREE | No | No | DBLogBy (250) | 8 | A | No | |
| IDDate | BTREE | No | No | DBDate (250) | 724 | A | No | |
| IDUnderBy | BTREE | No | No | DBUnderBy (250) | 30 | A | No | |
| IDStatus | BTREE | No | No | DBStatus (250) | 6 | A | No | |
| DBType | BTREE | No | No | DBType (250) | 4 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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) | 0 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 0 | A | No | |
| DBAmount | BTREE | No | No | DBAmount (250) | 0 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 0 | A | No | |
| DBCheckedBy | BTREE | No | No | DBCheckedBy (250) | 0 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 0 | 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 | 1732 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 1732 | A | No | |
| DBTransactionNumber | BTREE | No | No | DBTransactionNumber (250) | 1732 | A | No | |
| DBTransactionType | BTREE | No | No | DBTransactionType (250) | 4 | A | No | |
| DBAmount | BTREE | No | No | DBAmount (250) | 1732 | A | No | |
| DBCashFlow | BTREE | No | No | DBCashFlow (250) | 4 | A | No | |
| DBModeOfPayment | BTREE | No | No | DBModeOfPayment (250) | 4 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 1732 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1732 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 1732 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 8 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No |
pos_customer_credit_balance_table
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| DBID (Primary) | int(250) | No | ||||
| DBAccountNum | text | No | ||||
| DBReferenceNumber | text | No | ||||
| DBDetail | text | No | ||||
| DBAmount | 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 | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | A | No | ||
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | A | No | ||
| DBDetail | BTREE | No | No | DBDetail (250) | A | No | ||
| DBAmount | BTREE | No | No | DBAmount (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 |
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 | 1435 | A | No | |
| DBCustomerName | BTREE | No | No | DBCustomerName (250) | 1435 | A | No | |
| DBAddress | BTREE | No | No | DBAddress (250) | 1435 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 1435 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 4 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1435 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 4 | A | No | |
| DBOtherInformation | BTREE | No | No | DBOtherInformation (250) | 14 | 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 | 16732 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 16732 | A | No | |
| DBPayment | BTREE | No | No | DBPayment (250) | 5577 | A | No | |
| DBModeOfPayment | BTREE | No | No | DBModeOfPayment (250) | 12 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 2390 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1394 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 16732 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 26 | A | No | |
| DBCustomerNum | BTREE | No | No | DBCustomerNum (250) | 2788 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 6 | A | No | |
| DBPaymentDate | BTREE | No | No | DBPaymentDate (250) | 1195 | 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 | 29663 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 29663 | A | No | |
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | 29663 | A | No | |
| DBDraft | BTREE | No | No | DBDraft (250) | 12 | A | No | |
| DBTransactionType | BTREE | No | No | DBTransactionType (250) | 4 | A | No | |
| DBQuantity | BTREE | No | No | DBQuantity (250) | 674 | A | No | |
| DBPrice | BTREE | No | No | DBPrice (250) | 1348 | A | No | |
| DBCost | BTREE | No | No | DBCost (250) | 926 | A | No | |
| DBDiscount | BTREE | No | No | DBDiscount (250) | 1289 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 1348 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 29663 | A | No | |
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | 1348 | A | No | |
| DBPaymentDate | BTREE | No | No | DBPaymentDate (250) | 1348 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 5932 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 28 | A | No | |
| DBCustomerNum | BTREE | No | No | DBCustomerNum (250) | 2696 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 6 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 6 | A | No | |
| DBShippingFee | BTREE | No | No | DBShippingFee (250) | 429 | A | No | |
| DBPreparedBy | BTREE | No | No | DBPreparedBy (250) | 10 | A | No | |
| DBDatePrepared | BTREE | No | No | DBDatePrepared (250) | 18 | A | No | |
| DBTimePrepared | BTREE | No | No | DBTimePrepared (250) | 2 | A | No | |
| DBCustomerType | BTREE | No | No | DBCustomerType (250) | 8 | 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 | ||||
| DBReceivingStatus | 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) | 0 | A | No | |
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | 0 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 0 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 0 | A | No | |
| DBOldCost | BTREE | No | No | DBOldCost (250) | 0 | A | No | |
| DBNewCost | BTREE | No | No | DBNewCost (250) | 0 | A | No | |
| DBQuantity | BTREE | No | No | DBQuantity (250) | 0 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 0 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 0 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 0 | A | No | |
| DBDateApproved | BTREE | No | No | DBDateApproved (250) | 0 | A | No | |
| DBTimeApproved | BTREE | No | No | DBTimeApproved (250) | 0 | A | No | |
| DBApprovedBy | BTREE | No | No | DBApprovedBy (250) | 0 | A | No | |
| DBSupplierNum | BTREE | No | No | DBSupplierNum (250) | 0 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 0 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 0 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 0 | A | No | |
| DBReceivingStatus | BTREE | No | No | DBReceivingStatus (250) | 0 | 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) | 0 | A | No | |
| DBPassword | BTREE | No | No | DBPassword (250) | 0 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 0 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 0 | 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 | 4 | A | No | |
| DBBillingName | BTREE | No | No | DBBillingName (250) | 4 | A | No | |
| DBBillingCode | BTREE | No | No | DBBillingCode (250) | 4 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 1 | A | No | |
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | 1 | A | No | |
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | 4 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No | |
| DBAmount | BTREE | No | No | DBAmount (250) | 4 | A | No | |
| DBAutoInput | BTREE | No | No | DBAutoInput (250) | 1 | 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 | 21 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 10 | A | No | |
| DBPayment | BTREE | No | No | DBPayment (250) | 7 | A | No | |
| DBModeOfPayment | BTREE | No | No | DBModeOfPayment (250) | 5 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 7 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 5 | A | No | |
| DBPaymentDate | BTREE | No | No | DBPaymentDate (250) | 5 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 21 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 3 | A | No | |
| DBPropertyOwnerNum | BTREE | No | No | DBPropertyOwnerNum (250) | 7 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No | |
| DBPropertyNum | BTREE | No | No | DBPropertyNum (250) | 7 | 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 | 48 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 9 | A | No | |
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | 9 | A | No | |
| DBBillingNum | BTREE | No | No | DBBillingNum (250) | 8 | A | No | |
| DBAmount | BTREE | No | No | DBAmount (250) | 24 | A | No | |
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | 3 | A | No | |
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | 6 | A | No | |
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | 9 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No | |
| DBPropertyOwnerNum | BTREE | No | No | DBPropertyOwnerNum (250) | 6 | A | No | |
| DBPropertyNum | BTREE | No | No | DBPropertyNum (250) | 8 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 2 | A | No | |
| DBIsVoid | BTREE | No | No | DBIsVoid (250) | 2 | A | No | |
| DBVoidDate | BTREE | No | No | DBVoidDate (250) | 2 | A | No | |
| DBVoidTime | BTREE | No | No | DBVoidTime (250) | 2 | A | No | |
| DBVoidBy | BTREE | No | No | DBVoidBy (250) | 2 | A | No | |
| DBDueDate | BTREE | No | No | DBDueDate (250) | 6 | A | No | |
| DBBillReading | BTREE | No | No | DBBillReading (250) | 12 | A | No | |
| DBRate | BTREE | No | No | DBRate (250) | 6 | 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 | 1458 | A | No | |
| DBUnit | BTREE | No | No | DBProperty (250) | 1458 | A | No | |
| DBSquareMeter | BTREE | No | No | DBSquareMeter (250) | 3 | A | No | |
| DBRentalRate | BTREE | No | No | DBRentalRate (250) | 1 | A | No | |
| DBOccupiedDate | BTREE | No | No | DBOccupiedDate (250) | 1 | A | No | |
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | 1 | A | No | |
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | 6 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No | |
| DBUnitType | BTREE | No | No | DBPropertyType (250) | 1 | A | No | |
| DBDescription | BTREE | No | No | DBDescription (250) | 1 | A | No | |
| DBTentantNum | BTREE | No | No | DBPropertyOwnerNum (250) | 364 | A | No | |
| DBBuildingNumber | BTREE | No | No | DBBuildingNumber (250) | 9 | A | No | |
| DBTenantNum | BTREE | No | No | DBTenantNum (250) | 1 | A | No | |
| DBElectricty_PER_KWH | BTREE | No | No | DBElectricty_PER_KWH (250) | 2 | A | No | |
| DBWater_PER_CUBIC | BTREE | No | No | DBWater_PER_CUBIC (250) | 2 | A | No | |
| DBAssociationDue | BTREE | No | No | DBAssociationDue (250) | 2 | 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 | 383 | A | No | |
| DBName | BTREE | No | No | DBName (250) | 383 | A | No | |
| DBEmail | BTREE | No | No | DBEmail (250) | 2 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 383 | A | No | |
| DBPassword | BTREE | No | No | DBPassword (250) | 1 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 1 | A | No | |
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | 1 | A | No | |
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | 2 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | 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 | 1 | A | No | |
| DBName | BTREE | No | No | DBName (250) | 1 | A | No | |
| DBEmail | BTREE | No | No | DBEmail (250) | 1 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 1 | A | No | |
| DBPassword | BTREE | No | No | DBPassword (250) | 1 | A | No | |
| DBDateCreated | BTREE | No | No | DBDateCreated (250) | 1 | A | No | |
| DBTimeCreated | BTREE | No | No | DBTimeCreated (250) | 1 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 1 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 1 | 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 | 473 | A | No | |
| DBStockInID | BTREE | No | No | DBStockInID (250) | 473 | A | No | |
| DBStockReceived | BTREE | No | No | DBStockReceived (250) | 118 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 4 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 118 | A | No | |
| DBTime | BTREE | No | No | DBTime (250) | 473 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | 1801 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 900 | A | No | |
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | 900 | A | No | |
| DBInvoiceQuantity | BTREE | No | No | DBInvoiceQuantity (250) | 112 | A | No | |
| DBActualQuantity | BTREE | No | No | DBActualQuantity (250) | 112 | A | No | |
| DBCost | BTREE | No | No | DBCost (250) | 600 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 6 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 360 | A | No | |
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | 360 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 1801 | A | No | |
| DBSupplierNum | BTREE | No | No | DBSupplierNum (250) | 20 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 4 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 4 | A | No | |
| DBNewCost | BTREE | No | No | DBNewCost (250) | 450 | A | No | |
| DBOldCost | BTREE | No | No | DBOldCost (250) | 450 | 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 | 11 | A | No | |
| DBReferenceNumber | BTREE | No | No | DBReferenceNumber (250) | 2 | A | No | |
| DBInvoiceNumber | BTREE | No | No | DBInvoiceNumber (250) | 2 | A | No | |
| DBQuantity | BTREE | No | No | DBQuantity (250) | 11 | A | No | |
| DBCost | BTREE | No | No | DBCost (250) | 5 | A | No | |
| DBNote | BTREE | No | No | DBNote (250) | 2 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 2 | A | No | |
| DBInvoiceDate | BTREE | No | No | DBInvoiceDate (250) | 2 | A | No | |
| DBInventoryNum | BTREE | No | No | DBInventoryNum (250) | 11 | A | No | |
| DBFilterChecker | BTREE | No | No | DBFilterChecker (250) | 2 | A | No | |
| DBAccountNum | BTREE | No | No | DBAccountNum (250) | 2 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | 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 | 11 | A | No | |
| DBSupplierName | BTREE | No | No | DBSupplierName (250) | 11 | A | No | |
| DBAddress | BTREE | No | No | DBAddress (250) | 11 | A | No | |
| DBContact | BTREE | No | No | DBContact (250) | 11 | A | No | |
| DBStatus | BTREE | No | No | DBStatus (250) | 2 | A | No | |
| DBDate | BTREE | No | No | DBDate (250) | 11 | A | No | |
| DBBranchNum | BTREE | No | No | DBBranchNum (250) | 2 | A | No |