StudentDB

最新推荐文章于 2023-06-17 11:15:32 发布

piaolingzxh

最新推荐文章于 2023-06-17 11:15:32 发布

阅读量759

点赞数

CC 4.0 BY-SA版权

分类专栏： DataBase 文章标签： null table reference date email go

本文链接：https://blog.youkuaiyun.com/piaolingzxh/article/details/5628666

DataBase 专栏收录该内容

8 篇文章

订阅专栏

简单的三个实体学生、老师、班级，如下图

use StudentDB

create table Classes (
   ClassesId            int                  identity,
   ClassesName          nvarchar(25)         null,
   CreateTime           date                 null,
   constraint PK_CLASSES primary key (ClassesId)
)
go

/*==============================================================*/
/* Table: Students                                              */
/*==============================================================*/
create table Students (
   StudentId            int                  identity,
   ClassesId            int                  null,
   StudentName          nvarchar(25)         null,
   Age                  int                  null,
   Email                nvarchar(25)         null,
   Sex                  bit                  null,
   RegistTime           date                 null,
   Isleft               bit                  null,
   constraint PK_STUDENTS primary key (StudentId)
)
go

/*==============================================================*/
/* Table: Teachers                                              */
/*==============================================================*/
create table Teachers (
   TeacherId            int                  identity,
   TeacherName          nvarchar(25)         null,
   Age                  int                  null,
   constraint PK_TEACHERS primary key (TeacherId)
)
go

/*==============================================================*/
/* Table: Teaching                                              */
/*==============================================================*/
create table Teaching (
   StudentId            int                  not null,
   TeacherId            int                  not null,
   constraint PK_TEACHING primary key (StudentId, TeacherId)
)
go

alter table Students
add constraint FK_STUDENTS_REFERENCE_CLASSES foreign key (ClassesId)
references Classes (ClassesId)
go

alter table Teaching
add constraint FK_TEACHING_REFERENCE_STUDENTS foreign key (StudentId)
references Students (StudentId)
go

alter table Teaching
add constraint FK_TEACHING_REFERENCE_TEACHERS foreign key (TeacherId)
references Teachers (TeacherId)
go