test

Tables (5)

Board (Untitled2)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → Users.id — NOT NULL
  • created_at (Field) — datetime
  • modified_at (Field3) — datetime
  • likes (Field2) — bigint(20)
  • title (Field4) — varchar2(100)
  • content (Field5) — varchar2(500)
  • nickname (Field6) — varchar2(20)

Comment (Untitled3)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • board_id (Key2) — bigint(20) — Foreign key → Board.id — NOT NULL
  • user_id (Key3) — bigint(20) — Foreign key → Users.id — NOT NULL
  • created_at (Field) — datetime
  • modified_at (Field2) — datetime
  • content (Field4) — varchar2(500)

Like (Untitled5)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → Users.id — NOT NULL
  • board_id (Key3) — bigint(20) — Foreign key → Board.id — NOT NULL

ReplyComment (Untitled4)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • comment_id (Key2) — bigint(20) — Foreign key → Comment.id — NOT NULL
  • created_at (Field) — datetime
  • modified_at (Field2) — datetime
  • content (Field3) — varchar2(500)
  • user_id (Key3) — bigint(20) — Foreign key → Users.id — NOT NULL

Users (Untitled)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • ip (Field) — varchar2(50)