Office tbl

From UG

Revision as of 20:25, 2 February 2010 (edit) Alex (Talk | contribs) (→Related Business Object and Its Fields) ← Older edit		Revision as of 21:04, 2 February 2010 (edit) (undo) Alex (Talk | contribs) (→Name) Newer edit →
Line 60:		Line 60:
	=== Name===		=== Name===
-	` varchar(60) NOT NULL default '',	+	* varchar(60) NOT NULL default
	=== PhoneNumber===		=== PhoneNumber===

---

Revision as of 21:04, 2 February 2010

Contents 1 MySQL Table Definitions 2 Related Business Object and Its 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;

Related Business Object and Its 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',