Book Report

Tables (5)

Board (Untitled2)

  • board_id (Key) — NUMBER — Primary key — NOT NULL
  • book_id (Field) — Number — Primary key
  • user_id (Key2) — Number — Foreign key → User.user_id — NOT NULL
  • picture_url (Field3) — VARCHAR(40)
  • content (Field4) — VARCHAR(200)
  • like (Field5) — NUMBER

Book (Untitled3)

  • book_id (Key) — NUMBER — Primary key — NOT NULL
  • board_id (Key2) — NUMBER — Foreign key → Board.board_id — NOT NULL
  • user_id (Key22) — Number — Foreign key → Board.user_id — NOT NULL
  • Title (Field) — VARCHAR(20)
  • Author (Field2) — VARCHAR(30)

Comment (Untitled4)

  • comment_id (Key) — NUMBER — Primary key — NOT NULL
  • board_id (Forien Key) — NUMBER
  • user_id (Field) — NUMBER
  • comment (Field2) — VARCHAR(40)

Like (Untitled5)

  • board_id (Field) — NUMBER
  • user_id (Field2) — NUMBER

User (Untitled)

  • user_id (Key) — Number — Primary key — NOT NULL
  • id (Field) — VARCHAR(20)
  • password (Field2) — VARCHAR(30)
  • name (Field3) — VARCHAR(20)