Generic tbl
From UG
(→ShipperAddressId) |
|||
(6 intermediate revisions not shown) | |||
Line 4: | Line 4: | ||
[[CT bo]] | [[CT bo]] | ||
- | == MySQL | + | == MySQL Table Definitions == |
+ | |||
+ | on 08-Apr-2010 | ||
<pre> | <pre> | ||
mysql> describe tblGenericShipment; | mysql> describe tblGenericShipment; | ||
+ | |||
+-------------------------------------+---------------+------+-----+---------+----------------+ | +-------------------------------------+---------------+------+-----+---------+----------------+ | ||
| Field | Type | Null | Key | Default | Extra | | | Field | Type | Null | Key | Default | Extra | | ||
Line 44: | Line 47: | ||
| Jaguar3rdRef | varchar(30) | YES | | NULL | | | | Jaguar3rdRef | varchar(30) | YES | | NULL | | | ||
| MasterId | int(10) | YES | MUL | NULL | | | | MasterId | int(10) | YES | MUL | NULL | | | ||
- | | IsDeleted | bit(1) | NO | | | + | | IsDeleted | bit(1) | NO | | b'0' | | |
| LastModifiedUserId | int(10) | YES | MUL | NULL | | | | LastModifiedUserId | int(10) | YES | MUL | NULL | | | ||
| CreatedOnDate | datetime | YES | | NULL | | | | CreatedOnDate | datetime | YES | | NULL | | | ||
Line 64: | Line 67: | ||
| TableOfChargesId | int(10) | YES | MUL | NULL | | | | TableOfChargesId | int(10) | YES | MUL | NULL | | | ||
| SalesPersonId | int(10) | YES | MUL | NULL | | | | SalesPersonId | int(10) | YES | MUL | NULL | | | ||
+ | | CreatedByOfficeId | int(10) | NO | MUL | 1 | | | ||
+-------------------------------------+---------------+------+-----+---------+----------------+ | +-------------------------------------+---------------+------+-----+---------+----------------+ | ||
- | + | 54 rows in set | |
- | + | ||
- | + | ||
- | + | ||
-- ---------------------------- | -- ---------------------------- | ||
- | |||
-- Table structure for tblGenericShipment | -- Table structure for tblGenericShipment | ||
- | |||
-- ---------------------------- | -- ---------------------------- | ||
DROP TABLE IF EXISTS `tblGenericShipment`; | DROP TABLE IF EXISTS `tblGenericShipment`; | ||
- | |||
CREATE TABLE `tblGenericShipment` ( | CREATE TABLE `tblGenericShipment` ( | ||
- | `Id` int(10) NOT NULL | + | `Id` int(10) NOT NULL AUTO_INCREMENT, |
`ClientCompanyId` int(10) NOT NULL, | `ClientCompanyId` int(10) NOT NULL, | ||
- | `ShipperAddressId` int(10) | + | `ShipperAddressId` int(10) DEFAULT NULL, |
- | `ShipperAddressDescription` varchar(1500) | + | `ShipperAddressDescription` varchar(1500) DEFAULT NULL, |
- | `ConsigneeAddressId` int(10) | + | `ConsigneeAddressId` int(10) DEFAULT NULL, |
- | `ConsigneeAddressDescription` varchar(1500) | + | `ConsigneeAddressDescription` varchar(1500) DEFAULT NULL, |
- | `NotifyAddressId` int(10) | + | `NotifyAddressId` int(10) DEFAULT NULL, |
- | `NotifyAddressDescription` varchar(1500) | + | `NotifyAddressDescription` varchar(1500) DEFAULT NULL, |
- | `PickupAddressId` int(10) | + | `PickupAddressId` int(10) DEFAULT NULL, |
- | `PickupAddressDescription` varchar(1500) | + | `PickupAddressDescription` varchar(1500) DEFAULT NULL, |
- | `GeneralDeliveryToAddressId` int(10) | + | `GeneralDeliveryToAddressId` int(10) DEFAULT NULL, |
- | `GeneralDeliveryToAddressDescription` varchar(1500) | + | `GeneralDeliveryToAddressDescription` varchar(1500) DEFAULT NULL, |
- | `PickupComments` varchar(1500) | + | `PickupComments` varchar(1500) DEFAULT NULL, |
- | `PickupTruckerId` int(10) | + | `PickupTruckerId` int(10) DEFAULT NULL, |
- | `EstimatedPickupDate` date | + | `EstimatedPickupDate` date DEFAULT NULL, |
- | `ActualPickupDate` date | + | `ActualPickupDate` date DEFAULT NULL, |
- | `OriginPoint` varchar(30) | + | `OriginPoint` varchar(30) DEFAULT NULL, |
- | `DestinationPoint` varchar(30) | + | `DestinationPoint` varchar(30) DEFAULT NULL, |
- | `TransportModeId` int(10) | + | `TransportModeId` int(10) DEFAULT NULL, |
- | `ClientModeId` int(10) | + | `ClientModeId` int(10) DEFAULT NULL, |
- | `ShippingTermId` int(10) | + | `ShippingTermId` int(10) DEFAULT NULL, |
- | `ShippingTermLocation` varchar(30) | + | `ShippingTermLocation` varchar(30) DEFAULT NULL, |
- | `CommodityDescription` varchar(1500) | + | `CommodityDescription` varchar(1500) DEFAULT NULL, |
- | `MarksOrNumber` varchar(1500) | + | `MarksOrNumber` varchar(1500) DEFAULT NULL, |
- | `AuthorizedBy` varchar(30) | + | `AuthorizedBy` varchar(30) DEFAULT NULL, |
- | `AuthorizedDate` date | + | `AuthorizedDate` date DEFAULT NULL, |
- | `EstimatedDeliveryDate` date | + | `EstimatedDeliveryDate` date DEFAULT NULL, |
- | `AuthorizationMethodId` int(10) | + | `AuthorizationMethodId` int(10) DEFAULT NULL, |
- | `ExportRef` varchar(30) | + | `ExportRef` varchar(30) DEFAULT NULL, |
- | `ImportRef` varchar(30) | + | `ImportRef` varchar(30) DEFAULT NULL, |
- | `CustomerRef` varchar(30) | + | `CustomerRef` varchar(30) DEFAULT NULL, |
- | `Jaguar3rdRef` varchar(30) | + | `Jaguar3rdRef` varchar(30) DEFAULT NULL, |
- | `MasterId` int(10) | + | `MasterId` int(10) DEFAULT NULL, |
- | `IsDeleted` bit(1) NOT NULL | + | `IsDeleted` bit(1) NOT NULL DEFAULT b'0', |
- | `LastModifiedUserId` int(10) | + | `LastModifiedUserId` int(10) DEFAULT NULL, |
- | `CreatedOnDate` datetime | + | `CreatedOnDate` datetime DEFAULT NULL, |
- | `IsDimsMode` tinyint(1) NOT NULL | + | `IsDimsMode` tinyint(1) NOT NULL DEFAULT '0', |
- | `TotalHUInCubicMeters` double | + | `TotalHUInCubicMeters` double DEFAULT '0', |
- | `TotalHUInCubicFeets` double | + | `TotalHUInCubicFeets` double DEFAULT '0', |
- | `OriginPointCountryId` int(10) | + | `OriginPointCountryId` int(10) DEFAULT NULL, |
- | `DestinationPointCountryId` int(10) | + | `DestinationPointCountryId` int(10) DEFAULT NULL, |
- | `ShipmentGroupId` int(10) | + | `ShipmentGroupId` int(10) DEFAULT NULL, |
- | `NotificationDate` date | + | `NotificationDate` date DEFAULT NULL, |
- | `EnabledTransShipment` tinyint(1) | + | `EnabledTransShipment` tinyint(1) DEFAULT '0', |
- | `EnabledOriginTerminal` tinyint(1) | + | `EnabledOriginTerminal` tinyint(1) DEFAULT '0', |
- | `EnabledDestinationTerminal` tinyint(1) | + | `EnabledDestinationTerminal` tinyint(1) DEFAULT '0', |
- | `ShowPickupAddress` tinyint(1) | + | `ShowPickupAddress` tinyint(1) DEFAULT '0', |
- | `ShowDeliveryToAddress` tinyint(1) | + | `ShowDeliveryToAddress` tinyint(1) DEFAULT '0', |
- | `ShowOriginPointCountry` tinyint(1) | + | `ShowOriginPointCountry` tinyint(1) DEFAULT '0', |
- | `ShowDestinationPointCountry` tinyint(1) | + | `ShowDestinationPointCountry` tinyint(1) DEFAULT '0', |
- | `AuthorizedMOT` int(10) | + | `AuthorizedMOT` int(10) DEFAULT NULL, |
- | `TableOfChargesId` int(10) | + | `TableOfChargesId` int(10) DEFAULT NULL, |
- | `SalesPersonId` int(10) | + | `SalesPersonId` int(10) DEFAULT NULL, |
- | PRIMARY KEY | + | `CreatedByOfficeId` int(10) NOT NULL DEFAULT '1', |
+ | PRIMARY KEY (`Id`), | ||
KEY `GenericShipment_ClientCompanyId` (`ClientCompanyId`), | KEY `GenericShipment_ClientCompanyId` (`ClientCompanyId`), | ||
KEY `GenericShipment_ShipperAddressId` (`ShipperAddressId`), | KEY `GenericShipment_ShipperAddressId` (`ShipperAddressId`), | ||
Line 149: | Line 148: | ||
KEY `SalesPersonId` (`SalesPersonId`), | KEY `SalesPersonId` (`SalesPersonId`), | ||
KEY `TableOfChargesId` (`TableOfChargesId`), | KEY `TableOfChargesId` (`TableOfChargesId`), | ||
- | CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES ` | + | KEY `CreatedByOfficeId` (`CreatedByOfficeId`), |
- | CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES ` | + | CONSTRAINT `fkCreatedByOfficeId` FOREIGN KEY (`CreatedByOfficeId`) REFERENCES `tbloffice` (`Id`) ON UPDATE CASCADE, |
- | CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES `tbltableofcharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE, |
- | CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES `tblshipmentgroup` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE, |
- | CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblauthorizationmethod` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tbljaguaruser` (`Id`) ON UPDATE CASCADE, |
- | CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES `tbladdresstransportation` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblmasterocean` (`Id`) ON DELETE SET NULL, |
- | CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tbljaguaruser` (`Id`) ON DELETE SET NULL, |
- | CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblclientmode` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblclientcompany` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tbladdresstransportation` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tbladdresstransportation` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_8` FOREIGN KEY (`TransportModeId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tbladdresstransportation` (`Id`), |
- | CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES ` | + | CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tbladdresstransportation` (`Id`), |
- | ) ENGINE=InnoDB AUTO_INCREMENT= | + | CONSTRAINT `tblGenericShipment_ibfk_8` FOREIGN KEY (`TransportModeId`) REFERENCES `tbltransportmode` (`Id`), |
- | + | CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblshippingterm` (`Id`) | |
- | + | )ENGINE=InnoDB | |
- | + | AUTO_INCREMENT=300054 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci' | |
- | + | COMMENT='InnoDB free: 9216 kB; (`ShipmentGroupId`) REFER `cybertrax/t'; | |
- | + | ||
</pre> | </pre> | ||
- | == | + | == Fields == |
- | + | ||
- | + | ||
- | + | ||
- | + | === Id === | |
+ | ` int(10) NOT NULL AUTO_INCREMENT | ||
=== ClientCompanyId === | === ClientCompanyId === | ||
+ | ` int(10) NOT NULL | ||
- | + | === ShipperAddressId === | |
- | + | ` int(10) DEFAULT NULL | |
- | === ShipperAddressId | + | |
- | + | ||
- | + | ||
- | === ShipperAddressDescription | + | === ShipperAddressDescription === |
+ | ` varchar(1500) DEFAULT NULL | ||
- | + | === ConsigneeAddressId === | |
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === ConsigneeAddressDescription === |
+ | ` varchar(1500) DEFAULT NULL | ||
- | + | === NotifyAddressId === | |
- | + | ` int(10) DEFAULT NULL | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | === NotifyAddressId | + | |
- | + | ||
- | + | ||
=== NotifyAddressDescription === | === NotifyAddressDescription === | ||
+ | ` varchar(1500) DEFAULT NULL | ||
- | + | === PickupAddressId === | |
- | + | ` int(10) DEFAULT NULL | |
- | === PickupAddressId | + | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | === | + | === PickupAddressDescription === |
+ | ` varchar(1500) DEFAULT NULL | ||
- | + | === GeneralDeliveryToAddressId === | |
+ | ` int(10) DEFAULT NULL | ||
=== GeneralDeliveryToAddressDescription === | === GeneralDeliveryToAddressDescription === | ||
+ | ` varchar(1500) DEFAULT NULL | ||
- | + | === PickupComments === | |
+ | ` varchar(1500) DEFAULT NULL | ||
- | === | + | === PickupTruckerId === |
+ | ` int(10) DEFAULT NULL | ||
- | + | === EstimatedPickupDate === | |
+ | ` date DEFAULT NULL | ||
- | === | + | === ActualPickupDate === |
+ | ` date DEFAULT NULL | ||
- | + | === OriginPoint === | |
+ | ` varchar(30) DEFAULT NULL | ||
- | === | + | === DestinationPoint === |
+ | ` varchar(30) DEFAULT NULL | ||
- | + | === TransportModeId === | |
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === ClientModeId === |
+ | ` int(10) DEFAULT NULL | ||
- | + | === ShippingTermId === | |
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === ShippingTermLocation === |
+ | ` varchar(30) DEFAULT NULL | ||
- | + | === CommodityDescription === | |
+ | ` varchar(1500) DEFAULT NULL | ||
- | === | + | === MarksOrNumber === |
+ | ` varchar(1500) DEFAULT NULL | ||
- | + | === AuthorizedBy === | |
+ | ` varchar(30) DEFAULT NULL | ||
- | === | + | === AuthorizedDate === |
+ | ` date DEFAULT NULL | ||
- | + | === EstimatedDeliveryDate === | |
+ | ` date DEFAULT NULL | ||
- | + | === AuthorizationMethodId === | |
- | + | ` int(10) DEFAULT NULL | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | === AuthorizationMethodId | + | |
- | + | ||
- | + | ||
=== ExportRef === | === ExportRef === | ||
- | + | ` varchar(30) default NULL, | |
- | + | ||
- | === ImportRef | + | === ImportRef === |
+ | ` varchar(30) default NULL, | ||
- | + | === CustomerRef === | |
+ | ` varchar(30) default NULL, | ||
- | === | + | === Jaguar3rdRef === |
+ | ` varchar(30) default NULL, | ||
- | + | === MasterId === | |
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === IsDeleted === |
+ | ` bit(1) NOT NULL DEFAULT b'0' | ||
- | + | === LastModifiedUserId === | |
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === CreatedOnDate === |
+ | ` datetime DEFAULT NULL | ||
- | + | === IsDimsMode === | |
+ | ` tinyint(1) NOT NULL DEFAULT '0' | ||
- | === | + | === TotalHUInCubicMeters === |
+ | ` double DEFAULT '0' | ||
- | + | === TotalHUInCubicFeets === | |
+ | ` double DEFAULT '0' | ||
- | === | + | === OriginPointCountryId === |
+ | ` int(10) DEFAULT NULL | ||
- | + | === DestinationPointCountryId === | |
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === ShipmentGroupId === |
+ | ` int(10) DEFAULT NULL | ||
- | + | === NotificationDate === | |
+ | ` date DEFAULT NULL | ||
- | === | + | === EnabledTransShipment === |
+ | ` tinyint(1) DEFAULT '0' | ||
- | + | === EnabledOriginTerminal === | |
+ | ` tinyint(1) DEFAULT '0' | ||
- | === | + | === EnabledDestinationTerminal === |
+ | ` tinyint(1) DEFAULT '0' | ||
- | + | === ShowPickupAddress === | |
+ | ` tinyint(1) DEFAULT '0' | ||
- | === | + | === ShowDeliveryToAddress === |
+ | ` tinyint(1) DEFAULT '0' | ||
- | + | === ShowOriginPointCountry === | |
+ | ` tinyint(1) DEFAULT '0' | ||
- | === | + | === ShowDestinationPointCountry === |
+ | ` tinyint(1) DEFAULT '0' | ||
- | + | === AuthorizedMOT === | |
+ | ` int(10) DEFAULT NULL | ||
+ | === TableOfChargesId === | ||
+ | ` int(10) DEFAULT NULL | ||
- | === | + | === SalesPersonId === |
+ | ` int(10) DEFAULT NULL | ||
- | + | === CreatedByOfficeId === | |
- | + | ` int(10) NOT NULL DEFAULT '1' | |
- | === | + | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + |
Current revision as of 21:42, 21 May 2010
[edit] Related bo wiki
[edit] MySQL Table Definitions
on 08-Apr-2010
mysql> describe tblGenericShipment; +-------------------------------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------------------------+---------------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | ClientCompanyId | int(10) | NO | MUL | NULL | | | ShipperAddressId | int(10) | YES | MUL | NULL | | | ShipperAddressDescription | varchar(1500) | YES | | NULL | | | ConsigneeAddressId | int(10) | YES | MUL | NULL | | | ConsigneeAddressDescription | varchar(1500) | YES | | NULL | | | NotifyAddressId | int(10) | YES | MUL | NULL | | | NotifyAddressDescription | varchar(1500) | YES | | NULL | | | PickupAddressId | int(10) | YES | MUL | NULL | | | PickupAddressDescription | varchar(1500) | YES | | NULL | | | GeneralDeliveryToAddressId | int(10) | YES | MUL | NULL | | | GeneralDeliveryToAddressDescription | varchar(1500) | YES | | NULL | | | PickupComments | varchar(1500) | YES | | NULL | | | PickupTruckerId | int(10) | YES | MUL | NULL | | | EstimatedPickupDate | date | YES | | NULL | | | ActualPickupDate | date | YES | | NULL | | | OriginPoint | varchar(30) | YES | | NULL | | | DestinationPoint | varchar(30) | YES | | NULL | | | TransportModeId | int(10) | YES | MUL | NULL | | | ClientModeId | int(10) | YES | MUL | NULL | | | ShippingTermId | int(10) | YES | MUL | NULL | | | ShippingTermLocation | varchar(30) | YES | | NULL | | | CommodityDescription | varchar(1500) | YES | | NULL | | | MarksOrNumber | varchar(1500) | YES | | NULL | | | AuthorizedBy | varchar(30) | YES | | NULL | | | AuthorizedDate | date | YES | | NULL | | | EstimatedDeliveryDate | date | YES | | NULL | | | AuthorizationMethodId | int(10) | YES | MUL | NULL | | | ExportRef | varchar(30) | YES | | NULL | | | ImportRef | varchar(30) | YES | | NULL | | | CustomerRef | varchar(30) | YES | | NULL | | | Jaguar3rdRef | varchar(30) | YES | | NULL | | | MasterId | int(10) | YES | MUL | NULL | | | IsDeleted | bit(1) | NO | | b'0' | | | LastModifiedUserId | int(10) | YES | MUL | NULL | | | CreatedOnDate | datetime | YES | | NULL | | | IsDimsMode | tinyint(1) | NO | | 0 | | | TotalHUInCubicMeters | double | YES | | 0 | | | TotalHUInCubicFeets | double | YES | | 0 | | | OriginPointCountryId | int(10) | YES | | NULL | | | DestinationPointCountryId | int(10) | YES | | NULL | | | ShipmentGroupId | int(10) | YES | MUL | NULL | | | NotificationDate | date | YES | | NULL | | | EnabledTransShipment | tinyint(1) | YES | | 0 | | | EnabledOriginTerminal | tinyint(1) | YES | | 0 | | | EnabledDestinationTerminal | tinyint(1) | YES | | 0 | | | ShowPickupAddress | tinyint(1) | YES | | 0 | | | ShowDeliveryToAddress | tinyint(1) | YES | | 0 | | | ShowOriginPointCountry | tinyint(1) | YES | | 0 | | | ShowDestinationPointCountry | tinyint(1) | YES | | 0 | | | AuthorizedMOT | int(10) | YES | | NULL | | | TableOfChargesId | int(10) | YES | MUL | NULL | | | SalesPersonId | int(10) | YES | MUL | NULL | | | CreatedByOfficeId | int(10) | NO | MUL | 1 | | +-------------------------------------+---------------+------+-----+---------+----------------+ 54 rows in set -- ---------------------------- -- Table structure for tblGenericShipment -- ---------------------------- DROP TABLE IF EXISTS `tblGenericShipment`; CREATE TABLE `tblGenericShipment` ( `Id` int(10) NOT NULL AUTO_INCREMENT, `ClientCompanyId` int(10) NOT NULL, `ShipperAddressId` int(10) DEFAULT NULL, `ShipperAddressDescription` varchar(1500) DEFAULT NULL, `ConsigneeAddressId` int(10) DEFAULT NULL, `ConsigneeAddressDescription` varchar(1500) DEFAULT NULL, `NotifyAddressId` int(10) DEFAULT NULL, `NotifyAddressDescription` varchar(1500) DEFAULT NULL, `PickupAddressId` int(10) DEFAULT NULL, `PickupAddressDescription` varchar(1500) DEFAULT NULL, `GeneralDeliveryToAddressId` int(10) DEFAULT NULL, `GeneralDeliveryToAddressDescription` varchar(1500) DEFAULT NULL, `PickupComments` varchar(1500) DEFAULT NULL, `PickupTruckerId` int(10) DEFAULT NULL, `EstimatedPickupDate` date DEFAULT NULL, `ActualPickupDate` date DEFAULT NULL, `OriginPoint` varchar(30) DEFAULT NULL, `DestinationPoint` varchar(30) DEFAULT NULL, `TransportModeId` int(10) DEFAULT NULL, `ClientModeId` int(10) DEFAULT NULL, `ShippingTermId` int(10) DEFAULT NULL, `ShippingTermLocation` varchar(30) DEFAULT NULL, `CommodityDescription` varchar(1500) DEFAULT NULL, `MarksOrNumber` varchar(1500) DEFAULT NULL, `AuthorizedBy` varchar(30) DEFAULT NULL, `AuthorizedDate` date DEFAULT NULL, `EstimatedDeliveryDate` date DEFAULT NULL, `AuthorizationMethodId` int(10) DEFAULT NULL, `ExportRef` varchar(30) DEFAULT NULL, `ImportRef` varchar(30) DEFAULT NULL, `CustomerRef` varchar(30) DEFAULT NULL, `Jaguar3rdRef` varchar(30) DEFAULT NULL, `MasterId` int(10) DEFAULT NULL, `IsDeleted` bit(1) NOT NULL DEFAULT b'0', `LastModifiedUserId` int(10) DEFAULT NULL, `CreatedOnDate` datetime DEFAULT NULL, `IsDimsMode` tinyint(1) NOT NULL DEFAULT '0', `TotalHUInCubicMeters` double DEFAULT '0', `TotalHUInCubicFeets` double DEFAULT '0', `OriginPointCountryId` int(10) DEFAULT NULL, `DestinationPointCountryId` int(10) DEFAULT NULL, `ShipmentGroupId` int(10) DEFAULT NULL, `NotificationDate` date DEFAULT NULL, `EnabledTransShipment` tinyint(1) DEFAULT '0', `EnabledOriginTerminal` tinyint(1) DEFAULT '0', `EnabledDestinationTerminal` tinyint(1) DEFAULT '0', `ShowPickupAddress` tinyint(1) DEFAULT '0', `ShowDeliveryToAddress` tinyint(1) DEFAULT '0', `ShowOriginPointCountry` tinyint(1) DEFAULT '0', `ShowDestinationPointCountry` tinyint(1) DEFAULT '0', `AuthorizedMOT` int(10) DEFAULT NULL, `TableOfChargesId` int(10) DEFAULT NULL, `SalesPersonId` int(10) DEFAULT NULL, `CreatedByOfficeId` int(10) NOT NULL DEFAULT '1', PRIMARY KEY (`Id`), KEY `GenericShipment_ClientCompanyId` (`ClientCompanyId`), KEY `GenericShipment_ShipperAddressId` (`ShipperAddressId`), KEY `GenericShipment_ConsigneeAddressId` (`ConsigneeAddressId`), KEY `GenericShipment_NotifyAddressId` (`NotifyAddressId`), KEY `GenericShipment_PickupAddressId` (`PickupAddressId`), KEY `GenericShipment_GeneralDeliveryToAddressId` (`GeneralDeliveryToAddressId`), KEY `GenericShipment_PickupTruckerId` (`PickupTruckerId`), KEY `GenericShipment_TransportModeId` (`TransportModeId`), KEY `GenericShipment_ShippingTermId` (`ShippingTermId`), KEY `GenericShipment_AuthorizationMethodId` (`AuthorizationMethodId`), KEY `GenericShipment_MasterId` (`MasterId`), KEY `GenericShipment_LastModifiedUserId` (`LastModifiedUserId`), KEY `tblGenericShipment_ibfk_27` (`ClientModeId`), KEY `ShipmentGroupId` (`ShipmentGroupId`), KEY `SalesPersonId` (`SalesPersonId`), KEY `TableOfChargesId` (`TableOfChargesId`), KEY `CreatedByOfficeId` (`CreatedByOfficeId`), CONSTRAINT `fkCreatedByOfficeId` FOREIGN KEY (`CreatedByOfficeId`) REFERENCES `tbloffice` (`Id`) ON UPDATE CASCADE, CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES `tbltableofcharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES `tblshipmentgroup` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblauthorizationmethod` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tbljaguaruser` (`Id`) ON UPDATE CASCADE, CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblmasterocean` (`Id`) ON DELETE SET NULL, CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tbljaguaruser` (`Id`) ON DELETE SET NULL, CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblclientmode` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblclientcompany` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_8` FOREIGN KEY (`TransportModeId`) REFERENCES `tbltransportmode` (`Id`), CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblshippingterm` (`Id`) )ENGINE=InnoDB AUTO_INCREMENT=300054 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci' COMMENT='InnoDB free: 9216 kB; (`ShipmentGroupId`) REFER `cybertrax/t';
[edit] Fields
[edit] Id
` int(10) NOT NULL AUTO_INCREMENT
[edit] ClientCompanyId
` int(10) NOT NULL
[edit] ShipperAddressId
` int(10) DEFAULT NULL
[edit] ShipperAddressDescription
` varchar(1500) DEFAULT NULL
[edit] ConsigneeAddressId
` int(10) DEFAULT NULL
[edit] ConsigneeAddressDescription
` varchar(1500) DEFAULT NULL
[edit] NotifyAddressId
` int(10) DEFAULT NULL
[edit] NotifyAddressDescription
` varchar(1500) DEFAULT NULL
[edit] PickupAddressId
` int(10) DEFAULT NULL
[edit] PickupAddressDescription
` varchar(1500) DEFAULT NULL
[edit] GeneralDeliveryToAddressId
` int(10) DEFAULT NULL
[edit] GeneralDeliveryToAddressDescription
` varchar(1500) DEFAULT NULL
[edit] PickupComments
` varchar(1500) DEFAULT NULL
[edit] PickupTruckerId
` int(10) DEFAULT NULL
[edit] EstimatedPickupDate
` date DEFAULT NULL
[edit] ActualPickupDate
` date DEFAULT NULL
[edit] OriginPoint
` varchar(30) DEFAULT NULL
[edit] DestinationPoint
` varchar(30) DEFAULT NULL
[edit] TransportModeId
` int(10) DEFAULT NULL
[edit] ClientModeId
` int(10) DEFAULT NULL
[edit] ShippingTermId
` int(10) DEFAULT NULL
[edit] ShippingTermLocation
` varchar(30) DEFAULT NULL
[edit] CommodityDescription
` varchar(1500) DEFAULT NULL
[edit] MarksOrNumber
` varchar(1500) DEFAULT NULL
[edit] AuthorizedBy
` varchar(30) DEFAULT NULL
[edit] AuthorizedDate
` date DEFAULT NULL
[edit] EstimatedDeliveryDate
` date DEFAULT NULL
[edit] AuthorizationMethodId
` int(10) DEFAULT NULL
[edit] ExportRef
` varchar(30) default NULL,
[edit] ImportRef
` varchar(30) default NULL,
[edit] CustomerRef
` varchar(30) default NULL,
[edit] Jaguar3rdRef
` varchar(30) default NULL,
[edit] MasterId
` int(10) DEFAULT NULL
[edit] IsDeleted
` bit(1) NOT NULL DEFAULT b'0'
[edit] LastModifiedUserId
` int(10) DEFAULT NULL
[edit] CreatedOnDate
` datetime DEFAULT NULL
[edit] IsDimsMode
` tinyint(1) NOT NULL DEFAULT '0'
[edit] TotalHUInCubicMeters
` double DEFAULT '0'
[edit] TotalHUInCubicFeets
` double DEFAULT '0'
[edit] OriginPointCountryId
` int(10) DEFAULT NULL
[edit] DestinationPointCountryId
` int(10) DEFAULT NULL
[edit] ShipmentGroupId
` int(10) DEFAULT NULL
[edit] NotificationDate
` date DEFAULT NULL
[edit] EnabledTransShipment
` tinyint(1) DEFAULT '0'
[edit] EnabledOriginTerminal
` tinyint(1) DEFAULT '0'
[edit] EnabledDestinationTerminal
` tinyint(1) DEFAULT '0'
[edit] ShowPickupAddress
` tinyint(1) DEFAULT '0'
[edit] ShowDeliveryToAddress
` tinyint(1) DEFAULT '0'
[edit] ShowOriginPointCountry
` tinyint(1) DEFAULT '0'
[edit] ShowDestinationPointCountry
` tinyint(1) DEFAULT '0'
[edit] AuthorizedMOT
` int(10) DEFAULT NULL
[edit] TableOfChargesId
` int(10) DEFAULT NULL
[edit] SalesPersonId
` int(10) DEFAULT NULL
[edit] CreatedByOfficeId
` int(10) NOT NULL DEFAULT '1'