今天查询到了网络资源

if exists (select 1
   from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('TicketInfo') and o.name = 'FK_TICKETIN_REFERENCE_PASSENGE')
alter table TicketInfo
   drop constraint FK_TICKETIN_REFERENCE_PASSENGE
go

if exists (select 1
   from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('TicketInfo') and o.name = 'FK_TICKETIN_REFERENCE_BUNKTYPE')
alter table TicketInfo
   drop constraint FK_TICKETIN_REFERENCE_BUNKTYPE
go

if exists (select 1
   from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('TicketInfo') and o.name = 'FK_TICKETIN_REFERENCE_REBATETY')
alter table TicketInfo
   drop constraint FK_TICKETIN_REFERENCE_REBATETY
go

if exists (select 1
   from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('TicketInfo') and o.name = 'FK_TICKETIN_REFERENCE_VOYAGETY')
alter table TicketInfo
   drop constraint FK_TICKETIN_REFERENCE_VOYAGETY
go

if exists (select 1
            from  sysobjects
           where  id = object_id('BunkType')
            and   type = 'U')
   drop table BunkType
go

if exists (select 1
            from  sysobjects
           where  id = object_id('PassengerType')
            and   type = 'U')
   drop table PassengerType
go

if exists (select 1
            from  sysobjects
           where  id = object_id('RebateType')
            and   type = 'U')
   drop table RebateType
go

if exists (select 1
            from  sysobjects
           where  id = object_id('TicketInfo')
            and   type = 'U')
   drop table TicketInfo
go

if exists (select 1
            from  sysobjects
           where  id = object_id('VoyageType')
            and   type = 'U')
   drop table VoyageType
go

/*==============================================================*/
/* Table: BunkType                                              */
/*==============================================================*/
create table BunkType (
   BunkID               int                  not null,
   Name                 nvarchar(20)         null,
   Code                 nvarchar(10)         null,
   Description          nvarchar(200)        null,
   Rebate               float                null,
   constraint PK_BUNKTYPE primary key (BunkID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '座舱类型（舱位等级）',
   'user', @CurrentUser, 'table', 'BunkType'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '舱位名称',
   'user', @CurrentUser, 'table', 'BunkType', 'column', 'Name'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '舱位代号: 如T，F等',
   'user', @CurrentUser, 'table', 'BunkType', 'column', 'Code'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '折扣',
   'user', @CurrentUser, 'table', 'BunkType', 'column', 'Rebate'
go

/*==============================================================*/
/* Table: PassengerType                                         */
/*==============================================================*/
create table PassengerType (
   PassengerID          int                  not null,
   Name                 nvarchar(50)         null,
   Description          nvarchar(500)        null,
   Rebate               float                null,
   constraint PK_PASSENGERTYPE primary key (PassengerID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '乘客类型',
   'user', @CurrentUser, 'table', 'PassengerType'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '折扣',
   'user', @CurrentUser, 'table', 'PassengerType', 'column', 'Rebate'
go

/*==============================================================*/
/* Table: RebateType                                            */
/*==============================================================*/
create table RebateType (
   RebateID             int                  not null,
   Name                 nvarchar(20)         null,
   Description          nvarchar(200)        null,
   Rebate               float                null,
   constraint PK_REBATETYPE primary key (RebateID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '优惠（折扣）类型',
   'user', @CurrentUser, 'table', 'RebateType'
go

/*==============================================================*/
/* Table: TicketInfo                                            */
/*==============================================================*/
create table TicketInfo (
   TicketID             int                  not null,
   TicketCode           nvarchar(30)         null,
   FlightOrder          nvarchar(30)         null,
   GuestID              int                  null,
   Name                 nvarchar(30)         null,
   IDCard               nvarchar(20)         null,
   FlightTime           nvarchar(19)         null,
   FromCity             nvarchar(30)         null,
   ToCity               nvarchar(30)         null,
   PassengerID          int                  null,
   PassengerType        nvarchar(50)         null,
   PassengerRebate      float                null,
   BunkID               int                  null,
   Reb_RebateID         int                  null,
   BunkType             nvarchar(20)         null,
   BunkRebate           float                null,
   VoyageID             int                  null,
   VoyageType           nvarchar(20)         null,
   RebateID             nvarchar(20)         null,
   RebateName           nvarchar(50)         null,
   Rebate               float                null,
   Price                float                null,
   RebatePrice          float                null,
   BuildPrice           float                null,
   FuelPrice            float                null,
   Insurance            float                null,
   Total                float                null,
   AddTime              nvarchar(19)         null,
   Destiner             nvarchar(30)         null,
   DestineTel           nvarchar(30)         null,
   SendAddress          nvarchar(200)        null,
   SendTime             nvarchar(200)        null,
   CheckTaker           nvarchar(30)         null,
   Telephone            nvarchar(30)         null,
   Sender               nvarchar(30)         null,
   OperatorID           int                  null,
   Operator             nvarchar(30)         null,
   State                int                  null,
   Description          nvarchar(500)        null,
   constraint PK_TICKETINFO primary key (TicketID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '飞机票单',
   'user', @CurrentUser, 'table', 'TicketInfo'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '订票编号',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'TicketCode'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '航班编号',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'FlightOrder'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '持票人员',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Name'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '身份证号码',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'IDCard'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '航班时间',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'FlightTime'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '起始城市',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'FromCity'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '目的城市',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'ToCity'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '乘客类型',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'PassengerType'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '乘客类型折扣',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'PassengerRebate'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '舱位类型',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'BunkType'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '舱位折扣',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'BunkRebate'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '航程类型',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'VoyageType'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '优惠类型(淡季优惠)',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'RebateName'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '优惠折扣价',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Rebate'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '总价格',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Price'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '折扣后总价格',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'RebatePrice'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '机场建设费',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'BuildPrice'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '燃油费',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'FuelPrice'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '保险费',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Insurance'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '合计',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Total'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '预定时间',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'AddTime'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '预定人员',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Destiner'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '预定人员电话',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'DestineTel'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '送票地址',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'SendAddress'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '送票时间',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'SendTime'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '收票人员',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'CheckTaker'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '收票人电话',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Telephone'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '送票人员',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Sender'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '登记人员',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Operator'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '处理状态(0=登记;1=派送中;2=已收款;3=退单;)',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'State'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '配送描述',
   'user', @CurrentUser, 'table', 'TicketInfo', 'column', 'Description'
go

/*==============================================================*/
/* Table: VoyageType                                            */
/*==============================================================*/
create table VoyageType (
   VoyageID             int                  not null,
   Name                 nvarchar(20)         null,
   Description          nvarchar(200)        null,
   constraint PK_VOYAGETYPE primary key (VoyageID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '航程类型(往返/单程/联程  )',
   'user', @CurrentUser, 'table', 'VoyageType'
go

alter table TicketInfo
   add constraint FK_TICKETIN_REFERENCE_PASSENGE foreign key (PassengerID)
      references PassengerType (PassengerID)
go

alter table TicketInfo
   add constraint FK_TICKETIN_REFERENCE_BUNKTYPE foreign key (BunkID)
      references BunkType (BunkID)
go

alter table TicketInfo
   add constraint FK_TICKETIN_REFERENCE_REBATETY foreign key (Reb_RebateID)
      references RebateType (RebateID)
go

alter table TicketInfo
   add constraint FK_TICKETIN_REFERENCE_VOYAGETY foreign key (VoyageID)
      references VoyageType (VoyageID)
go