[web2py] Re: Linking Auth with another table to store additional info about user

2016-12-21 Thread Anthony
Think about how many users and how much extra space those fields will really take in the auth_user table vs. both the complexity and inefficiency of having to do joins whenever you need the extra fields if you keep them in a separate table. You might also consider keeping some of the extra data

[web2py] Re: Linking Auth with another table to store additional info about user

2016-12-21 Thread 黄祥
why not create a new table for that and reference it to auth_user table? *e.g.* *models/db.py* db.define_table('employee', Field('is_auth', 'boolean'), * Field('auth_user', 'reference auth_user'), * Field('first_name'), Field('last_name'), Field('email', 'list:string'), Field('occupation'),