SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sat Sep 28 21:17 UTC 2024
Legend:
Primary key columns
Columns with indexes
 

testdb.public contains 58 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
cor_uaa_user c_enabled bool 1  √  null
cor_uaa_user c_extern bool 1  √  null
cor_uaa_role c_immutable bool 1  √  null
cor_uaa_user c_locked bool 1  √  null
cor_uaa_email c_primary bool 1
cor_uaa_role_role c_grant_id int8 19
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_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_role_role c_role_id int8 19
cor_uaa_role_user c_role_id int8 19
cor_uaa_role_user c_user_id int8 19
cor_uaa_email c_user_pk int8 19  √  null
cor_uaa_user c_image oid 10  √  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_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_user c_expiration_date timestamptz 35,6  √  null
cor_uaa_user c_last_password_change timestamptz 35,6  √  null
cor_uaa_user_password c_password_changed timestamptz 35,6  √  null
cor_uaa_role c_type varchar 20
cor_uaa_user c_type varchar 31
cor_uaa_email c_address varchar 255
cor_uaa_user c_comment varchar 255  √  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_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_user c_im varchar 255  √  null
cor_uaa_role c_name varchar 255
cor_uaa_user c_office varchar 255  √  null
cor_uaa_user c_password varchar 255  √  null
cor_uaa_user_password c_password varchar 255  √  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_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_user c_username varchar 255
cor_uaa_user_password c_username varchar 255  √  null
cor_uaa_role c_description varchar 1024  √  null
cor_uaa_user c_description varchar 1024  √  null