and_backend

Tables (11)

chatMessage

  • chatMessageId — int — Primary key — NOT NULL
  • sender — String
  • text — String
  • createdAt — java.time.localtime
  • chatRoomId — int — Foreign key → chatRoom.chatRoomId — NOT NULL

chatRoom

  • chatRoomId — int — Primary key — NOT NULL
  • createdAt — java.time.localtime
  • closedAt — java.time.localtime
  • lossCaseID (lossCaseId) — int — Foreign key → lossCase.lossCaseID — NOT NULL

diary

  • id — int — Primary key — NOT NULL
  • symbol (symbolb) — byte[]
  • text — Sttring
  • cretaedAt (createdAt) — localDateTime
  • updatedAt — localDateTime
  • lossCaseID (lossCaseId) — int — Foreign key → lossCase.lossCaseID — NOT NULL

lossCase

  • lossCaseID (lossCaseId) — int — Primary key — NOT NULL
  • 상대 (subject) — Subject
  • 함께한기간 (withTime) — wihtTime
  • 이별날짜 (lossDate) — java.time.localdate
  • 이별사유 (lossReason) — LossReason
  • 이별대처법 (copeWay) — copeWay
  • 사진 (photo) — Byte[]
  • userId — int — Foreign key → user.userId — NOT NULL

preTestOpt

  • preTestOptId — int — Primary key — NOT NULL
  • text — String
  • preTestQId — int — Foreign key → preTestQ.preTestQId — NOT NULL

preTestQ

  • preTestQId — int — Primary key — NOT NULL
  • text — String
  • score — int
  • lossCaseID (lossCaseId) — int — Foreign key → lossCase.lossCaseID — NOT NULL

qnaA (Untitled5)

    qnaA

    • qnaAId — int — Primary key — NOT NULL
    • text — String
    • qnaQId — int — Foreign key → qnaQ.qnaQId — NOT NULL

    qnaQ

    • qnaQId — int — Primary key — NOT NULL
    • text
    • lossCaseID (lossCaseId) — int — Foreign key → lossCase.lossCaseID — NOT NULL

    quest

    • questId — int — Primary key — NOT NULL
    • text — string
    • lossCaseID (lossCaseId) — int — Foreign key → lossCase.lossCaseID — NOT NULL

    user

    • userId — int — Primary key — NOT NULL
    • email — string
    • pw — string
    • name — string
    • age — int
    • gender — string