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