ad
Tables (4)
comments
- id — INTEGER
- post_id — INTEGER — Foreign key → posts.id — NOT NULL
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — INTEGER
- created_at — TEXT
- updated_at — TEXT
messages
- id — INTEGER
- sender_id — INTEGER — NOT NULL
- receiver_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- is_read — INTEGER
- is_sender_deleted — INTEGER
- is_receiver_deleted — INTEGER
- created_at — TEXT
one_liners
- id — INTEGER
- owner_id — INTEGER — NOT NULL
- writer_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TEXT
posts
- id — INTEGER
- user_id — INTEGER — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- view_count — INTEGER
- is_notice — INTEGER
- is_deleted — INTEGER
- created_at — TEXT
- updated_at — TEXT