# javaeefinal

**Repository Path**: Maywct/javaeefinal

## Basic Information

- **Project Name**: javaeefinal
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2023-12-27
- **Last Updated**: 2024-01-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# javaeefinal
create table t_depinfo
(
F_id      int auto_increment
primary key,
F_mail    char(30) null,
F_address char(64) null,
F_code    char(10) null
);

create table t_departmen
(
F_id        int auto_increment
primary key,
F_name      char(8) not null,
F_principal int     not null,
constraint FK_depInfo
foreign key (F_id) references t_depinfo (F_id)
);

create table t_position
(
F_id         int auto_increment
primary key,
F_name       char(12) not null,
F_department int      not null,
constraint FK_department
foreign key (F_department) references t_departmen (F_id)
);

create table t_role
(
f_id   int auto_increment
primary key,
f_name varchar(18) not null
);

create table t_supplier
(
f_id   int auto_increment
primary key,
f_name varchar(18) not null
);

create table t_goodinfo
(
f_goodId     int auto_increment
primary key,
f_goodName   varchar(18) not null,
f_supplierId int         not null,
f_price      int         not null,
constraint FK_goodInfo_supplier
foreign key (f_supplierId) references t_supplier (f_id)
);

create table t_user
(
F_id       int auto_increment
primary key,
F_username char(12)      not null,
F_logname  char(16)      not null,
F_Position int           not null,
F_password char(16)      not null,
F_status   int default 0 not null,
constraint FK_Position
foreign key (F_Position) references t_position (F_id)
);

create table t_clientinfo
(
F_userId   int auto_increment
primary key,
F_userName varchar(18) not null,
F_phone    int         not null,
F_adress   varchar(32) null,
F_email    varchar(32) null,
F_sex      varchar(2)  null,
constraint FK_clientInfo_user
foreign key (F_userId) references t_user (F_id)
);

create table t_order
(
F_orderId int auto_increment
primary key,
F_goodId  int        not null,
F_userId  int        not null,
F_price   int        not null,
F_date    date       not null,
F_state   varchar(8) not null,
F_update  date       not null,
constraint FK_order_goodInfo
foreign key (F_goodId) references t_goodinfo (f_goodId),
constraint FK_order_user
foreign key (F_userId) references t_user (F_id)
);

create table t_user_role_relationship
(
F_user_id int not null,
F_role_id int not null,
primary key (F_user_id, F_role_id),
constraint FK_user_role_relationship_role
foreign key (F_role_id) references t_role (f_id),
constraint FK_user_role_relationship_user
foreign key (F_user_id) references t_user (F_id)
);

create index FK_user_role_relationship_role_idx
on t_user_role_relationship (F_role_id);

create table t_userinfo
(
F_id       int auto_increment
primary key,
F_number   char(15)  null,
F_mail     char(30)  null,
F_describe char(255) null,
constraint FK_userInfo_user
foreign key (F_id) references t_user (F_id)
);

-- 插入数据语句 仅供测试参考
INSERT INTO t_depInfo (F_id, F_mail, F_address, F_code) VALUES
(1, 'hr@company.com', '上海市黄浦区人民广场100号', '200001'),
(2, 'finance@company.com', '北京市朝阳区建国门外大街1号', '100001'),
(3, 'it@company.com', '广州市天河区珠江新城花城大道', '510000'),
(4, 'marketing@company.com', '深圳市福田区福华路', '518000'),
(5, 'sales@company.com', '成都市武侯区锦华路', '610000'),
(6, 'support@company.com', '杭州市西湖区莫干山路', '310000'),
(7, 'engineering@company.com', '南京市建邺区江东中路', '210000'),
(8, 'research@company.com', '武汉市江汉区解放大道', '430000'),
(9, 'operations@company.com', '西安市雁塔区太白南路', '710000'),
(10, 'customer_service@company.com', '苏州市工业园区星湖街', '215000')

INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('华润万家');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('美宜佳');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('全家FamilyMart');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('7-Eleven');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('百佳');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('山姆');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('柳州螺蛳粉有限公司');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('MINISO');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('正佳广场');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('天河城');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('时尚天河');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('万菱汇');
INSERT INTO `decision_platform_db`.`t_supplier` (`f_name`) VALUES ('太古汇');

INSERT INTO `decision_platform_db`.`t_role` (`f_id`, `f_name`) VALUES ('1', '超级管理员');
INSERT INTO `decision_platform_db`.`t_role` (`f_id`, `f_name`) VALUES ('2', '系统管理员');
INSERT INTO `decision_platform_db`.`t_role` (`f_id`, `f_name`) VALUES ('3', '普通用户');

INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('1', '市场部', '1001');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('2', '财务部', '1002');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('3', '营销部', '1003');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('4', '研发部', '1004');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('5', '生产部', '1005');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('6', '技术部', '1006');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('7', '法规部', '1007');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('8', '采购部', '1008');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('9', '客服部', '1009');
INSERT INTO `decision_platform_db`.`t_departmen` (`F_id`, `F_name`, `F_principal`) VALUES ('10', '管理部', '1010');

INSERT INTO `decision_platform_db`.`t_goodinfo` (`f_goodId`, `f_goodName`, `f_supplierId`, `f_price`) VALUES ('1', '经典螺蛳粉', '1', '12');
INSERT INTO `decision_platform_db`.`t_goodinfo` (`f_goodId`, `f_goodName`, `f_supplierId`, `f_price`) VALUES ('2', '加量螺蛳粉', '2', '14');
INSERT INTO `decision_platform_db`.`t_goodinfo` (`f_goodId`, `f_goodName`, `f_supplierId`, `f_price`) VALUES ('3', '终极螺蛳粉', '3', '20');
INSERT INTO `decision_platform_db`.`t_goodinfo` (`f_goodId`, `f_goodName`, `f_supplierId`, `f_price`) VALUES ('4', '加肉螺蛳粉', '4', '16');
INSERT INTO `decision_platform_db`.`t_goodinfo` (`f_goodId`, `f_goodName`, `f_supplierId`, `f_price`) VALUES ('5', '特辣螺蛳粉', '5', '13');
INSERT INTO `decision_platform_db`.`t_goodinfo` (`f_goodId`, `f_goodName`, `f_supplierId`, `f_price`) VALUES ('6', '口味螺蛳粉', '6', '13');

INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('1', '产品经理', '1');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('2', '程序员', '2');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('3', '程序员', '3');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('4', '技术员', '4');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('5', '测试员', '5');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('6', '业务员', '6');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('7', '营销员', '7');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('8', '检查员', '8');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('9', '会计', '9');
INSERT INTO `decision_platform_db`.`t_position` (`F_id`, `F_name`, `F_department`) VALUES ('10', '财务管理员', '10');

INSERT INTO `decision_platform_db`.`t_user` (`F_id`, `F_username`, `F_logname`, `F_Position`) VALUES ('1', 'admin1', 'xc', '8');
INSERT INTO `decision_platform_db`.`t_user` (`F_id`, `F_username`, `F_logname`, `F_Position`) VALUES ('2', 'admin2', 'XiaoMing', '8');
INSERT INTO `decision_platform_db`.`t_user` (`F_id`, `F_username`, `F_logname`, `F_Position`) VALUES ('3', 'admin3', 'LiHua', '8');

INSERT INTO `decision_platform_db`.`t_userinfo` (`F_id`, `F_number`, `F_mail`, `F_describe`) VALUES ('1', '13611483115', '1097735927@qq.com', 'people');

INSERT INTO `decision_platform_db`.`t_clientinfo` (`F_userId`, `F_userName`, `F_phone`, `F_adress`, `F_email`, `F_sex`) VALUES ('1', 'admin1', '123456789', 'gpnu', 'test@company.com', '男');
INSERT INTO `decision_platform_db`.`t_clientinfo` (`F_userId`, `F_userName`, `F_phone`, `F_adress`, `F_email`, `F_sex`) VALUES ('2', 'admin2', '123456789', 'gpnu', 'test@company.com', '女');
INSERT INTO `decision_platform_db`.`t_clientinfo` (`F_userId`, `F_userName`, `F_phone`, `F_adress`, `F_email`, `F_sex`) VALUES ('3', 'admin3', '123456789', 'gpnu', 'test@company.com', '男');

INSERT INTO `decision_platform_db`.`t_order` (`F_orderId`, `F_goodId`, `F_userId`, `F_price`, `F_date`, `F_state`, `F_update`) VALUES ('1', '1', '1', '12', '2023-12-17 17:34:25', '完成', '2023-12-18 17:34:25');
INSERT INTO `decision_platform_db`.`t_order` (`F_orderId`, `F_goodId`, `F_userId`, `F_price`, `F_date`, `F_state`, `F_update`) VALUES ('2', '1', '2', '12', '2023-12-17 17:34:25', '取消', '2023-12-18 17:34:25');
INSERT INTO `decision_platform_db`.`t_order` (`F_orderId`, `F_goodId`, `F_userId`, `F_price`, `F_date`, `F_state`, `F_update`) VALUES ('3', '2', '2', '14', '2023-12-17 17:34:25', '退单', '2023-12-18 17:34:25');

INSERT INTO `decision_platform_db`.`t_user_role_relationship` (`F_user_id`, `F_role_id`) VALUES ('1', '1');
INSERT INTO `decision_platform_db`.`t_user_role_relationship` (`F_user_id`, `F_role_id`) VALUES ('2', '1');
INSERT INTO `decision_platform_db`.`t_user_role_relationship` (`F_user_id`, `F_role_id`) VALUES ('3', '1');