TeamAssignment(advanced)
Tables (4)
Boards (??)
- board_id (Key) — long — Primary key — NOT NULL
- member_id (Key2) — long — Foreign key → Members.member_id — NOT NULL
- title (Field) — String
- content (Field2) — String
- file (Field3) — String
- commentList (Field4) — List<Comments>
- createdAt (Field5) — LocalDateTime
- modifiedAt (Field6) — LocalDateTime
Comments (Untitled3)
- comment_id (Key) — long — Primary key — NOT NULL
- member_id (Key2) — long — Foreign key → Members.member_id — NOT NULL
- board_id (Key3) — long — Foreign key → Boards.board_id — NOT NULL
- username (Field) — String
- comment (Field2) — String
- createdAt (Field3) — LocalDateTime
- modifiedAt (Field4) — LocalDateTime
Hearts (Untitled4)
- heart_id (Key) — long — Primary key — NOT NULL
- member_id (Key2) — long — Foreign key → Members.member_id — NOT NULL
- board_id (Key3) — long — Foreign key → Boards.board_id — NOT NULL
Members (Untitled)
- member_id (Key) — long — Primary key — NOT NULL
- username (Field) — String
- password (Field2) — String
- email (Field3) — String
- createdAt (Field4) — LocalDateTime
- modifiedAt (Field5) — LocalDateTime