NookBook

Tables (11)

User (Untitled)

  • id (Key) — Primary key — NOT NULL
  • nickname (Field)
  • username (Field2)

block (Untitled8)

  • id (Key2) — Primary key — NOT NULL
  • record_id (Key) — Foreign key → record.id — NOT NULL
  • content (Field)
  • image (Field2)

book (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • category (Field2)
  • image (Field3)

challenge (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • status (Field2)
  • image (Field3)
  • start_date (Field4)
  • end_date (Field5)
  • time_setting (Field6)
  • id (Key2) — Foreign key → User.id — NOT NULL

collection (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • book_id (Key3) — Foreign key → book.id — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • name (Field)

friends (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user1 (Key2) — Foreign key → User.id — NOT NULL
  • user2 (Key3) — Foreign key → User.id — NOT NULL

record (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • book_id (Key3) — Foreign key → book.id — NOT NULL
  • title (Field2)

request (Untitled6)

  • id (Key2) — Primary key — NOT NULL
  • send_user_id (Key) — Foreign key → User.id — NOT NULL
  • receive_user_id (Key3) — Foreign key → User.id — NOT NULL
  • status (Field)

search_word (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • keyword (Field)
  • user_id (Key2) — Foreign key → User.id — NOT NULL

time_setting (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → challenge.id — NOT NULL
  • start_time (Field)
  • end_time (Field2)

timer (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • book_id (Key3) — Foreign key → book.id — NOT NULL
  • time (Field)