Generic tbl
From UG
(→ExportRef) |
|||
Line 61: | Line 61: | ||
+-------------------------------------+---------------+------+-----+---------+----------------+ | +-------------------------------------+---------------+------+-----+---------+----------------+ | ||
53 rows in set | 53 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 '\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, | ||
+ | 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`), | ||
+ | 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=251003 DEFAULT CHARSET=latin1; | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
</pre> | </pre> | ||
Revision as of 21:29, 26 January 2010
Contents |
My sql table
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 | | | 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 | | +-------------------------------------+---------------+------+-----+---------+----------------+ 53 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 '\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, 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`), 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=251003 DEFAULT CHARSET=latin1;
links to fields
+-------------------------------------+---------------+------+-----+---------+----------------+ | 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
- Ct#Export ref
- 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 | |
| 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 | |
+-------------------------------------+---------------+------+-----+---------+----------------+