user_address


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
lib_library.address fk_lib_address R
user_user.address fk_user_address R
address1 VARCHAR 255 √ NULL
address2 VARCHAR 255 √ NULL
address3 VARCHAR 255 √ NULL
complement VARCHAR 255 √ NULL
postcode VARCHAR 255 √ NULL
city VARCHAR 255 √ NULL
country VARCHAR 255 √ NULL
label VARCHAR 255 √ NULL
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier

Relationships

Close relationships within degrees of separation