umeAPT

Tables (10)

apartment (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • group_id (Key2) — Foreign key → apartment_community.id — NOT NULL
  • name (Field2)
  • friendly_name (Field7)
  • region_hash_depth1 (Field6)
  • region_hash_depth2 (Field5)
  • region_hash_depth3 (Field3)
  • region_hash_depth4 (Field4)
  • active_depth_levell (Field9)

apartment_community (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • depth_level (Field2)

preopen_form (Untitled8)

  • Key — Primary key — NOT NULL
  • Field3
  • created_at (Field)
  • updated_at (Field2)

preopen_question (Untitled9)

  • karrot_id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • created_at (Field3)
  • Field4

question (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

user

  • karrot_id (Key) — Primary key — NOT NULL
  • push_agreed_at (Field)
  • created_at (Field2)
  • updated_at (Field3)

vote (Untitled)

  • id (Key) — Primary key — NOT NULL
  • writer_id (Key2) — Foreign key → user.karrot_id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

vote_item (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • vote_id (Key2) — Foreign key → vote.id — NOT NULL
  • name (Field)
  • created_at (Field2)
  • updated_at (Field3)

vote_participation (Untitled5)

  • id (Key2) — Primary key — NOT NULL
  • participant_id (Key) — Foreign key → user.karrot_id — NOT NULL
  • vote_item_id (Key3) — Foreign key → vote_item.id — NOT NULL
  • participate_at (Field)

vote_preview (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • viewer_id (Key2) — Foreign key → user.karrot_id — NOT NULL
  • vote_id (Key3) — Foreign key → vote.id — NOT NULL
  • preview_at (Field)