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