efub erd

Tables (9)

boards (Untitled2)

  • boardId (PK) — bigint — Primary key — NOT NULL
  • memberId (FK) — bigint — Foreign key → members.memberId — NOT NULL
  • name (Field) — varchar
  • password (Field2) — varchar
  • description (Field3) — varchar
  • notice (Field4) — varchar
  • createdAt (Field6) — date
  • modifiedAt (Field7) — date

commentLIke (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • commentId (FK) — bigint — Foreign key → comments.commentId — NOT NULL

comments

  • commentId (Key) — bigint — Primary key — NOT NULL
  • postId (FK) — bigint — Foreign key → posts.postId — NOT NULL
  • memberId (FK2) — bigint — Foreign key → members.memberId — NOT NULL
  • content (Field2) — varchar
  • createdAt (Field4) — date
  • modifiedAt (Field5) — date

members (Untitled)

  • memberId (PK) — bigint — Primary key — NOT NULL
  • studentId (Field) — varchar
  • school (Field2) — varchar
  • nickname (Field3) — varchar
  • email (Field4) — varchar
  • password (Field5) — varchar
  • createdAt (Field6) — date
  • modifiedAt (Field7) — date

message (Untitled5)

  • messageId (Key) — bigint — Primary key — NOT NULL
  • messageRoomId (FK) — bigint — Foreign key → messageRoom.messageRoomId — NOT NULL
  • content (Field2) — varchar
  • sendAt (Field3) — date

messageRoom (Untitled4)

  • messageRoomId (Key) — bigint — Primary key — NOT NULL
  • memberId (FK) — bigint — Foreign key → members.memberId — NOT NULL
  • senderId (Field) — int
  • receiverId (Field2) — int
  • content (Field3) — varchar
  • messageId (Field4) — int
  • createdAt (Field5) — date

notification (Untitled8)

  • notificationId (Key) — bigint — Primary key — NOT NULL
  • memberId (FK) — bigint — Foreign key → members.memberId — NOT NULL
  • type (Field) — varchar
  • boardName (Field2) — varchar
  • content (Field3) — varchar
  • timeStamp (Field4) — date

postLike (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • postId (FK) — bigint — Foreign key → posts.postId — NOT NULL
  • memberId (FK2) — bigint — Foreign key → members.memberId — NOT NULL

posts (Untitled3)

  • postId (Key) — bigint — Primary key — NOT NULL
  • boardId (FK) — bigint — Foreign key → boards.boardId — NOT NULL
  • memberId (FK2) — bigint — Foreign key → boards.memberId — NOT NULL
  • anonymous (Field3) — true
  • post (Field4) — varchar
  • createdAt (Field5) — date
  • modifiedAt (Field6) — date