news

Tables (10)

BlackList (접속불가 리스트(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • CreatedDate (createdDate) — LocalDateTime — Foreign key → Timestamp.CreatedDate — NOT NULL
  • Accessor (accessor) — String
  • Email (email) — String
  • RestrictionEndDateTime (restrictionEndDateTime) — LocalDateTime
  • Restriction (restriction) — Set<Restriction>/HashSet

Comment (댓글(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • NewsId (newsId) — Integer — Foreign key → News.Id — NOT NULL
  • LocalDateTime — String — Foreign key → Timestamp.CreatedDate — NOT NULL
  • CommentAuthor (commentAuthor) — String
  • Comment (comment) — String
  • IsDeleted (isDeleted) — boolean

MainChat (전체챗팅방채팅(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • LocalDateTime — String — Foreign key → Timestamp.CreatedDate — NOT NULL
  • IsDeleted (isDeleted) — String
  • NickName (nickName) — String
  • Messagem (message) — String
  • IpAddress (ipAddress) — String

MainChat (전체채팅방(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • LocalDateTime — String — Foreign key → Timestamp.CreatedDate — NOT NULL
  • ChatRoom (chatRoom) — String
  • Author (author) — String

Member (유저정보(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • LocalDateTime (createdDate) — LocalDateTime — Foreign key → Timestamp.CreatedDate — NOT NULL
  • NickName (nickName) — String
  • Email (email) — String
  • password (passowrd) — String
  • isDeleted — boolean

MemberDetail (유저 추가필요 정보(class))

  • Id (id) — Integer — Foreign key → Member.Id — NOT NULL
  • LocalDateTime (createdDate) — LocalDateTime — Foreign key → Member.LocalDateTime — NOT NULL
  • Age (age) — int
  • LiveRegion (liveRegion) — String
  • IpAddress (ipAddress) — String

News (뉴스정보(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • LocalDateTime — String — Foreign key → Timestamp.CreatedDate — NOT NULL
  • Author (author) — String
  • Title (title) — String
  • IsDeleted (isDeleted) — boolean
  • Content (content) — String
  • IsDeleted (isDelete) — boolean

RoomChat (1:1채팅방 관련(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • LocalDateTime — String — Foreign key → Timestamp.CreatedDate — NOT NULL
  • ChatRoomName (chatRoomName) — String
  • ApprovalMember (approvalMember) — Member
  • RequestMember (requestMember) — Member
  • GreedRoom (greedRoom) — boolean
  • IsDeleted (isDeleted) — boolean

RoomChat (유저간채팅방채팅(class))

  • Id (id) — Integer — Primary key — NOT NULL
  • LocalDateTime — String — Foreign key → Timestamp.CreatedDate — NOT NULL
  • RoomId (roomId) — Integer — Foreign key → RoomChat.Id — NOT NULL
  • IsDeleted (isDeleted) — String
  • NickName (nickName) — String
  • Messagem (message) — String
  • IsDeleted (IsDeletedChat) — String

Timestamp (시간(class))

  • CreatedDate (createdDate) — LocalDateTime — Primary key — NOT NULL
  • ModifiedDate (modifiedDate) — LocalDateTime