Home inventory
Tables (10)
accounts_passwordresetcode
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- code_hash — VARCHAR(128) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- used_at — DATETIME(6)
- attempts — SMALLINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
accounts_user
- id — BIGINT — Primary key — NOT NULL
- password — VARCHAR(128) — NOT NULL
- last_login — DATETIME(6)
- is_superuser — BOOLEAN — NOT NULL
- username — VARCHAR(150) — NOT NULL
- first_name — VARCHAR(150) — NOT NULL
- last_name — VARCHAR(150) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- is_staff — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- date_joined — DATETIME(6) — NOT NULL
- nickname — VARCHAR(80) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
homes_floorplan
- id — BIGINT — Primary key — NOT NULL
- home_id — BIGINT — Foreign key → homes_home.id — NOT NULL
- name — VARCHAR(120) — NOT NULL
- width — INT — NOT NULL
- height — INT — NOT NULL
- unit — VARCHAR(8) — NOT NULL
- background_image — VARCHAR(100)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
homes_home
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- name — VARCHAR(120) — NOT NULL
- address_optional — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
items_category
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- name — VARCHAR(80) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
items_item
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- category_id — BIGINT — Foreign key → items_category.id
- current_location_node_id — BIGINT — Foreign key → locations_locationnode.id
- name — VARCHAR(160) — NOT NULL
- description — TEXT — NOT NULL
- quantity — INT — NOT NULL
- photo — VARCHAR(100)
- purchase_price — DECIMAL(12, 2)
- purchase_date — DATE
- status — VARCHAR(16) — NOT NULL
- last_checked_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
items_itemlocationhistory
- id — BIGINT — Primary key — NOT NULL
- item_id — BIGINT — Foreign key → items_item.id — NOT NULL
- from_location_node_id — BIGINT — Foreign key → locations_locationnode.id
- to_location_node_id — BIGINT — Foreign key → locations_locationnode.id
- created_by_id — BIGINT — Foreign key → accounts_user.id
- memo — VARCHAR(255) — NOT NULL
- moved_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
items_itemtag
- id — BIGINT — Primary key — NOT NULL
- item_id — BIGINT — Foreign key → items_item.id — NOT NULL
- tag_id — BIGINT — Foreign key → items_tag.id — NOT NULL
items_tag
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- name — VARCHAR(80) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
locations_locationnode
- id — BIGINT — Primary key — NOT NULL
- home_id — BIGINT — Foreign key → homes_home.id — NOT NULL
- floor_plan_id — BIGINT — Foreign key → homes_floorplan.id
- parent_id — BIGINT — Foreign key → locations_locationnode.id
- node_type — VARCHAR(24) — NOT NULL
- code — VARCHAR(40) — NOT NULL
- name — VARCHAR(120) — NOT NULL
- full_code — VARCHAR(255) — NOT NULL
- path — VARCHAR(1000) — NOT NULL
- level — INT — NOT NULL
- geometry_json — JSON — NOT NULL
- metadata_json — JSON — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL