Miroom

Tables (4)

BucketList (Untitled)

  • _id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User._id — NOT NULL
  • title (Field)
  • description (Field2)
  • is_public (Field3)
  • created_at (Field4) — Date
  • updated_at (Field5) — Date

BucketListItem (Untitled2)

  • _id (Key) — bigint — Primary key — NOT NULL
  • bucket_list_id (Key2) — bigint — Foreign key → BucketList._id — NOT NULL
  • content (Field)
  • is_completed (Field2)
  • created_at (Field3)
  • updated_at (Field4)

DailyLog (Untitled4)

  • _id (Key) — bigint — Primary key — NOT NULL
  • date (Field)
  • title (Field2)
  • content (Field3)
  • bucket_list_references (Field4)
  • created_at (Field5) — Date
  • updated_at (Field6) — Date

User (users)

  • _id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — String
  • nickname (Field2) — String
  • password_hash (Field3) — String
  • favorites (Field4) — Array of ObjectId