Tables : res_users
Columns13 |
Keys2 |
Triggers0 |
Comment:Description: |
|
Indexes0 |
Contraints0 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id | id | true | INTEGER |
| active | active | BOOLEAN | |
| login | login | CHARACTER VARYING | |
| password | password | CHARACTER VARYING | |
| company_id | company_id | INTEGER | |
| partner_id | partner_id | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| signature | signature | TEXT | |
| action_id | action_id | INTEGER | |
| share | share | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) |
Keys :
| Name | Primary Key | Description |
|---|---|---|
| res_users_pkey | true | |
| res_users_login_key |
Columns Detail :
| Name | id |
| Table | res_users |
| Type | INTEGER |
| Domain | |
| Primary Key | true |
| Not null | true |
| Default Value | nextval('res_users_id_seq'::regclass) |
| Name | active |
| Table | res_users |
| Type | BOOLEAN |
| Domain | |
| Default Value | true |
| Name | login |
| Table | res_users |
| Type | CHARACTER VARYING |
| Domain | |
| Not null | true |
| Unique | true |
| Name | password |
| Table | res_users |
| Type | CHARACTER VARYING |
| Domain |
| Name | company_id |
| Table | res_users |
| Type | INTEGER |
| Domain | |
| Not null | true |
| Foreign key | true |
| Name | partner_id |
| Table | res_users |
| Type | INTEGER |
| Domain | |
| Not null | true |
| Foreign key | true |
| Name | create_date |
| Table | res_users |
| Type | TIMESTAMP(6) |
| Domain |
| Name | signature |
| Table | res_users |
| Type | TEXT |
| Domain |
| Name | action_id |
| Table | res_users |
| Type | INTEGER |
| Domain |
| Name | share |
| Table | res_users |
| Type | BOOLEAN |
| Domain |
| Name | create_uid |
| Table | res_users |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | write_uid |
| Table | res_users |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | write_date |
| Table | res_users |
| Type | TIMESTAMP(6) |
| Domain |
Project
Odoo Data Model