quote

Tables (7)

Book (Untitled)

  • book_id (Key) — Primary key — NOT NULL
  • title (Field)
  • author (Field2)
  • publisher (Field3)

Comment (Untitled2)

  • comment_id (Key) — Primary key — NOT NULL
  • content (Field)
  • quote_id (Key2) — Foreign key → Quote.quote_id — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL

Quote (Untitled3)

  • quote_id (Key) — Primary key — NOT NULL
  • content (Field)
  • page (Field2)
  • book_id (Key2) — Foreign key → Book.book_id — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL

QuoteTag (Untitled4)

  • quote_tag_id (Key) — Primary key — NOT NULL
  • quote_id (Key2) — Foreign key → Quote.quote_id — NOT NULL
  • tag_id (Key3) — Foreign key → Tag.tag_id — NOT NULL

RefreshToken (Untitled5)

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

Tag (Untitled6)

  • tag_id (Key) — Primary key — NOT NULL
  • tag (Field)

User (Untitled7)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • nickname (Field3)