AddAlpha

Tables (5)

comments

  • id — UUID
  • post_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • parent_id — UUID
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP

post_likes

  • user_id — UUID — Primary key — NOT NULL
  • post_id — UUID — Primary key — NOT NULL
  • created_at — TIMESTAMP

posts

  • id — UUID
  • user_id — UUID — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • likes — INTEGER
  • comment_count — INTEGER
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

profiles

  • id — UUID
  • device_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • avatar_url — TEXT
  • bio — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — UUID
  • email — VARCHAR(255)
  • phone — VARCHAR(255)
  • encrypted_password — VARCHAR(255)
  • email_confirmed_at — TIMESTAMP
  • last_sign_in_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP