網(wǎng)上花店管理系統(tǒng)數(shù)據(jù)庫設(shè)計報告-在線瀏覽
2024-09-21 12:26本頁面
【正文】 =================================*/if exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 收貨人goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 用戶goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 用途goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 訂單goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 訂單明細(xì)goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 購物車goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table 鮮花go/*==============================================================*//* Table: 收貨人 *//*==============================================================*/create table 收貨人 ( REid int not null, Uid int null, addr char(60) null, REname char(20) null, REiphone numeric(11) null, constraint PK_收貨人 primary key nonclustered (REid))go/*==============================================================*//* Table: 用戶 *//*==============================================================*/create table 用戶 ( Uid int not null, SHid int null, phone numeric(11) null, pwd char(20) null, char(20) null, Uname char(20) null, constraint PK_用戶 primary key nonclustered (Uid))go/*==============================================================*//* Table: 用途 *//*==============================================================*/create table 用途 ( PU
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1