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