SNS
Tables (5)
Board (게시판)
- board_id (Key) — long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- title (Field) — String
- content (Field2) — String
- count_favorite (Field5) — long
- count_comments (Field6) — long
- created_date (Field3) — LocalDateTime
- updated_date (Field4) — LocalDateTime
Comments (댓글)
- comment_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
- content (Field) — Text
- created_date (Field2) — LocalDateTime
- updated_date (Field3) — LocalDateTime
Favorite (좋아요)
- favorite_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
- is_clicked (Field) — boolean
- created_date (Field2) — LocalDateTime
- updated_date (Field3) — LocalDateTime
Member (사용자)
- member_id (Key) — Long — Primary key — NOT NULL
- user_login_id (Field8) — String
- user_name (Field) — String
- password (Field2) — String
- user_email (Field3) — String
- user_profile_img_url (Field5) — String
- visited_times (Field7) — Long
- updated_date (Field6) — LocalDateTime
- create_date (Field4) — LocalDateTime
- status (Field9) — String
- change_status_date (Field10) — String(Status Type)
Notification (알람)
- notification_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- board_id (Key3) — Long — Foreign key → Board.board_id — NOT NULL
- sender (Field) — String
- notification_type (Field2) — NotificationType
- create_date (Field3) — LocalDateTime
- updated_date (Field4) — LocalDateTime