Database Explorer | CarpetPro Admin

Tables 18

▶ areas 0
▶ customers 11,367
▶ delivery_states 0
▶ messages 0
▶ notes 0
▶ notes_relations 0
▶ notes_types 0
▶ order_stages 24
▶ orders 12,690
▶ orders_history 0
▶ payments 0
▶ pieces 0
▶ routes 0
▶ services 20
▶ sessions 0
▶ stops 0
▶ stops_pieces_relations 0
▶ users 38

📋 areas

2 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	numeric	not null	—	PK	—
	2	name	varchar	not null	—		max 255

📋 customers

9 columns 11,367 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	numeric	not null	—	PK	—
	2	area_id	numeric	null	—	FK	→ areas.id
	3	crm_id	numeric	not null	—		—
	4	name	varchar	not null	—		max 255
	5	address	varchar	null	—		max 400
	6	location	varchar	null	—		max 400
	8	created_at	timestamp	not null	`now()`		—
	9	updated_at	timestamp	not null	`now()`		—
	10	phone	text	null	—		—

📋 delivery_states

2 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	name	varchar	not null	—		max 255

📋 messages

15 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	service	message_service_enum	not null	—		—
	3	author_type	message_author_enum	not null	—		—
	4	author_id	varchar	null	—		max 255
	5	channel_id	varchar	not null	—		max 255
	6	chat_id	varchar	not null	—		max 36
	7	error_code	varchar	null	—		max 255
	8	error_message	varchar	null	—		max 334
	9	sms	boolean	null	—		—
	10	media_uri	varchar	null	—		max 338
	11	external_id	varchar	not null	—		max 255
	12	status	message_status_enum	not null	—		—
	13	text	text	null	—		—
	14	timestamp	timestamp	not null	`now()`		—
	15	type	varchar	not null	—		max 255

📋 notes

5 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	type_id	integer	not null	—		p=32
	3	text	text	null	—		—
	4	created_at	timestamp	not null	`now()`		—
	5	updated_at	timestamp	not null	`now()`		—

📋 notes_relations

3 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	note_id	integer	not null	—		p=32
	3	target_id	integer	not null	—		p=32

📋 notes_types

2 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	name	varchar	not null	—		max 255

📋 order_stages

8 columns 24 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	varchar	not null	—	PK	max 25
	2	display_value	varchar	not null	—		max 100
	3	actual_value	varchar	null	—		max 100
	4	sequence_number	integer	null	—		p=32
	5	colour_code	varchar	null	—		max 10
	6	probability	integer	null	—		p=32
	7	deal_category	varchar	null	—		max 25
	8	is_active	boolean	null	—		—

📋 orders

11 columns 12,690 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	numeric	not null	—	PK	—
	2	service_id	numeric	not null	—	FK	→ services.id
	3	customer_id	numeric	not null	—	FK	→ customers.id
	4	crm_id	varchar	null	—		max 38
	5	created_at	timestamp	not null	`now()`		—
	6	updated_at	timestamp	not null	`now()`		—
	7	app_version	varchar	null	—		—
	8	price	numeric	not null	—		—
	9	discount	numeric	null	—		—
	10	discount_type	discount_type_enum	not null	—		—
	11	finished	boolean	null	—		—

📋 orders_history

10 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	order_id	integer	null	—	FK	→ orders.id
	3	service_id	integer	not null	—		p=32
	4	customer_id	integer	not null	—		p=32
	5	created_at	timestamp	not null	`now()`		—
	6	app_version	varchar	not null	—		—
	7	price	bigint	not null	—		p=64
	8	discount	bigint	null	—		p=64
	9	discount_type	discount_type_enum	not null	`'amount'::discount_type_enum`		—
	10	finished	boolean	null	—		—

📋 payments

6 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	order_id	integer	not null	—	FK	→ orders.id
	3	type	payment_type_enum	not null	`'online'::payment_type_enum`		—
	4	amount	bigint	not null	—		p=64
	5	created_at	timestamp	not null	`now()`		—
	6	updated_at	timestamp	not null	`now()`		—

📋 pieces

14 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	order_id	integer	not null	—	FK	→ orders.id
	3	status_id	integer	not null	—	FK	→ delivery_states.id
	4	packer_id	integer	not null	—	FK	→ users.id
	5	height	numeric	null	—		—
	6	width	numeric	null	—		—
	7	ishm	boolean	null	—		—
	8	rate	integer	null	—		p=32
	9	size	numeric	null	—		—
	10	quantity	integer	null	—		p=32
	11	price	bigint	null	—		p=64
	12	mattress_type	mattress_type_enum	null	—		—
	13	created_at	timestamp	not null	`now()`		—
	14	updated_at	timestamp	not null	`now()`		—

📋 routes

6 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	driver_id	integer	not null	—	FK	→ users.id
	3	expediter_id	integer	not null	—	FK	→ users.id
	4	car	integer	not null	—		p=32
	5	created_at	timestamp	not null	`now()`		—
	6	updated_at	timestamp	not null	`now()`		—

📋 services

2 columns 20 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	numeric	not null	—	PK	—
	2	name	varchar	not null	—		max 255

📋 sessions

9 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	user_id	integer	not null	—	FK	→ users.id
	3	app_version	varchar	not null	—		—
	4	created_at	timestamp	not null	`now()`		—
	5	last_seen_at	timestamp	not null	`now()`		—
	6	expires_at	timestamp	not null	—		—
	7	revoked_at	timestamp	not null	—		—
	8	user_agent	varchar	null	—		max 255
	9	ip_address	inet	null	—		—

📋 stops

8 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	route_id	integer	not null	—	FK	→ routes.id
	3	type	stop_type_enum	not null	—		—
	4	number	integer	not null	—		p=32
	5	start_time	timestamp	not null	—		—
	6	end_time	timestamp	not null	—		—
	7	created_at	timestamp	not null	`now()`		—
	8	updated_at	timestamp	not null	`now()`		—

📋 stops_pieces_relations

3 columns 0 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	integer	not null	—	PK	p=32
	2	stop_id	integer	not null	—		p=32
	3	piece_id	integer	not null	—		p=32

📋 users

7 columns 38 rows

	#	Column	Type	Nullable	Default	Constraints	Details	Actions
	1	id	numeric	not null	—	PK	—
	2	crm_id	numeric	not null	—		—
	3	type	user_type_enum	not null	—		—
	4	name	varchar	not null	—		max 255
	5	phone	varchar	null	—		max 26
	6	created_at	timestamp	not null	`now()`		—
	7	updated_at	timestamp	not null	`now()`		—

0 columns selected

Column Name *

Data Type *

Length / Precision

Array Dimensions

Default Value

Written as raw SQL expression. Leave blank for no default.

Check Constraint

SQL boolean expression (do not include CHECK keyword or parentheses).

NOT NULL UNIQUE PRIMARY KEY