Office tbl

From UG

Revision as of 17:39, 25 November 2010 (edit) Andrei (Talk | contribs) (→MySQL Table Definitions: actualized) ← Older edit		Current revision as of 11:14, 7 August 2011 (edit) (undo) Andrei (Talk | contribs)
(2 intermediate revisions not shown)
Line 49:		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===	+
-	=== VAT ===	+	=== Address ===
		+	* varchar(1000) default NULL
-	` double default NULL,	+	=== CurrencyId ===
		+	* integer(10) default NULL
-	=== ImageLogo===	+	=== InternalInvoicesCurrencyId ===
-	` blob,	+	* integer(10) default NULL
-	=== Name===	+	=== VAT ===
		+	* double default NULL
		+
		+	=== ImageLogo ===
		+	* blob
		+
		+	=== Name ===
	* varchar(60) NOT NULL default		* varchar(60) NOT NULL default
-	=== PhoneNumber===	+	=== PhoneNumber ===
-	` varchar(15) default NULL,	+	* varchar(15) default NULL
		+
		+	=== FaxNumber ===
		+	* varchar(15) default NULL
		+
		+	=== Email ===
		+	* varchar(50) default NULL
		+
		+	=== IsMainOffice ===
		+	* bit(1) NOT NULL default
		+
		+	=== IsEnableIIFImport ===
		+	* bit(1) NOT NULL default
		+
		+	=== StartOfIIFImportDate ===
		+	* 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 1 MySQL Table Definitions 2 Fields 2.1 xxxx 2.2 Id 2.3 City 2.4 Flag 2.5 Abbreviation 2.6 Address 2.7 CurrencyId 2.8 InternalInvoicesCurrencyId 2.9 VAT 2.10 ImageLogo 2.11 Name 2.12 PhoneNumber 2.13 FaxNumber 2.14 Email 2.15 IsMainOffice 2.16 IsEnableIIFImport 2.17 StartOfIIFImportDate 2.18 DailyTimeOfCreatingIIF 2.19 TimeZoneId

[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