Linework — data model

Linework — data model An entity-relationship diagram generated by Archify. catalogue couple guests platform designs · Entity · catalogue designs PK key TEXT title TEXT style TEXT — frame | illustration description TEXT status TEXT — draft | live | archived sort INTEGER packages · Entity · catalogue packages PK id TEXT UK code TEXT title TEXT description TEXT price_cents INTEGER currency TEXT includes_json TEXT turnaround_days INTEGER active INTEGER sort INTEGER events · one settings record per couple · Entity · couple events PK id TEXT UK slug TEXT UK owner_token TEXT — couple's private link package INTEGER — 1 | 2 | 3 status TEXT — draft | live | archived partner_one TEXT partner_two TEXT email TEXT phone TEXT date_local TEXT — venue local time timezone TEXT lang TEXT layout TEXT — one-page | two-page style TEXT — frame | illustration design_key TEXT words_json TEXT — opening, venue, schedule… rsvp_json TEXT — deadline, maxGuests film_json TEXT — package 2 world_json TEXT — package 3 created_at TEXT updated_at TEXT orders · Entity · couple orders PK id TEXT FK event_id TEXT package INTEGER kind TEXT — order | inquiry status TEXT — inquiry … cancelled amount_cents INTEGER currency TEXT payment_provider TEXT — stripe | demo | manual stripe_checkout_session_id TEXT stripe_payment_intent_id TEXT paid_at TEXT questionnaire_json TEXT studio_notes TEXT created_at TEXT updated_at TEXT guests · no accounts; device-key cookie · Entity · guests guests PK id TEXT FK event_id TEXT name TEXT device_key TEXT — unique per event created_at TEXT rsvps · Entity · guests rsvps PKFK guest_id TEXT FK event_id TEXT attending INTEGER — 0 | 1 party_size INTEGER — 0..20 note TEXT updated_at TEXT stripe_events · webhook idempotency · Entity · platform stripe_events PK id TEXT — Stripe event id type TEXT received_at TEXT processed_at TEXT settings · Entity · platform settings PK key TEXT value TEXT updated_at TEXT for invited to reply of counted for Legend PK Primary key FK Foreign key UK Unique key One Many Optional