|
|
| Line 1: |
Line 1: |
| - | [[Category:DB]] | + | [[Category:XArc]] |
| - | | + | |
| - | <pre>
| + | |
| - | mysql> show tables;
| + | |
| - | +----------------------------------------+
| + | |
| - | | Tables_in_cybertrax |
| + | |
| - | +----------------------------------------+
| + | |
| - | | mymfavorites |
| + | |
| - | | tblAddressBillToParty |
| + | |
| - | | tblAddressCompanyCity |
| + | |
| - | | tblAddressJaguarVendor |
| + | |
| - | | tblAddressTransportation |
| + | |
| - | | tblAirShipment |
| + | |
| - | | tblAirline |
| + | |
| - | | tblAirport |
| + | |
| - | | tblAlwaysBCCEmails |
| + | |
| - | | tblAuthorizationMethod |
| + | |
| - | | tblAuthorizationMethodSettings |
| + | |
| - | | tblBusiestSeaPort |
| + | |
| - | | tblChargeBackInvoice |
| + | |
| - | | tblChargeCode |
| + | |
| - | | tblClient |
| + | |
| - | | tblClientCompany |
| + | |
| - | | tblClientCompanyGroup |
| + | |
| - | | tblClientCompanyGroupRelation |
| + | |
| - | | tblClientExchangeRate |
| + | |
| - | | tblClientMode |
| + | |
| - | | tblClientUser |
| + | |
| - | | tblClientUser2AddressTransportation |
| + | |
| - | | tblClientUser2Region |
| + | |
| - | | tblClientUserWatchList |
| + | |
| - | | tblClientsGroup |
| + | |
| - | | tblClientsGroupRelation |
| + | |
| - | | tblCommentsMailedTo |
| + | |
| - | | tblCommodity |
| + | |
| - | | tblCommodityDisplaySettings |
| + | |
| - | | tblCommodityItem |
| + | |
| - | | tblContainer |
| + | |
| - | | tblContainer2Master |
| + | |
| - | | tblContainer2Shipment |
| + | |
| - | | tblContainerSize |
| + | |
| - | | tblContainerType |
| + | |
| - | | tblCountry |
| + | |
| - | | tblCreditLimit |
| + | |
| - | | tblCreditStatus |
| + | |
| - | | tblCreditTerm |
| + | |
| - | | tblCurrency |
| + | |
| - | | tblCurrencyExchangeRate |
| + | |
| - | | tblCurrencyExchangeRateChange |
| + | |
| - | | tblCustomer |
| + | |
| - | | tblCustomsStatus |
| + | |
| - | | tblDailyQuotes |
| + | |
| - | | tblDeliveryDateTypes |
| + | |
| - | | tblDeliveryLocation |
| + | |
| - | | tblDropClientTops |
| + | |
| - | | tblDropCountryTops |
| + | |
| - | | tblEmailQueryHistory |
| + | |
| - | | tblEmailQueryHistoryCCAddresses |
| + | |
| - | | tblEstimatedTransitTime |
| + | |
| - | | tblExchangeRate |
| + | |
| - | | tblFDAStatus |
| + | |
| - | | tblGenericShipment |
| + | |
| - | | tblGenericUser |
| + | |
| - | | tblGroupObjectPermission |
| + | |
| - | | tblHandlingRemark |
| + | |
| - | | tblHandlingUnit |
| + | |
| - | | tblJaguarOpsGroup |
| + | |
| - | | tblJaguarOpsGroupClientRelation |
| + | |
| - | | tblJaguarOpsGroupCompanyRelation |
| + | |
| - | | tblJaguarUser |
| + | |
| - | | tblJaguarUserBCCList |
| + | |
| - | | tblJaguarUserGroup |
| + | |
| - | | tblJaguarUserType |
| + | |
| - | | tblLoose |
| + | |
| - | | tblMailTemplates |
| + | |
| - | | tblMaster |
| + | |
| - | | tblMasterComments |
| + | |
| - | | tblMasterCommentsMailedTo |
| + | |
| - | | tblMasterOcean |
| + | |
| - | | tblMasterPDFReports |
| + | |
| - | | tblMasterTransportMode |
| + | |
| - | | tblMoveType |
| + | |
| - | | tblOceanModeType |
| + | |
| - | | tblOceanShipment |
| + | |
| - | | tblOffice |
| + | |
| - | | tblOnPallets |
| + | |
| - | | tblPDFReports |
| + | |
| - | | tblPackagingCommodityType |
| + | |
| - | | tblPackagingPalletType |
| + | |
| - | | tblPackagingType |
| + | |
| - | | tblPurchaseInvoice |
| + | |
| - | | tblPurchaseInvoiceChargeCode |
| + | |
| - | | tblRSSNewsFeeds |
| + | |
| - | | tblRegion |
| + | |
| - | | tblReport |
| + | |
| - | | tblReportRecipient |
| + | |
| - | | tblSeaPort |
| + | |
| - | | tblSecuredUrl |
| + | |
| - | | tblShipline |
| + | |
| - | | tblShipment2ClientCompanyGroupRelation |
| + | |
| - | | tblShipment2ClientCompanyRelation |
| + | |
| - | | tblShipmentChargeCodes |
| + | |
| - | | tblShipmentComments |
| + | |
| - | | tblShipmentDateHistory |
| + | |
| - | | tblShipmentGroup |
| + | |
| - | | tblShipmentInvoice2ContainersRelation |
| + | |
| - | | tblShipmentInvoiceChargeCodes |
| + | |
| - | | tblShipmentInvoiceContainers |
| + | |
| - | | tblShipmentInvoices |
| + | |
| - | | tblShipmentLog |
| + | |
| - | | tblShipmentTemplate |
| + | |
| - | | tblShippingTerm |
| + | |
| - | | tblStandardComments |
| + | |
| - | | tblSteamshipline |
| + | |
| - | | tblTableOfCharges |
| + | |
| - | | tblTestimonials |
| + | |
| - | | tblTransportMode |
| + | |
| - | | tblTruckingShipment |
| + | |
| - | | tblUSAstate |
| + | |
| - | | tblUndefinedShipment |
| + | |
| - | | tblUnitType |
| + | |
| - | | tblUpdateLogRecord |
| + | |
| - | | tblUploadedFiles |
| + | |
| - | | tblUserGroup |
| + | |
| - | | tblUserGroupObject |
| + | |
| - | | tblUserRole |
| + | |
| - | | viewArchivedShipmentId |
| + | |
| - | | viewClientAirShipmentDetails |
| + | |
| - | | viewClientGenericShipment |
| + | |
| - | | viewClientGenericShipmentId |
| + | |
| - | | viewClientOceanShipmentDetails |
| + | |
| - | | viewClientShipmentCommodities |
| + | |
| - | | viewClientShipmentCommodityItems |
| + | |
| - | | viewClientShipmentContainers |
| + | |
| - | | viewClientTruckingShipmentDetails |
| + | |
| - | | viewClientUndefinedShipmentDetails |
| + | |
| - | | viewClientUserConsignees |
| + | |
| - | | viewClientUserDeliveryLocations |
| + | |
| - | | viewClientUserDestinationRegions |
| + | |
| - | | viewClientUserOriginRegions |
| + | |
| - | | viewClientUserPickUpLocations |
| + | |
| - | | viewClientUserShippers |
| + | |
| - | | viewClientUserShippingTerms |
| + | |
| - | | viewClientWatchList |
| + | |
| - | | viewGenericShipment |
| + | |
| - | | viewGenericShipment_new |
| + | |
| - | | viewPurchaseInvoice |
| + | |
| - | | viewPurchaseInvoiceChargeCode |
| + | |
| - | | viewPurchaseInvoiceExtended |
| + | |
| - | | viewPurchaseInvoiceStatus |
| + | |
| - | | viewPurchaseInvoiceWithStatus |
| + | |
| - | | viewPurchaseInvoiceWithStatusExtended |
| + | |
| - | | viewReport |
| + | |
| - | | viewShipment |
| + | |
| - | | viewShipmentContainersInfo |
| + | |
| - | | viewShipmentInvoice |
| + | |
| - | | viewShipmentTemplateInfo |
| + | |
| - | | viewTransportationCompanyCity |
| + | |
| - | | viewVendorCompanyCity |
| + | |
| - | | viewVisibilityClientCompany |
| + | |
| - | | viewVisibilityClientCompanyGroup |
| + | |
| - | | viewVisibilityClientCopmany |
| + | |
| - | +----------------------------------------+
| + | |
| - | 155 rows in set
| + | |
| - | </pre>
| + | |
