Data import

Import order matters for the inventory hierarchy. Properties reference landlords by landlord_code; sites reference properties by property_code; faces reference sites by site_code. Import in this order: ① Landlords → ② Properties → ③ Sites → ④ Faces. Each later upload will fail rows whose foreign-key code isn't already in the database.

⑤ Clients (brands + agencies you sell advertising to) are independent of the inventory tree — upload them whenever, in any order.

Codes are preserved on import. Whatever you put in the landlord_code / property_code / etc. column becomes the record's identifier — regardless of the active Number-prefix policy. Duplicates within the tenant are rejected.