Office tbl

From UG

Revision as of 20:24, 2 February 2010 (edit) Alex (Talk | contribs) (→CurrencyId) ← Older edit		Revision as of 20:25, 2 February 2010 (edit) (undo) Alex (Talk | contribs) (→Related Business Object and Its Fields) Newer edit →
Line 33:		Line 33:
-	This DB table corresponds to [[Office do]] [[data object]].	+	This DB table corresponds to ''[[Office do]]'' [[data object]].
	See its fields (attributes) below.		See its fields (attributes) below.

---

Revision as of 20:25, 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 do data 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',