{"id":188,"date":"2018-05-04T13:59:42","date_gmt":"2018-05-04T12:59:42","guid":{"rendered":"http:\/\/generic.wordpress.soton.ac.uk\/kanton\/?p=188"},"modified":"2018-05-04T14:02:05","modified_gmt":"2018-05-04T13:02:05","slug":"database-design","status":"publish","type":"post","link":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/2018\/05\/04\/database-design\/","title":{"rendered":"Database design"},"content":{"rendered":"

\uff081\uff09User simple registration information table.<\/p>\n

Tb_customer<\/p>\n\n\n\n\n\n\n
Fields<\/td>\nType<\/td>\nKey<\/td>\n<\/td>\n<\/tr>\n
Customer_id<\/td>\nint<\/td>\nPK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Customer_password<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Customer_email<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\uff082\uff09Group information table<\/p>\n

Tb_group<\/p>\n\n\n\n\n\n\n\n\n
Fields<\/td>\nType<\/td>\nKey<\/td>\n<\/td>\n<\/tr>\n
Group_id<\/td>\nint<\/td>\nPK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Group_name<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Group_org<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Group_Date<\/td>\nDate<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Group_type<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

(3) Friend information table<\/p>\n

Tb_friend<\/p>\n\n\n\n\n\n\n\n
Fields<\/td>\nType<\/td>\nKey<\/td>\n<\/td>\n<\/tr>\n
Friend_id<\/td>\nint<\/td>\nPK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Friend_user<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Friend_Item<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Friend_name<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

(4) Race information table<\/p>\n

Tb_item<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Fields<\/td>\nType<\/td>\nKey<\/td>\n<\/td>\n<\/tr>\n
Item_id<\/td>\nint<\/td>\nPK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_group<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_startime<\/td>\nDate<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_endtime<\/td>\nDate<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_startprice<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_endprice<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_state<\/td>\nint<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
Item_number<\/td>\nint<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

(5) User details table<\/p>\n

Tb_user<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Fields<\/td>\nType<\/td>\nKey<\/td>\n<\/td>\n<\/tr>\n
User_id<\/td>\nint<\/td>\nPK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_name<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_email<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_tel<\/td>\nint<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_signature<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_gender<\/td>\nvarchar<\/td>\n–<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_item<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_friend<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_group<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n
User_customer<\/td>\nint<\/td>\nFK<\/td>\nNOT NULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\uff081\uff09User simple registration information table. Tb_customer Fields Type Key Customer_id int PK NOT NULL Customer_password varchar – NOT NULL Customer_email varchar – NOT NULL   \uff082\uff09Group information table Tb_group Fields Type Key Group_id int PK NOT NULL Group_name varchar – NOT NULL Group_org int FK NOT NULL Group_Date Date – NOT NULL Group_type varchar – … Continue reading Database design<\/span><\/a><\/p>\n","protected":false},"author":3005,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[21],"class_list":["post-188","post","type-post","status-publish","format-standard","hentry","category-technology-and-design","tag-database"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9O41e-32","_links":{"self":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/posts\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/users\/3005"}],"replies":[{"embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/comments?post=188"}],"version-history":[{"count":1,"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/posts\/188\/revisions"}],"predecessor-version":[{"id":189,"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/posts\/188\/revisions\/189"}],"wp:attachment":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/media?parent=188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/categories?post=188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/kanton\/wp-json\/wp\/v2\/tags?post=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}