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