household-acc
Tables (10)
ExpenditureTransaction (CopyOfUntitled)
- id — Number — Primary key — NOT NULL
- date (Date) — TIMESTAMP — NOT NULL
- title (Title) — STring — NOT NULL
- price (Field) — number — NOT NULL
- expenditureType (Field3) — Enum
- memo (Field2) — NOT NULL
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
FormUser (유저)
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
- email (이메일) — string — NOT NULL
- password (pw) — string — NOT NULL
- nickname (닉네임) — string — NOT NULL
- createdAt (계정생성일) — Date — NOT NULL
- isVerified (Field) — boolean — NOT NULL
- verificationToken (Field2) — string — NOT NULL
IncomeTransaction (Untitled)
- id — Number — Primary key — NOT NULL
- date (Date) — TIMESTAMP — NOT NULL
- title (Title) — STring — NOT NULL
- price (Field) — number — NOT NULL
- incomeType (Field3) — Enum — NOT NULL
- memo (Field2) — NOT NULL
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
OauthUser (CopyOf유저)
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
- provider — string — NOT NULL
- nickname (닉네임) — string — NOT NULL
- createdAt (계정생성일) — Date — NOT NULL
- providerId — string — NOT NULL
User (Untitled3)
- id (Key) — num,ber — Primary key — NOT NULL
- DType (Field) — enum — NOT NULL — form_user / oauth_user
comment (댓글)
- id (comment id) — long — Primary key — NOT NULL
- id (post id) — long — Foreign key → post.id — NOT NULL
- body (댓글내용) — string — NOT NULL
- createdAt (작성일자) — Date — NOT NULL
- depth (대댓글용 댓글깊이) — int — NOT NULL
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
commentLike (댓글공감)
- id (comment id) — long — Foreign key → comment.id — NOT NULL
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
picture (사진)
- id (picture id) — long — Primary key — NOT NULL
- id (post id) — long — Foreign key → post.id — NOT NULL
post (게시글)
- id (post id) — long — Primary key — NOT NULL
- title (제목) — string — NOT NULL
- body (내용) — string — NOT NULL — 사진 포함
- category (글 카테고리) — string — NOT NULL
- createdAt (작성일자) — Date — NOT NULL
- id (Key) — num,ber — Foreign key → User.id — NOT NULL
postLike (게시글 공감)
- id (post id) — long — Foreign key → post.id — NOT NULL
- id (Key) — num,ber — Foreign key → User.id — NOT NULL