The New Year has arrived, and to the season of gold, silver and four, presumably everyone is looking at the new opportunities, I wish you here to get the offer of the desired big factory, get their own satisfactory salary.
The cause of
It all started with a joke in the tech crowd
Group friends: after the year back to consider the job, to start the interview review, looking for a topic is very troublesome ah, really want to have a can at any time on the phone to see the topic of the APP or small program ah, the existing small program, such as XX planet topic too little.
Me: That oneself write one
Group friend: you line you go up, write after we give you a reward
I: just didn’t write react for a long time, I top I top, don’t forget your dozen reward is good
Technology selection
Background management system: ANTD Pro + UMI + DVA + React + TS
Small program: taro/uni-app
Back-end: mysql + egg + Redis + Sequlize
Interview questions data entry methods: 1. Manual entry; 2. Crawler data entry
Because the author intends to review in this way, he chooses manual data entry
The first day
The prototype design
So let’s do it. The first step is to draw a rough prototype
The main features I want to design include the following
Home page:
1. Look at the questions randomly
2. Leaderboards: leaderboards of users who read the most questions per week/month (may be cut)
3. Author :(most important function)
4. Subject fuzzy search
5. Question of the Day (may be cut)
6.
At present, the topic classification is divided into two levels, and the first level of classification is the topic type
The second level classification is the topic topic type of knowledge classification, such as CSS topic classification can have: layout, CSS animation, positioning problems, all kinds of horizontal center and vertical center problems and so on
Company set of questions:
1. Find out what the topic is and when it was asked
2. Search for different categories under different companies
My collection:
1. Query the user’s favorite topics, and can be queried according to the classification, also can consider a long list to display all, provide according to the type of search topic or according to the title of the title fuzzy search topic
2. Users upload questions and solutions to facilitate summary (personal mini program may not be allowed to publish, may be cut)
My interview (which may be canceled) :
1. Users upload interview information for easy management
2. A long list of interview records and status is displayed
The second day
Database table design
After completing the prototype design, the next day is to design the database table, my table structure design is like this:
On the third day
Back-end interface implementation
After completing the operations behind the database table, all we need to do is copy and paste to implement the back-end interface. So far, the following interface has been implemented temporarily:
