users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('users_id_seq'::regclass)
advertisements.user_id fkj69sc4qf7g4p52q8vl0hqvbmp R
avatar_image.user_id fkstw4q4d4ma39cvyegufdqtus8 R
car.user_id fkc2osr9qmb46vr8pjyps6weii0 R
opinion.user_id fk7ce989bael9ib668qg78shpyt R
roles.user_id fk97mxvrajhkq19dmvboprimeg1 R
vote.user_id fkkmvvqilx49120p47nr9t56omf R
email varchar 255 null
password varchar 255 null
username varchar 30 null
points int4 10 √ null
verification varchar 255 √ null
enabled bool 1 √ null
city varchar 255 √ null
age int4 10 √ null
brand varchar 255 √ null
model varchar 255 √ null
sex varchar 255 √ null
phone_number varchar 255 √ null
avatar_id int8 19 √ null
avatar_image.id fkf7rbhxthyh9c0dta50wpcid58 R
reset_password varchar 255 √ null

Table contained 8 rows

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
uk_r43af9ap4edm43mmtq01oddj6 Must be unique Asc username
uk_sx468g52bpetvlad2j9y0lptc Must be unique Asc username

Relationships

Close relationships within degrees of separation