club_launch
value: clid int not nullvalue: uid int not null
activity_involvement
value: aid int not nullvalue: uid int not null
club
primary key: clid int auto_incrementvalue: title varchar(255) not nullvalue: descriptiont textvalue: startdate datevalue: wathcingCnt bigint default 0value: managerCnt bigint default 0value: levelRestriction bigint
track
primary key: tid int auto_incrementvalue: title varchar(255) not nullvalue: content textvalue: date datevalue: agreeCnt bigint default 0foreign key: uid
trackReview
primary key: trid int auto_incrementvalue: content textvalue: date datevalue: reviewerid bigintforeign key: tidforeign key: uid
clubTopic
primary key: cltid int auto_incrementvalue: title varchar(255) not nullvalue: content textvalue: date datevalue: levelRestriction bigintforeign key uid
friendNews
primary key: fnid int auto_incrementforeign key: fidvalue: content textvalue: date date
activity_launch
sport_data
primay key: did int auto_incrementvalue: runmiles bigint default 0value: stairs bigint default 0value: stepCnt bigint default 0value: energy bigint defalut 0value: joiningTime bigint default 0value: totalRun bigint default 0value: totalStairs bigint default 0value: totalEnergy bigint default 0value: totalStepCnt bigint default 0value: runAnalysis textvalue: stairAnalysis textvalue: energyAnalysis textvalue: coachOverview textvalue: doctorOverview textvalue: date dateforeign key: uid
clubTopicReview
primary key: cltrid int auto_incrementvalue: content textvalue: date datevalue: levelRestriction bigintforeign key uid
hobby
primary key: hid intvalue: content textforeign key: uid
friend
primary key: fid int auto_incrementforeign key: uidvalue: oid(origin user id)
activity
primary key: aid int auto_incrementvalue: title varchar(255) not nullvalue: content textvalue: startdate datevalue: enddate datevalue: involvementCnt bigint default 0value: laucherCnt bigint default 0value: state bigint
person_data
primay key: did int auto_incrementvalue: height bigint default 0value: weight bigint default 0value: fatrate float default 0value: date dateforeign key: uid
trackAgree
primary key: taid int auto_incrementvalue: date datevalue: agreerid intforeign key: tidforeign key: uid
user
primary key: uid int auto_incrementvalue: birthday varchar(255)value: location varchar(255)value: portrait textvalue: nickname varchar(255) not nullvalue: email_address varchar(255) not nullvalue: password text not nullvalue: motto textvalue: couchid int default -1value: doctorid int default -1value: rightLevel intvalue: gender int
