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)