게시판

테이블 (3)

comments

  • id — INTEGER
  • post_id — INTEGER — 외래 키 → posts.id — NOT NULL
  • user_id — INTEGER — 외래 키 → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — INTEGER
  • created_at — TEXT
  • updated_at — TEXT

posts

  • id — INTEGER
  • user_id — INTEGER — 외래 키 → users.id — 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

users

  • id — INTEGER
  • username — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • student_number — TEXT — NOT NULL
  • role — TEXT
  • profile_message — TEXT
  • created_at — TEXT
  • updated_at — TEXT