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)