DB Schema

Jump to bottom Edit New page

unenglishable edited this page Jul 30, 2014 · 12 revisions

Boards:

{
  "id": string // (generated)
  "name": string  
  "description": string
  "created_at": datetime number // (generated, if none exists)
  "imported_at": datetime number // (generated)
  "smf": {  // (legacy data)
    board_id:  number  // ID_BOARD
  }
}

Threads/Posts:

{
  "id": string // (generated)
  "title": string  
  "body": string  
  "thread_id": string
  "board_id": string // (only needed for threads)  
  "created_at": datetime number // (generated, if none exists)
  "imported_at": datetime number // (generated)
  "smf": {  // (legacy data)
    thread_id:  number // ID_TOPIC
    post_id: number // ID_MSG
  }
}