Generic tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(ShipperAddressId)
(ShipperAddressId)
 
(One intermediate revision not shown)
Line 4: Line 4:
[[CT bo]]
[[CT bo]]
-
== MySQL table ==
+
== 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      |                |
+-------------------------------------+---------------+------+-----+---------+----------------+
+-------------------------------------+---------------+------+-----+---------+----------------+
-
53 rows in set
+
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 auto_increment,
+
   `Id` int(10) NOT NULL AUTO_INCREMENT,
   `ClientCompanyId` int(10) NOT NULL,
   `ClientCompanyId` int(10) NOT NULL,
-
   `ShipperAddressId` int(10) default NULL,
+
   `ShipperAddressId` int(10) DEFAULT NULL,
-
   `ShipperAddressDescription` varchar(1500) default NULL,
+
   `ShipperAddressDescription` varchar(1500) DEFAULT NULL,
-
   `ConsigneeAddressId` int(10) default NULL,
+
   `ConsigneeAddressId` int(10) DEFAULT NULL,
-
   `ConsigneeAddressDescription` varchar(1500) default NULL,
+
   `ConsigneeAddressDescription` varchar(1500) DEFAULT NULL,
-
   `NotifyAddressId` int(10) default NULL,
+
   `NotifyAddressId` int(10) DEFAULT NULL,
-
   `NotifyAddressDescription` varchar(1500) default NULL,
+
   `NotifyAddressDescription` varchar(1500) DEFAULT NULL,
-
   `PickupAddressId` int(10) default NULL,
+
   `PickupAddressId` int(10) DEFAULT NULL,
-
   `PickupAddressDescription` varchar(1500) default NULL,
+
   `PickupAddressDescription` varchar(1500) DEFAULT NULL,
-
   `GeneralDeliveryToAddressId` int(10) default NULL,
+
   `GeneralDeliveryToAddressId` int(10) DEFAULT NULL,
-
   `GeneralDeliveryToAddressDescription` varchar(1500) default NULL,
+
   `GeneralDeliveryToAddressDescription` varchar(1500) DEFAULT NULL,
-
   `PickupComments` varchar(1500) default NULL,
+
   `PickupComments` varchar(1500) DEFAULT NULL,
-
   `PickupTruckerId` int(10) default NULL,
+
   `PickupTruckerId` int(10) DEFAULT NULL,
-
   `EstimatedPickupDate` date default NULL,
+
   `EstimatedPickupDate` date DEFAULT NULL,
-
   `ActualPickupDate` date default NULL,
+
   `ActualPickupDate` date DEFAULT NULL,
-
   `OriginPoint` varchar(30) default NULL,
+
   `OriginPoint` varchar(30) DEFAULT NULL,
-
   `DestinationPoint` varchar(30) default NULL,
+
   `DestinationPoint` varchar(30) DEFAULT NULL,
-
   `TransportModeId` int(10) default NULL,
+
   `TransportModeId` int(10) DEFAULT NULL,
-
   `ClientModeId` int(10) default NULL,
+
   `ClientModeId` int(10) DEFAULT NULL,
-
   `ShippingTermId` int(10) default NULL,
+
   `ShippingTermId` int(10) DEFAULT NULL,
-
   `ShippingTermLocation` varchar(30) default NULL,
+
   `ShippingTermLocation` varchar(30) DEFAULT NULL,
-
   `CommodityDescription` varchar(1500) default NULL,
+
   `CommodityDescription` varchar(1500) DEFAULT NULL,
-
   `MarksOrNumber` varchar(1500) default NULL,
+
   `MarksOrNumber` varchar(1500) DEFAULT NULL,
-
   `AuthorizedBy` varchar(30) default NULL,
+
   `AuthorizedBy` varchar(30) DEFAULT NULL,
-
   `AuthorizedDate` date default NULL,
+
   `AuthorizedDate` date DEFAULT NULL,
-
   `EstimatedDeliveryDate` date default NULL,
+
   `EstimatedDeliveryDate` date DEFAULT NULL,
-
   `AuthorizationMethodId` int(10) default NULL,
+
   `AuthorizationMethodId` int(10) DEFAULT NULL,
-
   `ExportRef` varchar(30) default NULL,
+
   `ExportRef` varchar(30) DEFAULT NULL,
-
   `ImportRef` varchar(30) default NULL,
+
   `ImportRef` varchar(30) DEFAULT NULL,
-
   `CustomerRef` varchar(30) default NULL,
+
   `CustomerRef` varchar(30) DEFAULT NULL,
-
   `Jaguar3rdRef` varchar(30) default NULL,
+
   `Jaguar3rdRef` varchar(30) DEFAULT NULL,
-
   `MasterId` int(10) default NULL,
+
   `MasterId` int(10) DEFAULT NULL,
-
   `IsDeleted` bit(1) NOT NULL default '\0',
+
   `IsDeleted` bit(1) NOT NULL DEFAULT b'0',
-
   `LastModifiedUserId` int(10) default NULL,
+
   `LastModifiedUserId` int(10) DEFAULT NULL,
-
   `CreatedOnDate` datetime default NULL,
+
   `CreatedOnDate` datetime DEFAULT NULL,
-
   `IsDimsMode` tinyint(1) NOT NULL default '0',
+
   `IsDimsMode` tinyint(1) NOT NULL DEFAULT '0',
-
   `TotalHUInCubicMeters` double default '0',
+
   `TotalHUInCubicMeters` double DEFAULT '0',
-
   `TotalHUInCubicFeets` double default '0',
+
   `TotalHUInCubicFeets` double DEFAULT '0',
-
   `OriginPointCountryId` int(10) default NULL,
+
   `OriginPointCountryId` int(10) DEFAULT NULL,
-
   `DestinationPointCountryId` int(10) default NULL,
+
   `DestinationPointCountryId` int(10) DEFAULT NULL,
-
   `ShipmentGroupId` int(10) default NULL,
+
   `ShipmentGroupId` int(10) DEFAULT NULL,
-
   `NotificationDate` date default NULL,
+
   `NotificationDate` date DEFAULT NULL,
-
   `EnabledTransShipment` tinyint(1) default '0',
+
   `EnabledTransShipment` tinyint(1) DEFAULT '0',
-
   `EnabledOriginTerminal` tinyint(1) default '0',
+
   `EnabledOriginTerminal` tinyint(1) DEFAULT '0',
-
   `EnabledDestinationTerminal` tinyint(1) default '0',
+
   `EnabledDestinationTerminal` tinyint(1) DEFAULT '0',
-
   `ShowPickupAddress` tinyint(1) default '0',
+
   `ShowPickupAddress` tinyint(1) DEFAULT '0',
-
   `ShowDeliveryToAddress` tinyint(1) default '0',
+
   `ShowDeliveryToAddress` tinyint(1) DEFAULT '0',
-
   `ShowOriginPointCountry` tinyint(1) default '0',
+
   `ShowOriginPointCountry` tinyint(1) DEFAULT '0',
-
   `ShowDestinationPointCountry` tinyint(1) default '0',
+
   `ShowDestinationPointCountry` tinyint(1) DEFAULT '0',
-
   `AuthorizedMOT` int(10) default NULL,
+
   `AuthorizedMOT` int(10) DEFAULT NULL,
-
   `TableOfChargesId` int(10) default NULL,
+
   `TableOfChargesId` int(10) DEFAULT NULL,
-
   `SalesPersonId` int(10) default NULL,
+
   `SalesPersonId` int(10) DEFAULT NULL,
-
   PRIMARY KEY (`Id`),
+
  `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 `tblTableOfCharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
+
  KEY `CreatedByOfficeId` (`CreatedByOfficeId`),
-
   CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES `tblShipmentGroup` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
+
  CONSTRAINT `fkCreatedByOfficeId` FOREIGN KEY (`CreatedByOfficeId`) REFERENCES `tbloffice` (`Id`) ON UPDATE CASCADE,
-
   CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblAuthorizationMethod` (`Id`),
+
   CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES `tbltableofcharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
-
   CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tblJaguarUser` (`Id`) ON UPDATE CASCADE,
+
   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 `tblAddressTransportation` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblauthorizationmethod` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblMasterOcean` (`Id`) ON DELETE SET NULL,
+
   CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tbljaguaruser` (`Id`) ON UPDATE CASCADE,
-
   CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tblJaguarUser` (`Id`) ON DELETE SET NULL,
+
   CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblClientMode` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblmasterocean` (`Id`) ON DELETE SET NULL,
-
   CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tblAddressJaguarVendor` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tbljaguaruser` (`Id`) ON DELETE SET NULL,
-
   CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblClientCompany` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblclientmode` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblclientcompany` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_8` FOREIGN KEY (`TransportModeId`) REFERENCES `tblTransportMode` (`Id`),
+
   CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-
   CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblShippingTerm` (`Id`)
+
   CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-
) ENGINE=InnoDB AUTO_INCREMENT=251003 DEFAULT CHARSET=latin1;
+
   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>
Line 172: Line 174:
==  Fields ==
==  Fields ==
-
===Id===
+
=== Id ===
-
` int(10) NOT NULL auto_increment
+
` int(10) NOT NULL AUTO_INCREMENT
-
===ClientCompanyId===
+
=== ClientCompanyId ===
` int(10) NOT NULL  
` int(10) NOT NULL  
-
===ShipperAddressId===
+
=== ShipperAddressId ===
-
` int(10) default NULL  
+
` int(10) DEFAULT NULL
 +
=== ShipperAddressDescription ===
 +
` varchar(1500) DEFAULT NULL
-
  `ShipperAddressDescription` varchar(1500) default NULL,
+
=== ConsigneeAddressId ===
-
  `ConsigneeAddressId` int(10) default NULL,
+
` 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,
+
 +
=== 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 ===
=== ExportRef ===
` varchar(30) default NULL,
` 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
-
  `ImportRef` varchar(30) default NULL,
+
=== CreatedByOfficeId ===
-
  `CustomerRef` varchar(30) default NULL,
+
` int(10) NOT NULL DEFAULT '1'
-
  `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,
+

Current revision as of 21:42, 21 May 2010


Contents

[edit] Related bo wiki

CT bo

[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'

Personal tools