Columns

Columns

Table	Type	Column	Type	Size	Nulls	Auto	Default	Comments
users	Table	phone_number	varchar	255	√		null
avatar_image	Table	user_id	int8	19	√		null
car	Table	id	bigserial	19		√	nextval('car_id_seq'::regclass)
vote	Table	id	bigserial	19		√	nextval('vote_id_seq'::regclass)
users	Table	sex	varchar	255	√		null
opinion	Table	car_id	int8	19	√		null
vote	Table	result	bool	1			null
users	Table	age	int4	10	√		null
avatar_image	Table	id	bigserial	19		√	nextval('avatar_image_id_seq'::regclass)
model	Table	name	varchar	50			null
advertisements	Table	vin	varchar	255	√		null
users	Table	id	bigserial	19		√	nextval('users_id_seq'::regclass)
advertisements	Table	car_engine	varchar	255	√		null
opinion	Table	id	bigserial	19		√	nextval('opinion_id_seq'::regclass)
users	Table	model	varchar	255	√		null
opinion_images	Table	data	oid	10	√		null
brand	Table	id	bigserial	19		√	nextval('brand_id_seq'::regclass)
users	Table	city	varchar	255	√		null
advertisements	Table	model_id	int8	19	√		null
advertisements	Table	city	varchar	255	√		null
ad_images	Table	data	oid	10	√		null
avatar_image	Table	data	oid	10	√		null
roles	Table	id	bigserial	19		√	nextval('roles_id_seq'::regclass)
opinion	Table	user_id	int8	19	√		null
vote	Table	added_points	int4	10	√		null
car	Table	vin	varchar	255			null
users	Table	password	varchar	255			null
users	Table	reset_password	varchar	255	√		null
ad_images	Table	file_type	varchar	255	√		null
users	Table	points	int4	10	√		null
model	Table	brand_id	int8	19	√		null
vote	Table	opinion_id	int8	19	√		null
avatar_image	Table	file_type	varchar	255	√		null
users	Table	email	varchar	255			null
advertisements	Table	id	bigserial	19		√	nextval('advertisements_id_seq'::regclass)
users	Table	verification	varchar	255	√		null
model	Table	id	bigserial	19		√	nextval('model_id_seq'::regclass)
advertisements	Table	user_id	int8	19	√		null
opinion	Table	timestamp	timestamp	29	√		CURRENT_TIMESTAMP
car	Table	model_id	int8	19	√		null
opinion	Table	content	varchar	5000			null
ad_images	Table	id	bigserial	19		√	nextval('ad_images_id_seq'::regclass)
advertisements	Table	description	varchar	255	√		null
roles	Table	user_id	int8	19	√		null
roles	Table	role	varchar	255	√		null
users	Table	username	varchar	30			null
users	Table	enabled	bool	1	√		null
advertisements	Table	engine_capacity	float8	17	√		null
users	Table	brand	varchar	255	√		null
opinion_images	Table	id	bigserial	19		√	nextval('opinion_images_id_seq'::regclass)
car	Table	user_id	int8	19	√		null
advertisements	Table	price	float8	17	√		null
vote	Table	user_id	int8	19	√		null
users	Table	avatar_id	int8	19	√		null
brand	Table	name	varchar	50			null
opinion_images	Table	opinion_id	int8	19	√		null
advertisements	Table	production_year	int4	10	√		null
ad_images	Table	advertisement_id	int8	19	√		null
opinion_images	Table	file_type	varchar	255	√		null