sqld

Tables (4)

board (Untitled2)

  • board_id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(500)
  • content (Field2) — VARCHAR(1000)
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE
  • hit (Field5) — INT
  • user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL

comment (Untitled)

  • c_id (Key) — INT — Primary key — NOT NULL
  • content (Field) — VARCHAR(500)
  • board_id (Key2) — INT — Foreign key → board.board_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL

like (Untitled4)

  • like_id (Key) — INT — Primary key — NOT NULL
  • board_id (Key2) — INT — Foreign key → board.board_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL

user (Untitled3)

  • user_id (Key) — INT — Primary key — NOT NULL
  • u_name (Field) — VARCHAR(15)
  • u_nickname (Field2) — VARCHAR(15)
  • u_joinedAt (Field3) — DATE
  • u_mobile (Field4) — VACRHAR(15)
  • u_email (Field5) — VARCHAR(50)