anabada

Tables (12)

Beach (Untitled7)

  • beachId (Key) — Long — Primary key — NOT NULL
  • beachNum (Field4) — String
  • beachName (Field) — String
  • x (Field2) — Double
  • y (Field3) — Double
  • tmp (Field5) — String
  • wav (Field6) — String
  • wsd (Field7) — String
  • pop (Field8) — String
  • pcp (Field9) — String
  • pty (Field10) — String
  • sky (Field11) — String

ChatMessage (Untitled6)

  • id (Key3) — Long — Primary key — NOT NULL
  • userId (Key) — Long — Foreign key → User.userId — NOT NULL
  • roomId (Key2) — Long — Foreign key → ChatRoom.roomId — NOT NULL
  • userId (Key22) — Long — Foreign key → ChatRoom.userId — NOT NULL
  • content (Field) — String

ChatRoom (Untitled5)

  • roomId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL

Comment (Untitled3)

  • commentId (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → Post.userId — NOT NULL
  • post_id (Key3) — Long — Foreign key → User.userId — NOT NULL
  • content (Field) — String

Like (Untitled4)

  • likeId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → Post.userId — NOT NULL
  • postId (Key3) — Long — Foreign key → User.userId — NOT NULL

Notification (Untitled11)

  • notificationId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • postId (Key3) — Long — Foreign key → Post.postId — NOT NULL
  • notificationType (Field) — String
  • isRead (Field2) — boolean
  • isBadge (Field3) — boolean

Post (Untitled2)

  • postId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • title (Field) — String
  • area (Field2) — Enum
  • content (Field3) — String
  • thumbnailUrl (Field4) — String
  • amenity (Field5) — String

S3ImageUpload (Untitled10)

  • S3ImageUploadId (Key2) — Long — Primary key — NOT NULL
  • postId (Key) — Long — Foreign key → Post.postId — NOT NULL
  • url (Field) — String
  • Field2 — String

ThunderLike (Untitled8)

  • thunderLikeId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • thunderPostId (Key3) — Long — Foreign key → ThunderPost.thunderPostId — NOT NULL

ThunderPost (Untitled9)

  • thunderPostId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • title (Field) — String
  • nickname (Field2) — String
  • place (Field3) — String
  • goalMember (Field4) — Int
  • currentMember (Field5) — Int
  • thumbnailUrl (Field6) — String
  • thumbnailFilename (Field7) — String
  • startDate (Field8) — String
  • endDate (Field9) — String

ThunderRequest (Untitled12)

  • thunderRequestId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • thunderPostId (Key3) — Long — Foreign key → ThunderPost.thunderPostId — NOT NULL

User (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • nickname (Field2) — String
  • password (Field3) — String
  • profileImg (Field4) — String