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)