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