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