Office tbl
From UG
(Difference between revisions)
(→MySQL Table Definitions: actualized) |
(→Fields) |
||
Line 49: | Line 49: | ||
- | === Id === | + | === Id === |
- | === City=== | + | * integer(10) NOT NULL auto_increment |
+ | |||
+ | === City=== | ||
+ | * varchar(30) NOT NULL default | ||
+ | |||
=== Flag=== | === Flag=== | ||
+ | * varchar(30) | ||
+ | |||
=== Abbreviation === | === Abbreviation === | ||
- | + | * varchar(3) | |
- | + | ||
- | + | ||
- | === | + | === Address === |
+ | * varchar(1000) default NULL | ||
- | + | === CurrencyId === | |
+ | * integer(10) default NULL | ||
- | === | + | === InternalInvoicesCurrencyId === |
- | + | * integer(10) default NULL | |
- | === Name=== | + | === VAT === |
+ | * double default NULL | ||
+ | |||
+ | === ImageLogo === | ||
+ | * blob | ||
+ | |||
+ | === Name === | ||
* varchar(60) NOT NULL default | * varchar(60) NOT NULL default | ||
- | === PhoneNumber=== | + | === PhoneNumber === |
- | + | * varchar(15) default NULL | |
+ | |||
+ | === FaxNumber === | ||
+ | * varchar(15) default NULL | ||
+ | |||
+ | === Email === | ||
+ | * 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 | |
- | + |
Revision as of 17:55, 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
- 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