profile
profile_detail
client
client_document_list
manager
manager_document_list
profile
address_list
document
document_item_list
item
document_item_list
delivery_address
document_list
parent_item
item_list
profile_detail
profile_id
PK FK
bio
phone
profile
id
PK
email
UQ
name
type
client_id
UQ
manager_id
UQ
created_at
document
id
PK
client_id
FK
manager_id
FK
delivery_address_id
FK
doc_number
UQ
issued_at
address
id
PK
profile_id
FK
city
street
document_item
document_id
PK FK
item_id
PK FK
quantity
item
id
PK
parent_item_id
FK
sku
UQ
name
price
exactly one
zero or one
zero or many
lookup — to one row
list — to many rows