SchemaSpy Analysis of testdb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Sat Sep 28 21:17 UTC 2024 |
| |||||
|
testdb.public contains 58 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
cor_uaa_email | c_address | varchar | 255 | ||||
cor_uaa_user | c_comment | varchar | 255 | √ | null | ||
cor_uaa_email | c_created | timestamp | 29,6 | √ | null | ||
cor_uaa_role | c_created | timestamp | 29,6 | √ | null | ||
cor_uaa_user | c_created | timestamp | 29,6 | √ | null | ||
cor_uaa_user_password | c_created | timestamp | 29,6 | √ | null | ||
cor_uaa_email | c_created_by | varchar | 255 | √ | null | ||
cor_uaa_role | c_created_by | varchar | 255 | √ | null | ||
cor_uaa_user | c_created_by | varchar | 255 | √ | null | ||
cor_uaa_user_password | c_created_by | varchar | 255 | √ | null | ||
cor_uaa_user | c_department | varchar | 255 | √ | null | ||
cor_uaa_role | c_description | varchar | 1024 | √ | null | ||
cor_uaa_user | c_description | varchar | 1024 | √ | null | ||
cor_uaa_user | c_enabled | bool | 1 | √ | null | ||
cor_uaa_user | c_expiration_date | timestamptz | 35,6 | √ | null | ||
cor_uaa_user | c_extern | bool | 1 | √ | null | ||
cor_uaa_email | c_full_name | varchar | 255 | √ | null | ||
cor_uaa_user | c_fullname | varchar | 255 | √ | null | ||
cor_uaa_user | c_gender | varchar | 255 | √ | null | ||
cor_uaa_role_role | c_grant_id | int8 | 19 | ||||
cor_uaa_user | c_im | varchar | 255 | √ | null | ||
cor_uaa_user | c_image | oid | 10 | √ | null | ||
cor_uaa_role | c_immutable | bool | 1 | √ | null | ||
cor_uaa_user | c_last_password_change | timestamptz | 35,6 | √ | null | ||
cor_uaa_user | c_locked | bool | 1 | √ | null | ||
cor_uaa_role | c_name | varchar | 255 | ||||
cor_uaa_user | c_office | varchar | 255 | √ | null | ||
cor_uaa_email | c_ol | int8 | 19 | √ | null | ||
cor_uaa_role | c_ol | int8 | 19 | √ | null | ||
cor_uaa_user | c_ol | int8 | 19 | √ | null | ||
cor_uaa_user_password | c_ol | int8 | 19 | √ | null | ||
cor_uaa_user | c_password | varchar | 255 | √ | null | ||
cor_uaa_user_password | c_password | varchar | 255 | √ | null | ||
cor_uaa_user_password | c_password_changed | timestamptz | 35,6 | √ | null | ||
cor_uaa_user | c_phone_no | varchar | 255 | √ | null | ||
cor_uaa_role | c_pid | varchar | 255 | ||||
cor_uaa_user | c_pid | varchar | 255 | ||||
cor_uaa_email | c_pk | int8 | 19 | ||||
cor_uaa_role | c_pk | int8 | 19 | ||||
cor_uaa_user | c_pk | int8 | 19 | ||||
cor_uaa_user_password | c_pk | int8 | 19 | ||||
cor_uaa_email | c_primary | bool | 1 | ||||
cor_uaa_role_role | c_role_id | int8 | 19 | ||||
cor_uaa_role_user | c_role_id | int8 | 19 | ||||
cor_uaa_role | c_type | varchar | 20 | ||||
cor_uaa_user | c_type | varchar | 31 | ||||
cor_uaa_email | c_updated | timestamp | 29,6 | √ | null | ||
cor_uaa_role | c_updated | timestamp | 29,6 | √ | null | ||
cor_uaa_user | c_updated | timestamp | 29,6 | √ | null | ||
cor_uaa_user_password | c_updated | timestamp | 29,6 | √ | null | ||
cor_uaa_email | c_updated_by | varchar | 255 | √ | null | ||
cor_uaa_role | c_updated_by | varchar | 255 | √ | null | ||
cor_uaa_user | c_updated_by | varchar | 255 | √ | null | ||
cor_uaa_user_password | c_updated_by | varchar | 255 | √ | null | ||
cor_uaa_role_user | c_user_id | int8 | 19 | ||||
cor_uaa_email | c_user_pk | int8 | 19 | √ | null | ||
cor_uaa_user | c_username | varchar | 255 | ||||
cor_uaa_user_password | c_username | varchar | 255 | √ | null |