Office tbl

From UG

Revision as of 21:04, 2 February 2010 (edit) Alex (Talk | contribs) (→Name) ← Older edit		Revision as of 22:42, 2 February 2010 (edit) (undo) Alex (Talk | contribs) (→Related Business Object and Its Fields) Newer edit →
Line 30:		Line 30:
-	== Related Business Object and Its Fields ==	+	== Fields ==

---

Revision as of 22:42, 2 February 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 VAT 2.9 ImageLogo 2.10 Name 2.11 PhoneNumber 2.12 FaxNumber 2.13 Email

MySQL Table Definitions

DROP TABLE IF EXISTS `tblOffice`;

CREATE TABLE `tblOffice` (
  `Id` int(10) NOT NULL auto_increment,
  `City` varchar(30) NOT NULL,
  `Flag` varchar(30) default NULL,
  `Abbreviation` varchar(3) default '',
  `Address` varchar(1000) default NULL,
  `CurrencyId` int(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 '\0',
  PRIMARY KEY  (`Id`),
  KEY `CurrencyId` (`CurrencyId`),
  CONSTRAINT `tblOffice_fk` FOREIGN KEY (`CurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

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