02. Model

Preview scheme

Description

Shelter

Name	Type	Properties
id	bigint	auto increament, unique, primary key
name	varchar(255)
address	varchar(255)
location_map	text

Pet

Name	Type	Properties
id	bigint	auto increament, unique, primary key
age	integer
id_breed	bigint
decision_date	timestamp
file_path	varchar(255)
file_size	bigint
media_type	varchar(255)
name	varchar(255)
photo	bytea
id_customer	bigint
id_shelter	bigint

Breed

Name	Type	Properties
id	bigint	auto increament, unique, primary key
breed	varchar(255)
child_age	integer
recommendations_adult	varchar(255)
recommendations_adult	varchar(255)

Customer

Name	Type	Properties
id	bigint	auto increament, unique, primary key
chat_id	bigint
surname	varchar(25)
name	varchar(25)
second_name	varchar(25)
phone	varchar(12)
address	text

Report

Name	Type	Properties
id	bigint	auto increament, unique, primary key
date	timestamp
file_path	varchar(255)
file_size	bigint
media_type	varchar(255)
pet_report	varchar(255)
photo	bytea
id_pet	bigint

Info

Name	Type	Properties
id	bigint	auto increament, unique, primary key
area	varchar(255)
instructions	varchar(255)

Volunteer

Name	Type	Properties
id	bigint	auto increament, unique, primary key
address	varchar(255)
chat_id	bigint
name	varchar(255)
phone	varchar(255)
second_name	varchar(255)
surname	varchar(255)