Office tbl

From UG

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

Revision as of 17:39, 25 November 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

City

Flag

Abbreviation

Address

CurrencyId

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 '\0',
Personal tools