th
Tables (4)
comments
- id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → posts.id — NOT NULL
- parent_id — INTEGER — Foreign key → comments.id
- author_id — INTEGER — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
posts
- id — INTEGER — Primary key — NOT NULL
- author_id — INTEGER — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- shared_post_id — INTEGER — Foreign key → posts.id
- created_at — DATETIME
- updated_at — DATETIME
reactions
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- post_id — INTEGER — Foreign key → posts.id
- comment_id — INTEGER — Foreign key → comments.id
- reaction_type — VARCHAR(50) — NOT NULL
users
- id — INTEGER — Primary key — NOT NULL
- birth_year — INTEGER
- user_type — VARCHAR(50) — NOT NULL
- country — VARCHAR(100)
- email — VARCHAR(255) — NOT NULL
- hashed_password — VARCHAR(255)
- nickname — VARCHAR(100)
- provider — VARCHAR(50) — NOT NULL
- social_id — VARCHAR(128)
- is_active — BOOLEAN — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- last_login_at — DATETIME
- last_logout_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME