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