Office tbl
From UG
Contents |
MySQL Table Definitions
CREATE TABLE `tblOffice` ( `Id` INTEGER(10) NOT NULL AUTO_INCREMENT, `City` VARCHAR(30) COLLATE latin1_swedish_ci NOT NULL DEFAULT '', `Flag` VARCHAR(30) COLLATE latin1_swedish_ci DEFAULT NULL, `Abbreviation` VARCHAR(3) COLLATE latin1_swedish_ci DEFAULT '', `Address` VARCHAR(1000) COLLATE latin1_swedish_ci DEFAULT NULL, `CurrencyId` INTEGER(10) DEFAULT NULL, `InternalInvoicesCurrencyId` INTEGER(10) DEFAULT NULL, `VAT` DOUBLE DEFAULT NULL, `ImageLogo` BLOB, `Name` VARCHAR(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '', `PhoneNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL, `FaxNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL, `Email` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL, `IsMainOffice` BIT(1) NOT NULL DEFAULT 0, `IsEnableIIFImport` BIT(1) NOT NULL DEFAULT 0, `StartOfIIFImportDate` DATETIME DEFAULT NULL, `DailyTimeOfCreatingIIF` TINYINT(23) DEFAULT NULL, `TimeZoneId` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL, PRIMARY KEY (`Id`), KEY `CurrencyId` (`CurrencyId`), KEY `tblOffice_InternalInvoicesCurrencyId_fk1` (`InternalInvoicesCurrencyId`), CONSTRAINT `tblOffice_fk` FOREIGN KEY (`CurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE, CONSTRAINT `tblOffice_InternalInvoicesCurrencyId_fk1` FOREIGN KEY (`InternalInvoicesCurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE )ENGINE=InnoDB AUTO_INCREMENT=6 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';
Fields
This DB table corresponds to Office bo business object.
See its fields (attributes) below.
xxxx
- meaning:
- type/format:
- example: CA
Id
- integer(10) NOT NULL auto_increment
City
- varchar(30) NOT NULL default
Flag
- varchar(30)
Abbreviation
- varchar(3)
Address
- varchar(1000) default NULL
CurrencyId
- integer(10) default NULL
InternalInvoicesCurrencyId
- integer(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
- varchar(50) default NULL
IsMainOffice
- bit(1) NOT NULL default
IsEnableIIFImport
- bit(1) NOT NULL default
StartOfIIFImportDate
- datetime default NULL
DailyTimeOfCreatingIIF
- tinyint(23) default NULL
TimeZoneId
- varchar(50) default NULL