db.md

favelog DB

Tabelas

---

retail_table

field	type	obs
retail_id	number	PK, autoincrement
created_at	time	autogenerated
updated_at	time	autogenerated
name	varchar	-
email	varchar	-
cpf	number	-
tel	number	-
pix	varchar	-
pickup_address	varchar	-

---

courier_table

field	type	obs
courier_id	number	PK, autoincrement
created_at	time	autogenerated
updated_at	time	autogenerated
name	varchar	-
email	varchar	-
cpf	number	-
tel	number	-
pix	varchar	-
vehicle_plate	varchar	-
vehicle_model	varchar	-

---

delivery_table

field	type	obs
delivery_id	number	autoincrement
created_at	time	autogenerated
updated_at	time	autogenerated
request_retail	number	from retail_table
called_courier	number	from courie_table
pickup_address	varchar	-
delivery_address	varchar	-
value_tax	number	-
delivery_status	number	-
payment_status	number	-