Advertisement
g0hww

VRS aircraft table schema

Jul 20th, 2013
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. CREATE TABLE [Aircraft] ([AircraftID] integer primary key, [FirstCreated] datetime not null, [LastModified] datetime not null, [ModeS] varchar(6) not null unique, [ModeSCountry] varchar(24), [Country] varchar(24), [Registration] varchar(20), [CurrentRegDate] varchar(10), [PreviousID] varchar(10), [FirstRegDate] varchar(10), [Status] varchar(10), [DeRegDate] varchar(10), [Manufacturer] varchar(60), [ICAOTypeCode] varchar(10), [Type] varchar(40), [SerialNo] varchar(30), [PopularName] varchar(20), [GenericName] varchar(20), [AircraftClass] varchar(20), [Engines] varchar(40), [OwnershipStatus] varchar(10), [RegisteredOwners] varchar(100), [MTOW] varchar(10), [TotalHours] varchar(20), [YearBuilt] varchar(4), [CofACategory] varchar(30), [CofAExpiry] varchar(10), [UserNotes] varchar(300), [Interested] boolean not null default 0, [UserTag] varchar(5), [InfoURL] varchar(150), [PictureURL1] varchar(150), [PictureURL2] varchar(150), [PictureURL3] varchar(150), [UserBool1] boolean not null default 0, [UserBool2] boolean not null default 0, [UserBool3] boolean not null default 0, [UserBool4] boolean not null default 0, [UserBool5] boolean not null default 0, [UserString1] varchar(20), [UserString2] varchar(20), [UserString3] varchar(20), [UserString4] varchar(20), [UserString5] varchar(20), [UserInt1] integer default 0, [UserInt2] integer default 0, [UserInt3] integer default 0, [UserInt4] integer default 0, [UserInt5] integer default 0, [OperatorFlagCode] varchar(20))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement