[web2py] auth tables definition

[Jean-Guy]

Hello,

Did I defined my auth tables correctly ?

Here is my auth tables definitions :

Not sure of the FK in red...

auth_table = db.define_table(
    auth.settings.table_event_name,
    Field('time_stamp','datetime'),
    Field('client_ip','string',length=512),
    Field('user_id',db.auth_user),
    Field('origin','string',length=512),
    Field('description','text'),
    migrate=False)

auth_table = db.define_table(
    auth.settings.table_group_name,
    Field('role','string',length=512),
    Field('description','text'),
    migrate=False)

auth_table = db.define_table(
    auth.settings.table_membership_name,
    Field('user_id',db.auth_user),
    Field('group_id',db.auth_group),
    migrate=False)

auth_table = db.define_table(
    auth.settings.table_permission_name,
    Field('group_id',db.auth_group),
    Field('name','string',length=512),
    Field('table_name','string',length=512),
    Field('record_id','integer'),
    migrate=False)

Maybe I should use those referencers  :

auth.settings.table_user
auth.settings.table_group
auth.settings.table_membership
auth.settings.table_permission
auth.settings.table_event


Thanks

Jonhy