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