grabowski
b59904fdae
Data model - Properties, rooms (+optional floors), assets (typed custom fields + Zod runtime validator + move history), documents (polymorphic scope) - Projects -> work packages -> tasks -> subtasks - Decision events (scoped to project/property/asset/work_package) - Checklist templates + instances, maintenance schedules (time + usage) with auto-materialized checklists on event recording - Wiki (global + per-project) with revisions + tsvector FTS - Property accounts (utility/meter numbers by kind) - Notifications table + per-user channel prefs Infra - RBAC guards (requireCompany / requireAdmin) - Storage abstraction: LocalDiskStorage (HMAC signed URLs) + S3Storage behind the same interface, switchable via STORAGE_BACKEND - CSV export for assets / maintenance / decisions - QR labels: /api/qr SVG endpoint + printable /assets/[id]/label - Notifications: in-app + SMTP (own server via nodemailer) + Matrix (Client-Server API, per-company room) with opt-in per user - Company switcher + auto-select first company on login UI - Topbar: bell with unread count, theme toggle, name, Sign Out (flat) - Sidebar: main nav + dedicated Admin section (Asset types, Users, Company) - Nested-route tabs on property / project / asset detail pages - Admin UIs for users (invite, role, reset pw, deactivate) and company settings (default currency, Matrix room id) - Custom asset type creation + field-def editor with immutable key/type guard and auto-deprecate when removing a field still referenced Graph - graphify-out/ committed: GRAPH_REPORT.md, graph.html, graph.json
16 lines
585 B
SQL
16 lines
585 B
SQL
-- Rooms follow-up: constraints + updated_at triggers.
|
|
|
|
-- A room assignment only makes sense when the asset is at a property.
|
|
ALTER TABLE "assets" ADD CONSTRAINT "assets_room_requires_property" CHECK (
|
|
"current_room_id" IS NULL
|
|
OR "current_container_kind" = 'property'
|
|
);
|
|
--> statement-breakpoint
|
|
|
|
CREATE TRIGGER property_floors_set_updated_at BEFORE UPDATE ON "property_floors"
|
|
FOR EACH ROW EXECUTE FUNCTION set_updated_at();
|
|
--> statement-breakpoint
|
|
|
|
CREATE TRIGGER property_rooms_set_updated_at BEFORE UPDATE ON "property_rooms"
|
|
FOR EACH ROW EXECUTE FUNCTION set_updated_at();
|