Office tbl

From UG

Revision as of 20:23, 2 February 2010 (edit) Alex (Talk | contribs) (Created page with 'Category:Admin Data Objects == MySQL Table Definitions == <pre> DROP TABLE IF EXISTS `tblOffice`; CREATE TABLE `tblOffice` ( `Id` int(10) NOT NULL auto_increment, `C…') ← Older edit		Revision as of 20:24, 2 February 2010 (edit) (undo) Alex (Talk | contribs) (→CurrencyId) Newer edit →
Line 52:		Line 52:
	=== CurrencyId===		=== CurrencyId===
-	=== VAT	+	=== VAT ===
		+
	` double default NULL,		` double default NULL,

---

Revision as of 20:24, 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',