Airline tbl
From UG
(Difference between revisions)
(→MySQL Table Definitions) |
|||
(6 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:Carriers]] |
- | == | + | == MySQL == |
<pre> | <pre> | ||
Line 27: | Line 27: | ||
</pre> | </pre> | ||
- | == | + | == Fields == |
+ | |||
+ | ===Id=== | ||
- | + | ` int(10) NOT NULL auto_increment, | |
- | + | ===TwoLetterCode=== | |
- | + | ` varchar(2) NOT NULL, | |
- | + | ===Name=== | |
- | + | ||
- | + | ||
- | + | ` varchar(30) NOT NULL, | |
- | + | ===NumericCode=== | |
- | + | ||
- | + | ||
- | + | ` varchar(3) NOT NULL, | |
- | + | ||
- | + | ||
- | + | ||
- | + |
Current revision as of 21:22, 3 February 2010
Contents |
[edit] MySQL
mysql> describe tblAirline; +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | TwoLetterCode | varchar(2) | NO | | NULL | | | Name | varchar(30) | NO | | NULL | | | NumericCode | varchar(3) | NO | | NULL | | +---------------+-------------+------+-----+---------+----------------+ 4 rows in set CREATE TABLE `tblAirline` ( `Id` int(10) NOT NULL auto_increment, `TwoLetterCode` varchar(2) NOT NULL, `Name` varchar(30) NOT NULL, `NumericCode` varchar(3) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;
[edit] Fields
[edit] Id
` int(10) NOT NULL auto_increment,
[edit] TwoLetterCode
` varchar(2) NOT NULL,
[edit] Name
` varchar(30) NOT NULL,
[edit] NumericCode
` varchar(3) NOT NULL,