Office tbl
From UG
(Difference between revisions)
(→MySQL Table Definitions: actualized) |
|||
Line 5: | Line 5: | ||
<pre> | <pre> | ||
- | |||
- | |||
CREATE TABLE `tblOffice` ( | CREATE TABLE `tblOffice` ( | ||
- | `Id` | + | `Id` INTEGER(10) NOT NULL AUTO_INCREMENT, |
- | `City` | + | `City` VARCHAR(30) COLLATE latin1_swedish_ci NOT NULL DEFAULT '', |
- | `Flag` | + | `Flag` VARCHAR(30) COLLATE latin1_swedish_ci DEFAULT NULL, |
- | `Abbreviation` | + | `Abbreviation` VARCHAR(3) COLLATE latin1_swedish_ci DEFAULT '', |
- | `Address` | + | `Address` VARCHAR(1000) COLLATE latin1_swedish_ci DEFAULT NULL, |
- | `CurrencyId` | + | `CurrencyId` INTEGER(10) DEFAULT NULL, |
- | `VAT` | + | `InternalInvoicesCurrencyId` INTEGER(10) DEFAULT NULL, |
- | `ImageLogo` | + | `VAT` DOUBLE DEFAULT NULL, |
- | `Name` | + | `ImageLogo` BLOB, |
- | `PhoneNumber` | + | `Name` VARCHAR(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '', |
- | `FaxNumber` | + | `PhoneNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL, |
- | `Email` | + | `FaxNumber` VARCHAR(15) COLLATE latin1_swedish_ci DEFAULT NULL, |
- | `IsMainOffice` | + | `Email` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL, |
- | PRIMARY KEY | + | `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 `CurrencyId` (`CurrencyId`), | ||
- | CONSTRAINT `tblOffice_fk` FOREIGN KEY (`CurrencyId`) REFERENCES `tblCurrency` (`Id`) ON UPDATE CASCADE | + | KEY `tblOffice_InternalInvoicesCurrencyId_fk1` (`InternalInvoicesCurrencyId`), |
- | ) ENGINE=InnoDB AUTO_INCREMENT=6 | + | 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'; | ||
</pre> | </pre> | ||
- | |||
== Fields == | == Fields == |
Revision as of 17:39, 25 November 2010
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
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',