todaymohani

테이블 (4)

가계부 (accounts)

  • idx (PK) — Long — 기본 키 — NOT NULL
  • memberNo (FK) — Long — 외래 키 → 회원.memberNo — NOT NULL
  • money (Field) — Long — NOT NULL
  • date (Field2) — String — NOT NULL
  • in_ex (Field3) — boolean — NOT NULL
  • memo (Field4) — String
  • createdAt (Field5) — LocalDateTime
  • modifiedAt (Field6) — LocalDateTime

금액 조회 (totalMoney)

  • date (PK) — String — 기본 키 — NOT NULL
  • income (Field) — Long
  • expenditure (Field2) — Long

일정 (schedule)

  • seq (PK) — Long — 기본 키 — NOT NULL
  • memberNo (FK) — Long — 외래 키 → 회원.memberNo — NOT NULL
  • title (Field) — String — NOT NULL
  • startDate (Field2) — String
  • endDate (Field3) — String
  • startTime (Field4) — String
  • endTime (Field5) — String
  • content (Field6) — String
  • loc (Field7) — String
  • createdAt (Field8) — LocalDateTime
  • modifiedAt (Field9) — LocalDateTime

회원 (member)

  • memberNo (PK) — Long — 기본 키 — NOT NULL
  • email (Field1) — String — NOT NULL — unique
  • password (Field2) — String — NOT NULL
  • name (Field3) — String — NOT NULL
  • phoneNumber (Field4) — String — NOT NULL
  • type (Field5) — MemberType — NOT NULL
  • createdAt (Field6) — LocalDateTime
  • modifiedAt (Field7) — LocalDateTime