firstproject
Tables (5)
Board (게시글)
- board_id (Key) — Long — Primary key — NOT NULL
- title (Field2) — String
- author (Field3) — String
- content (Field4) — String
- view (Field5) — int
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
Comment (댓글)
- comment_id (Key) — Long — Primary key — NOT NULL
- content (Field3) — String
- parent (Field4) — Comment
- board_id (Key2) — Long — Foreign key → Board.board_id — NOT NULL
- member_id (Key3) — Long — Foreign key → Member.member_id — NOT NULL
Likes (좋아요)
- likes_id (Key) — Long — Primary key — NOT NULL
- board_id (Key2) — Long — Foreign key → Board.board_id — NOT NULL
- member_id (Key3) — Long — Foreign key → Member.member_id — NOT NULL
Member (회원)
- member_id (Key) — Long — Primary key — NOT NULL
- loginId (Field) — String
- name (Field2) — String
- password (Field3) — String
- role (Field4) — Role
- provider (Field5) — String
- providerId (Field6) — String
Notice (알림)
- notice_id (Key) — Long — Primary key — NOT NULL
- content (Field3) — String
- isChecked (Field4) — boolean
- sender (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- receiver (Key3) — Long — Foreign key → Member.member_id — NOT NULL