DB Schema

DB Schema

Table pages
- id		integer primary key autoincrement
- page		text not null
  Store the page relation to the baka-tsuki url.
  for example: http://www.baka-tsuki.org/project/index.php?title=7_Nights, the value after title is saved to page
- title		text not null
  title is taken from displayTitle, in this case "7 Nights"
- type		text not null
  Novel list, Novel contents, others.
- parent	text
  Where the page is referenced. The top on is from Main_Page, for pag=Main_Page, the parent is ""
- last_update	integer
- last_check	integer
- is_watched	integer

Table images
- id		integer primary key autoincrement
- name		text not null
  the filename
- filepath	text not null
  full path to the filename
- url		text not null
  the image url
- last_update	integer
- last_check	integer

Table novel_details
- id		integer primary key autoincrement
- page		text not null
  used for reference from table pages.
- synopsis	text not null
- image		text not null
  the cover image, reference from table images, might change do id?
- last_update	integer
- last_check	integer

Table novel_books
- id		integer primary key autoincrement
- page		text not null
  used for reference from table pages.
- title		text not null
  the book/volume title
- last_update	integer
- last_check	integer


To create Books to Chapter relations, we can fetch the page from pages table
where the parent = page + "%" + title.