Seller
Tableseller, id prefix sel. The store account and profile.
Relations:
professional_details, address, payment_details (one-to-one,
deleted with the seller), members (many-to-many through SellerMember),
member_invites (one-to-many, deleted with the seller).
ProfessionalDetails
Tableprofessional_details, id prefix selprodet. Presence marks the store as
a registered business.
SellerAddress
Tableseller_address, id prefix seladdr. Fields: name, company,
first_name, last_name, address_1, address_2, city, country_code,
province, postal_code, phone, and metadata. All are nullable.
PaymentDetails
Tablepayment_details, id prefix selpaydet. Fields: country_code,
holder_name, bank_name, iban, bic, routing_number, and
account_number. All are nullable.
Member
Tablemember, id prefix mem. A dashboard user that can belong to one or more
stores.
SellerMember
Tableseller_member, id prefix selmem. Pivot between Seller and Member,
unique on (seller_id, member_id).
MemberInvite
Tablemember_invite, id prefix meminv. A pending team invitation, carrying
the invited email, target seller_id, role_id, and an expiry.