blog

Tables (7)

Board (board)

  • Key (board_id) — TEXT — Primary key — NOT NULL
  • Key (user_id) — TEXT — Foreign key → User.Key — NOT NULL
  • title (title_id) — TEXT
  • content (content_id) — TEXT

Reply (reply)

  • Key (reply_id) — TEXT — Primary key — NOT NULL
  • Key (user_id) — TEXT — Foreign key → User.Key — NOT NULL
  • Key (board_id) — TEXT — Foreign key → Board.Key — NOT NULL
  • Key (user_id2) — TEXT — Foreign key → Board.Key — NOT NULL
  • Field

Tag (tag)

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

Untitled

  • Key (board_id) — CHAR(5) — Foreign key → Board.Key — NOT NULL
  • Key (tag_id) — CHAR(5) — Foreign key → Tag.Key — NOT NULL
  • Key (user_id) — TEXT — Foreign key → Board.Key — NOT NULL

Untitled2

  • Key (user_id) — TEXT — Foreign key → User.Key — NOT NULL
  • Key (tag_id) — TEXT — Foreign key → Tag.Key — NOT NULL

User (user)

  • Key (user_id) — TEXT — Primary key — NOT NULL
  • Field

image (imgae)

  • Key (Imgae_id) — TEXT — Primary key — NOT NULL
  • Key (board_id) — TEXT — Foreign key → Board.Key — NOT NULL
  • Key (user_id) — TEXT — Foreign key → Board.Key — NOT NULL
  • image (image_id) — TEXT
  • Field