tinkly
Tables (10)
BlockUser (Untitled10)
- id — INTEGER — Primary key — NOT NULL
- user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- created_at — DATETIME
- modified_at — DATETIME
- is_deeletd (is_deleted) — BOOLEAN
- blocked_user_id — UUID
Comment (Untitled7)
- id — INTEGER — Primary key — NOT NULL
- post_id — UUID — Foreign key → Post.id — NOT NULL
- create_user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- parent_comment_id (id2) — INTEGER — Foreign key → Comment.id — NOT NULL
- content — TEXT
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — DATETIME
CommentLike (Untitled8)
- id — INTEGER — Primary key — NOT NULL
- comment_id — INTEGER — Foreign key → Comment.id — NOT NULL
- user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — DATETIME
Notification (Untitled5)
- id — INTEGER — Primary key — NOT NULL
- user_Id (user_id) — UUID — Foreign key → UserInfo.id — NOT NULL
- is_read — BOOLEAN
- content — TEXT
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — BOOLEAN
Post (Untitled2)
- id — UUID — Primary key — NOT NULL
- create_user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- space_id — INT — Foreign key → Space.id — NOT NULL
- parent_post_id — UUID — Foreign key → Post.id — NOT NULL
- thumbnail_path — TEXT
- content — TEXT
- duration_seconds — INT
- players — ARRAY(UUID)
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — BOOLEAN
PostLike (Untitled6)
- id — INTEGER — Primary key — NOT NULL
- post_id — UUID — Foreign key → Post.id — NOT NULL
- user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — BOOLEAN
Scrap (Untitled9)
- id — INTEGER — Primary key — NOT NULL
- post_id — UUID — Foreign key → Post.id — NOT NULL
- user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — BOOLEAN
Space (Untitled3)
- id — INT — Primary key — NOT NULL
- create_user_id — UUID — Foreign key → UserInfo.id — NOT NULL
- name — TEXT
- description — TEXT
- activity_country — TEXT
- activity_region — TEXT
- is_private — BOOLEAN
- image_path — TEXT
- created_at — DATETIME
- modified_at — TEXT
- is_deleted — BOOLEAN
User (Untitled)
- id — UUID — Primary key — NOT NULL
UserInfo (Untitled4)
- id — UUID — Foreign key → User.id — NOT NULL
- social_email — TEXT
- user_name — TEXT
- musical_instruments — TEXT
- image_path — TEXT
- birth_date — DATETIME
- fcm_tokens — ARRAY(TEXT)
- created_at — DATETIME
- modified_at — DATETIME
- is_deleted — BOOLEAN