Personal Information Network Management System for Company Employees

Posted by vestax1984 on Thu, 15 Aug 2019 15:31:47 +0200

mysql Database Creation Statement of Personal Information Network Management System for Company Employees
Company employees personal information network management system oracle database creation statement
SQL Server database creation statement for company employees'personal information network management system

Company employees personal information network 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 table creation statement is as follows:

create table t_file_up(
	id int primary key auto_increment comment 'Primary key',
	customerId int comment '',
	toId int comment ''
) comment '';

The tag table creation statement is as follows:

create table t_bq(
	id int primary key auto_increment comment 'Primary key',
	content varchar(100) comment ''
) comment 'Label';

The order table creation statement is as follows:

create table t_order(
	id int primary key auto_increment comment 'Primary key',
	insertDate datetime comment '',
	status varchar(100) comment '',
	flag varchar(100) comment '',
	zpId int comment 'Main Key of Recruitment Form',
	fileUrl varchar(100) comment 'File Address',
	bqName varchar(100) comment 'Label',
	username varchar(100) comment 'Account number',
	password varchar(100) comment 'Password ',
	ptadminName varchar(100) comment 'Full name',
	age varchar(100) comment 'Age',
	sex varchar(100) comment 'Gender',
	phone varchar(100) comment 'Telephone',
	banjiName varchar(100) comment 'class',
	customerId int comment 'user',
	productDetail varchar(100) comment 'Detailed order'
) comment 'Order';

The class table creation statement is as follows:

create table t_banji(
	id int primary key auto_increment comment 'Primary key',
	allPrice varchar(100) comment 'Total Order Price'
) comment 'class';

The table creation statement is as follows:

create table t_liuyan(
	id int primary key auto_increment comment 'Primary key',
	status varchar(100) comment 'state',
	orderNum varchar(100) comment 'Order Number',
	pl varchar(100) comment 'Logistics Information',
	insertDate datetime comment 'date',
	userId int comment '',
	orderDate datetime comment ''
) comment '';

The general administrator table creation statement is as follows:

create table t_ptadmin(
	id int primary key auto_increment comment 'Primary key',
	address varchar(100) comment 'address',
	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 'General Administrator';

The public hearing table creation statement is as follows:

create table t_gktz(
	id int primary key auto_increment comment 'Primary key',
	productId int comment 'product',
	kcNum int comment 'Inventory Quantity',
	insertDate datetime comment 'date',
	sgxxName varchar(100) comment 'Accident Information Number',
	tzdd varchar(100) comment 'Place of hearing'
) comment 'public hearing';

The inventory table creation statement is as follows:

create table t_kc(
	id int primary key auto_increment comment 'Primary key',
	tzsj datetime comment 'Hearing time',
	fileUrl varchar(100) comment 'Records of Hearing Documents',
	sply varchar(100) comment 'Video recording'
) comment 'Stock';

Company employees personal information network 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 table creation statement is as follows:

create table t_file_up(
	id integer,
	customerId int,
	toId int
);
--Field annotation
comment on column t_file_up.id is 'Primary key';
comment on column t_file_up.customerId is '';
comment on column t_file_up.toId is '';
--Notes on tables
comment on table t_file_up is '';

The tag table creation statement is as follows:

create table t_bq(
	id integer,
	content varchar(100)
);
--Label field annotated
comment on column t_bq.id is 'Primary key';
comment on column t_bq.content is '';
--Label Table with Notes
comment on table t_bq is 'Label';

The order table creation statement is as follows:

create table t_order(
	id integer,
	insertDate datetime,
	status varchar(100),
	flag varchar(100),
	zpId int,
	fileUrl varchar(100),
	bqName varchar(100),
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	banjiName varchar(100),
	customerId int,
	productDetail varchar(100)
);
--Annotation of order field
comment on column t_order.id is 'Primary key';
comment on column t_order.insertDate is '';
comment on column t_order.status is '';
comment on column t_order.flag is '';
comment on column t_order.zpId is 'Main Key of Recruitment Form';
comment on column t_order.fileUrl is 'File Address';
comment on column t_order.bqName is 'Label';
comment on column t_order.username is 'Account number';
comment on column t_order.password is 'Password ';
comment on column t_order.ptadminName is 'Full name';
comment on column t_order.age is 'Age';
comment on column t_order.sex is 'Gender';
comment on column t_order.phone is 'Telephone';
comment on column t_order.banjiName is 'class';
comment on column t_order.customerId is 'user';
comment on column t_order.productDetail is 'Detailed order';
--Note the order form
comment on table t_order is 'Order';

The class table creation statement is as follows:

create table t_banji(
	id integer,
	allPrice varchar(100)
);
--Annotation of Class Fields
comment on column t_banji.id is 'Primary key';
comment on column t_banji.allPrice is 'Total Order Price';
--Annotation of Class Schedule
comment on table t_banji is 'class';

The table creation statement is as follows:

create table t_liuyan(
	id integer,
	status varchar(100),
	orderNum varchar(100),
	pl varchar(100),
	insertDate datetime,
	userId int,
	orderDate datetime
);
--Field annotation
comment on column t_liuyan.id is 'Primary key';
comment on column t_liuyan.status is 'state';
comment on column t_liuyan.orderNum is 'Order Number';
comment on column t_liuyan.pl is 'Logistics Information';
comment on column t_liuyan.insertDate is 'date';
comment on column t_liuyan.userId is '';
comment on column t_liuyan.orderDate is '';
--Notes on tables
comment on table t_liuyan is '';

The general administrator table creation statement is as follows:

create table t_ptadmin(
	id integer,
	address varchar(100),
	lxr varchar(100),
	lxfs varchar(100),
	pj varchar(100),
	back varchar(100),
	productId int
);
--Annotation of General Administrator Field
comment on column t_ptadmin.id is 'Primary key';
comment on column t_ptadmin.address is 'address';
comment on column t_ptadmin.lxr is 'Contacts';
comment on column t_ptadmin.lxfs is 'Contact information';
comment on column t_ptadmin.pj is 'evaluate';
comment on column t_ptadmin.back is 'Reply';
comment on column t_ptadmin.productId is '';
--Annotation of General Administrator Table
comment on table t_ptadmin is 'General Administrator';

The public hearing table creation statement is as follows:

create table t_gktz(
	id integer,
	productId int,
	kcNum int,
	insertDate datetime,
	sgxxName varchar(100),
	tzdd varchar(100)
);
--Annotation of Public Hearing Field
comment on column t_gktz.id is 'Primary key';
comment on column t_gktz.productId is 'product';
comment on column t_gktz.kcNum is 'Inventory Quantity';
comment on column t_gktz.insertDate is 'date';
comment on column t_gktz.sgxxName is 'Accident Information Number';
comment on column t_gktz.tzdd is 'Place of hearing';
--Annotation of the Public Hearing Form
comment on table t_gktz is 'public hearing';

The inventory table creation statement is as follows:

create table t_kc(
	id integer,
	tzsj datetime,
	fileUrl varchar(100),
	sply varchar(100)
);
--Annotation of Inventory Field
comment on column t_kc.id is 'Primary key';
comment on column t_kc.tzsj is 'Hearing time';
comment on column t_kc.fileUrl is 'Records of Hearing Documents';
comment on column t_kc.sply is 'Video recording';
--Notes to Inventory Statement
comment on table t_kc is 'Stock';

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

create sequence s_t_file_up;
create sequence s_t_bq;
create sequence s_t_order;
create sequence s_t_banji;
create sequence s_t_liuyan;
create sequence s_t_ptadmin;
create sequence s_t_gktz;
create sequence s_t_kc;

The company employee personal information network management system SQL Server 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 table creation statement is as follows:

--Notes to tables
create table t_file_up(
	id int identity(1,1) primary key not null,--Primary key
	customerId int,--
	toId int--
);

The tag table creation statement is as follows:

--Notes to Tag Table
create table t_bq(
	id int identity(1,1) primary key not null,--Primary key
	content varchar(100)--
);

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
	insertDate datetime,--
	status varchar(100),--
	flag varchar(100),--
	zpId int,--Main Key of Recruitment Form
	fileUrl varchar(100),--File Address
	bqName varchar(100),--Label
	username varchar(100),--Account number
	password varchar(100),--Password 
	ptadminName varchar(100),--Full name
	age varchar(100),--Age
	sex varchar(100),--Gender
	phone varchar(100),--Telephone
	banjiName varchar(100),--class
	customerId int,--user
	productDetail varchar(100)--Detailed order
);

The class table creation statement is as follows:

--Annotation of Class Schedule
create table t_banji(
	id int identity(1,1) primary key not null,--Primary key
	allPrice varchar(100)--Total Order Price
);

The table creation statement is as follows:

--Notes to tables
create table t_liuyan(
	id int identity(1,1) primary key not null,--Primary key
	status varchar(100),--state
	orderNum varchar(100),--Order Number
	pl varchar(100),--Logistics Information
	insertDate datetime,--date
	userId int,--
	orderDate datetime--
);

The general administrator table creation statement is as follows:

--General Administrator Table Notes
create table t_ptadmin(
	id int identity(1,1) primary key not null,--Primary key
	address varchar(100),--address
	lxr varchar(100),--Contacts
	lxfs varchar(100),--Contact information
	pj varchar(100),--evaluate
	back varchar(100),--Reply
	productId int--
);

The public hearing table creation statement is as follows:

--Annotations to the Public Hearing Form
create table t_gktz(
	id int identity(1,1) primary key not null,--Primary key
	productId int,--product
	kcNum int,--Inventory Quantity
	insertDate datetime,--date
	sgxxName varchar(100),--Accident Information Number
	tzdd varchar(100)--Place of hearing
);

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
	tzsj datetime,--Hearing time
	fileUrl varchar(100),--Records of Hearing Documents
	sply varchar(100)--Video recording
);

Topics: network Database Oracle MySQL

Programmer Think

Personal Information Network Management System for Company Employees

Company employees personal information network management system mysql database version source code:

Company employees personal information network management system oracle database version source code:

The company employee personal information network management system SQL Server database version source code:

Hot Topics