Office tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(→CurrencyId)
 
(8 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Admin Data Objects]]
+
[[Category:Users and Offices]]
== MySQL Table Definitions ==
== MySQL Table Definitions ==
Line 5: Line 5:
<pre>
<pre>
-
 
-
DROP TABLE IF EXISTS `tblOffice`;
 
CREATE TABLE `tblOffice` (
CREATE TABLE `tblOffice` (
-
   `Id` int(10) NOT NULL auto_increment,
+
   `Id` INTEGER(10) NOT NULL AUTO_INCREMENT,
-
   `City` varchar(30) NOT NULL,
+
   `City` VARCHAR(30) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
-
   `Flag` varchar(30) default NULL,
+
   `Flag` VARCHAR(30) COLLATE latin1_swedish_ci DEFAULT NULL,
-
   `Abbreviation` varchar(3) default '',
+
   `Abbreviation` VARCHAR(3) COLLATE latin1_swedish_ci DEFAULT '',
-
   `Address` varchar(1000) default NULL,
+
   `Address` VARCHAR(1000) COLLATE latin1_swedish_ci DEFAULT NULL,
-
   `CurrencyId` int(10) default NULL,
+
   `CurrencyId` INTEGER(10) DEFAULT NULL,
-
   `VAT` double default NULL,
+
  `InternalInvoicesCurrencyId` INTEGER(10) DEFAULT NULL,
-
   `ImageLogo` blob,
+
   `VAT` DOUBLE DEFAULT NULL,
-
   `Name` varchar(60) NOT NULL default '',
+
   `ImageLogo` BLOB,
-
   `PhoneNumber` varchar(15) default NULL,
+
   `Name` VARCHAR(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
-
   `FaxNumber` varchar(15) default NULL,
+
   `PhoneNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL,
-
   `Email` varchar(50) default NULL,
+
   `FaxNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL,
-
   `IsMainOffice` bit(1) NOT NULL default '\0',
+
   `Email` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL,
-
   PRIMARY KEY (`Id`),
+
   `IsMainOffice` BIT(1) NOT NULL DEFAULT 0,
 +
  `IsEnableIIFImport` BIT(1) NOT NULL DEFAULT 0,
 +
  `StartOfIIFImportDate` DATETIME DEFAULT NULL,
 +
  `DailyTimeOfCreatingIIF` TINYINT(23) DEFAULT NULL,
 +
  `TimeZoneId` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL,
 +
   PRIMARY KEY (`Id`),
   KEY `CurrencyId` (`CurrencyId`),
   KEY `CurrencyId` (`CurrencyId`),
-
   CONSTRAINT `tblOffice_fk` FOREIGN KEY (`CurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE
+
  KEY `tblOffice_InternalInvoicesCurrencyId_fk1` (`InternalInvoicesCurrencyId`),
-
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+
   CONSTRAINT `tblOffice_fk` FOREIGN KEY (`CurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE,
 +
  CONSTRAINT `tblOffice_InternalInvoicesCurrencyId_fk1` FOREIGN KEY (`InternalInvoicesCurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE
 +
)ENGINE=InnoDB
 +
AUTO_INCREMENT=6 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';
</pre>
</pre>
 +
== Fields ==
-
== Related Business Object and Its Fields ==
 
-
 
+
This DB table corresponds to ''[[Office bo]]'' [[business object]].
-
This DB table corresponds to [[Office do]] [[data object]].
+
See its fields (attributes) below.
See its fields (attributes) below.
Line 44: Line 49:
-
=== Id ===  
+
=== Id ===
-
=== City===  
+
* integer(10) NOT NULL auto_increment
 +
 
 +
=== City===
 +
* varchar(30) NOT NULL default
 +
 
=== Flag===  
=== Flag===  
 +
* varchar(30)
 +
=== Abbreviation ===
=== Abbreviation ===
-
+
* varchar(3)
-
=== Address===  
+
 
-
=== CurrencyId===  
+
=== Address ===
 +
* varchar(1000) default NULL
 +
 
 +
=== CurrencyId ===  
 +
* integer(10) default NULL
 +
 
 +
=== InternalInvoicesCurrencyId ===
 +
* integer(10) default NULL
=== VAT ===
=== VAT ===
 +
* double default NULL
 +
 +
=== ImageLogo ===
 +
* blob
 +
 +
=== Name ===
 +
* varchar(60) NOT NULL default
 +
 +
=== PhoneNumber ===
 +
* varchar(15) default NULL
 +
 +
=== FaxNumber ===
 +
* varchar(15) default NULL
-
` double default NULL,
+
=== Email ===
 +
* varchar(50) default NULL
-
=== ImageLogo===
+
=== IsMainOffice ===
-
` blob,
+
* bit(1) NOT NULL default
-
=== Name===
+
=== IsEnableIIFImport ===
-
` varchar(60) NOT NULL default '',
+
* bit(1) NOT NULL default
-
=== PhoneNumber===
+
=== StartOfIIFImportDate ===
-
` varchar(15) default NULL,
+
* datetime default NULL
-
=== FaxNumber===
+
=== DailyTimeOfCreatingIIF ===
-
` varchar(15) default NULL,
+
* tinyint(23) default NULL
-
=== Email===
+
=== TimeZoneId ===
-
` varchar(50) default NULL,
+
* varchar(50) default NULL
-
  `IsMainOffice` bit(1) NOT NULL default '\0',
+

Current revision as of 11:14, 7 August 2011


Contents

[edit] MySQL Table Definitions 


CREATE TABLE `tblOffice` (
  `Id` INTEGER(10) NOT NULL AUTO_INCREMENT,
  `City` VARCHAR(30) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `Flag` VARCHAR(30) COLLATE latin1_swedish_ci DEFAULT NULL,
  `Abbreviation` VARCHAR(3) COLLATE latin1_swedish_ci DEFAULT '',
  `Address` VARCHAR(1000) COLLATE latin1_swedish_ci DEFAULT NULL,
  `CurrencyId` INTEGER(10) DEFAULT NULL,
  `InternalInvoicesCurrencyId` INTEGER(10) DEFAULT NULL,
  `VAT` DOUBLE DEFAULT NULL,
  `ImageLogo` BLOB,
  `Name` VARCHAR(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `PhoneNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL,
  `FaxNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL,
  `Email` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL,
  `IsMainOffice` BIT(1) NOT NULL DEFAULT 0,
  `IsEnableIIFImport` BIT(1) NOT NULL DEFAULT 0,
  `StartOfIIFImportDate` DATETIME DEFAULT NULL,
  `DailyTimeOfCreatingIIF` TINYINT(23) DEFAULT NULL,
  `TimeZoneId` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `CurrencyId` (`CurrencyId`),
  KEY `tblOffice_InternalInvoicesCurrencyId_fk1` (`InternalInvoicesCurrencyId`),
  CONSTRAINT `tblOffice_fk` FOREIGN KEY (`CurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE,
  CONSTRAINT `tblOffice_InternalInvoicesCurrencyId_fk1` FOREIGN KEY (`InternalInvoicesCurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE
)ENGINE=InnoDB
AUTO_INCREMENT=6 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';

[edit] Fields

This DB table corresponds to Office bo business object.

See its fields (attributes) below.

[edit] xxxx

  • meaning:
  • type/format:
  • example: CA


[edit] Id

  • integer(10) NOT NULL auto_increment

[edit] City

  • varchar(30) NOT NULL default

[edit] Flag

  • varchar(30)

[edit] Abbreviation

  • varchar(3)

[edit] Address

  • varchar(1000) default NULL

[edit] CurrencyId

  • integer(10) default NULL

[edit] InternalInvoicesCurrencyId

  • integer(10) default NULL

[edit] VAT

  • double default NULL

[edit] ImageLogo

  • blob

[edit] Name

  • varchar(60) NOT NULL default

[edit] PhoneNumber

  • varchar(15) default NULL

[edit] FaxNumber

  • varchar(15) default NULL

[edit] Email

  • varchar(50) default NULL

[edit] IsMainOffice

  • bit(1) NOT NULL default

[edit] IsEnableIIFImport

  • bit(1) NOT NULL default

[edit] StartOfIIFImportDate

  • datetime default NULL

[edit] DailyTimeOfCreatingIIF

  • tinyint(23) default NULL

[edit] TimeZoneId

  • varchar(50) default NULL
Retrieved from "https://wiki.jaguarfreight.com/Office_tbl"
Personal tools