Ingda
Tables (6)
Member (Untitled)
- memberId (Key) — Long — Primary key — NOT NULL
- email (Field) — String
- nickname (Field2) — String
- password (Field3) — String
- createdAt (Field4) — Date
- modifiedAt (Field5) — date
- inactive (Field7) — Datetime
- reviewCount (Field8) — Long
- role (Field9) — String
- lastConnection (Field10) — date
- birth (Field6) — date
- sex (Field11) — String
TempEmail (redis)
- email (Key) — String — Primary key — NOT NULL
- code (Field) — String
- verified (Field2) — boolean
- timeStamp (Field3) — date
diary (Untitled2)
- diaryId (Key) — Long — Primary key — NOT NULL
- memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
- subject (Field) — String
- content (Field2) — String
- writeDate (Field4) — date
- review (Field3) — boolean
ranking (Untitled5)
- memberId (Key) — Long — Foreign key → Member.memberId — NOT NULL
- ranking (Field) — Long
- nickname (Field2) — String
- score (Field3) — Long
review (Untitled4)
- reviewId (Key) — Primary key — NOT NULL
- memberId (Key22) — Long — Foreign key → diary.memberId — NOT NULL
- diaryId (Key2) — Long — Foreign key → diary.diaryId — NOT NULL
- reviewDate (Field) — date
- reviewContent (Field2) — String
- original (Field3) — String
score (Untitled3)
- memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
- loginCount (Field) — Long
- diaryScore (Field2) — Long
- reviewScore (Field3) — Long