-- =============================================-- 12306-单-- http://www.12306.cn-- author:yuanbo-- 16:25 2016/9/22-- =============================================use TrainTicketgogo-- =============================================-- table:订单表-- author:yuanbo-- =============================================create table [Order](orderId uniqueidentifier primary key,    --编号【PK，UQ】station varchar(200),        --站名--车次--车厢-座号--发车地点--发车时间pubdate datetime default(getdate()),    --订单时间diabled bit,accountId uniqueidentifier references Account(accountId)    --用户ID【FK】)go-- =============================================-- table:订单表-- author:yuanbo-- =============================================create table OrderDetails(orderDetailsId uniqueidentifier primary key,    --编号【PK，UQ】--车次trainNumberId uniqueidentifier references TrainNumber(trainNumberId),    --车次ID【FK】trainNumber varchar(200),    --车次--车厢-座号carriageId uniqueidentifier references Carriage(carriageId),    --车厢ID【FK】carriage varchar(200),    --车厢seatType varchar(200),    --坐席seatId uniqueidentifier references Seat(seatId),    --座位ID【FK】seatNumber varchar(200),        --座位编号departureStationId uniqueidentifier references Station(stationId),    --车站ID【FK】departureStation varchar(200),    --发车地点destinationStationId uniqueidentifier references Station(stationId),    --车站ID【FK】destinationStation varchar(200),    --目的车站departureTime datetime,        --发车时间ticketStatus varchar(200),    --订票状态：正常|已退票flagTicketed bit default(0),    --是否出票flagChange bit default(0),        --是否改签（只允许改签一次）diabled bit,orderId uniqueidentifier references [Order](orderId)    --订单ID【FK】)