ribborn
Tables (8)
ChatMessage
- messageId (Key) — Long — Primary key — NOT NULL
- roomId (Field10) — Long
- isRead (Field) — boolean
- message (Field2) — String
- senderId (Field3) — Long
- type (Field4) — String
- senderName (Field5) — String
- nickName (Field6) — String
- senderNickName (Field7) — String
- senderName (Field8) — String
- img (Field9) — String
ChatRoom
- roomId (Key) — Long — Primary key — NOT NULL
- acceptorUserId (Key3) — Long — Foreign key → User.userId — NOT NULL
- requesterUserId (Key2) — Long — Foreign key → User.userId — NOT NULL
- accFixed (Field) — boolean
- accOut (Field2) — boolean
- reqFixed (Field3) — boolean
- reqOut (Field4)
Comment
- commentId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
- userId (Key22) — Long — Foreign key → Post.userId — NOT NULL
- comment (Field) — String
Contents
- contentsId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
- userId (Key22) — Long — Foreign key → Post.userId — NOT NULL
- image (Field) — String
- content (Field2) — String
Love
- loveId (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- postId (Key3) — Long — Foreign key → Post.postId — NOT NULL
Post
- postId (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- likeCount (Field) — int
- commentCount (Field2) — int
- titile (Field3) — String
- category (Field5) — String
- region (Field6) — String
- item (Field7) — String
- postCate (Field8)
TimeStamp
- createAt (Field) — localDateTime
- modifyAt (Field2) — localDateTime
User
- userId (Key) — Long — Primary key — NOT NULL
- username (Field) — String
- password (Field2) — String
- nickname (Field3) — String
- userType (Field4) — int
- companyNum (Field5) — String
- phoneNum (Field6) — String
- addressCategory (Field7) — String
- addressDetail (Field8) — String
- introduction (Field9)