BOARD

Tables (10)

board (Untitled)

  • b_id (Key) — INT — Primary key — NOT NULL
  • b_title (Field) — VARCHAR(60)
  • b_content (Field2) — VARCHAR(500)
  • b_author (Field3) — VARCHAR(20)
  • b_createdAt (Field4) — DATE
  • b_updatedAt (Field5) — DATE
  • b_hit (Field6) — INT

board (Untitled4)

  • board_id (Key) — INT — Primary key — NOT NULL
  • b_title (Field) — VARCHAR(20)
  • b_content (Field2) — VARCHAR(500)
  • b_createdAt (Field3) — DATE
  • b_updatedAt (Field4) — DATE
  • b_hit (Field5) — INT
  • user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL

board (CopyOfUntitled)

  • b_id (Key) — INT — Primary key — NOT NULL
  • b_title (Field) — VARCHAR(60)
  • b_content (Field2) — VARCHAR(500)
  • b_author (Field3) — VARCHAR(20)
  • b_createdAt (Field4) — DATE
  • b_updatedAt (Field5) — DATE
  • b_hit (Field6) — INT
  • user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL

boardlike (Untitled6)

  • blike_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

comment (Untitled2)

  • c_id (Key) — INT — Primary key — NOT NULL
  • c_author (Field4) — VARCHAR(20)
  • c_content (Field) — VARCHAR(300)
  • c_createdAt (Field2) — DATE
  • c_updatedAt (Field3) — DATE
  • b_id (Key2) — INT — Foreign key → board.b_id — NOT NULL

comment (Untitled5)

  • comment_id (Key) — INT — Primary key — NOT NULL
  • c_content (Field) — VARCHAR(300)
  • user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL
  • board_id (Key3) — INT — Foreign key → board.board_id — NOT NULL

comment (CopyOfUntitled2)

  • c_id (Key) — INT — Primary key — NOT NULL
  • c_author (Field4) — VARCHAR(20)
  • c_content (Field) — VARCHAR(300)
  • c_createdAt (Field2) — DATE
  • c_updatedAt (Field3) — DATE
  • b_id (Key2) — INT — Foreign key → board.b_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL

commentlike (Untitled7)

  • clike_id (Key2) — INT — Primary key — NOT NULL
  • comment_id (Key) — INT — Foreign key → comment.comment_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(20)
  • u_id (Field2) — VARCHAR(40)
  • u_nickname (Field3) — VARCHAR(30)
  • u_password (Field4) — VARCHAR(8)
  • u_joinedAt (Field5) — DATE
  • u_mobile (Field6) — VARCHAR(15)
  • u_email (Field7) — VARCHAR(50)

user (CopyOfUntitled3)

  • user_id (Key) — INT — Primary key — NOT NULL
  • u_name (Field) — VARCHAR(20)
  • u_id (Field2) — VARCHAR(40)
  • u_nickname (Field3) — VARCHAR(30)
  • u_password (Field4) — VARCHAR(8)
  • u_joinedAt (Field5) — DATE
  • u_mobile (Field6) — VARCHAR(15)
  • u_email (Field7) — VARCHAR(50)