Student Comprehensive Evaluation System

Keywords: Mobile Database Oracle MySQL

Student Comprehensive Evaluation System

The source code of mysql database version of student comprehensive evaluation system:

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 recommended table creation statement is as follows:

create table t_contact(
	id int primary key auto_increment comment 'Primary key',
	username varchar(100) comment 'Account number',
	password varchar(100) comment 'Password',
	name varchar(100) comment 'Full name',
	gh varchar(100) comment 'Job number'
) comment 'proposal';

The order details table creation statement is as follows:

create table t_orderlist(
	id int primary key auto_increment comment 'Primary key',
	mobile varchar(100) comment 'Mobile phone',
	title varchar(100) comment 'Title',
	content varchar(100) comment 'content',
	pic varchar(100) comment 'picture',
	customerId int comment 'user',
	orderId int comment 'Order',
	productId int comment 'variety of dishes',
	sl int comment '',
	productName varchar(100) comment '',
	price int comment '',
	productPic1 varchar(100) comment '',
	xj varchar(100) comment ''
) comment 'Order details';

My message table creation statement is as follows:

create table t_wdxx(
	id int primary key auto_increment comment 'Primary key',
	content varchar(100) comment '',
	plDate datetime comment '',
	pic varchar(100) comment '',
	customerName varchar(100) comment '',
	customerId int comment 'user',
	phone varchar(100) comment 'Contact information',
	content varchar(100) comment 'content',
	insertDate datetime comment 'date'
) comment 'My news';

Classification table creation statement is as follows:

create table t_types(
	id int primary key auto_increment comment 'Primary key',
	customerId int comment 'I'
) comment 'classification';

The order table creation statement is as follows:

create table t_order(
	id int primary key auto_increment comment 'Primary key',
	title varchar(100) comment 'Title',
	pic varchar(100) comment 'picture',
	content varchar(100) comment 'content',
	zan int comment 'Fabulous',
	insertDate datetime comment 'Date of publication',
	nologin varchar(100) comment 'Visibility of tourists',
	bkId int comment '',
	typesName varchar(100) comment 'classification',
	customerId int comment 'user',
	productDetail varchar(100) comment 'Detailed order',
	allPrice varchar(100) comment 'Total Order Price',
	status varchar(100) comment 'state',
	orderNum varchar(100) comment 'Order Number',
	pl varchar(100) comment 'Logistics Information',
	insertDate datetime comment 'date'
) comment 'Order';

The information table creation statement is as follows:

create table t_zx(
	id int primary key auto_increment comment 'Primary key',
	userId int comment '',
	orderDate varchar(100) comment '',
	address varchar(100) comment 'address'
) comment 'information';

The general staff table creation statement is as follows:

create table t_user(
	id int primary key auto_increment comment 'Primary key',
	lxr varchar(100) comment 'Contacts',
	lxfs varchar(100) comment 'Contact information',
	pj varchar(100) comment 'evaluate',
	back varchar(100) comment 'Reply',
	productId int comment ''
) comment 'Ordinary staff';

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',
	num int comment 'Number',
	customerId int comment ''
) comment 'Shopping Cart';

The source code of oracle database version of student comprehensive evaluation system:

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 recommended table creation statement is as follows:

create table t_contact(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	gh varchar(100)
);
--Recommended fields with comments
comment on column t_contact.id is 'Primary key';
comment on column t_contact.username is 'Account number';
comment on column t_contact.password is 'Password';
comment on column t_contact.name is 'Full name';
comment on column t_contact.gh is 'Job number';
--Notes to the table of suggestions
comment on table t_contact is 'proposal';

The order details table creation statement is as follows:

create table t_orderlist(
	id integer,
	mobile varchar(100),
	title varchar(100),
	content varchar(100),
	pic varchar(100),
	customerId int,
	orderId int,
	productId int,
	sl int,
	productName varchar(100),
	price int,
	productPic1 varchar(100),
	xj varchar(100)
);
--Note the order details field
comment on column t_orderlist.id is 'Primary key';
comment on column t_orderlist.mobile is 'Mobile phone';
comment on column t_orderlist.title is 'Title';
comment on column t_orderlist.content is 'content';
comment on column t_orderlist.pic is 'picture';
comment on column t_orderlist.customerId is 'user';
comment on column t_orderlist.orderId is 'Order';
comment on column t_orderlist.productId is 'variety of dishes';
comment on column t_orderlist.sl is '';
comment on column t_orderlist.productName is '';
comment on column t_orderlist.price is '';
comment on column t_orderlist.productPic1 is '';
comment on column t_orderlist.xj is '';
--Annotation of Order Details Table
comment on table t_orderlist is 'Order details';

My message table creation statement is as follows:

create table t_wdxx(
	id integer,
	content varchar(100),
	plDate datetime,
	pic varchar(100),
	customerName varchar(100),
	customerId int,
	phone varchar(100),
	content varchar(100),
	insertDate datetime
);
--Annotate my message field
comment on column t_wdxx.id is 'Primary key';
comment on column t_wdxx.content is '';
comment on column t_wdxx.plDate is '';
comment on column t_wdxx.pic is '';
comment on column t_wdxx.customerName is '';
comment on column t_wdxx.customerId is 'user';
comment on column t_wdxx.phone is 'Contact information';
comment on column t_wdxx.content is 'content';
comment on column t_wdxx.insertDate is 'date';
--Annotate my message sheet
comment on table t_wdxx is 'My news';

Classification table creation statement is as follows:

create table t_types(
	id integer,
	customerId int
);
--Annotation of Classification Fields
comment on column t_types.id is 'Primary key';
comment on column t_types.customerId is 'I';
--Annotation of Classification Table
comment on table t_types is 'classification';

The order table creation statement is as follows:

create table t_order(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	zan int,
	insertDate datetime,
	nologin varchar(100),
	bkId int,
	typesName varchar(100),
	customerId int,
	productDetail varchar(100),
	allPrice varchar(100),
	status varchar(100),
	orderNum varchar(100),
	pl varchar(100),
	insertDate datetime
);
--Annotation of order field
comment on column t_order.id is 'Primary key';
comment on column t_order.title is 'Title';
comment on column t_order.pic is 'picture';
comment on column t_order.content is 'content';
comment on column t_order.zan is 'Fabulous';
comment on column t_order.insertDate is 'Date of publication';
comment on column t_order.nologin is 'Visibility of tourists';
comment on column t_order.bkId is '';
comment on column t_order.typesName is 'classification';
comment on column t_order.customerId is 'user';
comment on column t_order.productDetail is 'Detailed order';
comment on column t_order.allPrice is 'Total Order Price';
comment on column t_order.status is 'state';
comment on column t_order.orderNum is 'Order Number';
comment on column t_order.pl is 'Logistics Information';
comment on column t_order.insertDate is 'date';
--Note the order form
comment on table t_order is 'Order';

The information table creation statement is as follows:

create table t_zx(
	id integer,
	userId int,
	orderDate varchar(100),
	address varchar(100)
);
--Annotation of Information Fields
comment on column t_zx.id is 'Primary key';
comment on column t_zx.userId is '';
comment on column t_zx.orderDate is '';
comment on column t_zx.address is 'address';
--Notes to Information Sheet
comment on table t_zx is 'information';

The general staff table creation statement is as follows:

create table t_user(
	id integer,
	lxr varchar(100),
	lxfs varchar(100),
	pj varchar(100),
	back varchar(100),
	productId int
);
--Annotation of General Employee Field
comment on column t_user.id is 'Primary key';
comment on column t_user.lxr is 'Contacts';
comment on column t_user.lxfs is 'Contact information';
comment on column t_user.pj is 'evaluate';
comment on column t_user.back is 'Reply';
comment on column t_user.productId is '';
--Annotation of General Staff Statement
comment on table t_user is 'Ordinary staff';

The shopping cart table creation statement is as follows:

create table t_shopcar(
	id integer,
	productId int,
	num int,
	customerId int
);
--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.num is 'Number';
comment on column t_shopcar.customerId is '';
--Comments on shopping cart list
comment on table t_shopcar is 'Shopping Cart';

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

create sequence s_t_contact;
create sequence s_t_orderlist;
create sequence s_t_wdxx;
create sequence s_t_types;
create sequence s_t_order;
create sequence s_t_zx;
create sequence s_t_user;
create sequence s_t_shopcar;

The source code of SQL Server database version of student comprehensive evaluation system:

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 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
	username varchar(100),--Account number
	password varchar(100),--Password
	name varchar(100),--Full name
	gh varchar(100)--Job number
);

The order details table creation statement is as follows:

--Notes to Order Details Table
create table t_orderlist(
	id int identity(1,1) primary key not null,--Primary key
	mobile varchar(100),--Mobile phone
	title varchar(100),--Title
	content varchar(100),--content
	pic varchar(100),--picture
	customerId int,--user
	orderId int,--Order
	productId int,--variety of dishes
	sl int,--
	productName varchar(100),--
	price int,--
	productPic1 varchar(100),--
	xj varchar(100)--
);

My message table creation statement is as follows:

--My Message Table Comments
create table t_wdxx(
	id int identity(1,1) primary key not null,--Primary key
	content varchar(100),--
	plDate datetime,--
	pic varchar(100),--
	customerName varchar(100),--
	customerId int,--user
	phone varchar(100),--Contact information
	content varchar(100),--content
	insertDate datetime--date
);

Classification table creation statement is as follows:

--Annotation of Classification Table
create table t_types(
	id int identity(1,1) primary key not null,--Primary key
	customerId int--I
);

The order table creation statement is as follows:

--Notes to the order form
create table t_order(
	id int identity(1,1) primary key not null,--Primary key
	title varchar(100),--Title
	pic varchar(100),--picture
	content varchar(100),--content
	zan int,--Fabulous
	insertDate datetime,--Date of publication
	nologin varchar(100),--Visibility of tourists
	bkId int,--
	typesName varchar(100),--classification
	customerId int,--user
	productDetail varchar(100),--Detailed order
	allPrice varchar(100),--Total Order Price
	status varchar(100),--state
	orderNum varchar(100),--Order Number
	pl varchar(100),--Logistics Information
	insertDate datetime--date
);

The information table creation statement is as follows:

--Information sheet notes
create table t_zx(
	id int identity(1,1) primary key not null,--Primary key
	userId int,--
	orderDate varchar(100),--
	address varchar(100)--address
);

The general staff table creation statement is as follows:

--Notes to the General Staff Statement
create table t_user(
	id int identity(1,1) primary key not null,--Primary key
	lxr varchar(100),--Contacts
	lxfs varchar(100),--Contact information
	pj varchar(100),--evaluate
	back varchar(100),--Reply
	productId int--
);

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
	num int,--Number
	customerId int--
);

Posted by michaellunsford on Mon, 26 Aug 2019 22:33:12 -0700

Hot Keywords

©2024 Programmer Group