News Management System Based on WEB

• WEB-based news management system mysql database creation statement
• WEB-based news management system oracle database creation statement
• WEB-based news management system sqlserver database creation statement

WEB-based news management system mysql database version source code:

Super Administrator Table Creation Statement is as follows:

create table t_admin(
	id int primary key auto_increment comment 'Primary key',
	username varchar(100) comment 'Super Administrator Account',
	password varchar(100) comment 'Super Administrator Password'
) comment 'Super Administrator';
insert into t_admin(username,password) values('admin','123456');

The inventory table creation statement is as follows:

create table t_kc(
	id int primary key auto_increment comment 'Primary key',
	jfName varchar(100) comment 'Integral Product Name',
	jfCost int comment 'Integral quantity',
	jfPic varchar(100) comment 'Product pictures'
) comment 'Stock';

The shopping cart table creation statement is as follows:

create table t_shopcar(
	id int primary key auto_increment comment 'Primary key',
	productId int comment 'product',
	kcNum int comment 'Inventory quantity',
	insertDate datetime comment 'date'
) comment 'Shopping Cart';

The following statement is used to create the integral exchange product table:

create table t_jfdh(
	id int primary key auto_increment comment 'Primary key',
	customerId int comment 'user',
	phone varchar(100) comment 'Contact information',
	content varchar(100) comment 'content'
) comment 'Integral Exchange Products';

The recommended table creation statement is as follows:

create table t_contact(
	id int primary key auto_increment comment 'Primary key',
	insertDate datetime comment 'date',
	productId int comment 'product',
	num int comment 'Number',
	customerId int comment ''
) comment 'proposal';

WEB-based news management system oracle database version source code:

Super Administrator Table Creation Statement is as follows:

create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--Super Administrator Field Annotated
comment on column t_admin.id is 'Primary key';
comment on column t_admin.username is 'Super Administrator Account';
comment on column t_admin.password is 'Super Administrator Password';
--Super Administrator Table Annotated
comment on table t_admin is 'Super Administrator';

The inventory table creation statement is as follows:

create table t_kc(
	id integer,
	jfName varchar(100),
	jfCost int,
	jfPic varchar(100)
);
--Annotation of Inventory Field
comment on column t_kc.id is 'Primary key';
comment on column t_kc.jfName is 'Integral Product Name';
comment on column t_kc.jfCost is 'Integral quantity';
comment on column t_kc.jfPic is 'Product pictures';
--Notes to Inventory Statement
comment on table t_kc is 'Stock';

The shopping cart table creation statement is as follows:

create table t_shopcar(
	id integer,
	productId int,
	kcNum int,
	insertDate datetime
);
--Comments on shopping cart fields
comment on column t_shopcar.id is 'Primary key';
comment on column t_shopcar.productId is 'product';
comment on column t_shopcar.kcNum is 'Inventory quantity';
comment on column t_shopcar.insertDate is 'date';
--Comments on shopping cart list
comment on table t_shopcar is 'Shopping Cart';

The following statement is used to create the integral exchange product table:

create table t_jfdh(
	id integer,
	customerId int,
	phone varchar(100),
	content varchar(100)
);
--Annotation of Integral Exchange Product Field
comment on column t_jfdh.id is 'Primary key';
comment on column t_jfdh.customerId is 'user';
comment on column t_jfdh.phone is 'Contact information';
comment on column t_jfdh.content is 'content';
--Notes on the Points Exchange Product List
comment on table t_jfdh is 'Integral Exchange Products';

The recommended table creation statement is as follows:

create table t_contact(
	id integer,
	insertDate datetime,
	productId int,
	num int,
	customerId int
);
--Recommended fields with comments
comment on column t_contact.id is 'Primary key';
comment on column t_contact.insertDate is 'date';
comment on column t_contact.productId is 'product';
comment on column t_contact.num is 'Number';
comment on column t_contact.customerId is '';
--Notes to the table of suggestions
comment on table t_contact is 'proposal';

oracle is unique, and the corresponding sequence is as follows:

create sequence s_t_kc;
create sequence s_t_shopcar;
create sequence s_t_jfdh;
create sequence s_t_contact;

WEB-based news management system sqlserver database version source code:

Super Administrator Table Creation Statement is as follows:

--Super Administrator
create table t_admin(
	id int identity(1,1) primary key not null,--Primary key
	username varchar(100),--Super Administrator Account
	password varchar(100)--Super Administrator Password
);
insert into t_admin(username,password) values('admin','123456');

The inventory table creation statement is as follows:

--Notes to Inventory Statement
create table t_kc(
	id int identity(1,1) primary key not null,--Primary key
	jfName varchar(100),--Integral Product Name
	jfCost int,--Integral quantity
	jfPic varchar(100)--Product pictures
);

The shopping cart table creation statement is as follows:

--Comments on shopping cart list
create table t_shopcar(
	id int identity(1,1) primary key not null,--Primary key
	productId int,--product
	kcNum int,--Inventory quantity
	insertDate datetime--date
);

The following statement is used to create the integral exchange product table:

--Notes to the Product List of Integral Exchange
create table t_jfdh(
	id int identity(1,1) primary key not null,--Primary key
	customerId int,--user
	phone varchar(100),--Contact information
	content varchar(100)--content
);

The recommended table creation statement is as follows:

--Notes to the Recommendation Table
create table t_contact(
	id int identity(1,1) primary key not null,--Primary key
	insertDate datetime,--date
	productId int,--product
	num int,--Number
	customerId int--
);