tbl_categories
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| dUpdatedDate | datetime | No | ||||
| vTitle | varchar(300) | No | ||||
| tSummary | text | No | ||||
| tDes | text | No | ||||
| vCode | varchar(300) | No | ||||
| fImage | varchar(300) | No | ||||
| vSection | varchar(300) | No | prod_cat,menu,news,blog,brand | |||
| iDisplayOrder | int(11) | No | ||||
| iShowOnTop | int(11) | No | ||||
| iShowOnBottom | int(11) | No | ||||
| iCat2ID | int(11) | No | ||||
| iCat3ID | int(11) | No | ||||
| iCat1ID | int(11) | No | ||||
| vPageLink | varchar(300) | No | ||||
| vExternalLinkName | varchar(300) | No | ||||
| vExternalLink | varchar(300) | No | ||||
| tExtraText | text | No | ||||
| vHeader1 | varchar(300) | No | ||||
| vHeader2 | varchar(300) | No | ||||
| vHeader3 | varchar(300) | No | ||||
| vHeader4 | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 39 | A | No |
tbl_company
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vCompanyName | varchar(300) | No | ||||
| vEmail | varchar(300) | No | ||||
| vTel | varchar(300) | No | ||||
| vMobile | varchar(300) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| dAddedDate | datetime | No | ||||
| vAddress1 | varchar(300) | No | ||||
| vAddress2 | varchar(300) | No | ||||
| vAddress3 | varchar(300) | No | ||||
| vCity | varchar(300) | No | ||||
| vRegion | varchar(300) | No | ||||
| vCountry | varchar(300) | No | ||||
| vPostalCode | varchar(300) | No | ||||
| fLogo | varchar(300) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| tSummary | text | No | ||||
| vMetaTitle | varchar(300) | No | ||||
| tMetaDes | text | No | ||||
| tMetaKeywords | text | No | ||||
| vSocial_fb | varchar(300) | No | ||||
| vSocial_youtube | varchar(300) | No | ||||
| vSocial_linkedin | varchar(300) | No | ||||
| vSocial_twitter | varchar(300) | No | ||||
| tGoogleMap | text | No | ||||
| fFavicon | varchar(300) | No | ||||
| tDes | text | No | ||||
| vNotificationEmail | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 1 | A | No |
tbl_company_contacts
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iCompanyID | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| tSummary | text | No | ||||
| tDes | text | No | ||||
| vTelGenaral | varchar(300) | No | ||||
| vMobile | varchar(300) | No | ||||
| vFax | varchar(300) | No | ||||
| vEmailGenaral | varchar(300) | No | ||||
| vAddress1 | varchar(300) | No | ||||
| vCity | varchar(300) | No | ||||
| vRegion | varchar(300) | No | ||||
| vCountry | varchar(300) | No | ||||
| vPostalCode | varchar(300) | No | ||||
| tGoogleMap | text | No | ||||
| vContactName | varchar(300) | No | ||||
| vAddress2 | varchar(300) | No | ||||
| vAddress3 | varchar(300) | No | ||||
| vTelSupport | varchar(300) | No | ||||
| vTelHotline | varchar(300) | No | ||||
| vTelSales | varchar(300) | No | ||||
| vEmailSupport | varchar(300) | No | ||||
| vEmailHotline | varchar(300) | No | ||||
| vEmailSales | varchar(300) | No | ||||
| vType | varchar(300) | No | Partners,Offices | |||
| fLogo | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 4 | A | No |
tbl_company_paymentgateway
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iCompanyID | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vLiveLink | varchar(300) | No | ||||
| vTestLink | varchar(300) | No | ||||
| vMerchantID_live | varchar(300) | No | ||||
| vPassword_live | varchar(300) | No | ||||
| vMerchantID_test | varchar(300) | No | ||||
| vPassword_test | varchar(300) | No | ||||
| tDes | text | No | ||||
| vToken_live | text | No | ||||
| vToken_test | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_images
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iRecordID | int(11) | No | ||||
| vSectionCode | varchar(300) | No | prod_cat,menu,news,blog,brand,products,pages | |||
| vType | varchar(300) | No | Images,Videos,Documents,Sections | |||
| vTitle | varchar(300) | No | ||||
| tDes | text | No | ||||
| vHeader1 | varchar(300) | No | ||||
| vHeader2 | varchar(300) | No | ||||
| vHeader3 | varchar(300) | No | ||||
| vLink | varchar(300) | No | ||||
| vLinkName | varchar(300) | No | ||||
| fFile | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| vHeader4 | varchar(300) | No | ||||
| iDeleteFlag | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 55 | A | No |
tbl_inquiries
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iMemberID | int(11) | No | ||||
| vSubject | varchar(300) | No | ||||
| tFeedback | text | No | ||||
| dDateTime | datetime | No | ||||
| iCompanyID | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iProductID | int(11) | No | ||||
| vType | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 88 | A | No |
tbl_inquiries_reply
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iFeedbackID | int(11) | No | ||||
| tReply | text | No | ||||
| dDateTime | datetime | No | ||||
| iReplyByID | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_members
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vFirstName | varchar(300) | No | ||||
| vLastName | varchar(300) | No | ||||
| vEmail | varchar(300) | No | ||||
| vTel | varchar(300) | No | ||||
| vMobile | varchar(300) | No | ||||
| tDes | text | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| dAddedDate | datetime | No | ||||
| vAddress1 | varchar(300) | No | ||||
| vAddress2 | varchar(300) | No | ||||
| vAddress3 | varchar(300) | No | ||||
| vCity | varchar(300) | No | ||||
| vRegion | varchar(300) | No | ||||
| vCountry | varchar(300) | No | ||||
| vPostalCode | varchar(300) | No | ||||
| fPhoto | varchar(300) | No | ||||
| vCustomerCode | varchar(300) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| tSummary | text | No | ||||
| iNewsLetter | int(11) | No | ||||
| vType | varchar(300) | No | PartnerCustomer,Member,Partner | |||
| vUserName | varchar(300) | No | ||||
| vPassword | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 114934 | A | No |
tbl_members_address
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vFirstName | varchar(300) | No | ||||
| vLastName | varchar(300) | No | ||||
| vEmail | varchar(300) | No | ||||
| vTel | varchar(300) | No | ||||
| vMobile | varchar(300) | No | ||||
| tDes | text | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| dAddedDate | datetime | No | ||||
| vAddress1 | varchar(300) | No | ||||
| vAddress2 | varchar(300) | No | ||||
| vAddress3 | varchar(300) | No | ||||
| vCity | varchar(300) | No | ||||
| vRegion | varchar(300) | No | ||||
| vCountry | varchar(300) | No | ||||
| vPostalCode | varchar(300) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| tSummary | text | No | ||||
| iMemberID | int(11) | No | ||||
| vType | varchar(300) | No | shipping,billing,post |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_pages
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| dUpdatedDate | datetime | No | ||||
| vTitle | varchar(300) | No | ||||
| vSubTitle | varchar(300) | No | ||||
| tSummary | text | No | ||||
| tDes | text | No | ||||
| fImage | varchar(300) | No | ||||
| vSection | varchar(300) | No | page,news,blog,events,media,products,services,testimonials,team,partners,clients,vacancies | |||
| iCat1ID | int(11) | No | primary id of the category | |||
| vHeader1 | varchar(300) | No | ||||
| vHeader2 | varchar(300) | No | ||||
| vHeader3 | varchar(300) | No | ||||
| tExtraText | text | No | ||||
| iCat2ID | int(11) | No | ||||
| iCat3ID | int(11) | No | ||||
| iSlider | int(11) | No | ||||
| vPageLink | varchar(300) | No | ||||
| vEventDateFrom | varchar(300) | No | ||||
| vEventDateTo | varchar(300) | No | ||||
| vEventTime | varchar(300) | No | ||||
| vLocation | varchar(300) | No | ||||
| vExtraLink | varchar(300) | No | ||||
| vExtraLinkName | varchar(300) | No | ||||
| dExpDate | date | No | ||||
| vDesignation | varchar(300) | No | ||||
| vFBLink | varchar(300) | No | ||||
| vLinkedInLink | varchar(300) | No | ||||
| vTwitterLink | varchar(300) | No | ||||
| vCustomerName | varchar(300) | No | ||||
| vCustomerCompany | varchar(300) | No | ||||
| dRate | double | No | ||||
| vRelatedProductsID | text | No | ||||
| vRelatedServicesID | text | No | ||||
| vRelatedEcomProductsID | text | No | ||||
| iOrder | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 187 | A | No |
tbl_pages_section
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iPageID | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| vSubTitle | varchar(300) | No | ||||
| tSummary | text | No | ||||
| tDes | text | No | ||||
| fIcon | varchar(300) | No | ||||
| fImage | varchar(300) | No | ||||
| iOrder | int(11) | No | ||||
| iCat1ID | int(11) | No | ||||
| iCat2ID | int(11) | No | ||||
| iCat3ID | int(11) | No | ||||
| vType | varchar(300) | No | section,feature | |||
| vHeader1 | varchar(300) | No | ||||
| vHeader2 | varchar(300) | No | ||||
| fImage2 | varchar(300) | No | ||||
| fImage3 | varchar(300) | No | ||||
| fImage4 | varchar(300) | No | ||||
| fImage5 | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 64 | A | No |
tbl_partner_portal
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| iLocationID | int(11) | No | ||||
| iRoleID | int(11) | No | ||||
| iLicenseProgrameID | int(11) | No | ||||
| dEstimatedCloseDate | date | No | ||||
| dSolutionCloseDate | date | No | ||||
| iCurrencyID | int(11) | No | ||||
| dEstimatedRevenue | double | No | ||||
| iCustomerID | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| vStatus | varchar(300) | No | Open,Pending,Close | |||
| dModifiedDate | datetime | No | ||||
| iCoSell | int(11) | No | ||||
| iPartnerID | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 2 | A | No |
tbl_products
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| dUpdatedDate | datetime | No | ||||
| vProductType | varchar(300) | No | product,services | |||
| vTitle | varchar(300) | No | ||||
| vSubTitle1 | varchar(300) | No | ||||
| vSubTitle2 | varchar(300) | No | ||||
| vSKU | varchar(300) | No | ||||
| vSerialNo | varchar(300) | No | ||||
| vReferenceNo | varchar(300) | No | ||||
| iCat1ID | int(11) | No | Primary id of the category | |||
| iBrandID | int(11) | No | Primary id of the category | |||
| vBarCode | varchar(300) | No | ||||
| vQRcode | varchar(300) | No | ||||
| dWidth | varchar(300) | No | ||||
| dHeight | varchar(300) | No | ||||
| dWeight | varchar(300) | No | ||||
| dDepth | varchar(300) | No | ||||
| tSummary | text | No | ||||
| tDes | text | No | ||||
| tSpecialNote | text | No | ||||
| tFeatures | text | No | ||||
| tWarranty | text | No | ||||
| vWarrantyPeriod | varchar(300) | No | ||||
| iDisplayOrder | int(11) | No | ||||
| vProductCode | varchar(300) | No | ||||
| tSpecification | text | No | ||||
| iSupplierID | int(11) | No | ||||
| fImage | varchar(300) | No | ||||
| iCat2ID | int(11) | No | ||||
| iCat3ID | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_orders
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iMemberID | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| vOrderStatus | varchar(300) | No | paid,not paid | |||
| tPaymentGatewayDes | text | No | ||||
| vTransactionCode | varchar(300) | No | ||||
| iMemberAddressID | int(11) | No | ||||
| dTotalAmount | double | No | ||||
| dTotalDiscount | double | No | ||||
| dTotalTax | double | No | ||||
| dDiscountType | varchar(300) | No | %,amount | |||
| dDiscountAmount | double | No | ||||
| tOrderNote | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_orders_details
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iOrderID | int(11) | No | ||||
| iProductID | int(11) | No | ||||
| iStockID | int(11) | No | ||||
| dQty | double | No | ||||
| dPrice | double | No | ||||
| dTotalDiscountAmount | double | No | ||||
| dDiscountType | varchar(300) | No | %,Amount | |||
| dDiscountAmount | double | No | ||||
| iProductVarianceID | int(11) | No | ||||
| dTotalAmount | double | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_specials
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vSubTitle | varchar(300) | No | ||||
| tSummary | text | No | ||||
| tDes | text | No | ||||
| vHeader1 | varchar(300) | No | ||||
| vHeader2 | varchar(300) | No | ||||
| dDiscount | double | No | ||||
| dDiscountType | varchar(300) | No | %,amount | |||
| dFrom | date | No | ||||
| dTo | date | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| dUpdatedDate | datetime | No | ||||
| fImage | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_specials_products
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iSpecialID | int(11) | No | ||||
| iProductID | int(11) | No | ||||
| dDiscount | double | No | ||||
| dDiscountType | varchar(300) | No | %,amount | |||
| iProductVarianceID | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_stock
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iProductID | int(11) | No | ||||
| iSupplierID | int(11) | No | ||||
| dQty | double | No | ||||
| iFinish | int(11) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| dUpdatedDate | datetime | No | ||||
| iProductVarianceID | int(11) | No | ||||
| dSellingPrice | double | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_stock_flow
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iStockID | int(11) | No | ||||
| iProductID | int(11) | No | ||||
| dQty | double | No | ||||
| iOrderID | int(11) | No | ||||
| dAddedDate | datetime | No | ||||
| vType | varchar(300) | No | sale,return,damage | |||
| iProductVarianceID | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_products_variance
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iProductID | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vSKU | varchar(300) | No | ||||
| tDes | text | No | ||||
| tSummary | text | No | ||||
| iDeleteFlag | int(11) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| dUpdatedDate | datetime | No | ||||
| vHeader1 | varchar(300) | No | ||||
| vHeader2 | varchar(300) | No | ||||
| fFile | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_suppliers
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| vFirstName | varchar(300) | No | ||||
| vLastName | varchar(300) | No | ||||
| vEmail | varchar(300) | No | ||||
| vTel | varchar(300) | No | ||||
| vMobile | varchar(300) | No | ||||
| tDes | text | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| dAddedDate | datetime | No | ||||
| vAddress1 | varchar(300) | No | ||||
| vAddress2 | varchar(300) | No | ||||
| vAddress3 | varchar(300) | No | ||||
| vCity | varchar(300) | No | ||||
| vRegion | varchar(300) | No | ||||
| vCountry | varchar(300) | No | ||||
| vPostalCode | varchar(300) | No | ||||
| fPhoto | varchar(300) | No | ||||
| vCustomerCode | varchar(300) | No | ||||
| iDeleteFlag | int(11) | No | ||||
| tSummary | text | No | ||||
| vCompanyName | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 0 | A | No |
tbl_users
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| vFirstName | varchar(300) | No | ||||
| vLastName | varchar(300) | No | ||||
| vEmail | varchar(300) | No | ||||
| vMobile | varchar(300) | No | ||||
| vDesignation | varchar(300) | No | ||||
| vUserName | varchar(300) | No | ||||
| vPassword | varchar(300) | No | ||||
| iUserType | int(11) | No | ||||
| fImage | varchar(300) | No | ||||
| dAddedDate | datetime | No | ||||
| iDeleteFlag | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 2 | A | No |
tbl_users_privilages
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iUserID | int(11) | No | ||||
| iPrivilageID | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| iAdd | int(11) | No | ||||
| iEdit | int(11) | No | ||||
| iDelete | int(11) | No | ||||
| iView | int(11) | No | ||||
| dAddedDate | datetime | No | ||||
| vCode | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 31 | A | No |
tbl_users_privilage_main_cat
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| vTitle | varchar(300) | No | ||||
| iPublish | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| vCode | varchar(300) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 9 | A | No |
tbl_users_token
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iUserID | int(11) | No | ||||
| vToken | varchar(300) | No | ||||
| dCreatedDate | datetime | No | ||||
| dExpireDate | datetime | No | ||||
| dDuration | double | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 8 | A | No |
tbl_user_logs
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| iID (Primary) | int(11) | No | ||||
| iUserID | int(11) | No | ||||
| vAccessURL | varchar(300) | No | ||||
| dDateTime | datetime | No | ||||
| vSection | varchar(300) | No | ||||
| vIP | varchar(300) | No | ||||
| vLocation | varchar(300) | No | ||||
| tDes | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | iID | 1 | A | No |