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