Office tbl
From UG
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;
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,
` varchar(50) default NULL, `IsMainOffice` bit(1) NOT NULL default '\0',