table.sql

基于JSP的网上购物系统,包含数据库DB设计文档

CREATE TABLE `tbs001` (
  `Tbs001_inc` int unsigned NOT NULL auto_increment,
  `Id` varchar(20) NOT NULL,
  `nickname` varchar(40) not null,
  `pwd` Varchar(60) NOT NULL,
  `Email` Varchar(60) NOT NULL,
  `Name` Varchar(40),
  `Address` Varchar(100),
   zipcode char(6),
  `Tel` Varchar(40),
   fax varchar(40),
  `Mobilephone` Varchar(40),
  `birthday` date,
  `vocation` varchar(40),
  `Create_time` Datetime NOT NULL,
  `Log_time` Datetime NOT NULL,
  `Type` int NOT NULL default 0,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tbs001_inc`,`id`,`nickname`)
) TYPE=MyISAM;

CREATE TABLE `tbs002` (
  `Tbs002_inc` int unsigned NOT NULL auto_increment,
  `Name` varchar(50) NOT NULL,
  `parentid` int NOT NULL default 0,
  Is_banner char(2) not null default '00',
   Sort int not null default 100,
  `Status` Char(2) NOT NULL default '00',
  PRIMARY KEY  (`tbs002_inc`)
) TYPE=MyISAM;


CREATE TABLE `tbs003` (
  `Tbs003_inc` int unsigned NOT NULL auto_increment,
  `Tbs001_inc` int NOT NULL,
   Tbs002_inc int NOT NULL,
  `parentid` int NOT NULL,
   author varchar(40) not null,
   Title varchar(100) not null,
   url varchar(150) not null default '0',
   Is_banner char(2) not null default '00',
   Article_type char(2) not null default '00',
   pick varchar(100) ,
   Content text not null,
   Create_time Datetime not null ,
   type Char(2) default '00',
   url_type Char(1) not null default 0,
   Sort int not null default 100,
  `Status` Char(2) NOT NULL default '00',
  PRIMARY KEY  (`tbs003_inc`)
) TYPE=MyISAM;

CREATE TABLE tbs004 (
  Tbs004_inc int unsigned NOT NULL auto_increment,
  Tbs001_inc int NOT NULL,
   nickname varchar(40),
  Tbs003_inc int NOT NULL,
   Content Text not null,
   ip varchar(20) not null,
   sort int not null default 100,
   Create_time Datetime not null ,
  Status Char(2) NOT NULL default '00',
  PRIMARY KEY  (tbs004_inc)
) TYPE=MyISAM;


CREATE TABLE `tbs005` (
  `Tbs005_inc` int unsigned NOT NULL auto_increment,
  `id` varchar(20) NOT NULL,
   title varchar(100) not null,
   Content Text not null,
   Low_valid_date date not null,
   Hight_valid_date date not null,
   sort int not null default 100,
   Create_time Datetime not null ,
  `Status` Char(2) NOT NULL default '00',
  PRIMARY KEY  (`tbs005_inc`)
) TYPE=MyISAM;

CREATE TABLE `tbs006` (
  `Tbs006_inc` int unsigned NOT NULL auto_increment,
  `id` varchar(20) NOT NULL,
   brief varchar(200) not null,
   web_url varchar(150) not null,
   image_url varchar(150) not null,
   type char(2) not null,
   sort int not null,
   Create_time Datetime not null ,
  `Status` Char(2) NOT NULL default '00',
  PRIMARY KEY  (`tbs006_inc`)
) TYPE=MyISAM;





CREATE TABLE `tbs051` (
  `Tbs051_inc` int unsigned NOT NULL auto_increment,
  `Catalog_id` int NOT NULL,
  `name` varchar(255) not null,
  `Keywords` Varchar(50) NOT NULL,
   brief varchar(200) not null,
  `Product_intr` Text NOT NULL,
  `manufacturer` Varchar(100),
   market_price int,
  `Price` int,
  `Member_price` int,
   cost_price int,
  `Currency_id` Char(5) not null,
  `Type` Char(2)  not null,
   position char(2) not null,
  `is_supply` Char(2)  not null default '00',
  `Create_id` Char(20),
  `Create_date` DATETIME NOT NULL,
   update_date Datetime,
   update_id varchar(20),
   Sort int default 100,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tbs051_inc`)
) TYPE=MyISAM;



CREATE TABLE `tbs052` (
  `Tbs052_inc` int unsigned NOT NULL auto_increment,  
  `Tbs051_inc` int,  
   Img_url varchar(150),
   brief varchar(200),
   Position char(10),
  `Create_id` Char(20),
  `Create_time` DATEtime NOT NULL,
   Sort int default 100,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tbs052_inc`)
) TYPE=MyISAM;


CREATE TABLE `tbs053` (
  `Tbs053_inc` int unsigned NOT NULL auto_increment,  
  `Tbs051_inc` int,  
   title varchar(50),
   content text,
   Ip varchar(20),
  `Create_id` Char(20),
  `Create_time` DATEtime NOT NULL,
  `update_time` DATEtime NOT NULL,
   Sort int default 100,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tbs053_inc`)
) TYPE=MyISAM;


CREATE TABLE `tbs053` (
  `Tbs053_inc` int unsigned NOT NULL auto_increment,  
  `Tbs052_inc` int,  
   Title varchar(50),
   Content varchar(255),
  `id` varchar(20),
  `Create_date` DATE NOT NULL,
   Sort int default 100,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tbs053_inc`)
) TYPE=MyISAM;

CREATE TABLE `tap001` (
  `Tap001_inc` int unsigned NOT NULL auto_increment,
   tbs051_inc int not null,
  `Goodsname` varchar(255) NOT NULL,
   Member_rice int not null,
   Access_price int not null,
   Cost_price int not null,
   Ordernum int not null,
   Membertotalprice int not null,
   Totalprice int not null,
   costtotalprice int not null,
   Confirm_type Char(2) not null,
   Pay_type Char(2) not null,
   remark text,   
  `nickname` varchar(40) not null, 
  `Email` Varchar(60) NOT NULL,
  `Name` Varchar(40),
  `Address` Varchar(100),
   zipcode char(6),
  `Tel` Varchar(40),
   fax varchar(40),
  `Mobilephone` Varchar(40),
  `Create_time` Datetime NOT NULL,
   Create_id varchar(20) not null,
  `update_time` Datetime NOT NULL,
   update_id varchar(20),
  `reason` text,
   sendgoods char(2),
  `Status` Char(5) NOT NULL,
  PRIMARY KEY  (`tap001_inc`)
) TYPE=MyISAM;



CREATE TABLE `tcd001` (
  `Tcd001_inc` int unsigned NOT NULL auto_increment,  
  `Name` varchar(50) not null,  
   Sort int not null default 100,   
  `Is_banner` char(2) not null,
   Positon char(10) not null,
   Parentid int not null,
   Create_time datetime not null,
   create_id varchar(20) not null,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tcd001_inc`)
) TYPE=MyISAM;



CREATE TABLE `tcd002` ( 
   id char(2) not null,
  `Name` varchar(50) not null, 
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE `tcd003` (
   typeid char(2) not null,  
  `Name` varchar(50) not null,   
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (typeid)
) TYPE=MyISAM;



CREATE TABLE `tcd004` (
   typeid char(5) not null,  
  `Name` varchar(50) not null,   
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (typeid)
) TYPE=MyISAM;


CREATE TABLE `tsy001` (
  `Tsy001_inc` int unsigned NOT NULL auto_increment,  
  `id` varchar(20),  
   Name varchar(50),
   pwd varchar(60),
  `Create_date` DATE NOT NULL,
   type int default 0,
   Sort int default 100,
  `Status` Char(2) NOT NULL,
  PRIMARY KEY  (`tsy001_inc`,id)
) TYPE=MyISAM;