數(shù)據(jù)庫課程設(shè)計(jì)大學(xué)教材征訂信息管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)-文庫吧資料
2025-02-16 01:51本頁面
【正文】 _CI_AS NOT NULL, [學(xué)院編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [教材編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_專業(yè)表] PRIMARY KEY CLUSTERED ( [專業(yè)編號(hào)] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF創(chuàng)建學(xué)院表：CREATE TABLE [dbo].[學(xué)院表]( [學(xué)院編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [學(xué)院名稱] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_學(xué)院表] PRIMARY KEY CLUSTERED ( [學(xué)院編號(hào)] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF創(chuàng)建教師表：CREATE TABLE [dbo].[教師表]( [教師編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [教師姓名] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [密碼] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [學(xué)院編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_教師表] PRIMARY KEY CLUSTERED ( [教師編號(hào)] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF創(chuàng)建教材表：CREATE TABLE [dbo].[教材表]( [教材編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [教材名稱] [char](40) COLLATE Chinese_PRC_CI_AS NOT NULL, [出版時(shí)間] [smalldatetime] NOT NULL, [單價(jià)] [smallmoney] NOT NULL, [出版社] [char](40) COLLATE Chinese_PRC_CI_AS NOT NULL, [作者] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_教材表] PRIMARY KEY CLUSTERED ( [教材編號(hào)] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF創(chuàng)建教材工作人員表：CREATE TABLE [dbo].[教材工作人員表]( [工作人員編號(hào)] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [姓名] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [密碼] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [購書時(shí)間] [smalldatetime] NULL, [發(fā)書時(shí)間] [smalldatetime] NULL, CONSTRAINT [PK_教材發(fā)放人員
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1