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
- 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