Office tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(Fields)
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

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
Personal tools