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