sqld

Tables (6)

board (Untitled)

  • b_id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • content (Field2) — TEXT
  • author (Field3) — VARCHAR(50)
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE
  • hit (Field6) — INT

board (Untitled4)

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

comment (Untitled2)

  • c_id (Key) — INT — Primary key — NOT NULL
  • content (Field) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE
  • b_id (Key2) — INT — Foreign key → board.b_id — NOT NULL

comment (Untitled5)

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

good (Untitled6)

  • g_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(50)
  • u_nickname (Field2) — VARCHAR(100)
  • u_password (Field3) — VARCHAR(100)
  • u_joinedAt (Field4) — DATE
  • u_mobile (Field5) — VARCHAR(15)
  • u_email (Field6) — VARCHAR(50)