Asp 쇼핑몰 구축 프로젝트 모듈 기반 쇼핑몰 개발 실무 - Shop DB 테이블 내용

<설명>
1. ASP 쇼핑몰 구축 프로젝트 의 DB 스크립트 입니다.
2. www.hanb.co.kr/exam/1390 에 소스 자료가 있습니다.
3. 책 제목은 "Asp 쇼핑몰 구축 프로젝트 모듈 기반 쇼핑몰 개발 실무"

Table

USE [master]
GO
/****** 개체:  Database [eshop]    스크립트 날짜: 12/19/2008 10:11:29 ******/
CREATE DATABASE [eshop] ON  PRIMARY
( NAME = N'eshop', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\eshop.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON
( NAME = N'eshop_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\eshop_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'eshop', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [eshop].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [eshop] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [eshop] SET ANSI_NULLS OFF
GO
ALTER DATABASE [eshop] SET ANSI_PADDING OFF
GO
ALTER DATABASE [eshop] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [eshop] SET ARITHABORT OFF
GO
ALTER DATABASE [eshop] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [eshop] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [eshop] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [eshop] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [eshop] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [eshop] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [eshop] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [eshop] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [eshop] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [eshop] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [eshop] SET  ENABLE_BROKER
GO
ALTER DATABASE [eshop] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [eshop] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [eshop] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [eshop] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [eshop] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [eshop] SET  READ_WRITE
GO
ALTER DATABASE [eshop] SET RECOVERY FULL
GO
ALTER DATABASE [eshop] SET  MULTI_USER
GO
ALTER DATABASE [eshop] SET PAGE_VERIFY CHECKSUM 
GO
ALTER DATABASE [eshop] SET DB_CHAINING OFF

Member

USE [eshop]
GO
/****** 개체:  Table [dbo].[member]    스크립트 날짜: 12/19/2008 10:14:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[member](
 [mem_idx] [int] IDENTITY(1,1) NOT NULL,
 [id] [nvarchar](20) NOT NULL,
 [pwd] [nvarchar](20) NOT NULL,
 [name] [nvarchar](30) NOT NULL,
 [ssn] [nvarchar](20) NOT NULL,
 [tel] [nvarchar](20) NULL,
 [hp] [nvarchar](20) NULL,
 [address] [nvarchar](100) NULL,
 [email] [nvarchar](40) NULL,
 [grade] [nvarchar](20) NULL
) ON [PRIMARY]

Product

USE [eshop]
GO
/****** 개체:  Table [dbo].[product]    스크립트 날짜: 12/19/2008 10:14:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[product](
 [pidx] [int] IDENTITY(1,1) NOT NULL,
 [pcategory] [nvarchar](30) NULL,
 [pmodel] [nvarchar](50) NULL,
 [pcode] [nvarchar](20) NULL,
 [pcompany] [nvarchar](30) NULL,
 [pimage] [nvarchar](70) NULL,
 [price] [int] NULL,
 [pspec] [nvarchar](10) NULL,
 [pcontents] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Category

USE [eshop]
GO
/****** 개체:  Table [dbo].[category]    스크립트 날짜: 12/19/2008 10:15:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[category](
 [cgname] [nvarchar](100) NULL,
 [cgcode] [nvarchar](50) NULL
) ON [PRIMARY]

Cart

USE [eshop]
GO
/****** 개체:  Table [dbo].[cart]    스크립트 날짜: 12/19/2008 10:15:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cart](
 [cmodel] [nvarchar](50) NULL,
 [cnt] [int] NULL,
 [cprice] [int] NULL,
 [cid] [nvarchar](20) NULL,
 [code] [nvarchar](20) NULL
) ON [PRIMARY]

Btable

USE [eshop]
GO
/****** 개체:  Table [dbo].[btable]    스크립트 날짜: 12/19/2008 10:16:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[btable](
 [num] [int] IDENTITY(1,1) NOT NULL,
 [subject] [nvarchar](100) NULL,
 [uid] [nvarchar](30) NULL,
 [regdate] [datetime] NULL,
 [hits] [int] NULL,
 [contents] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Porder

USE [eshop]
GO
/****** 개체:  Table [dbo].[porder]    스크립트 날짜: 12/19/2008 10:16:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[porder](
 [oname] [nvarchar](30) NULL,
 [oaddr] [nvarchar](100) NULL,
 [oemail] [nvarchar](40) NULL,
 [ophone] [nvarchar](20) NULL,
 [onum] [nvarchar](20) NOT NULL,
 [ototsum] [int] NULL,
 [odeliver] [nvarchar](20) NULL,
 [osendday] [nvarchar](50) NULL,
 [orecvday] [nvarchar](50) NULL,
 [omoneyok] [nvarchar](20) NULL,
 [oid] [nvarchar](20) NULL,
 [odate] [datetime] NULL
) ON [PRIMARY]