Office tbl
From UG
Contents |
[edit] 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';
[edit] Fields
This DB table corresponds to Office bo business object.
See its fields (attributes) below.
[edit] xxxx
- meaning:
- type/format:
- example: CA
[edit] Id
- integer(10) NOT NULL auto_increment
[edit] City
- varchar(30) NOT NULL default
[edit] Flag
- varchar(30)
[edit] Abbreviation
- varchar(3)
[edit] Address
- varchar(1000) default NULL
[edit] CurrencyId
- integer(10) default NULL
[edit] InternalInvoicesCurrencyId
- integer(10) default NULL
[edit] VAT
- double default NULL
[edit] ImageLogo
- blob
[edit] Name
- varchar(60) NOT NULL default
[edit] PhoneNumber
- varchar(15) default NULL
[edit] FaxNumber
- varchar(15) default NULL
[edit] Email
- varchar(50) default NULL
[edit] IsMainOffice
- bit(1) NOT NULL default
[edit] IsEnableIIFImport
- bit(1) NOT NULL default
[edit] StartOfIIFImportDate
- datetime default NULL
[edit] DailyTimeOfCreatingIIF
- tinyint(23) default NULL
[edit] TimeZoneId
- varchar(50) default NULL