火车售票系统课程设计sqlserver，创建用户表、乘客表、订单表、火车表、车站表完整代码

以下是一个基础的火车售票系统的 SQL Server 表结构设计：

CREATE TABLE [dbo].[User](
    [UserId] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [UserName] [nvarchar](50) NOT NULL,
    [Password] [nvarchar](50) NOT NULL,
    [Email] [nvarchar](50) NOT NULL,
    [Phone] [nvarchar](50) NOT NULL,
    [CreateTime] [datetime] NOT NULL
)

CREATE TABLE [dbo].[Passenger](
    [PassengerId] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [UserId] [int] NOT NULL,
    [Name] [nvarchar](50) NOT NULL,
    [IDNumber] [nvarchar](50) NOT NULL,
    [Phone] [nvarchar](50) NOT NULL,
    [CreateTime] [datetime] NOT NULL,
    CONSTRAINT [FK_Passenger_User] FOREIGN KEY([UserId]) REFERENCES [dbo].[User]([UserId])
)

CREATE TABLE [dbo].[Order](
    [OrderId] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [UserId] [int] NOT NULL,
    [PassengerId] [int] NOT NULL,
    [TrainId] [int] NOT NULL,
    [StartStation] [nvarchar](50) NOT NULL,
    [EndStation] [nvarchar](50) NOT NULL,
    [StartTime] [datetime] NOT NULL,
    [EndTime] [datetime] NOT NULL,
    [Price] [float] NOT NULL,
    [CreateTime] [datetime] NOT NULL,
    CONSTRAINT [FK_Order_User] FOREIGN KEY([UserId]) REFERENCES [dbo].[User]([UserId]),
    CONSTRAINT [FK_Order_Passenger] FOREIGN KEY([PassengerId]) REFERENCES [dbo].[Passenger]([PassengerId]),
    CONSTRAINT [FK_Order_Train] FOREIGN KEY([TrainId]) REFERENCES [dbo].[Train]([TrainId])
)

CREATE TABLE [dbo].[Train](
    [TrainId] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [TrainNumber] [nvarchar](50) NOT NULL,
    [StartTime] [datetime] NOT NULL,
    [EndTime] [datetime] NOT NULL,
    [StartStation] [nvarchar](50) NOT NULL,
    [EndStation] [nvarchar](50) NOT NULL,
    [Price] [float] NOT NULL,
    [CreateTime] [datetime] NOT NULL
)

CREATE TABLE [dbo].[Station](
    [StationId] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [StationName] [nvarchar](50) NOT NULL,
    [CreateTime] [datetime] NOT NULL
)

CREATE TABLE [dbo].[TrainStation](
    [TrainStationId] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [TrainId] [int] NOT NULL,
    [StationId] [int] NOT NULL,
    [Order] [int] NOT NULL,
    CONSTRAINT [FK_TrainStation_Train] FOREIGN KEY([TrainId]) REFERENCES [dbo].[Train]([TrainId]),
    CONSTRAINT [FK_TrainStation_Station] FOREIGN KEY([StationId]) REFERENCES [dbo].[Station]([StationId])
)

以上是一个简单的表结构设计，包括了用户表、乘客表、订单表、火车表和车站表。你还可以添加一些其他的表，例如车票表、座位表等。

在数据库设计完成后，你可以使用 SQL 语句插入数据或使用其他工具进行操作，比如 Microsoft SQL Server Management Studio。