php - MYSQLI database design/structure -

i don't have coding question more of structure related one.

if had site example allowed user sign up, login, , manage finances, or family photobook or whatever.(the job front end performing irrelevant) if have multiple users registering , creating there own accounts correct way store data? assume not have single table different users data proper create single table user logins automatically create new table exclusive each new user hold data related there personal login?

take online check book example, have table manages user logins during registration process automatically create table user hold data entries own check book. correct? if data requires multiple tables manage 1 particular users data?

also have links on proper database structure check out? not knowing correct terminology hindering searches.

thanks in advance!

do not create table each user, create 1 table keyed user's unique identifier , put user's data it. can create 1 such table each logical set of information however. e.g., users table user information, posts table blog posts made user, friends table links users together.

keep in mind -- day-to-day operation of application should never require changes database schema (like create table), row manipulation operations (like insert , update.) first normal form place start reading on subject.