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