Why are you learning a language? Even if you talk about synchronization with Honne base, it's different for each person.
I am also one who wants to make the same Nanika as you.
Well, it's good to meet. I felt that December 25th was coming up, but I didn't have a partner, so I was alone this year.
An app that everyone has registered like LINE? Isn't it? Then I could approach that cute girl standing in front of Hachiko. (On the contrary, problem ant? Lol)
LINE can be done even by minors, but dating is R18. Please do not take a closer look at good children, including those hits.
Now, let's start the defense record of the Heppoko programmer.
** It is better for nearby people to understand by location information and distance ** For example, even if you enclose it in "Hokkaido", if it is far away, it will end up as just a chat partner However, it's a little bit to pin it on Google Maps.
** Are you aiming for AI? ** ** Is it Python? No Java. I want to do machine learning, but I don't feel like I can go that far. It would be nice if we could put out compatibility (◎ heaven O-net?) Depending on the degree of matching of each other's hobbies. At this stage, it seems a little impossible, so I will aim for hobby search.
** Because it is a global society ** There are languages and countries of origin. Sexual orientation is also global. I also want to chat with a white man with blonde hair. If you can filter by the country you want to go to or location information "I'm going on a trip in May, so if you like, you can have a meal." Let's make the first goal to complete it in Japanese (laughs)
UI? UX? There is no choice but to choose a country, but if possible, use radiobtn rather than combo! When entering, you have to tap (1) combo (2) select an item twice in total. In that respect, I heard that radio is good because you can select it with just one push. When it comes to UI design and UX, I think it's still a long way off ...
First of all, it's a database. I don't want to make a big update to expand the function later, so I want to put it all out now!
The following is the information received from various places. Questions will be written in the section below. If you have an opinion that "this is the person here", we welcome your comments!
** Public information ** ・ Name --VARCHAR (12) ** NOT NULL ** // Name or nickname ・ Pic1 --TEXT (-) ** NULL ** // Photo upload cloud URL (up to 5) ref.1 ・ Sex --INT (2) ** NOT NULL ** // Gender [01. Male 02. Female] ・ Sexual --INT (2) ** NOT NULL ** [01.Straight 02.Les 03.Gay 04.Bi 05.Trans 06.Queer 07.X 08.asexual 09.IS] ・ IntSex --INT (2) ** NOT NULL ** // Target [01. Male 02. Female 03. Bi… Hmm? ] ・ Height --INT (3) ** NOT NULL ** // Height ・ Weight --INT (3) ** NOT NULL ** // Weight ・ Birthday --DATE (8) ** NOT NULL ** // Birthday ・ Location --GEOMETRY (-) ** NULL ** // Location information ref.2 ・ Local --VARCHAR (12) ** NULL ** // Place of residence ・ Country --INT (3) ** NOT NULL ** // Hometown 365 countries ・ Lang --SET? ENUM? ** NOT NULL ** // Language ref.3 ref.4 ・ Body --INT (2) ** NOT NULL ** // System [01. Skinny 02. Normal 03. Muscular 04. Chubby] ・ Married --INT (2) ** NOT NULL ** [01. Married 02. Single] ・ Child --INT (2) ** NOT NULL ** [01. With children 02. No children] ・ Profile --VARCHAR (120) ** NOT NULL ** // Self-introduction
** Private information ** ・ UID (UUID) --BINARY (16) ** NOT NULL ** // User ID ref.5 -EAddress --VARCHAR (256) ** NOT NULL ** ref.6 ・ PW --VARCHAR (256) ** NOT NULL ** // SHA256 ・ Userlvl --INT (3) ** NOT NULL ** // User level [01. Free member 02. Paid member] · LatestLogin --Timestamp (-) ** NOT NULL ** // Last login date
** SNS cooperation ** ・ Twitter --VARCHAR (15) ** NULL ** ref.7 ・ Facebook --INT (128) ** NULL ** ref.8 [ref.9](https://stackoverflow. com / questions / 7566672 / whats-the-max-length-of-a-facebook-uid) ・ Instagram --VARCHAR (30) ** NULL ** ref.10 ・ LINE --VARCHAR (20) ** NULL ** ref.11
** Maybe there was something like this ** -PrivateInfo1- ?? ** NULL ** // User list that published private images (by myself) -PrivateInfo2- ?? ** NULL ** // User list showing (I) published a private profile · BlockedUser-?? ** NULL ** // List of blocked users ・ FootPrint-?? ** NULL ** // People who have footprints
** Search for hobbies ** ・ Aim --INT (2) ** NOT NULL ** [01. Recruiting friends 02. Recruiting lovers 03. Recruiting marriage partners 04. Sefu r ...] ・ Holiday --INT (2) ** NOT NULL ** [01. Saturdays, Sundays, and holidays 02.Saturdays and Sundays 03.Weekdays 04.Irregular] ・ Academic --INT (2) ** NOT NULL ** [01. Middle 02. High 03. Large 04. Master 05. Doctor] ・ Occupation --INT (2) ** NOT NULL ** [01. Civil servant 02. Freelance 03.IT 04. Medical ...] ref.12 ・ Income --INT (5) ** NULL ** // Annual income (10,000 yen) ・ Smoke --INT (2) ** NOT NULL ** [01. Smoking 02. Smoking cessation 03. Occasionally smoking] ・ Alcohol --INT (2) ** NOT NULL ** [01. Drink daily 02. Drink often 03. Occasionally 04. Rarely 05. Can't drink] ・ Hobby --SET? ENUM? ** NOT NULL ** // Hobbies
** Registration of multiple items ** I think that it should be implemented in multiple items, such as [hobbies], [blocklists], and [footprints]. If it's a hobby, block list is a way to register a UUID. Is it okay to use SET type or ENUM type? How do you reflect the person who blocked it? (Extract with SQL → It will be slow if displayed ...)
** About message function ** I don't know how to implement the essential message function ... Save to database ...? I think it's a TEXT type? A new column for each person? With PHP! Even if it comes out by searching, I do not understand much. (I understand even PHP n ←)
This time, I thought about what I wanted to make and the background database. I heard that if you want to make something like this yourself, your motivation and knowledge will increase. I've never seen it before, so I thought I should try something like this.
It's a little content, but I think I'll continue unless it's banned. For the time being, thank you for reading the first and the end.
Well, there was also an article like this about gender. informative … That means that NOT NULL must be minimized! ??
to be continued Reference This is the page that I referred to in the above link. ref.1 5 mistakes that beginners tend to make when working with databases --yakst ref.2 How to start location-based services 5th Let's save location-based services (Part 1) -gihyo ref.3 Let's use MySQL's original ENUM / SET type --itmedia ref.4 SET type --dbonline ref.5 Using UUID with JPA + MySQL --qiita ref.6 What is the optimal varchar length for MySQL email addresses? --teratail ref.7 Maximum number of characters for Twitter user ID --operationservicebu diary ref.8 User Properties --facebook for developers ref.9 What's the max. length of a Facebook uid? - stackoverflow ref.10 Character Limit on Instagram Usernames - stackoverflow ref.11 How many characters can the LINE ID have? --Yahoo Answers ref.12 Occupation list --career garden ref.13 What you need to know before handling "gender" information in the system --qiita