Office tbl

From UG

Revision as of 17:55, 25 November 2010 (edit) Andrei (Talk | contribs) (→Fields) ← Older edit		Revision as of 05:06, 23 December 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
-	[[Category:Users and Offices]]	+	[[Category:OpsAdmin]]
	== MySQL Table Definitions ==		== MySQL Table Definitions ==

---

Revision as of 05:06, 23 December 2010

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

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

Fields

This DB table corresponds to Office bo business object.

See its fields (attributes) below.

xxxx

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

Id

• integer(10) NOT NULL auto_increment

City

• varchar(30) NOT NULL default

Flag

• varchar(30)

Abbreviation

• varchar(3)

Address

• varchar(1000) default NULL

CurrencyId

• integer(10) default NULL

InternalInvoicesCurrencyId

• integer(10) default NULL

VAT

• double default NULL

ImageLogo

• blob

Name

• varchar(60) NOT NULL default

PhoneNumber

• 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

DailyTimeOfCreatingIIF

• tinyint(23) default NULL

TimeZoneId

• varchar(50) default NULL