2022工作学习等记录追踪_日工作记录追踪-CSDN博客

本文链接：https://blog.csdn.net/Edidaughter/article/details/122359213

1.建库

create DATABASE workRecord2022;

create DATABASE studyRecord2022;

2.相关建表语句

2.1 表tab_job_list

drop table tab_job_list;
create table tab_job_list_January
(
indexNum integer primary key AUTO_INCREMENT, 
trackingId varchar(20) not null unique, 
comment varchar(200) not null, 
linkman varchar(60),
belongTo varchar(40),
schedule varchar(10), 
ifDone varchar(1) 
);

2.2 表study_list_2022

drop table study_list_2022
create table study_list_2022
(
    indexNum integer primary key AUTO_INCREMENT, 
    targetNum int,
    trackingId varchar(20) not null unique, 
    author varchar(60),
    res_type varchar(10),
    comment varchar(200) not null, 
    start_date varchar(20),
    plan_end_date varchar(20),
    Times int,
    schedule varchar(10), 
    ifDone varchar(1) 
);

2.3 tab_keyWords_comments

create table tab_keyWords_comments
(
   indexNum integer primary key AUTO_INCREMENT, 
   abbreviation varchar(20) not null unique,
   comment varchar(200)
);
insert into tab_keyWords_comments(abbreviation,comment)VALUES('PA','Programming Assignment,编程作业');
insert into tab_keyWords_comments(abbreviation,comment)VALUES('IF','Instruction Fetch,取指');