Clblog Database Design

Design Introduction

• Complete the "Nine Gongge Diary-nine aspects of the details" information maintenance, need to store 10 kinds of data: Nine Gongge Diary, today's situation, tomorrow work three important matters, financial management, the most successful five things, emotional contact, skills upgrading, goals achieved, health status, information collation.
• Nine Gongge diary table structure design:
• Table Name: Diaryinfo
• Journal title: Dtitle
• Weather: Dweather
• Date: Ddate
• Time: Dtime
• Wake Up Time: Drisetime
• Length of sleep: Dsleeptimelong
• Daily inspiration: Dinsights
• today's situation : Dtoday
• Three things to do tomorrow: Dtomorrow
• Money: Dmoney
• The five most successful things: dsuccess
• Emotional Contact: dfeelings
• Skill Enhancement: Dskill
• Target achieved: Dtarget
• Health status: Dhealth
• Information collation: Dinfo
• today's Status table structure design:
• Table Name: Todayinfo
• Time Use situation: Todtime
• Working life situation: Todwork
• Remark: Todremark
• Nine Gongge Diary: Toddiary
• Three things to do tomorrow. Table Structure Design:
• Table Name: Tomorrowinfo
• First frog: Tomone
• Second frog: Tomtwo
• Third frog: Tomthree
• Remark: Tomremark
• Nine Gongge Diary: Tomdiary
• Financial statement Structure Design:
• Table Name: Moneyinfo
• READ: monreading
• What to learn: Monstudy
• Bookkeeping: Monaccount
• Remark: Monremark
• Nine Gongge Diary: Mondiary
• The most successful five things table structure design:
• Table Name: Successinfo
• First thing: Sucone
• The second thing: Suctwo
• The third thing: Sucthree
• Fourth thing: Sucfour
• Fifth thing: Sucfive
• Remark: Sucremark
• Nine Gongge Diary: Sucdiary
• Emotional contact sheet Structure design:
• Table Name: Feelingsinfo
• Family: feefamily
• Friend: Feefriend
• Special Person: feespecial
• Emotional gain: Feegains
• Remark: Feeremark
• Nine Gongge Diary: Feediary
• Skill Lift Table Structure design:
• Table Name: SkillInfo
• Creative: Skicreat
• Interests: Skiinterest
• Special training Situation: Skitrain
• Remark: Skiremark
• Nine Gongge Diary: Skidiary
• Objective to achieve the table structure of the design:
• Table Name: Targetinfo
• Progress: Tarprogress
• Insufficient: Tarinsufficient
• Remark: Tarremark
• Nine Gongge Diary: Tardiary
• Health state table Structure design:
• Table Name: Healthinfo
• Physical condition: Heabody
• Food condition: Headiet
• Workout situation: Heaexercise
• Remark: Hearemark
• Nine Gongge Diary: Diary
• Structure design of Information collation table:
• Table Name: Infoinfo
• Important Information: Infimportant
• READ: Infread
• Writing: Infwrite
• Remark: Infremark
• Nine Gongge Diary: Infdiary
• Primary table-child tables have a one-to-one relationship

Clblog Database Design