Office tbl
From UG
(Difference between revisions)
(→Related Business Object and Its Fields) |
|||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:Users and Offices]] |
== MySQL Table Definitions == | == MySQL Table Definitions == |
Revision as of 23:06, 3 February 2010
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',