Office tbl

From UG

Revision as of 20:23, 2 February 2010 by Alex (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Contents

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