Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| audit_id | int8 | 19 | √ | null |
|
|
||
| audit_time | timestamptz | 35,6 | √ | null |
|
|
||
| audit_action | text | 2147483647 | √ | null |
|
|
||
| audit_user | int4 | 10 | √ | null |
|
|
||
| audit_ws | int4 | 10 | √ | null |
|
|
||
| id | int4 | 10 | √ | null |
|
|
||
| card | int4 | 10 | √ | null |
|
|
||
| profile | int4 | 10 | √ | null |
|
|
||
| usrname | text | 2147483647 | √ | null |
|
|
||
| text | 2147483647 | √ | null |
|
|
|||
| passwd | text | 2147483647 | √ | null |
|
|
||
| standing | int4 | 10 | √ | null |
|
|
||
| ident_type | int4 | 10 | √ | null |
|
|
||
| ident_value | text | 2147483647 | √ | null |
|
|
||
| ident_type2 | int4 | 10 | √ | null |
|
|
||
| ident_value2 | text | 2147483647 | √ | null |
|
|
||
| net_access_level | int4 | 10 | √ | null |
|
|
||
| photo_url | text | 2147483647 | √ | null |
|
|
||
| prefix | text | 2147483647 | √ | null |
|
|
||
| first_given_name | text | 2147483647 | √ | null |
|
|
||
| second_given_name | text | 2147483647 | √ | null |
|
|
||
| family_name | text | 2147483647 | √ | null |
|
|
||
| suffix | text | 2147483647 | √ | null |
|
|
||
| guardian | text | 2147483647 | √ | null |
|
|
||
| pref_prefix | text | 2147483647 | √ | null |
|
|
||
| pref_first_given_name | text | 2147483647 | √ | null |
|
|
||
| pref_second_given_name | text | 2147483647 | √ | null |
|
|
||
| pref_family_name | text | 2147483647 | √ | null |
|
|
||
| pref_suffix | text | 2147483647 | √ | null |
|
|
||
| name_keywords | text | 2147483647 | √ | null |
|
|
||
| name_kw_tsvector | tsvector | 2147483647 | √ | null |
|
|
||
| alias | text | 2147483647 | √ | null |
|
|
||
| day_phone | text | 2147483647 | √ | null |
|
|
||
| evening_phone | text | 2147483647 | √ | null |
|
|
||
| other_phone | text | 2147483647 | √ | null |
|
|
||
| mailing_address | int4 | 10 | √ | null |
|
|
||
| billing_address | int4 | 10 | √ | null |
|
|
||
| home_ou | int4 | 10 | √ | null |
|
|
||
| dob | date | 13 | √ | null |
|
|
||
| active | bool | 1 | √ | null |
|
|
||
| master_account | bool | 1 | √ | null |
|
|
||
| super_user | bool | 1 | √ | null |
|
|
||
| barred | bool | 1 | √ | null |
|
|
||
| deleted | bool | 1 | √ | null |
|
|
||
| juvenile | bool | 1 | √ | null |
|
|
||
| usrgroup | int4 | 10 | √ | null |
|
|
||
| claims_returned_count | int4 | 10 | √ | null |
|
|
||
| credit_forward_balance | numeric | 6,2 | √ | null |
|
|
||
| last_xact_id | text | 2147483647 | √ | null |
|
|
||
| create_date | timestamptz | 35,6 | √ | null |
|
|
||
| expire_date | timestamptz | 35,6 | √ | null |
|
|
||
| claims_never_checked_out_count | int4 | 10 | √ | null |
|
|
||
| last_update_time | timestamptz | 35,6 | √ | null |
|
|
||
| locale | text | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
